Alas I myself do not understand anything in the server configuration, tried to add things myself on a regular interlude homeserver and got stuck at the first step. sql files are not added to the database through Navikat, on 2 different builds and different servers writes an error that the partition with this name in the table does not exist.
//
[SQL] Query armor start [ERR] 1146 - Table 'l2jmega1.armor' doesn't exist [ERR] INSERT INTO armor (item_id, name, bodypart, crystallizable, armor_type, weight, material, crystal_type, avoid_modify, duration, p_def, m_def, mp_bonus, price, crystal_count, sellable, dropable, destroyable, tradeable, item_skill_id, item_skill_lvl) VALUES (9391, 'bow_master_circlet', 'hair', 'false', 'none', 10, 'wood', 'none', 0, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 9391, 1); INSERT INTO armor (item_id, name, bodypart, crystallizable, armor_type, weight, material, crystal_type, avoid_modify, duration, p_def, m_def, mp_bonus, price, crystal_count, sellable, dropable, destroyable, tradeable, item_skill_id, item_skill_lvl) VALUES (9392, 'dagger_master_circlet', 'hair', 'false', 'none', 10, 'wood', 'none', 0, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 9392, 1); INSERT INTO armor (item_id, name, bodypart, crystallizable, armor_type, weight, material, crystal_type, avoid_modify, duration, p_def, m_def, mp_bonus, price, crystal_count, sellable, dropable, destroyable, tradeable, item_skill_id, item_skill_lvl) VALUES (9393, 'darkelf_circlet', 'hair', 'false', 'none', 10, 'wood', 'none', 0, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 9393, 1); INSERT INTO armor (item_id, name, bodypart, crystallizable, armor_type, weight, material, crystal_type, avoid_modify, duration, p_def, m_def, mp_bonus, price, crystal_count, sellable, dropable, destroyable, tradeable, item_skill_id, item_skill_lvl) VALUES (9394, 'darkelf_high_circlet', 'hair', 'false', 'none', 10, 'wood', 'none', 0, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 9394, 1); INSERT INTO armor (item_id, name, bodypart, crystallizable, armor_type, weight, material, crystal_type, avoid_modify, duration, p_def, m_def, mp_bonus, price, crystal_count, sellable, dropable, destroyable, tradeable, item_skill_id, item_skill_lvl) VALUES (9395, 'dwarf_circlet', 'hair', 'false', 'none', 10, 'wood', 'none', 0, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 9395, 1); INSERT INTO armor (item_id, name, bodypart, crystallizable, armor_type, weight, material, crystal_type, avoid_modify, duration, p_def, m_def, mp_bonus, price, crystal_count, sellable, dropable, destroyable, tradeable, item_skill_id, item_skill_lvl) VALUES (9396, 'dwarf_high_circlet', 'hair', 'false', 'none', 10, 'wood', 'none', 0, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 9396, 1); INSERT INTO armor (item_id, name, bodypart, crystallizable, armor_type, weight, material, crystal_type, avoid_modify, duration, p_def, m_def, mp_bonus, price, crystal_count, sellable, dropable, destroyable, tradeable, item_skill_id, item_skill_lvl) VALUES (9397, 'elf_circlet', 'hair', 'false', 'none', 10, 'wood', 'none', 0, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 9397, 1); INSERT INTO armor (item_id, name, bodypart, crystallizable, armor_type, weight, material, crystal_type, avoid_modify, duration, p_def, m_def, mp_bonus, price, crystal_count, sellable, dropable, destroyable, tradeable, item_skill_id, item_skill_lvl) VALUES (9398, 'elf_high_circlet', 'hair', 'false', 'none', 10, 'wood', 'none', 0, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 9398, 1); INSERT INTO armor (item_id, name, bodypart, crystallizable, armor_type, weight, material, crystal_type, avoid_modify, duration, p_def, m_def, mp_bonus, price, crystal_count, sellable, dropable, destroyable, tradeable, item_skill_id, item_skill_lvl) VALUES (9399, 'enchanter_circlet', 'hair', 'false', 'none', 10, 'wood', 'none', 0, -1, 0, 0, 0, 0, 0, 'true', 'true', 'true', 'true', 9399, 1); INSERT INTO armor (item_id, name, bodypart, crystallizable, [SQL] Finished with error
//
WHY:
Looking for someone who can customize the server la2 interlude (offline) and add there a package of things from La2world
I also want to have L2Autobots on the server.
At the end I want to get a “packaged” server and client, that would be able to download it all on any PC, unzip, start the server offline and play.
Immediately I say that before payment I want to see a video-demonstration of how everything works.
- L2Autobots - https://github.com/Elfocrash/L2Autobots
- Pack Armor and Weapon (la2world) for Interlude - https://disk.yandex.ru/d/D4pL-3nfVXwsU