Ir para conteúdo
  • Cadastre-se
  • 0

ADAPTAÇÃO DE WEAPON PARA FROZEN


IiIzeIiI

Pergunta

Alguem pode adaptar essa SQL para mim para JFrozen ? Obrigado desde já !!

 

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

(99991, 'Valakas Spear', 'lrhand', 'true', 2010, 1, 1, 'steel', 's', 363, 0, 'pole', 8, -3.00000, 0, 0, 0, 325, 0, 163, -1, 40600000, 1980, '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

(99992, 'Sword of Valakas', 'rhand', 'true', 1520, 1, 1, 'steel', 's', 353, 0, 'sword', 8, 0.00000, 0, 0, 0, 379, 0, 163, -1, 40600000, 1980, '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

(99993, 'Dagger of Valakas', 'rhand', 'true', 1520, 1, 1, 'steel', 's', 318, 0, 'dagger', 12, -3.00000, 0, 0, 0, 433, 0, 163, -1, 40600000, 1980, '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

(99994, 'Valakas Hammer', 'rhand', 'true', 1740, 1, 1, 'steel', 's', 353, 0, 'blunt', 4, 4.00000, 0, 0, 0, 379, 0, 163, -1, 40600000, 1980, '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

(99995, 'Two Handed Sword of Valakas', 'lrhand', 'true', 1740, 1, 1, 'steel', 's', 442, 0, 'bigsword', 8, 0.00000, 0, 0, 0, 325, 0, 163, -1, 40600000, 1980, '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

(99996, 'Bow of Valakas', 'lrhand', 'true', 1520, 1, 1, 'steel', 's', 689, 0, 'bow', 12, -3.00000, 0, 0, 0, 293, 9, 163, -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

(99997, 'Staff of Valakas', 'rhand', 'true', 1080, 1, 1, 'steel', 's', 290, 0, 'bigblunt', 4, 4.00000, 0, 0, 0, 379, 0, 217, -1, 40600000, 1980, '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

(99998, 'Valakas Fists', 'lrhand', 'true', 1550, 1, 1, 'steel', 's', 442, 0, 'dualfist', 4, 4.00000, 0, 0, 0, 325, 0, 163, -1, 40600000, 1980, '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

(99999, 'Dual of Valakas', 'lrhand', 'true', 1580, 1, 1, 'steel', 's', 442, 0, 'dual', 8, 0.00000, 0, 0, 0, 325, 0, 163, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

Vem que é sucesso !

Link para o comentário
Compartilhar em outros sites

3 respostass a esta questão

Posts recomendados

  • 0

Testa ai!

 

 

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
(99991, 'Valakas Spear', 'lrhand', 'true', 2010, 1, 1, 's', 363, 0, 'pole', 8, -3.00000, 0, 0, 0, 325, 0, 163, -1, 40600000, 1980, '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
(99992, 'Sword of Valakas', 'rhand', 'true', 1520, 1, 1, 's', 353, 0, 'sword', 8, 0.00000, 0, 0, 0, 379, 0, 163, -1, 40600000, 1980, '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
(99993, 'Dagger of Valakas', 'rhand', 'true', 1520, 1, 1, 's', 318, 0, 'dagger', 12, -3.00000, 0, 0, 0, 433, 0, 163, -1, 40600000, 1980, '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
(99994, 'Valakas Hammer', 'rhand', 'true', 1740, 1, 1, 's', 353, 0, 'blunt', 4, 4.00000, 0, 0, 0, 379, 0, 163, -1, 40600000, 1980, '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
(99995, 'Two Handed Sword of Valakas', 'lrhand', 'true', 1740, 1, 1, 's', 442, 0, 'bigsword', 8, 0.00000, 0, 0, 0, 325, 0, 163, -1, 40600000, 1980, '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
(99996, 'Bow of Valakas', 'lrhand', 'true', 1520, 1, 1, 's', 689, 0, 'bow', 12, -3.00000, 0, 0, 0, 293, 9, 163, -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
(99997, 'Staff of Valakas', 'rhand', 'true', 1080, 1, 1, 's', 290, 0, 'bigblunt', 4, 4.00000, 0, 0, 0, 379, 0, 217, -1, 40600000, 1980, '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
(99998, 'Valakas Fists', 'lrhand', 'true', 1550, 1, 1, 's', 442, 0, 'dualfist', 4, 4.00000, 0, 0, 0, 325, 0, 163, -1, 40600000, 1980, '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
(99999, 'Dual of Valakas', 'lrhand', 'true', 1580, 1, 1, 's', 442, 0, 'dual', 8, 0.00000, 0, 0, 0, 325, 0, 163, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

19028-361.gif

Link para o comentário
Compartilhar em outros sites


Visitante
Este tópico está impedido de receber novos posts.




×
×
  • 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.