Смена зборки l2jserver l2emu gracia p2

[APKO]

Вопрос какие именно базы нада перетажить?

[Redvain]

Извините, у меня парсилка в мозгу клинит от слова зборка.
Не понятно, откуда и куда вы собрались перетажиться, с какой ревизиии на какую.
Открываете тот же навикат, и сравниватее следующие таблички последовательно:

Код:

accounts, castle, castle_functions, character_friends, character_hennas, character_quest_global_data, character_quests, character_raid_points, character_recipebook, character_skills, character_skills_save, character_subclasses, characters, clan_data, clan_skills, clanhall, clanhall_functions, fort, fort_functions, fortsiege_clans, items, olympiad_data, olympiad_nobles, olympiad_nobles_eom, pets;

[APKO]

l2jserver rev 5776 на l2dream v26

[Redvain]

А в заголовке темы вообще l2emu.
Сравнивайте таблички, и переносите вручную.

[arivano]

Проблема не только в сравнении таблиц, вернее полей в них, а и в значениях. К примеру я желаю перейти с L2jfree на l2jserver и в сборках значение поля accesslevel разные (L2jfree GM - 100, Lj2server GM - 1). Так что сравнивать придется внимательнее. Сам только начал, надеюсь, это единственная значимая разница.

[PROGRAMMATOR]

Я думаю у вас на сервере не 1000 Гм-ов, так что это все не настолько важно. Важно что бы вещи, кланы, замки, животные персонажей и сами персонажи, остались на своих местах.

[arivano]

Совершенно точно. Просто одно расхождение наталкивает на мысль в разнице значений и в другом, что уже может создать большую проблему, чем сменить 100 на 1 в уровне доступа.

[arivano]

На днях перевел сервер с L2JFree Part II на L2JServer Final
Вот скрипт, которым переносил данные:

Код:

delete from accounts;
insert into accounts (login, password, lastactive, accesslevel, lastip, lastserver) select login, password, lastactive, 0, lastip, lastserverid from accounts_copy;
delete from character_friends;
insert into character_friends select * from character_friends_copy;
delete from item_attributes;
insert into item_attributes(itemid, augattributes, augskillid, augskilllevel) select item_id, attributes, skill, level from augmentations;
delete from character_hennas;
insert into character_hennas select * from character_hennas_copy;
delete from character_macroses;
insert into character_macroses select * from character_macroses_copy;
delete from character_quests;
insert into character_quests select * from character_quests_copy;
delete from character_raid_points;
insert into character_raid_points select * from character_raid_points_copy;
delete from character_recipebook;
insert into character_recipebook(charid, id, type) select charid, id, type from character_recipebook_copy;
delete from character_recommends;
insert into character_recommends select * from character_recommends_copy;
delete from character_shortcuts;
insert into character_shortcuts select * from character_shortcuts_copy;
delete from character_skills;
insert into character_skills select * from character_skills_copy;
delete from character_skills_save;
insert into character_skills_save select * from character_skills_save_copy;
delete from character_subclasses;
insert into character_subclasses select * from character_subclasses_copy;
delete from characters;
insert into characters(account_name, charid, char_name, level, maxhp, curhp, maxcp, curcp, maxmp, curmp, face, hairstyle, haircolor, sex, heading, x, y, z, exp, expbeforedeath, sp, karma, fame, pvpkills, pkkills, clanid, race, classid, base_class, transform_id, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, onlinetime, char_slot, newbie, lastaccess, clan_privs, wantspeace, isin7sdungeon, punish_level, punish_timer, power_grade, nobless, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally, clan_join_expiry_time, clan_create_expiry_time, death_penalty_level, bookmarkslot)
select account_name, charid, char_name, level, maxhp, curhp, maxcp, curcp, maxmp, curmp, face,  hairstyle, haircolor, sex, heading, x, y, z, exp, expbeforedeath, sp, karma, 0, pvpkills, pkkills, clanid, race, classid, base_class, transform_id, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, onlinetime, char_slot, newbie, lastaccess, clan_privs, wantspeace, isin7sdungeon, in_jail, jail_timer, 0, nobless, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally, clan_join_expiry_time, clan_create_expiry_time, death_penalty_level, 0   from characters_copy;
delete from clan_data;
insert into clan_data(clan_id, clan_name, clan_level, reputation_score, hascastle, ally_id, ally_name, leader_id, crest_id, crest_large_id, ally_crest_id, auction_bid_at, ally_penalty_expiry_time, ally_penalty_type, char_penalty_expiry_time, dissolving_expiry_time)
select clan_id, clan_name, clan_level, reputation_score, hascastle, ally_id, ally_name, leader_id, crest_id, crest_large_id, ally_crest_id, auction_bid_at, ally_penalty_expiry_time, ally_penalty_type, char_penalty_expiry_time, dissolving_expiry_time from clan_data_copy;
delete from clan_notices;
insert into clan_notices (clan_id, enabled, notice) select clanid, enabled, notice from clan_notices_copy;
delete from clan_privs;
insert into clan_privs (clan_id, rank, party, privs) select clan_id, rank, party, privilleges from clan_privs_copy;
delete from clan_skills;
insert into clan_skills select * from clan_skills_copy;
delete from clan_subpledges;
insert into clan_subpledges select * from clan_subpledges_copy;
delete from clan_wars;
insert into clan_wars select * from clan_wars_copy;
update clanhall, clanhall_copy set clanhall.ownerid=clanhall_copy.ownerId where clanhall.id=clanhall_copy.Id;
update fort, fort_copy set fort.lastownedtime=fort_copy.lastOwnedTime, fort.owner=fort_copy.owner where fort.id=fort_copy.id;
delete from forums;
insert into forums select * from forums_copy;
delete from items;
insert into items(owner_id, object_id, item_id, count, enchant_level, loc, loc_data, time_of_use, custom_type1, custom_type2, mana_left, time) select owner_id, object_id, item_id, count, enchant_level, loc, loc_data, time_of_use, custom_type1, custom_type2, mana_left, 0 from items_copy;
delete from pets;
insert into pets(item_obj_id, name, level, curhp, curmp, exp, sp, fed, weapon, armor, jewel) select item_obj_id, name, level, curhp, curmp, exp, sp, fed, NULL, NULL, NULL from pets_copy;
delete from seven_signs;
insert into seven_signs select * from seven_signs_copy;

Перед запуском скрипта необходимые таблицы скопировал из старой базы в новую.
Перед копирование данных в новые таблицы они зачищяются во избежание конфликтов.
Лично у меня пока проблем не было после переноса, так что, кому надо, пользуйтесь.

Параллельно есть вопрос:
Каким образом изменить скрипт

Код:

select * from items where ownerid in (select charid from characters order by onlinetime desc limit 0, 30);

, чтобы он работал? Показывает ошибку, что нельзя делать вложение limit в in.