Modcraft - The community dedicated to quality WoW modding!

Wrath of the Lich King Modding => Resources and Tools => Topic started by: akriso on April 29, 2014, 01:51:32 pm

Title: [QUESTION] dbc tool
Post by: akriso on April 29, 2014, 01:51:32 pm

how i can delete 1 column from .dbc file?  - CSVed breaks my dbc file...

Title: Re: [QUESTION] dbc tool
Post by: ferreon on April 29, 2014, 02:44:22 pm

For me taliis works properly and do not crash the file.

http://gyazo.com/c8ecfb80bf3562c003a34ec04cc3c32a (http://gyazo.com/c8ecfb80bf3562c003a34ec04cc3c32a" onclick="window.open(this.href);return false;)

Title: Re: [QUESTION] dbc tool
Post by: akriso on April 29, 2014, 02:54:05 pm

i need delete column ( not row )

Title: Re: [QUESTION] dbc tool
Post by: stoneharry on April 29, 2014, 03:07:41 pm

Convert to CSV format, delete the column, make sure each row still ends with a comma and that there are no new lines at the end of the file. Then it should convert back without issues.

Title: Re: [QUESTION] dbc tool
Post by: akriso on April 29, 2014, 03:13:28 pm

Quote from: "stoneharry"

Convert to CSV format, delete the column, make sure each row still ends with a comma and that there are no new lines at the end of the file. Then it should convert back without issues.

dbc broken after this... ItemDisplayInfo.dbc

Title: Re: [QUESTION] dbc tool
Post by: stoneharry on April 29, 2014, 04:16:01 pm

Quote from: "akriso"

Quote from: "stoneharry"

Convert to CSV format, delete the column, make sure each row still ends with a comma and that there are no new lines at the end of the file. Then it should convert back without issues.

dbc broken after this... ItemDisplayInfo.dbc

Define broken. What is broken? Open it in 010 editor - does the header and such exist with valid data?

WoW won't be able to load it because you deleted a column...

Title: Re: [QUESTION] dbc tool
Post by: akriso on April 29, 2014, 04:21:32 pm

i would convert dbc 1 dbc from mop to 434 - mop have 27 columns / cata have 26 columns ( need only delete latest column ).

Title: Re: [QUESTION] dbc tool
Post by: akriso on April 29, 2014, 04:23:21 pm

(http://take.ms/ja414)

0040E1D0: 48 27 82 0D  46 61 69 6C  65 64 20 74  6F 20 72 65  H'..Failed to re
0040E1E0: 61 64 20 66  69 6C 65 20  66 72 6F 6D  20 6C 6F 63  ad file from loc
0040E1F0: 61 6C 2E 0A  0A 44 65 74  61 69 6C 73  3A 20 28 53  al...Details: (S
0040E200: 74 72 65 61  6D 69 6E 67  20 53 74 61  74 75 73 3A  treaming Status:
0040E210: 20 45 6E 61  62 6C 65 64  20 2F 20 4D  66 69 6C 20   Enabled / Mfil
0040E220: 4E 6F 74 20  52 64 79 20  2F 20 44 61  74 61 20 4E  Not Rdy / Data N
0040E230: 6F 74 20 52  64 79 2C 20  42 75 69 6C  64 3A 20 31  ot Rdy, Build: 1
0040E240: 35 35 39 35  29 0A 5B 36  5D 20 65 72  72 3D 30 20  5595).[6] err=0
0040E250: 74 65 78 74  3D 53 46 69  6C 65 52 65  61 64 46 69  text=SFileReadFi
0040E260: 6C 65 20 2D  20 44 42 46  69 6C 65 73  43 6C 69 65  le - DBFilesClie
0040E270: 6E 74 5C 49  74 65 6D 44  69 73 70 6C  61 79 49 6E  ntItemDisplayIn
0040E280: 66 6F 2E 64  62 63 20 2D  20 44 61 74  61 2F 77 6F  fo.dbc - Data/wo
0040E290: 77 2D 75 70  64 61 74 65  2D 62 61 73  65 2D 31 38  w-update-base-18

Title: Re: [QUESTION] dbc tool
Post by: akriso on April 29, 2014, 04:28:41 pm

before CSVed

557,"","","","","INV_Misc_Bowl_01","",0,0,0,0x0,0,15,0,0,"","","","","","","","","",0,0,
568,"","","","","INV_Misc_MonsterScales_03","",0,0,0,0x0,0,16,0,0,"","","","","","","","","",0,0,
634,"","","","","INV_Scroll_04","",0,0,0,0x0,0,19,0,0,"","","","","","","","","",0,0,
679,"Sword_1H_Short_A_01.mdx","","Sword_1H_Short_A_01Blue","","INV_Sword_04","",0,0,0,0x0,0,8,0,0,"","","","","","","","","",0,0,
683,"","","","","INV_Pants_02","",0,0,0,0x0,0,7,0,0,"","","","","","Leather_B_01_Pant_LU","Leather_B_01_Pant_LL","","",0,0,
684,"","","","","INV_Chest_Wolf","",0,0,0,0x0,0,7,0,0,"","","","Leather_B_01_Chest_TU","Leather_B_01_Chest_TL","","","","",0,0,
685,"","","","","INV_Pants_03","",0,0,0,0x0,0,10,0,0,"","","","","","Mail_A_02_Pant_LU","Mail_A_02_Pant_LL","","",0,0,
687,"","","","","INV_Pants_03","",0,0,0,0x0,0,10,0,0,"","","","","","Mail_A_01_Pant_LU","Mail_A_01_Pant_LL","","",0,0,


after  CSVed

557,,,,,INV_Misc_Bowl_01,,0,0,0,0,0,15,0,0,,,,,,,,,0,0
568,,,,,INV_Misc_MonsterScales_03,,0,0,0,0,0,16,0,0,,,,,,,,,0,0
634,,,,,INV_Scroll_04,,0,0,0,0,0,19,0,0,,,,,,,,,0,0
679,Sword_1H_Short_A_01.mdx,,Sword_1H_Short_A_01Blue,,INV_Sword_04,,0,0,0,0,0,8,0,0,,,,,,,,,0,0
683,,,,,INV_Pants_02,,0,0,0,0,0,7,0,0,,,,,,Leather_B_01_Pant_LU,Leather_B_01_Pant_LL,,0,0
684,,,,,INV_Chest_Wolf,,0,0,0,0,0,7,0,0,,,,Leather_B_01_Chest_TU,Leather_B_01_Chest_TL,,,,0,0
685,,,,,INV_Pants_03,,0,0,0,0,0,10,0,0,,,,,,Mail_A_02_Pant_LU,Mail_A_02_Pant_LL,,0,0
687,,,,,INV_Pants_03,,0,0,0,0,0,10,0,0,,,,,,Mail_A_01_Pant_LU,Mail_A_01_Pant_LL,,0,0
691,,,,,INV_Pants_02,,0,0,0,0,0,7,0,0,,,,,,Leather_B_02_Pant_LU,Leather_B_02_Pant_LL,,0,0

how to fix this shit?

Title: Re: [QUESTION] dbc tool
Post by: MR. Farrare on April 30, 2014, 05:15:43 am

delete  colum by Microsoft exel

Title: Re: [QUESTION] dbc tool
Post by: stoneharry on April 30, 2014, 06:40:43 pm

Quote from: "akriso"

before CSVed

557,"","","","","INV_Misc_Bowl_01","",0,0,0,0x0,0,15,0,0,"","","","","","","","","",0,0,
568,"","","","","INV_Misc_MonsterScales_03","",0,0,0,0x0,0,16,0,0,"","","","","","","","","",0,0,
634,"","","","","INV_Scroll_04","",0,0,0,0x0,0,19,0,0,"","","","","","","","","",0,0,
679,"Sword_1H_Short_A_01.mdx","","Sword_1H_Short_A_01Blue","","INV_Sword_04","",0,0,0,0x0,0,8,0,0,"","","","","","","","","",0,0,
683,"","","","","INV_Pants_02","",0,0,0,0x0,0,7,0,0,"","","","","","Leather_B_01_Pant_LU","Leather_B_01_Pant_LL","","",0,0,
684,"","","","","INV_Chest_Wolf","",0,0,0,0x0,0,7,0,0,"","","","Leather_B_01_Chest_TU","Leather_B_01_Chest_TL","","","","",0,0,
685,"","","","","INV_Pants_03","",0,0,0,0x0,0,10,0,0,"","","","","","Mail_A_02_Pant_LU","Mail_A_02_Pant_LL","","",0,0,
687,"","","","","INV_Pants_03","",0,0,0,0x0,0,10,0,0,"","","","","","Mail_A_01_Pant_LU","Mail_A_01_Pant_LL","","",0,0,


after  CSVed

557,,,,,INV_Misc_Bowl_01,,0,0,0,0,0,15,0,0,,,,,,,,,0,0
568,,,,,INV_Misc_MonsterScales_03,,0,0,0,0,0,16,0,0,,,,,,,,,0,0
634,,,,,INV_Scroll_04,,0,0,0,0,0,19,0,0,,,,,,,,,0,0
679,Sword_1H_Short_A_01.mdx,,Sword_1H_Short_A_01Blue,,INV_Sword_04,,0,0,0,0,0,8,0,0,,,,,,,,,0,0
683,,,,,INV_Pants_02,,0,0,0,0,0,7,0,0,,,,,,Leather_B_01_Pant_LU,Leather_B_01_Pant_LL,,0,0
684,,,,,INV_Chest_Wolf,,0,0,0,0,0,7,0,0,,,,Leather_B_01_Chest_TU,Leather_B_01_Chest_TL,,,,0,0
685,,,,,INV_Pants_03,,0,0,0,0,0,10,0,0,,,,,,Mail_A_02_Pant_LU,Mail_A_02_Pant_LL,,0,0
687,,,,,INV_Pants_03,,0,0,0,0,0,10,0,0,,,,,,Mail_A_01_Pant_LU,Mail_A_01_Pant_LL,,0,0
691,,,,,INV_Pants_02,,0,0,0,0,0,7,0,0,,,,,,Leather_B_02_Pant_LU,Leather_B_02_Pant_LL,,0,0

how to fix this shit?

It looks like it is not interpreting strings correctly.

Title: Re: [QUESTION] dbc tool
Post by: akriso on April 30, 2014, 06:47:31 pm

yeah. maybe u can help me - delete 1 column ? i'll send my csv file to u

Title: Re: [QUESTION] dbc tool
Post by: stoneharry on April 30, 2014, 06:57:53 pm

Quote from: "akriso"

yeah. maybe u can help me - delete 1 column ? i'll send my csv file to u

The tool is not open source, perhaps write your own converter.

I have created both VB and C# frameworks for modifying DBC files. All you would need to do is define the structures then decrease the record size and number of fields per record and not write the last column back.