Help Error Execute Sql File

[ThegameSeconds]

Some one help me about this

[Err] 1136 - Column count doesn't match value count at row 1
[Err] INSERT INTO `weapon` VALUES  
(18565983, "Antharas Sword {Awake} [R99]", "rhand", "true", 970, 1, 1, "adamantaite", "s", 281, 5, "sword", 12, -3, 0, 0, 0, 433, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3023, 3, 0, 0, 0, 0, 0, 0, 0, 0),
(18565986, "Antharas Dagger {Awake} [R99]", "rhand", "true", 1800, 1, 1, "adamantaite", "s", 309, 10, "dagger", 5, -3, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18565989, "Antharas Mace {Awake} [R99]]", "rhand", "true", 1350, 1, 1, "adamantaite", "s", 281, 5, "blunt", 4, 4, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18565992, "Antharas Hammer {Awake} [R99]", "rhand", "true", 1380, 1, 1, "adamantaite", "s", 342, 10, "blunt", 8, 0, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18565995, "Antharas Bigsword {Awake} [R99]", "lrhand", "true", 1650, 1, 1, "adamantaite", "s", 581, 5, "bigsword", 12, -3, 0, 0, 0, 300, 11, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18565998, "Antharas Fist {Awake} [R99]", "lrhand", "true", 1420, 2, 2, "adamantaite", "s", 342, 10, "dualfist", 5, 0, 0, 0, 0, 379, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3050, 1, 0, 0, 0, 0, 0, 0, 0, 0),
(18566001, "Antharas Polearm {Awake} [R99]", "lrhand", "true", 1730, 3, 3, "adamantaite", "s", 376, 20, "pole", 5, 4, 0, 0, 0, 379, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566004, "Antharas Staff {Awake} [R99]", "lrhand", "true", 1300, 1, 1, "adamantaite", "s", 247, 20, "bigblunt", 4, 4, 0, 0, 0, 379, 0, 192, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566007, "Antharas Stick {Awake} [R99]", "rhand", "true", 2080, 1, 1, "adamantaite", "s", 397, 10, "blunt", 8, 0, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566010, "Antharas Spirit {Awake} [R99]", "rhand", "true", 970, 1, 1, "adamantaite", "s", 281, 5, "blunt", 12, -3, 0, 0, 0, 433, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3023, 3, 0, 0, 0, 0, 0, 0, 0, 0),
(18566013, "Antharas Bow {Awake} [R99]", "lrhand", "true", 1800, 1, 1, "adamantaite", "s", 309, 10, "bow", 5, -3, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566016, "Antharas Rapier {Awake} [R99]", "rhand", "true", 1350, 1, 1, "adamantaite", "s", 281, 5, "sword", 4, 4, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566019, "Antharas Wingblade {Awake} [R99]", "rhand", "true", 1380, 1, 1, "adamantaite", "s", 342, 10, "sword", 8, 0, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566022, "Antharas Crossbow {Awake} [R99]", "lrhand", "true", 1650, 1, 1, "adamantaite", "s", 581, 5, "bow", 12, -3, 0, 0, 0, 300, 11, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18566153, "Antharas Dual Daggers {Awake} [R99]", "lrhand", "true", 1420, 2, 2, "adamantaite", "s", 342, 10, "dagger", 5, 0, 0, 0, 0, 379, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3050, 1, 0, 0, 0, 0, 0, 0, 0, 0),
(18566155, "Antharas Dual sword {Awake} [R99]", "lrhand", "true", 1730, 3, 3, "adamantaite", "s", 376, 20, "dual", 5, 4, 0, 0, 0, 379, 0, 145, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(1565587, "Antharas Shield [R99]", "lhand", "true", 1300, 1, 1, "adamantaite", "s", 247, 20, "shield", 4, 4, 0, 0, 0, 379, 0, 192, -1, 0, 0, "false", "true", "true", "true", 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(18575983, "Valakas Sword {Awake} [R99]", "rhand", "true", 970, 1, 1, "adamantaite", "s", 281, 5, "sword", 12, -3, 0, 0, 0, 433, 0, 145, -1, 0, 0, "false", "true", "true", "true", 3023, 3, 0, 0, 0, 0, 0, 0, 0, 0),
(18575986, "Valakas Dagger {Awake} [R99]", "rhand", "true", 1800, 1, 1, "adamantaite", "s", 309, 10, "dagger", 5, -3, 0, 0, 0, 325, 0, 145, -1, 0, 0, "false", "true", "true", "
[Msg] Finished - Unsuccessfully
--------------------------------------------------

[Dante44®]

Pack and client?

[Dante44®]

Choose lower ID what is that 44555566 ID?

 

That id is too big18565983 also the others change them also on itemname and weapongroup

Edited February 17, 2015 by Dante44®

[ThegameSeconds]

I got it from this http://www.maxcheaters.com/topic/162663-antharas-valakas-lindvior-weapons-freya-god/

[Pleyne]

Column count doesn't match value count at row 1

 In weapon table there are too many columns or missing some, if you don't know what is column use google translate. Long story short, you will need to add it manually, some columns may be empty ( and you should decide what to input into them by yourself, but it's so easy anyone can think it out ) or there can be too much information to input into column, so you will have to skip some from sql file.

[Dante44®]

That is for freya h5 l2j dont have the weapons in database the weapons are located in xml file

[Dante44®]

http://www.mediafire.com/download/1341nc7bny2t6ip/patch.7z

 

http://www.mediafire.com/download/q0w5gd68eqx59x2/files.rar

 

God armor and weapons Tested And Working