Jump to content

12 Anos Online! 🎂


⭐ Parcerias





⚔️ Servers Apoiadores



🎁 Ofertas







Adaptando SQL para L2JFrozen


Recommended Posts

 

 

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

zDKDc.png

"Viver é enfrentar um problema atrás do outro. O modo como você os encara é que faz a diferença."

 

Skype: andrew_psycho_mk

MP não é tira dúvidas.

Link to post
Share on other sites
  • 4 weeks later...

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

Link to post
Share on other sites

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', 'none', '0', '-1', '0', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');

Link to post
Share on other sites
  • 5 weeks later...

[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?

Link to post
Share on other sites

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 ?

Link to post
Share on other sites
  • 2 weeks later...

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

Link to post
Share on other sites
  • 1 month later...
  • 1 month later...

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

Dynasty Metal Green armor

INSERT INTO `armor` VALUES ('9705', 'Dynasty Metal Green Plate', 'chest', 'false', 'heavy', '0', 'wood', 's', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9706', 'Dynasty Metal Green Gaiters', 'legs', 'false', 'heavy', '0', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9707', 'Dynasty Metal Green Helm', 'head', 'false', 'none', '0', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9708', 'Dynasty Metal Green Gloves', 'gloves', 'false', 'none', '0', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9709', 'Dynasty Metal Green Boots', 'feet', 'false', 'none', '0', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9710', 'Dynasty Metal Green Leather', 'chest', 'false', 'light', '0', 'wood', 's', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9711', 'Dynasty Metal Green Leather Pants', 'legs', 'false', 'light', '0', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9712', 'Dynasty Metal Green Leather Helm', 'head', 'false', 'none', '0', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9713', 'Dynasty Metal Green Leather Gloves', 'gloves', 'false', 'none', '0', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9714', 'Dynasty Metal Green Leather Shoes', 'feet', 'false', 'none', '0', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9715', 'Dynasty Metal Green Robe', 'chest', 'false', 'magic', '0', 'wood', 's', '0', '-1', '219', '0', '257', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9716', 'Dynasty Metal Green Pants', 'legs', 'false', 'magic', '0', 'wood', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9717', 'Dynasty Metal Green Cap', 'head', 'false', 'none', '0', 'wood', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9718', 'Dynasty Metal Green Mittens', 'gloves', 'false', 'none', '0', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9719', 'Dynasty Metal Green Slippers', 'feet', 'false', 'none', '0', 'wood', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9720', 'Dynasty Metal Green Helmet', 'hair', 'false', 'none', '10', 'steel', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');
INSERT INTO `armor` VALUES ('9721', 'Dynasty Metal Green Mantra', 'hair', 'false', 'none', '10', 'steel', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');
INSERT INTO `armor` VALUES ('9722', 'Dynasty Metal Green Wing', 'face', 'false', 'none', '10', 'steel', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');
INSERT INTO `armor` VALUES ('9723', 'Dynasty Metal Green Wing shok', 'face', 'false', 'none', '10', 'steel', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');
INSERT INTO `armor` VALUES ('9724', 'Dynasty Metal Green New Helmet', 'dhair', 'false', 'none', '10', 'steel', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');

Dynasty Metal Green weapons

INSERT INTO `weapon` VALUES ('9400', 'Dynasty Metal Green Rapier', 'rhand', 'true', '0', '1', '1', 'steel', 's', '278', '1', 'sword', '12', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9401', 'Dynasty Metal Green Rapier - Focus', 'rhand', 'true', '0', '1', '1', 'steel', 's', '278', '1', 'sword', '12', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9402', 'Dynasty Metal Green Rapier - Health', 'rhand', 'true', '0', '1', '1', 'steel', 's', '278', '1', 'sword', '12', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9403', 'Dynasty Metal Green Rapier - Light', 'rhand', 'true', '0', '1', '1', 'steel', 's', '278', '1', 'sword', '12', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9404', 'Dynasty Metal Green Ancient Sword', 'lrhand', 'true', '0', '1', '1', 'steel', 's', '332', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9405', 'Dynasty Metal Green Ancient Sword - Focus', 'lrhand', 'true', '0', '1', '1', 'steel', 's', '332', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9406', 'Dynasty Metal Green Ancient Sword - Health', 'lrhand', 'true', '0', '1', '1', 'steel', 's', '332', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9407', 'Dynasty Metal Green Ancient Sword - Light', 'lrhand', 'true', '0', '1', '1', 'steel', 's', '332', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9408', 'Dynasty Metal Green Crossbow', 'lrhand', 'true', '0', '1', '1', 'bone', 's', '389', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9409', 'Dynasty Metal Green Crossbow - Cheap Shot', 'lrhand', 'true', '0', '1', '1', 'bone', 's', '389', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9410', 'Dynasty Metal Green Crossbow - Guidance', 'lrhand', 'true', '0', '1', '1', 'bone', 's', '389', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3064', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9411', 'Dynasty Metal Green Crossbow - Evasion', 'lrhand', 'true', '0', '1', '1', 'bone', 's', '389', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3009', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9412', 'Dynasty Metal Green Shield', 'lhand', 'false', '0', '0', '0', 'bone', 'none', '0', '0', 'none', '0', '0.00000', '-8', '310', '20', '0', '0', '0', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9413', 'Dynasty Metal Green Shield - Evasion', 'lhand', 'true', '0', '0', '0', 'bone', 's', '0', '0', 'none', '0', '0.00000', '-8', '310', '20', '0', '0', '0', '-1', '0', '0', 'true', 'true', 'true', 'true', '3009', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9414', 'Dynasty Metal Green Blade', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9415', 'Dynasty Metal Green Blade - Focus', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9416', 'Dynasty Metal Green Blade - Health', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9417', 'Dynasty Metal Green Blade - Light', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9418', 'Dynasty Metal Green Two Handed Sword', 'lrhand', 'true', '0', '1', '1', 'mithril', 's', '374', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9419', 'Dynasty Metal Green Two Handed Sword - Focus', 'lrhand', 'true', '0', '1', '1', 'mithril', 's', '374', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9420', 'Dynasty Metal Green Two Handed Sword - Health', 'lrhand', 'true', '0', '1', '1', 'mithril', 's', '374', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9421', 'Dynasty Metal Green Two Handed Sword - Light', 'lrhand', 'true', '0', '1', '1', 'mithril', 's', '374', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9422', 'Dynasty Metal Green Magic Sword', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '246', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9423', 'Dynasty Metal Green Magic Sword - Acumen', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '246', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3047', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9424', 'Dynasty Metal Green Magic Sword - Mana Up', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '246', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3014', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9425', 'Dynasty Metal Green Magic Sword - Conversion', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '246', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3048', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9426', 'Dynasty Metal Green Bow', 'lrhand', 'true', '0', '1', '1', 'bone', 's', '634', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9427', 'Dynasty Metal Green Bow - Cheap Shot', 'lrhand', 'true', '0', '1', '1', 'bone', 's', '634', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9428', 'Dynasty Metal Green Bow - Guidance', 'lrhand', 'true', '0', '1', '1', 'bone', 's', '634', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3064', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9429', 'Dynasty Metal Green Bow - Evasion', 'lrhand', 'true', '0', '1', '1', 'bone', 's', '634', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3009', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9430', 'Dynasty Metal Green Dagger', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '269', '1', 'dagger', '12', '-9.99999', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9431', 'Dynasty Metal Green Dagger - Focus', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '269', '1', 'dagger', '12', '-9.99999', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9432', 'Dynasty Metal Green Dagger - Evasion', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '269', '1', 'dagger', '12', '-9.99999', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3009', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9433', 'Dynasty Metal Green Dagger - Critical Damage', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '269', '1', 'dagger', '12', '-9.99999', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3023', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9434', 'Dynasty Metal Green Spear', 'lrhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'pole', '8', '-9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9435', 'Dynasty Metal Green Spear - Anger', 'lrhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'pole', '8', '-9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3012', '4', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9436', 'Dynasty Metal Green Spear - Critical Stun', 'lrhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'pole', '8', '-9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3016', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9437', 'Dynasty Metal Green Spear - Light', 'lrhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'pole', '8', '-9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9438', 'Dynasty Metal Green Hammer', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'blunt', '4', '9.99999', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9439', 'Dynasty Metal Green Hammer - Anger', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'blunt', '4', '9.99999', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3012', '4', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9440', 'Dynasty Metal Green Hammer - Health', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'blunt', '4', '9.99999', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9441', 'Dynasty Metal Green Hammer - Risk Focus', 'rhand', 'true', '0', '1', '1', 'mithril', 's', '307', '1', 'blunt', '4', '9.99999', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3027', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9442', 'Dynasty Metal Green Staff', 'rhand', 'true', '0', '1', '1', 'bone', 's', '299', '1', 'bigblunt', '4', '9.99999', '0', '0', '0', '325', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9443', 'Dynasty Metal Green Staff - Mana Up', 'rhand', 'true', '0', '1', '1', 'bone', 's', '299', '1', 'bigblunt', '4', '9.99999', '0', '0', '0', '325', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3014', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9444', 'Dynasty Metal Green Staff - Conversion', 'rhand', 'true', '0', '1', '1', 'bone', 's', '299', '1', 'bigblunt', '4', '9.99999', '0', '0', '0', '325', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3048', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9445', 'Dynasty Metal Green Staff - Acumen', 'rhand', 'true', '0', '1', '1', 'bone', 's', '299', '1', 'bigblunt', '4', '9.99999', '0', '0', '0', '325', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3047', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9446', 'Dynasty Metal Green Fist', 'lrhand', 'true', '0', '1', '1', 'adamantaite', 's', '374', '1', 'dualfist', '4', '9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9447', 'Dynasty Metal Green Fist - Risk Haste', 'lrhand', 'true', '0', '1', '1', 'adamantaite', 's', '374', '1', 'dualfist', '4', '9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3032', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9448', 'Dynasty Metal Green Fist - Risk Evasion', 'lrhand', 'true', '0', '1', '1', 'adamantaite', 's', '374', '1', 'dualfist', '4', '9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3028', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9449', 'Dynasty Metal Green Fist - Haste', 'lrhand', 'true', '0', '1', '1', 'adamantaite', 's', '374', '1', 'dualfist', '4', '9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3036', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9450', 'Dynasty Metal Green Dual ', 'lrhand', 'true', '0', '1', '1', 'adamantaite', 's', '562', '10', 'dual', '8', '0.00000', '0', '0', '0', '325', '0', '160', '-1', '0', '1927', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

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

16li3w5.jpg
Link to post
Share on other sites

 

 

INSERT INTO `armor` VALUES ('9705', 'Dynasty Metal Green Plate', 'chest', 'false', 'heavy', '0', 's', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9706', 'Dynasty Metal Green Gaiters', 'legs', 'false', 'heavy', '0', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9707', 'Dynasty Metal Green Helm', 'head', 'false', 'none', '0', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9708', 'Dynasty Metal Green Gloves', 'gloves', 'false', 'none', '0', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9709', 'Dynasty Metal Green Boots', 'feet', 'false', 'none', '0', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9710', 'Dynasty Metal Green Leather', 'chest', 'false', 'light', '0', 's', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9711', 'Dynasty Metal Green Leather Pants', 'legs', 'false', 'light', '0', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9712', 'Dynasty Metal Green Leather Helm', 'head', 'false', 'none', '0', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9713', 'Dynasty Metal Green Leather Gloves', 'gloves', 'false', 'none', '0', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9714', 'Dynasty Metal Green Leather Shoes', 'feet', 'false', 'none', '0', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9715', 'Dynasty Metal Green Robe', 'chest', 'false', 'magic', '0', 's', '0', '-1', '219', '0', '257', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9716', 'Dynasty Metal Green Pants', 'legs', 'false', 'magic', '0', 's', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9717', 'Dynasty Metal Green Cap', 'head', 'false', 'none', '0', 's', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9718', 'Dynasty Metal Green Mittens', 'gloves', 'false', 'none', '0', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9719', 'Dynasty Metal Green Slippers', 'feet', 'false', 'none', '0', 's', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9720', 'Dynasty Metal Green Helmet', 'hair', 'false', 'none', '10', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');
INSERT INTO `armor` VALUES ('9721', 'Dynasty Metal Green Mantra', 'hair', 'false', 'none', '10', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');
INSERT INTO `armor` VALUES ('9722', 'Dynasty Metal Green Wing', 'face', 'false', 'none', '10', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');
INSERT INTO `armor` VALUES ('9723', 'Dynasty Metal Green Wing shok', 'face', 'false', 'none', '10', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');
INSERT INTO `armor` VALUES ('9724', 'Dynasty Metal Green New Helmet', 'dhair', 'false', 'none', '10', 'none', '0', '-1', '0', '0', '0', '0', '0', 'false', 'true', 'true', 'false', '0', '0');

 

 

 

 

 

INSERT INTO `weapon` VALUES ('9400', 'Dynasty Metal Green Rapier', 'rhand', 'true', '0', '1', '1', 's', '278', '1', 'sword', '12', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9401', 'Dynasty Metal Green Rapier - Focus', 'rhand', 'true', '0', '1', '1', 's', '278', '1', 'sword', '12', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9402', 'Dynasty Metal Green Rapier - Health', 'rhand', 'true', '0', '1', '1', 's', '278', '1', 'sword', '12', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9403', 'Dynasty Metal Green Rapier - Light', 'rhand', 'true', '0', '1', '1', 's', '278', '1', 'sword', '12', '0.00000', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9404', 'Dynasty Metal Green Ancient Sword', 'lrhand', 'true', '0', '1', '1', 's', '332', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9405', 'Dynasty Metal Green Ancient Sword - Focus', 'lrhand', 'true', '0', '1', '1', 's', '332', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9406', 'Dynasty Metal Green Ancient Sword - Health', 'lrhand', 'true', '0', '1', '1', 's', '332', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9407', 'Dynasty Metal Green Ancient Sword - Light', 'lrhand', 'true', '0', '1', '1', 's', '332', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9408', 'Dynasty Metal Green Crossbow', 'lrhand', 'true', '0', '1', '1', 's', '389', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9409', 'Dynasty Metal Green Crossbow - Cheap Shot', 'lrhand', 'true', '0', '1', '1', 's', '389', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9410', 'Dynasty Metal Green Crossbow - Guidance', 'lrhand', 'true', '0', '1', '1', 's', '389', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3064', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9411', 'Dynasty Metal Green Crossbow - Evasion', 'lrhand', 'true', '0', '1', '1', 's', '389', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3009', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9412', 'Dynasty Metal Green Shield', 'lhand', 'false', '0', '0', '0', 'none', '0', '0', 'none', '0', '0.00000', '-8', '310', '20', '0', '0', '0', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9413', 'Dynasty Metal Green Shield - Evasion', 'lhand', 'true', '0', '0', '0', 's', '0', '0', 'none', '0', '0.00000', '-8', '310', '20', '0', '0', '0', '-1', '0', '0', 'true', 'true', 'true', 'true', '3009', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9414', 'Dynasty Metal Green Blade', 'rhand', 'true', '0', '1', '1', 's', '307', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9415', 'Dynasty Metal Green Blade - Focus', 'rhand', 'true', '0', '1', '1', 's', '307', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9416', 'Dynasty Metal Green Blade - Health', 'rhand', 'true', '0', '1', '1', 's', '307', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9417', 'Dynasty Metal Green Blade - Light', 'rhand', 'true', '0', '1', '1', 's', '307', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9418', 'Dynasty Metal Green Two Handed Sword', 'lrhand', 'true', '0', '1', '1', 's', '374', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9419', 'Dynasty Metal Green Two Handed Sword - Focus', 'lrhand', 'true', '0', '1', '1', 's', '374', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9420', 'Dynasty Metal Green Two Handed Sword - Health', 'lrhand', 'true', '0', '1', '1', 's', '374', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9421', 'Dynasty Metal Green Two Handed Sword - Light', 'lrhand', 'true', '0', '1', '1', 's', '374', '1', 'bigsword', '8', '0.00000', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9422', 'Dynasty Metal Green Magic Sword', 'rhand', 'true', '0', '1', '1', 's', '246', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9423', 'Dynasty Metal Green Magic Sword - Acumen', 'rhand', 'true', '0', '1', '1', 's', '246', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3047', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9424', 'Dynasty Metal Green Magic Sword - Mana Up', 'rhand', 'true', '0', '1', '1', 's', '246', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3014', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9425', 'Dynasty Metal Green Magic Sword - Conversion', 'rhand', 'true', '0', '1', '1', 's', '246', '1', 'sword', '12', '0.00000', '0', '0', '0', '379', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3048', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9426', 'Dynasty Metal Green Bow', 'lrhand', 'true', '0', '1', '1', 's', '634', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9427', 'Dynasty Metal Green Bow - Cheap Shot', 'lrhand', 'true', '0', '1', '1', 's', '634', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9428', 'Dynasty Metal Green Bow - Guidance', 'lrhand', 'true', '0', '1', '1', 's', '634', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3064', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9429', 'Dynasty Metal Green Bow - Evasion', 'lrhand', 'true', '0', '1', '1', 's', '634', '1', 'bow', '12', '-9.99999', '0', '0', '0', '293', '9', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3009', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9430', 'Dynasty Metal Green Dagger', 'rhand', 'true', '0', '1', '1', 's', '269', '1', 'dagger', '12', '-9.99999', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9431', 'Dynasty Metal Green Dagger - Focus', 'rhand', 'true', '0', '1', '1', 's', '269', '1', 'dagger', '12', '-9.99999', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3050', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9432', 'Dynasty Metal Green Dagger - Evasion', 'rhand', 'true', '0', '1', '1', 's', '269', '1', 'dagger', '12', '-9.99999', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3009', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9433', 'Dynasty Metal Green Dagger - Critical Damage', 'rhand', 'true', '0', '1', '1', 's', '269', '1', 'dagger', '12', '-9.99999', '0', '0', '0', '433', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3023', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9434', 'Dynasty Metal Green Spear', 'lrhand', 'true', '0', '1', '1', 's', '307', '1', 'pole', '8', '-9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9435', 'Dynasty Metal Green Spear - Anger', 'lrhand', 'true', '0', '1', '1', 's', '307', '1', 'pole', '8', '-9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3012', '4', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9436', 'Dynasty Metal Green Spear - Critical Stun', 'lrhand', 'true', '0', '1', '1', 's', '307', '1', 'pole', '8', '-9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3016', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9437', 'Dynasty Metal Green Spear - Light', 'lrhand', 'true', '0', '1', '1', 's', '307', '1', 'pole', '8', '-9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '1257', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9438', 'Dynasty Metal Green Hammer', 'rhand', 'true', '0', '1', '1', 's', '307', '1', 'blunt', '4', '9.99999', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9439', 'Dynasty Metal Green Hammer - Anger', 'rhand', 'true', '0', '1', '1', 's', '307', '1', 'blunt', '4', '9.99999', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3012', '4', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9440', 'Dynasty Metal Green Hammer - Health', 'rhand', 'true', '0', '1', '1', 's', '307', '1', 'blunt', '4', '9.99999', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3013', '1', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9441', 'Dynasty Metal Green Hammer - Risk Focus', 'rhand', 'true', '0', '1', '1', 's', '307', '1', 'blunt', '4', '9.99999', '0', '0', '0', '379', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3027', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9442', 'Dynasty Metal Green Staff', 'rhand', 'true', '0', '1', '1', 's', '299', '1', 'bigblunt', '4', '9.99999', '0', '0', '0', '325', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9443', 'Dynasty Metal Green Staff - Mana Up', 'rhand', 'true', '0', '1', '1', 's', '299', '1', 'bigblunt', '4', '9.99999', '0', '0', '0', '325', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3014', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9444', 'Dynasty Metal Green Staff - Conversion', 'rhand', 'true', '0', '1', '1', 's', '299', '1', 'bigblunt', '4', '9.99999', '0', '0', '0', '325', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3048', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9445', 'Dynasty Metal Green Staff - Acumen', 'rhand', 'true', '0', '1', '1', 's', '299', '1', 'bigblunt', '4', '9.99999', '0', '0', '0', '325', '0', '186', '-1', '0', '0', 'true', 'true', 'true', 'true', '3047', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9446', 'Dynasty Metal Green Fist', 'lrhand', 'true', '0', '1', '1', 's', '374', '1', 'dualfist', '4', '9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9447', 'Dynasty Metal Green Fist - Risk Haste', 'lrhand', 'true', '0', '1', '1', 's', '374', '1', 'dualfist', '4', '9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3032', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9448', 'Dynasty Metal Green Fist - Risk Evasion', 'lrhand', 'true', '0', '1', '1', 's', '374', '1', 'dualfist', '4', '9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3028', '2', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9449', 'Dynasty Metal Green Fist - Haste', 'lrhand', 'true', '0', '1', '1', 's', '374', '1', 'dualfist', '4', '9.99999', '0', '0', '0', '325', '0', '140', '-1', '0', '0', 'true', 'true', 'true', 'true', '3036', '3', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `weapon` VALUES ('9450', 'Dynasty Metal Green Dual ', 'lrhand', 'true', '0', '1', '1', 's', '562', '10', 'dual', '8', '0.00000', '0', '0', '0', '325', '0', '160', '-1', '0', '1927', 'true', 'true', 'true', 'true', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

 

 

Edited by BossForever
Link to post
Share on other sites
  • 2 years later...

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');
Link to post
Share on other sites
  • 5 months later...

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

  • Like 1

SJ9atJj.png


#Nunca Desista Dos Seus Sonhos !



Link to post
Share on other sites
  • 1 year later...
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);
Link to post
Share on other sites
  • 3 years later...
  • 5 months later...
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.

zDKDc.png

"Viver é enfrentar um problema atrás do outro. O modo como você os encara é que faz a diferença."

 

Skype: andrew_psycho_mk

MP não é tira dúvidas.

Link to post
Share on other sites
×
×
  • Create New...