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 Flash™ Posted November 17, 2009 Share Posted November 17, 2009 file gia npc mporo na se boi8iso na peraseis sto pack alla gia weapons oxi REPLACE INTO `npc` VALUES ('1000000', '18782', 'Breath of Halisha', '0', '', '0', 'Monster3.portrait_spirit_winged', '10.00', '20.00', '85', 'male', 'L2Merchant', '40', '18060', '9999', '13.43', '3.09', '40', '43', '30', '21', '20', '10', '30', '2', '2600', '2350', '1600', '2045', '253', '6000', '333', '0', '0', '0', '0', '55', '66', 'frintezza_clan', '6000', '0', '0', 'LAST_HIT', '0', '0', '0', 'fighter', 'false'); exei pou exo to 1000000 8a baleis to id tou npc pou 8eleis kai edo L2Merchant 8a to ftia3eis oste to html pou 8a to peraseis.. px Gm_shop: L2Merchant Buffer: 'L2Npc Gk: L2Teleporter Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 18, 2009 Author Share Posted November 18, 2009 ty man 8a to dokimasw . kapios alos gia ta wep ??? Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 18, 2009 Author Share Posted November 18, 2009 to dokimasa ala kai pali error mu vgazei ... :'/ Link to comment Share on other sites More sharing options...
0 Flash™ Posted November 18, 2009 Share Posted November 18, 2009 file pes mou to id tou npc kai ti einai to npc na sou to ftia3o Link to comment Share on other sites More sharing options...
0 3xpl0it3R Posted November 18, 2009 Share Posted November 18, 2009 Min kaneis dipla post.reported.. Kai me tin L2JOfficial 8a exeis polla problimata.Apla pare L2JFree kai 8a perastoun ola. Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 18, 2009 Author Share Posted November 18, 2009 po re pali apo tn arxh.... dld na paw gia l2jArchid kalitera ?? Link to comment Share on other sites More sharing options...
0 3xpl0it3R Posted November 18, 2009 Share Posted November 18, 2009 I L2jArchid einai c6, oxi ct2.3 .... kai den xreiazete na brizeis... kana edit to post sou, prin se dei kanenas kai fas -1 .. Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 19, 2009 Author Share Posted November 19, 2009 :S to kalitero pack gia C6 pio ine ?? gia ct2.3 ine o L2j free Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 19, 2009 Author Share Posted November 19, 2009 :S to kalitero pack gia C6 pio ine ?? gia ct2.3 ine o L2j free Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 19, 2009 Author Share Posted November 19, 2009 ohhh pff eleoC katala9os ekana double post ... kolaei to pc kamia fora kai paei 2 fores .., borw na svisw t 1 ??? Link to comment Share on other sites More sharing options...
0 Sillent Posted November 19, 2009 Share Posted November 19, 2009 INSERT 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',3037,0,0,0,0,0,0,0,0,'0-0;'); Test it! Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 19, 2009 Author Share Posted November 19, 2009 OMG dulepse !!! 1kkkkk ty re sillent ala mia xarh akoma..na mu ftiaksei kai ta ipolipa weps p postarw apo katw Link to comment Share on other sites More sharing options...
0 Sillent Posted November 19, 2009 Share Posted November 19, 2009 Γράψτα και στα κάνω... Link to comment Share on other sites More sharing options...
0 angelos95 Posted November 19, 2009 Author Share Posted November 19, 2009 INSERT 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',3037,0,0,0,0,0,0,0,0,'0-0;'); Test it! INSERT 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, 78800000, 2440, 'false', 'false', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT 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, 78800000, 2440, 'false', 'false', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT 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, 78800000, 2440, 'false', 'false', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); INSERT INTO `weapon` VALUES ('9704', 'Odin Cleaver', 'lrhand', 'true', '1650', '1', '1', 'adamantaite', 's', '751', '5', 'bigsword', '12', '-3.00000', '0', '0', '0', '293', '11', '132', '-1', '48800000', 2440, 'false', 'false', 'true', 'true', '3567', '1', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT 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', '48800000', 2440, 'false', 'false', 'true', 'true', '3565', '1', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT 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', '48800000', 2440, 'false', 'false', 'true', 'true', '3013', '4', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT 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', '48800000', 2440, 'false', 'false', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT 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', '48800000', 2440, 'false', 'false', 'true', 'true', '3047', '2', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT 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', '175', '-1', '48800000', 2440, 'false', 'false', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0'); INSERT 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', '48800000', 2440, 'false', 'false', 'true', 'true', '3076', '1', '0', '0', '0', '0', '0', '0', '0', '0'); Link to comment Share on other sites More sharing options...
0 Sillent Posted November 19, 2009 Share Posted November 19, 2009 Test it! 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;'), (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;'), (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;'), (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;'), ('9704', 'Odin Cleaver', 'lrhand', 'true', '1650', '1', '1', 'adamantaite', 's', '751', '5', 'bigsword', '12', '-3.00000', '0', '0', '0', '293',-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'), ('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;'), ('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;'), ('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;'), ('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;'), ('9709', 'Dual Medusa Blade', 'lrhand', 'true', '1300', '1', '1', 'adamantaite', 's', '310', '20', 'dual', '4', '4.00000', '0', '0', '0', '379', '0', '175',-1,-1,48800000,2440,'false','false','true','true','true',0,0,0,0,0,0,0,0,0,'0-0;'), ('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...
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