[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

 

 

[Flash™]

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

[angelos95]

ty man 8a to dokimasw . kapios alos gia ta wep ???

[angelos95]

to dokimasa ala kai pali error mu vgazei ... :'/

[Flash™]

file pes mou to id tou npc  kai ti  einai  to npc  na sou to ftia3o

[3xpl0it3R]

Min kaneis dipla post.reported..

 

Kai me tin L2JOfficial 8a exeis polla problimata.Apla pare L2JFree kai 8a perastoun ola.

[angelos95]

po re pali apo tn arxh.... dld na paw gia l2jArchid kalitera ??

[3xpl0it3R]

I L2jArchid einai c6, oxi ct2.3 .... kai den xreiazete na brizeis... kana edit to post sou, prin se dei kanenas kai fas -1 ..

[angelos95]

:S to kalitero pack gia C6 pio ine ?? gia ct2.3 ine o L2j free

[angelos95]

:S to kalitero pack gia C6 pio ine ?? gia ct2.3 ine o L2j free

[angelos95]

ohhh pff eleoC katala9os ekana double post ... kolaei to pc kamia fora kai paei 2 fores .., borw na svisw t 1 ???

[Sillent]

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!

[angelos95]

OMG dulepse !!! 1kkkkk ty re sillent ala mia xarh akoma..na mu ftiaksei kai ta ipolipa weps p postarw apo katw

[Sillent]

Γράψτα και στα κάνω...

[angelos95]

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');

 

[Sillent]

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;');