angelos95 Posted November 17, 2009 Share Posted November 17, 2009 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 Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 19, 2009 Author Share Posted November 19, 2009 :S mu vgazei error st odin cleaver Link to comment Share on other sites More sharing options...
0 Sillent Posted November 19, 2009 Share Posted November 19, 2009 Τώρα; 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;'); Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 19, 2009 Author Share Posted November 19, 2009 twra malista bika ola !! ty man Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 19, 2009 Author Share Posted November 19, 2009 ok pira tn apadish mu twra 'Topic Locked pedia Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
19 answers to this question
Recommended Posts