Tattoo H5

[Thoorr]

hi i have problem with add sql file can any help ?

 

 

<o><o><o>By Zealot Alias Hecko <o><o><o>

 

 

INSERT INTO `l2jgs`.`armor` (`item_id`, `name`, `bodypart`, `crystallizable`, `armor_type`, `weight`, `material`, `crystal_type`, `avoid_modify`, `duration`, `time`, `p_def`, `m_def`, `mp_bonus`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `enchant4_skill`, `skill`) VALUES ('91001', 'Tattoo of Flame', 'underwear', 'true', 'none', '800', 'dyestuff', 'b', '0', '-1', '-1', '139', '0', '0', '3470000', '463', 'true', 'true', 'true', 'true', '0-0', '0-0;');

INSERT INTO `l2jgs`.`armor` (`item_id`, `name`, `bodypart`, `crystallizable`, `armor_type`, `weight`, `material`, `crystal_type`, `avoid_modify`, `duration`, `time`, `p_def`, `m_def`, `mp_bonus`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `enchant4_skill`, `skill`) VALUES ('91002', 'Tattoo of Blood', 'underwear', 'true', 'none', '3800', 'dyestuff', 'a', '0', '-1', '-1', '132', '0', '0', '3470000', '278', 'true', 'true', 'true', 'true', '0-0', '0-0;');

INSERT INTO `l2jgs`.`armor` (`item_id`, `name`, `bodypart`, `crystallizable`, `armor_type`, `weight`, `material`, `crystal_type`, `avoid_modify`, `duration`, `time`, `p_def`, `m_def`, `mp_bonus`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `enchant4_skill`, `skill`) VALUES ('91003', 'Tattoo of Absolute', 'underwear', 'true', 'none', '800', 'dyestuff', 'a', '0', '-1', '-1', '146', '0', '0', '5280000', '422', 'true', 'true', 'true', 'true', '0-0', '0-0;');

INSERT INTO `l2jgs`.`armor` (`item_id`, `name`, `bodypart`, `crystallizable`, `armor_type`, `weight`, `material`, `crystal_type`, `avoid_modify`, `duration`, `time`, `p_def`, `m_def`, `mp_bonus`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `enchant4_skill`, `skill`) VALUES ('91004', 'Tattoo of Nightmarish', 'underwear', 'true', 'none', '4150', 'dyestuff', 'd', '0', '-1', '-1', '65', '0', '0', '99900', '182', 'true', 'true', 'true', 'true', '0-0', '0-0;');

INSERT INTO `l2jgs`.`armor` (`item_id`, `name`, `bodypart`, `crystallizable`, `armor_type`, `weight`, `material`, `crystal_type`, `avoid_modify`, `duration`, `time`, `p_def`, `m_def`, `mp_bonus`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `enchant4_skill`, `skill`) VALUES ('91005', 'Tattoo of Avadon', 'underwear', 'true', 'none', '4000', 'dyestuff', 'b', '0', '-1', '-1', '117', '0', '0', '1560000', '208', 'true', 'true', 'true', 'true', '0-0', '0-0;');

INSERT INTO `l2jgs`.`armor` (`item_id`, `name`, `bodypart`, `crystallizable`, `armor_type`, `weight`, `material`, `crystal_type`, `avoid_modify`, `duration`, `time`, `p_def`, `m_def`, `mp_bonus`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `enchant4_skill`, `skill`) VALUES ('91006', 'Tattoo of Doom', 'underwear', 'true', 'none', '4100', 'dyestuff', 'b', '0', '-1', '-1', '125', '0', '0', '2410000', '321', 'true', 'true', 'true', 'true', '0-0', '0-0;');

INSERT INTO `l2jgs`.`armor` (`item_id`, `name`, `bodypart`, `crystallizable`, `armor_type`, `weight`, `material`, `crystal_type`, `avoid_modify`, `duration`, `time`, `p_def`, `m_def`, `mp_bonus`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `enchant4_skill`, `skill`) VALUES ('91007', 'Tattoo of Pledge', 'underwear', 'true', 'none', '4000', 'dyestuff', 'b', '0', '-1', '-1', '124', '0', '0', '1560000', '208', 'true', 'true', 'true', 'true', '0-0', '0-0;');

INSERT INTO `l2jgs`.`armor` (`item_id`, `name`, `bodypart`, `crystallizable`, `armor_type`, `weight`, `material`, `crystal_type`, `avoid_modify`, `duration`, `time`, `p_def`, `m_def`, `mp_bonus`, `price`, `crystal_count`, `sellable`, `dropable`, `destroyable`, `tradeable`, `enchant4_skill`, `skill`) VALUES ('91008', 'Tattoo of Divine', 'underwear', 'true', 'none', '4100', 'dyestuff', 'b', '0', '-1', '-1', '131', '0', '0', '2410000', '321', 'true', 'true', 'true', 'true', '0-0', '0-0;');

[Fanky]

the syntax is wrong.

 

insert the values manually.

[Trance]

yes and where add manualy ?

 

Check armor from database. You can take an example from there and editing it with the current values.

This is how you can adapt it.

[Trance]

in database no armor table :D

 

Because on h5 everything is moved to xml. (/data/stats/items)

You should convert them.