[Help]need pr00 help gia navicat kai SQL arxeia

[angelos95]

hi se olus elpizw na me help. ftiaxnw enan l2jOfficia pack kai 8elw na valw mesa npc kai items ala dn borw gt mu vgazei error .... 

sigura ine kati me to syntax ala dn 3erw ti alo na kanw. plzz help me  kai e3igiste mu pws

 

 

 

 

 

 

INSERT INTO `weapon` (`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`) VALUES

('9700', 'Devil Spear', 'lrhand', 'true', '1300', '1', '1', 'adamantaite', 's', '366', '10', 'pole', '8', '0.00000', '0', '0', '0', '379', '0', '132', '-1', '48800000', 2440, 'false', 'false', 'true', 'true', '3037', '2', '0', '0', '0', '0', '0', '0', '0', '0');

 

 

this is the SQL for 1 of the epic weps plzzz fix and repost it plz

 

 

[angelos95]

:S mu vgazei error st odin cleaver

[Sillent]

Τώρα;

 

REPLACE INTO `weapon` VALUES
(9700,'Devil Spear','lrhand','true',1300,1,1,'adamantaite','s',366,10,'sword',8,0.00000,0,0,0,379,0,132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9701, 'Medusa Blade', 'rhand', 'true', 2080, 1, 1, 'adamantaite', 's', 378, 40, 'sword', 8, 0.00000, 0, 0, 0, 325, 0, 129,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9702, 'Hades Dagger', 'rhand', 'true', 2080, 1, 1, 'adamantaite', 's', 378, 40, 'dagger', 8, 0.00000, 0, 0, 0, 325, 0, 129,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9703, 'Thor Hammer', 'rhand', 'true', 2080, 1, 1, 'adamantaite', 's', 378, 40, 'blunt', 8, 0.00000, 0, 0, 0, 325, 0, 129,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9704, 'Odin Cleaver', 'rhand', 'true', 1650, 1, 1, 'adamantaite', 's', 751, 5, 'bigsword', 12, -3.00000, 0, 0, 0, 293, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9705, 'Artemis Bow', 'lrhand', 'true', 1820, 1, 1, 'adamantaite', 's', 444, 20, 'bow', 4, 4.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9706, 'Zeus Mace', 'rhand', 'true', 1800, 1, 1, 'adamantaite', 's', 366, 5, 'blunt', 8, -3.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9707, 'Ares Fists', 'lrhand', 'true', 1350, 1, 1, 'adamantaite', 's', 444, 5, 'dualfist', 4, 4.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9708, 'Aphrodite Staff', 'lrhand', 'true', 1380, 1, 1, 'adamantaite', 's', 444, 5, 'bigblunt', 8, 0.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9704, 'Odin Cleaver', 'rhand', 'true', 1650, 1, 1, 'adamantaite', 's', 751, 5, 'bigsword', 12, -3.00000, 0, 0, 0, 293, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9705, 'Artemis Bow', 'lrhand', 'true', 1820, 1, 1, 'adamantaite', 's', 444, 20, 'bow', 4, 4.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9706, 'Zeus Mace', 'rhand', 'true', 1800, 1, 1, 'adamantaite', 's', 366, 5, 'blunt', 8, -3.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9707, 'Ares Fists', 'lrhand', 'true', 1350, 1, 1, 'adamantaite', 's', 444, 5, 'dualfist', 4, 4.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9708, 'Aphrodite Staff', 'lrhand', 'true', 1380, 1, 1, 'adamantaite', 's', 444, 5, 'bigblunt', 8, 0.00000, 0, 0, 0, 325, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9709, 'Dual Medusa Blade', 'lrhand', 'true', 1300, 1, 1, 'adamantaite', 's', 310, 20, 'dual', 4, 4.00000, 0, 0, 0, 379, 0, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');
REPLACE INTO `weapon` VALUES
(9710, 'Spartan Shield', 'lhand', 'true', 1650, 1, 1, 'adamantaite', 's', 751, 5, 'none', 12, -3.00000, 0, 0, 0, 293, 11, 132,-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;');

[angelos95]

twra malista bika ola !! ty man

[angelos95]

ok pira tn apadish mu twra 'Topic Locked pedia