It is currently 07 Dec 2019, 19:03
   
Text Size

rules text of cards in ct_all.csv possible?

Discuss Upcoming Releases, Coding New Cards, Etc.
PLEASE DO NOT REPORT BUGS HERE!

Moderators: BAgate, drool66, stassy, Aswan jaguar, gmzombie, CCGHQ Admins

rules text of cards in ct_all.csv possible?

Postby Aswan jaguar » 04 Aug 2018, 11:50

It would be of great assistance if we had the rules text of cards in ct_all.csv as reference as well. This is very convenient when searching, testing, making comparisons and many other tasks. Sonic provided me with such a csv with each patch but unfortunately he is not around and while I have tried to follow his instructions to be able to make such the file myself I can't handle it. This is not the best way of course as I would need help with each update (unfortunately very long time since that happened - new update ) while if the rules text is inserted in the official ct_all.csv which gets released there would be no need for such a task with every update.
Last edited by Aswan jaguar on 25 Aug 2018, 09:32, edited 1 time in total.
Reason: edited the underlined sentence to be more comprehensive
---
Trying to squash some bugs and playtesting.
User avatar
Aswan jaguar
Super Tester
 
Posts: 6668
Joined: 13 May 2010, 12:17
Has thanked: 543 times
Been thanked: 281 times

Re: rules text of cards in ct_all.csv possible?

Postby foolosopher » 24 Aug 2018, 22:08

Can you post the instructions? I will try to help.
I long for the time where one man could make a difference...
foolosopher
 
Posts: 189
Joined: 19 May 2010, 20:53
Location: Greece
Has thanked: 13 times
Been thanked: 17 times

Re: rules text of cards in ct_all.csv possible?

Postby Aswan jaguar » 25 Aug 2018, 11:23

Thanks for the offer to help. Unfortunately I don't have the directions possibly I deleted his post with them by accident. :oops:
I am attaching the last CT_ALLRULES.xls I have to see how it is. It has manalink in the first file and rules text in the other file which is what I want. The first 3 columns are the ones imported from manalink but with the ct_all numbering: Full Name (Manalink), Type Text (Manalink), Rules Text (Manalink). Then begin the ct_all columns.
Edit: The file is too big I will upload it to mediafire.
http://www.mediafire.com/file/2ahm4do4v ... s.rar/file
Attachments
2018-08-25_142438ct-allrules.jpg
---
Trying to squash some bugs and playtesting.
User avatar
Aswan jaguar
Super Tester
 
Posts: 6668
Joined: 13 May 2010, 12:17
Has thanked: 543 times
Been thanked: 281 times

Re: rules text of cards in ct_all.csv possible?

Postby foolosopher » 26 Aug 2018, 20:59

Can you upload the manalink and ct_all files that you want to combine?
I long for the time where one man could make a difference...
foolosopher
 
Posts: 189
Joined: 19 May 2010, 20:53
Location: Greece
Has thanked: 13 times
Been thanked: 17 times

Re: rules text of cards in ct_all.csv possible?

Postby Aswan jaguar » 27 Aug 2018, 07:33

---
Trying to squash some bugs and playtesting.
User avatar
Aswan jaguar
Super Tester
 
Posts: 6668
Joined: 13 May 2010, 12:17
Has thanked: 543 times
Been thanked: 281 times

Re: rules text of cards in ct_all.csv possible?

Postby foolosopher » 30 Aug 2018, 23:14

OK took a better look and below is what I found.
manalink.csv: 17523 rows, JZ columns, which is 32 more columns/expansions after "Duel Decks: Speed vs. Cunning" and different ordering of cards than ct_allrules.xls[Manalink]

ct_allrules.xls:
[Manalink]: 14511 rows, IT columns, at row 14206 the rules engine cards start,
these columns each have a number in the last row: CODED CARD equal to sum, Num Pics equal to sum+1, dunno why but in the manalink.csv the sums are wrong.
[Card Types]: 12000 rows, DI columns

indentation is different in some cells, although I think this does not affect anything.

I copied the same number of rows(14206)/ columns (IT) from manalink.csv to ct_allrules.xls[Manalink] and seems to work.
Also in ct_allrules.xls[[Manalink] at line 14206 start rules engine and card types until the end of the file.
vice versa in ct_allrules.xls[Card Types] until line 278 special cards are put and after that the rest cards in alphabetical order, if I noticed correctly.

So we can try to reverse engineer a bit, but it would be best if someone finds/remembers how this file is properly made.
I long for the time where one man could make a difference...
foolosopher
 
Posts: 189
Joined: 19 May 2010, 20:53
Location: Greece
Has thanked: 13 times
Been thanked: 17 times

Re: rules text of cards in ct_all.csv possible?

Postby Aswan jaguar » 04 Oct 2018, 17:29

I made again an effort on this but tokens and other cards (some of them real cards - which seem to give error about 10000+) give errors with this function that mostly works(it is the function that worked for previous files made by Sonic).
Above is the function for "Angel" the first entry to give an error:
"=VLOOKUP($F404;Manalink!$B$2:$AJ$15000;1;FALSE)" which used to work for "Angel" in Sonic files but now gives an error. Any idea why this is happening?
I forgot to mention that also the functions for types column and for rules text column doesn't work for the same entries like "Angel" one.
---
Trying to squash some bugs and playtesting.
User avatar
Aswan jaguar
Super Tester
 
Posts: 6668
Joined: 13 May 2010, 12:17
Has thanked: 543 times
Been thanked: 281 times

Re: rules text of cards in ct_all.csv possible?

Postby Korath » 05 Oct 2018, 06:08

You're just looking to get a copy of ct_all.csv with the corresponding "Rules text" column from Manalink.csv stuck onto the end?
Attachments
ct_plus_rulestext.zip
(1.03 MiB) Downloaded 52 times
User avatar
Korath
DEVELOPER
 
Posts: 3412
Joined: 02 Jun 2013, 05:57
Has thanked: 482 times
Been thanked: 950 times


Return to Development

Who is online

Users browsing this forum: No registered users and 2 guests


Who is online

In total there are 2 users online :: 0 registered, 0 hidden and 2 guests (based on users active over the past 10 minutes)
Most users ever online was 564 on 05 Dec 2019, 12:05

Users browsing this forum: No registered users and 2 guests

Login Form