Jump to content
  • 0

Help to add La2world pack to home server


Jimbo24

Question

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

Link to comment
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.



×
×
  • Create New...