Thoorr Posted June 22, 2013 Share Posted June 22, 2013 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;'); Link to comment Share on other sites More sharing options...
0 Fanky Posted June 22, 2013 Share Posted June 22, 2013 the syntax is wrong. insert the values manually. Link to comment Share on other sites More sharing options...
0 Trance Posted June 22, 2013 Share Posted June 22, 2013 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. Link to comment Share on other sites More sharing options...
0 Trance Posted June 22, 2013 Share Posted June 22, 2013 in database no armor table :D Because on h5 everything is moved to xml. (/data/stats/items) You should convert them. Link to comment Share on other sites More sharing options...
Question
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;');
Link to comment
Share on other sites
3 answers to this question
Recommended Posts