Jump to content

Adaptando SQL para L2JFrozen


OverMaster

Recommended Posts

 

 

Acredito que não tem nada haver ,

rs

É só mudar a linha de lugar.

 

 

 

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

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

 

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

zDKDc.png

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

 

Skype: andrew_psycho_mk

MP não é tira dúvidas.

Link to comment
Share on other sites


  • 4 weeks later...

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

 

 

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

Link to comment
Share on other sites

  • 5 weeks later...

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

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

[Err] INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES'

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

[Msg] Finished - Unsuccessfully

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

 

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

Link to comment
Share on other sites

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES'

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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

 

 

 

 

como faço pra adpita esse aqui ?

Link to comment
Share on other sites

  • 2 weeks later...

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

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

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

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

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

 

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

Link to comment
Share on other sites

  • 1 month later...
  • 1 month later...
  • 2 years later...

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

 

INSERT INTO `armor` VALUES ('9534', 'Desert Eagle Helmet', 'head', 'false', 'none', '550','s', '0', '-1', '89', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9535', 'Desert Eagle Breastplate', 'chest', 'false', 'heavy', '7620','s', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9536', 'Desert Eagle Gaiters', 'legs', 'false', 'heavy', '3260','s', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9537', 'Desert Eagle Gloves', 'gloves', 'false', 'none', '540','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9538', 'Desert Eagle Boots', 'feet', 'false', 'none', '1110','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9539', 'Desert Eagle Leather', 'chest', 'false', 'light', '7620','s', '0', '-1', '219', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9540', 'Desert Eagle Leggings', 'legs', 'false', 'light', '3260','s', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9541', 'Desert Eagle Gloves', 'gloves', 'false', 'none', '540','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9542', 'Desert Eagle Boots', 'feet', 'false', 'none', '1110','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9543', 'Desert Eagle Tunic', 'chest', 'false', 'magic', '7620','s', '0', '-1', '219', '0', '257', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9544', 'Desert Eagle Stockings', 'legs', 'false', 'magic', '3260','s', '0', '-1', '137', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9545', 'Desert Eagle Gloves', 'gloves', 'false', 'none', '540','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
INSERT INTO `armor` VALUES ('9546', 'Desert Eagle Boots', 'feet', 'false', 'none', '1110','s', '0', '-1', '59', '0', '0', '0', '0', 'true', 'true', 'true', 'true', '0', '0');
Link to comment
Share on other sites

  • 5 months later...

e pra adaptar sql para criar um mob para frozen ?

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

  • Like 1

SJ9atJj.png


#Nunca Desista Dos Seus Sonhos !



Link to comment
Share on other sites

  • 1 year later...
tentei mas ta dando esse erro aqui ainda ! T.T


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

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


INSERT INTO weapon

(`item_id`, `name`, `bodypart`, `crystallizable`, `weight`, `soulshots`, `spiritshots`, `material`, `crystal_type`, `p_dam`, `rnd_dam`, `weaponType`, `critical`, `hit_modify`, `avoid_modify`, `shield_def`, `shield_def_rate`, `atk_speed`, `mp_consume`, `m_dam`, `duration`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `item_skill_id`, `item_skill_lvl`, `enchant4_skill_id`, `enchant4_skill_lvl`, `onCast_skill_id`, `onCast_skill_lvl`, `onCast_skill_chance`, `onCrit_skill_id`, `onCrit_skill_lvl`, `onCrit_skill_chance`)

VALUES

(9737, 'Dusk Shield Unique', 'lhand', 'true', 0, 0, 0, 'leather', 's', 0, 0, 'none', 0, 0.00000, 0, 0, 0, 0, 0, 0, -1, 48800000, 2440, 'true', 'true', 'true', 'true', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
Link to comment
Share on other 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 to comment
Share on other sites





×
×
  • Create New...

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.