Ir para conteúdo
  • Cadastre-se

Adaptando SQL para L2JFrozen


OverMaster

Posts recomendados

 

 

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 para o comentário
Compartilhar em outros 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 para o comentário
Compartilhar em outros 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 para o comentário
Compartilhar em outros 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 para o comentário
Compartilhar em outros 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 para o comentário
Compartilhar em outros 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 para o comentário
Compartilhar em outros 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 para o comentário
Compartilhar em outros 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');

 

 

Editado por BossForever
Link para o comentário
Compartilhar em outros 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 para o comentário
Compartilhar em outros 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

SJ9atJj.png


#Nunca Desista Dos Seus Sonhos !



Link para o comentário
Compartilhar em outros 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 para o comentário
Compartilhar em outros sites

  • 3 years 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 para o comentário
Compartilhar em outros sites

  • Registre-se

    Faça parte da maior e  mais antigas comunidades sobre Lineage2 da América Latina.





  • Patrocinadores

  • Quem Está Navegando

    • Nenhum usuário registrado visualizando esta página.
  • Posts

    • Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?     Teria como fazer do dusk shield e do zombie shield dessa maneira?    
    • muchas gracias muy lindos NPC 🙂
    • relaxa jovem gafanhoto, testa as quests. e posTa os erros indesejaveis.  
    • Se alguém pudesse me ensinar como codificar as missões, eu ficaria feliz em fazer isso sozinho ou pelo menos ajudar. Eu realmente quero jogar em um servidor onde todas as quests funcionem bem e melhor ainda se você puder fazer quests customizadas!
    • mas no interlude, nem todas as quests de class,  vai mostrar onde tem que ir, ate o reborn nao mostrava quando era interlude, só mostrou depois que eles colocaram client classic pra rodar, e ficou melhor ainda quando virou hellbound em diante, mas ha sim alguma chance de modificar isso direto no script para fazer igualmente, só basta te um pouco de paciencia e persistencia exato
    • 408_PathToElvenwizard dá Orion eu tive que mexer tbm, até modifiquei e consegui deixar ela igual do Classic, com a seta e a marcação no mapa. (não retail IL) Dá pra importar py de várias revs, o foda é que não da regular as quest py através do debug em tempo real, pelo menos eu não consegui rsrs
    • Hasta el momento todas las QUESTS son completables si te guias con un tutorial de youtube. El problema es que tienen bugs de locacion y de subquests que no avanzan o no te marcan correctamente a donde ir en el mapa, cosa que en Retail si se ve como corresponde.
    • estranho, mas pelo menos a galera nunca reclamo das quests quando tinha aberto 5x, geral fez class primeira e segunda job, poucos que compraram a class
    • en RUSaCis-3.5 data pack, las Quests estan en formato .java y son diferentes a como estan redactadas en jOrion y jFrozen 1.5 (ProyectX) package net.sf.l2j.gameserver.scripting.quest; import net.sf.l2j.commons.random.Rnd; import net.sf.l2j.gameserver.enums.Paperdoll; import net.sf.l2j.gameserver.enums.QuestStatus; import net.sf.l2j.gameserver.enums.actors.ClassId; import net.sf.l2j.gameserver.model.actor.Creature; import net.sf.l2j.gameserver.model.actor.Npc; import net.sf.l2j.gameserver.model.actor.Player; import net.sf.l2j.gameserver.network.serverpackets.SocialAction; import net.sf.l2j.gameserver.scripting.QuestState; public class Q224_TestOfSagittarius extends SecondClassQuest { private static final String QUEST_NAME = "Q224_TestOfSagittarius"; // Items private static final int BERNARD_INTRODUCTION = 3294; private static final int HAMIL_LETTER_1 = 3295; private static final int HAMIL_LETTER_2 = 3296; private static final int HAMIL_LETTER_3 = 3297; private static final int HUNTER_RUNE_1 = 3298; private static final int HUNTER_RUNE_2 = 3299; private static final int TALISMAN_OF_KADESH = 3300; private static final int TALISMAN_OF_SNAKE = 3301; private static final int MITHRIL_CLIP = 3302; private static final int STAKATO_CHITIN = 3303; private static final int REINFORCED_BOWSTRING = 3304; private static final int MANASHEN_HORN = 3305; private static final int BLOOD_OF_LIZARDMAN = 3306; private static final int CRESCENT_MOON_BOW = 3028; private static final int WOODEN_ARROW = 17; // Rewards private static final int MARK_OF_SAGITTARIUS = 3293; // NPCs private static final int BERNARD = 30702; private static final int HAMIL = 30626; private static final int SIR_ARON_TANFORD = 30653; private static final int VOKIAN = 30514; private static final int GAUEN = 30717; // Monsters private static final int ANT = 20079; private static final int ANT_CAPTAIN = 20080; private static final int ANT_OVERSEER = 20081; private static final int ANT_RECRUIT = 20082; private static final int ANT_PATROL = 20084; private static final int ANT_GUARD = 20086; private static final int NOBLE_ANT = 20089; private static final int NOBLE_ANT_LEADER = 20090; private static final int BREKA_ORC_SHAMAN = 20269; private static final int BREKA_ORC_OVERLORD = 20270; private static final int MARSH_STAKATO_WORKER = 20230; private static final int MARSH_STAKATO_SOLDIER = 20232; private static final int MARSH_STAKATO_DRONE = 20234; private static final int MARSH_SPIDER = 20233; private static final int ROAD_SCAVENGER = 20551; private static final int MANASHEN_GARGOYLE = 20563; private static final int LETO_LIZARDMAN = 20577; private static final int LETO_LIZARDMAN_ARCHER = 20578; private static final int LETO_LIZARDMAN_SOLDIER = 20579; private static final int LETO_LIZARDMAN_WARRIOR = 20580; private static final int LETO_LIZARDMAN_SHAMAN = 20581; private static final int LETO_LIZARDMAN_OVERLORD = 20582; private static final int SERPENT_DEMON_KADESH = 27090; public Q224_TestOfSagittarius() { super(224, "Test Of Sagittarius"); setItemsIds(BERNARD_INTRODUCTION, HAMIL_LETTER_1, HAMIL_LETTER_2, HAMIL_LETTER_3, HUNTER_RUNE_1, HUNTER_RUNE_2, TALISMAN_OF_KADESH, TALISMAN_OF_SNAKE, MITHRIL_CLIP, STAKATO_CHITIN, REINFORCED_BOWSTRING, MANASHEN_HORN, BLOOD_OF_LIZARDMAN, CRESCENT_MOON_BOW); addQuestStart(BERNARD); addTalkId(BERNARD, HAMIL, SIR_ARON_TANFORD, VOKIAN, GAUEN); addMyDying(ANT, ANT_CAPTAIN, ANT_OVERSEER, ANT_RECRUIT, ANT_PATROL, ANT_GUARD, NOBLE_ANT, NOBLE_ANT_LEADER, BREKA_ORC_SHAMAN, BREKA_ORC_OVERLORD, MARSH_STAKATO_WORKER, MARSH_STAKATO_SOLDIER, MARSH_STAKATO_DRONE, MARSH_SPIDER, ROAD_SCAVENGER, MANASHEN_GARGOYLE, LETO_LIZARDMAN, LETO_LIZARDMAN_ARCHER, LETO_LIZARDMAN_SOLDIER, LETO_LIZARDMAN_WARRIOR, LETO_LIZARDMAN_SHAMAN, LETO_LIZARDMAN_OVERLORD, SERPENT_DEMON_KADESH); } @Override public String onAdvEvent(String event, Npc npc, Player player) { String htmltext = event; QuestState st = player.getQuestList().getQuestState(QUEST_NAME); if (st == null) return htmltext; // BERNARD if (event.equalsIgnoreCase("30702-04.htm")) { st.setState(QuestStatus.STARTED); st.setCond(1); playSound(player, SOUND_ACCEPT); giveItems(player, BERNARD_INTRODUCTION, 1); if (giveDimensionalDiamonds39(player)) htmltext = "30702-04a.htm"; } // HAMIL else if (event.equalsIgnoreCase("30626-03.htm")) { st.setCond(2); playSound(player, SOUND_MIDDLE); takeItems(player, BERNARD_INTRODUCTION, 1); giveItems(player, HAMIL_LETTER_1, 1); } else if (event.equalsIgnoreCase("30626-07.htm")) { st.setCond(5); playSound(player, SOUND_MIDDLE); takeItems(player, HUNTER_RUNE_1, 10); giveItems(player, HAMIL_LETTER_2, 1); } // SIR_ARON_TANFORD else if (event.equalsIgnoreCase("30653-02.htm")) { st.setCond(3); playSound(player, SOUND_MIDDLE); takeItems(player, HAMIL_LETTER_1, 1); } // VOKIAN else if (event.equalsIgnoreCase("30514-02.htm")) { st.setCond(6); playSound(player, SOUND_MIDDLE); takeItems(player, HAMIL_LETTER_2, 1); } return htmltext; } @Override public String onTalk(Npc npc, Player player) { String htmltext = getNoQuestMsg(); QuestState st = player.getQuestList().getQuestState(QUEST_NAME); if (st == null) return htmltext; switch (st.getState()) { case CREATED: if (player.getClassId() != ClassId.ROGUE && player.getClassId() != ClassId.ELVEN_SCOUT && player.getClassId() != ClassId.ASSASSIN) htmltext = "30702-02.htm"; else if (player.getStatus().getLevel() < 39) htmltext = "30702-01.htm"; else htmltext = "30702-03.htm"; break; case STARTED: int cond = st.getCond(); switch (npc.getNpcId()) { case BERNARD: htmltext = "30702-05.htm"; break; case HAMIL: if (cond == 1) htmltext = "30626-01.htm"; else if (cond == 2 || cond == 3) htmltext = "30626-04.htm"; else if (cond == 4) htmltext = "30626-05.htm"; else if (cond > 4 && cond < 8) htmltext = "30626-08.htm"; else if (cond == 8) { htmltext = "30626-09.htm"; st.setCond(9); playSound(player, SOUND_MIDDLE); takeItems(player, HUNTER_RUNE_2, 10); giveItems(player, HAMIL_LETTER_3, 1); } else if (cond > 8 && cond < 12) htmltext = "30626-10.htm"; else if (cond == 12) { htmltext = "30626-11.htm"; st.setCond(13); playSound(player, SOUND_MIDDLE); } else if (cond == 13) htmltext = "30626-12.htm"; else if (cond == 14) { htmltext = "30626-13.htm"; takeItems(player, BLOOD_OF_LIZARDMAN, -1); takeItems(player, CRESCENT_MOON_BOW, 1); takeItems(player, TALISMAN_OF_KADESH, 1); giveItems(player, MARK_OF_SAGITTARIUS, 1); rewardExpAndSp(player, 54726, 20250); player.broadcastPacket(new SocialAction(player, 3)); playSound(player, SOUND_FINISH); st.exitQuest(false); } break; case SIR_ARON_TANFORD: if (cond == 2) htmltext = "30653-01.htm"; else if (cond > 2) htmltext = "30653-03.htm"; break; case VOKIAN: if (cond == 5) htmltext = "30514-01.htm"; else if (cond == 6) htmltext = "30514-03.htm"; else if (cond == 7) { htmltext = "30514-04.htm"; st.setCond(8); playSound(player, SOUND_MIDDLE); takeItems(player, TALISMAN_OF_SNAKE, 1); } else if (cond > 7) htmltext = "30514-05.htm"; break; case GAUEN: if (cond == 9) { htmltext = "30717-01.htm"; st.setCond(10); playSound(player, SOUND_MIDDLE); takeItems(player, HAMIL_LETTER_3, 1); } else if (cond == 10) htmltext = "30717-03.htm"; else if (cond == 11) { htmltext = "30717-02.htm"; st.setCond(12); playSound(player, SOUND_MIDDLE); takeItems(player, MANASHEN_HORN, 1); takeItems(player, MITHRIL_CLIP, 1); takeItems(player, REINFORCED_BOWSTRING, 1); takeItems(player, STAKATO_CHITIN, 1); giveItems(player, CRESCENT_MOON_BOW, 1); giveItems(player, WOODEN_ARROW, 10); } else if (cond > 11) htmltext = "30717-04.htm"; break; } break; case COMPLETED: htmltext = getAlreadyCompletedMsg(); break; } return htmltext; } @Override public void onMyDying(Npc npc, Creature killer) { final Player player = killer.getActingPlayer(); final QuestState st = checkPlayerState(player, npc, QuestStatus.STARTED); if (st == null) return; switch (npc.getNpcId()) { case ANT: case ANT_CAPTAIN: case ANT_OVERSEER: case ANT_RECRUIT: case ANT_PATROL: case ANT_GUARD: case NOBLE_ANT: case NOBLE_ANT_LEADER: if (st.getCond() == 3 && dropItems(player, HUNTER_RUNE_1, 1, 10, 500000)) st.setCond(4); break; case BREKA_ORC_SHAMAN: case BREKA_ORC_OVERLORD: if (st.getCond() == 6 && dropItems(player, HUNTER_RUNE_2, 1, 10, 500000)) { st.setCond(7); giveItems(player, TALISMAN_OF_SNAKE, 1); } break; case MARSH_STAKATO_WORKER: case MARSH_STAKATO_SOLDIER: case MARSH_STAKATO_DRONE: if (st.getCond() == 10 && dropItems(player, STAKATO_CHITIN, 1, 1, 100000) && player.getInventory().hasItems(MANASHEN_HORN, MITHRIL_CLIP, REINFORCED_BOWSTRING)) st.setCond(11); break; case MARSH_SPIDER: if (st.getCond() == 10 && dropItems(player, REINFORCED_BOWSTRING, 1, 1, 100000) && player.getInventory().hasItems(MANASHEN_HORN, MITHRIL_CLIP, STAKATO_CHITIN)) st.setCond(11); break; case ROAD_SCAVENGER: if (st.getCond() == 10 && dropItems(player, MITHRIL_CLIP, 1, 1, 100000) && player.getInventory().hasItems(MANASHEN_HORN, REINFORCED_BOWSTRING, STAKATO_CHITIN)) st.setCond(11); break; case MANASHEN_GARGOYLE: if (st.getCond() == 10 && dropItems(player, MANASHEN_HORN, 1, 1, 100000) && player.getInventory().hasItems(REINFORCED_BOWSTRING, MITHRIL_CLIP, STAKATO_CHITIN)) st.setCond(11); break; case LETO_LIZARDMAN: case LETO_LIZARDMAN_ARCHER: case LETO_LIZARDMAN_SOLDIER: case LETO_LIZARDMAN_WARRIOR: case LETO_LIZARDMAN_SHAMAN: case LETO_LIZARDMAN_OVERLORD: if (st.getCond() == 13) { if (((player.getInventory().getItemCount(BLOOD_OF_LIZARDMAN) - 120) * 5) > Rnd.get(100)) { playSound(player, SOUND_BEFORE_BATTLE); takeItems(player, BLOOD_OF_LIZARDMAN, -1); addSpawn(SERPENT_DEMON_KADESH, player, false, 300000, true); } else dropItemsAlways(player, BLOOD_OF_LIZARDMAN, 1, 0); } break; case SERPENT_DEMON_KADESH: if (st.getCond() == 13) { if (player.getInventory().getItemIdFrom(Paperdoll.RHAND) == CRESCENT_MOON_BOW) { st.setCond(14); playSound(player, SOUND_MIDDLE); giveItems(player, TALISMAN_OF_KADESH, 1); } else addSpawn(SERPENT_DEMON_KADESH, player, false, 300000, true); } break; } } }  
×
×
  • Criar Novo...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.