[Share] SQL Creator V 1.0 Armor

[zconll]

great work, thanks for share

[iWeeKeni]

thank you all

[l2support]

Great work. Working fine :)

[SensationWhite]

great work, thanks for share

[d0ds™]

for what chronicles?

 

 

good work dud!

 

P.S. where is your karma?

 

EDIT

hmmm... I think the generated SQL file when it will execute will having an issue in different chronicles, with this statement

INSERT INTO `armor` VALUES (21, 'Shirt', '', 'chest', 'false', 'light', 4830, 'cloth', 'none', 0, -1, -1, 36, 1, 0, 113, 0, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

it could be possible to have a mismatch column.

I suggest you will specify the column head and include it to the generated SQL

 

sample

INSERT INTO 'armor' ('item ID', Name, AddionalName, 'Body Part', Crystalizable, 'Armor Type', Weight, Material, 'Crystal Type', 'Crystal Count', Avoid, Modify, Duration, Time, 'P. Def', 'M. Def', 'MP Bonus', Price, Sellable, Dropable, Destoyable, Tradeable, Depositable)

VALUES (21, 'Shirt', '', 'chest', 'false', 'light', 4830, 'cloth', 'none', 0, -1, -1, 36, 1, 0, 113, 0, 'true', 'true', 'true', 'true', 'true', '0-0', '0-0;');

and modify every server armor table with allow null to every column to avoid unsuccessfully execution of the sql, where other column head is not included to be inserted some values

 

 

I hope you get my point ;)

 

keep it going dud!

[iWeeKeni]

thank you very much, now we change the program and upload it again

[Sick]

Great file is there anything like this one for Npcs?

[[Geo]Sky]

Hou Hou Hou :D :D :D Very Nice Perfect Tnx ;)

[notfound]

Well too bad maybe you didnt heard.

L2J removed armor tables for armors,etcitem and weapons. all now its on xml files faster and easier to change.

Although i think this will come handy for lots of ppl.

[Dev Atlas]

Man very usefull ty!

[MixMasteR]

amazing

thanks

[`NeverMore]

:o Thanks man..! Reallly good JOB Keep trying

[iWeeKeni]

thanks everyone  ;D

[L1ght]

/agree NotFound

 

it changed ,however GJ keep it up ^^

[RETRoXg1]

I will use it for my server, good work thank you iWeeKeniI