Пользователь
Регистрация: 29.05.2008
Возраст: 42
Сообщений: 51
Отблагодарили 2 раз(а)
Рейтинг мнений:
|
Ответ: Смена зборки l2jserver l2emu gracia p2
На днях перевел сервер с 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.
|