Adaptando SQL para L2JFrozen

[OverMaster]

 

 

Acredito que não tem nada haver ,

rs

É só mudar a linha de lugar.

 

 

 

Pegue a linha do item que você quer adicionar no itemname-e, e modifique-a de lugar...

Bote logo depois da linha da Adena, que fica bem no inicio quando abre o itemname-e.dat !

 

Não sei sobre esse problema, comigo dificilmente da, procuro sempre itens de 4D

[WariinG]

 

Já é uma nova resolução, para um problema antigo.

rs

[tiquim123]

Aprendi a adptar Sql só algumas diferentes que é meio tenso mais vamo que vamo.

[romali]

a minha ta desse jeito aqui como que eu fasso pra deixar para l2jfrozen

 

 

INSERT INTO `armor` VALUES ('6657', 'Final Form Stone', 'hair', 'true', 'none', '570', 'fine_steel', 'none', '0', '-1', '0', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

[Bian]

a minha ta desse jeito aqui como que eu fasso pra deixar para l2jfrozen

 

 

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

[romali]

vlw por ajuda

[erikasilva]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''

('9711', 'Bow of Scion', 'lrhand', 'true', '1650', '1','1', 's', '581', '0' at line 3

[Err] INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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'

('9711', 'Bow of Scion', 'lrhand', 'true', '1650', '1','1', 's', '581', '0', 'bow', '0','-1.00000', '0', '0', '0', '0', '0', '0', '-1', '48800000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 

veio deu esse problema no meu, alguen podi me ajuda?

[erikasilva]

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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'

('9711', 'Bow of Scion', 'lrhand', 'true', 1650, '1','1', 's', '581', '0', 'bow', '0',' -1.00000', '0', '0', '0', '0', '0', '0', '-1', '48800000', '2440', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

('9712', 'Bow of Scion Epic-Cheap Shot', 'lrhand', 'true', 1650, 1, 1, 's', 581, 5, 'bow', 12, -3.00000, 0, 0, 0, 293, 11, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

('9713', 'Bow of Scion Epic-Focus', 'lrhand', 'true', 1650, 1, 1, 's', 581, 5, 'bow', 12, -3.00000, 0, 0, 0, 293, 11, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

('9714', 'Bow of Scion Epic-Crt. Slow', 'lrhand', 'true', 1650, 1, 1, 's', 581, 5, 'bow', 12, -3.00000, 0, 0, 0, 293, 11, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9715, 'Glint Eye', 'rhand', 'true', 970, 1, 1, 's', 318, 0, 'dagger', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9716, 'Glint Eye Epic-Focus', 'rhand', 'true', 970, 1, 1, 's', 318, 5,, 12, -3.00000, 0, 0, 0, 293, 11, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9717, 'Glint Eye Epic-Might Mortal', 'rhand', 'true', 970, 1, 1, 's', 318, 5, 'dagger', 12, -3.00000, 0, 0, 0, 433, 0, 99, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3035, 6, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9718, 'Glint Eye Epic-Haste', 'rhand', 'true', 970, 1, 1, 's', 318, 5, 'dagger', 12, -3.00000, 0, 0, 0, 433, 0, 68, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9719, 'Dual Gods Blade', 'lrhand', 'true', 2600, 1, 1, 's', 281, 0, 'dual', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9720, 'Dual Gods Blade Haste', 'lrhand', 'true', 2600, 2, 2, 's', 281, 10, 'dual', 8, -3.00000, 0, 0, 0, 379, 0, 132, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9721, 'Dual Gods Blade Health', 'lrhand', 'true', 2600, 2, 2, 's', 281, 10, 'dual', 8, -1.00000, 0, 0, 0, 379, 0, 132, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9722, 'Dual Gods Blade Focus', 'lrhand', 'true', 2600, 2, 2, 's', 281, 10, 'dual', 8, 0.00000, 0, 0, 0, 379, 0, 132, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9723, 'Sword of Templar', 'rhand', 'true', 1350, 1, 1, 's', 281, 0, 'sword', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9724, 'Sword of Templar Epic-Focus', 'rhand', 'true', 1350, 1, 1, 's', 281, 10, 'sword', 8, 0.00000, 0, 0, 0, 379, 0, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9725, 'Sword of Templar Epic-Haste', 'rhand', 'true', 1350, 1, 1, 's', 281, 10, 'sword', 8, 0.00000, 0, 0, 0, 379, 0, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9726, 'Sword of Templar Epic-Crt. Stun', 'rhand', 'true', 1350, 1, 1, 's', 281, 5, 'sword', 4, 4.00000, 0, 0, 0, 325, 0, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9727, 'Dual Dragon Slayer', 'lrhand', 'true', 4880, 2, 2, 's', 0, 0, 'dual', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

('9728', 'Ares Fists', 'lrhand', 'true', '1420', '1', '1', 's', '374', '5', 'dualfist', '4', '4.75000', '0', '0', '0', '325', '0', '152', '-1', '8680000', '1464', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9729, 'Dusk Sword Unique', 'rhand', 'true', 1670, 3, 3, 's', 170, 0, 'sword', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9730, 'Dusk Sword Unique Acumen', 'rhand', 'true', 1670, 3, 3, 's', 170, 20, 'sword', 4, 4.00000, 0, 0, 0, 379, 0, 143, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3047, 3, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9731, 'Dusk Sword Unique Empower', 'rhand', 'true', 1670, 3, 3, 's', 170, 10, 'sword', 8, 0.00000, 0, 0, 0, 379, 0, 143, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9732, 'Dusk Sword Unique Mana Up', 'rhand', 'true', 1670, 3, 3, 's', 170, 5, 'sword', 12, -3.00000, 0, 0, 0, 293, 9, 107, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3014, 2, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9733, 'Dusk Staff Unique', 'rhand', 'true', 1670, 3, 3, 's', 170, 0, 'sword', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9734, 'Dusk Staff Unique Acumen', 'rhand', 'true', 1670, 3, 3, 's', 170, 20, 'blunt', 4, 4.00000, 0, 0, 0, 379, 0, 143, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3047, 3, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9735, 'Dusk Staff Unique Empower', 'rhand', 'true', 1670, 3, 3, 's', 170, 10, 'blunt', 8, 0.00000, 0, 0, 0, 379, 0, 143, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9736, 'Dusk Staff Unique Mana Up', 'rhand', 'true', 1670, 3, 3, 's', 170, 5, 'blunt', 12, -3.00000, 0, 0, 0, 293, 9, 107, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3014, 2, 0, 0, 0, 0, 0, 0, 0, 0);

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `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

(9737, 'Dusk Shield Unique', 'lhand', 'true', 0, 0, 0, 's', 0, 0, 'none', 0, 0.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

 

 

 

 

como faço pra adpita esse aqui ?

[xSystemx]

Muito Oberigado Over.... Ajudo muito.. tava com a SQL do TT aki pra l2j mas nao consiguia roda na Frozen, graças ao o tuto eu consegui!! vlw mesmo (Y)

[biriu]

INSERT INTO `etcitem` VALUES ('15642', '15642', 'TOP Coin', 'false', 'none', '0', 'stackable', '', 'none', '-1', '100000', '0', 'true', 'false', 'true', 'true', 'Custom_Item', 'none');

INSERT INTO `etcitem` VALUES ('15643', '15643', 'Monster Coin', 'false', 'none', '0', 'stackable', '', 'none', '-1', '100000', '0', 'true', 'false', 'true', 'true', 'Custom_Item', 'none');

INSERT INTO `etcitem` VALUES ('15644', '15644', 'PvP Coin', 'false', 'none', '0', 'stackable', '', 'none', '-1', '100000', '0', 'true', 'false', 'true', 'true', 'Custom_Item', 'none');

INSERT INTO `etcitem` VALUES ('15645', '15645', 'Event Coin', 'false', 'none', '0', 'stackable', '', 'none', '-1', '100000', '0', 'true', 'false', 'true', 'true', 'Custom_Item', 'none');

INSERT INTO `etcitem` VALUES ('15646', '15646', 'RBC Coin', 'false', 'none', '0', 'stackable', '', 'none', '-1', '100000', '0', 'true', 'false', 'true', 'true', 'Custom_Item', 'none');

 

se tive condições de me ajuda eu agradeço , L2jbrasil ;D ''

[montero]

Obrigado Amigo vs me Ajudou Graças a vc consegui adptar o helmet rabo de cavalo no meu sever :)))

[shippuuden]

eu não to conseguindo adaptar esse set...

Dynasty Metal Green armor

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

Dynasty Metal Green weapons

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

alguem pode me ajudar a fazer essa adaptação pro frozen ?

[Leonardo Holanda]

 

 

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

 

 

 

 

 

O conteúdo está oculto, favor efetuar login ou se cadastrar!

• Entre
• ou
• Cadastre-se

 

 

Editado Abril 26, 2013 por BossForever

[PesteFeia]

eu tirei o Wood da sql , mais mesmo assim ainda n funfou , alguem me ajuda ?

 

INSERT INTO `armor` VALUES ('9534', 'Desert Eagle Helmet', 'head', 'false', 'none', '550','s', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9535', 'Desert Eagle Breastplate', 'chest', 'false', 'heavy', '7620','s', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9536', 'Desert Eagle Gaiters', 'legs', 'false', 'heavy', '3260','s', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9537', 'Desert Eagle Gloves', 'gloves', 'false', 'none', '540','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9538', 'Desert Eagle Boots', 'feet', 'false', 'none', '1110','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9539', 'Desert Eagle Leather', 'chest', 'false', 'light', '7620','s', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9540', 'Desert Eagle Leggings', 'legs', 'false', 'light', '3260','s', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9541', 'Desert Eagle Gloves', 'gloves', 'false', 'none', '540','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9542', 'Desert Eagle Boots', 'feet', 'false', 'none', '1110','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9543', 'Desert Eagle Tunic', 'chest', 'false', 'magic', '7620','s', '0', '-1', '219', '0', '257', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9544', 'Desert Eagle Stockings', 'legs', 'false', 'magic', '3260','s', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9545', 'Desert Eagle Gloves', 'gloves', 'false', 'none', '540','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

INSERT INTO `armor` VALUES ('9546', 'Desert Eagle Boots', 'feet', 'false', 'none', '1110','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

[Roger Martins]

e pra adaptar sql para criar um mob para frozen ?

[zSnow]

e pra adaptar sql para criar um mob para frozen ?

Só pegar uma SQL existente de algum outro mob da própria frozen. E mudar o ID

[Roger Martins]

Só pegar uma SQL existente de algum outro mob da própria frozen. E mudar o ID

obrigado!!

[ShadooW]

tentei mas ta dando esse erro aqui ainda ! T.T

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

(9711, 'Bow of Scion', 'lrhand', 'true', 1650, 1, 1, 's', 581, 0, 'bow', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9712, 'Bow of Scion Epic/Cheap Shot', 'lrhand', 'true', 1650, 1, 1, 's', 581, 5, 'bow', 12, -3.00000, 0, 0, 0, 293, 11, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9713, 'Bow of Scion Epic/Focus', 'lrhand', 'true', 1650, 1, 1, 's', 581, 5, 'bow', 12, -3.00000, 0, 0, 0, 293, 11, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9714, 'Bow of Scion Epic/Crt. Slow', 'lrhand', 'true', 1650, 1, 1, 's', 581, 5, 'bow', 12, -3.00000, 0, 0, 0, 293, 11, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9715, 'Glint Eye', 'rhand', 'true', 970, 1, 1, 's', 318, 0, 'dagger', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9716, 'Glint Eye Epic/Focus', 'rhand', 'true', 970, 1, 1, 's', 318, 5, 'dagger', 12, -3.00000, 0, 0, 0, 293, 11, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9717, 'Glint Eye Epic/Might Mortal', 'rhand', 'true', 970, 1, 1, 's', 318, 5, 'dagger', 12, -3.00000, 0, 0, 0, 433, 0, 99, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3035, 6, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9718, 'Glint Eye Epic/Haste', 'rhand', 'true', 970, 1, 1, 's', 318, 5, 'dagger', 12, -3.00000, 0, 0, 0, 433, 0, 68, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9719, 'Dual Gods Blade', 'lrhand', 'true', 2600, 1, 1, 's', 281, 0, 'dual', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9720, 'Dual Gods Blade Haste', 'lrhand', 'true', 2600, 2, 2, 's', 281, 10, 'dual', 8, -3.00000, 0, 0, 0, 379, 0, 132, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9721, 'Dual Gods Blade Health', 'lrhand', 'true', 2600, 2, 2, 's', 281, 10, 'dual', 8, -1.00000, 0, 0, 0, 379, 0, 132, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9722, 'Dual Gods Blade Focus', 'lrhand', 'true', 2600, 2, 2, 's', 281, 10, 'dual', 8, 0.00000, 0, 0, 0, 379, 0, 132, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9723, 'Sword of Templar', 'rhand', 'true', 1350, 1, 1, 's', 281, 0, 'sword', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9724, 'Sword of Templar Epic/Focus', 'rhand', 'true', 1350, 1, 1, 's', 281, 10, 'sword', 8, 0.00000, 0, 0, 0, 379, 0, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9725, 'Sword of Templar Epic/Haste', 'rhand', 'true', 1350, 1, 1, 's', 281, 10, 'sword', 8, 0.00000, 0, 0, 0, 379, 0, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9726, 'Sword of Templar Epic/Crt. Stun', 'rhand', 'true', 1350, 1, 1, 's', 281, 5, 'sword', 4, 4.00000, 0, 0, 0, 325, 0, 132, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9727, 'Dual Dragon Slayer', 'lrhand', 'true', 4880, 2, 2,'s', 0, 0, 'dual', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 97600000, 4880, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9729, 'Dusk Sword Unique', 'rhand', 'true', 1670, 3, 3, 's', 170, 0, 'sword', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9730, 'Dusk Sword Unique Acumen', 'rhand', 'true', 1670, 3, 3, 's', 170, 20, 'sword', 4, 4.00000, 0, 0, 0, 379, 0, 143, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3047, 3, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9731, 'Dusk Sword Unique Empower', 'rhand', 'true', 1670, 3, 3, 's', 170, 10, 'sword', 8, 0.00000, 0, 0, 0, 379, 0, 143, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9732, 'Dusk Sword Unique Mana Up', 'rhand', 'true', 1670, 3, 3, 's', 170, 5, 'sword', 12, -3.00000, 0, 0, 0, 293, 9, 107, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3014, 2, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9733, 'Dusk Staff Unique', 'rhand', 'true', 1670, 3, 3, 's', 170, 0, 'sword', 0, -1.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9734, 'Dusk Staff Unique Acumen', 'rhand', 'true', 1670, 3, 3, 's', 170, 20, 'blunt', 4, 4.00000, 0, 0, 0, 379, 0, 143, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3047, 3, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9735, 'Dusk Staff Unique Empower', 'rhand', 'true', 1670, 3, 3, 's', 170, 10, 'blunt', 8, 0.00000, 0, 0, 0, 379, 0, 143, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9736, 'Dusk Staff Unique Mana Up', 'rhand', 'true', 1670, 3, 3, 's', 170, 5, 'blunt', 12, -3.00000, 0, 0, 0, 293, 9, 107, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 3014, 2, 0, 0, 0, 0, 0, 0, 0, 0);

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

(9737, 'Dusk Shield Unique', 'lhand', 'true', 0, 0, 0, 'leather', 's', 0, 0, 'none', 0, 0.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

[OverMaster]

Em 06/09/2020 at 20:32, Agencia Dimes Design disse:

para adaptar sql para l2jdream mas atual como é sabe dizer?

Estou parado a anos com L2j em geral. Nem sei como esta a comunidade.

[Juniorceara]

Alguém podem me ajudar a fazer uma sql de drop pra Boss ...mais queria add apenas nos Boss de lvl 50 a 70 ... Alguém sabe como add apenas nesses lvl de Boss