nh0xIskate
23-10-15, 09:59 AM
id item lấy theo hình ảnh trong good ở client
Muốn gộp được mỗi sever phải set s_id khác nhau, Nếu không sẽ trùng UID !
Lưu dữ liệu Server 2 là "arpg2'
Chạy lệnh SQL sau là gộp hoàn tất.
Dữ liệu sau khi gộp ở arpg, Xóa arpg2.
INSERT INTO `arpg`.`guild`(`guild_id`, `guild_name`, `create_time`, `guild_level`, `guild_exp`, `xiangfang_level`, `jianzhu_level1`, `jianzhu_exp1`, `jianzhu_level2`, `jianzhu_exp2`, `jianzhu_level3`, `jianzhu_exp3`, `jianzhu_level4`, `jianzhu_exp4`, `camp`, `notice`, `storage_use_limit`, `shop_use_limit`, `boss_level`, `boss_exp`, `boss_growup_value`, `last_update_dayid`, `warning_dismiss_days`, `applyfor_setup`, `boss_call_day_count`, `last_active_time`, `guild_task_score`, `tianci_tongbi_day_count`, `auto_kickout_setup`, `tower_defend_daycount`, `guild_max_capability`, `personal_tower_defend_max_wave`, `personal_equip_fb_max_layer`, `today_kill_shenjiang_flag`, `csqd_kill_boss_count`) SELECT `guild_id`, `guild_name`, `create_time`, `guild_level`, `guild_exp`, `xiangfang_level`, `jianzhu_level1`, `jianzhu_exp1`, `jianzhu_level2`, `jianzhu_exp2`, `jianzhu_level3`, `jianzhu_exp3`, `jianzhu_level4`, `jianzhu_exp4`, `camp`, `notice`, `storage_use_limit`, `shop_use_limit`, `boss_level`, `boss_exp`, `boss_growup_value`, `last_update_dayid`, `warning_dismiss_days`, `applyfor_setup`, `boss_call_day_count`, `last_active_time`, `guild_task_score`, `tianci_tongbi_day_count`, `auto_kickout_setup`, `tower_defend_daycount`, `guild_max_capability`, `personal_tower_defend_max_wave`, `personal_equip_fb_max_layer`, `today_kill_shenjiang_flag`, `csqd_kill_boss_count` FROM `arpg2`.`guild` WHERE 1;
INSERT INTO `arpg`.`guildevent`(`guild_id`, `event_index`, `FOR_INDEX`, `event_type`, `event_owner`, `event_owner_post`, `event_time`, `big_event`, `cannot_remove`, `param0`, `param1`, `param2`, `param3`, `sparam0`) SELECT `guild_id`, `event_index`, `FOR_INDEX`, `event_type`, `event_owner`, `event_owner_post`, `event_time`, `big_event`, `cannot_remove`, `param0`, `param1`, `param2`, `param3`, `sparam0` FROM `arpg2`.`guildevent` WHERE 1;
INSERT INTO `arpg`.`guildmember`(`guild_id`, `member_index`, `FOR_INDEX`, `uid`, `role_name`, `plat_name`, `level`, `sex`, `prof`, `post`, `gongxian`, `total_gongxian`, `zhangong`, `caifu`, `capability`, `vip_type`, `vip_level`, `join_time`, `last_login_time`, `guild_task_luck`, `blessing_count`, `be_blessing_count`) SELECT `guild_id`, `member_index`, `FOR_INDEX`, `uid`, `role_name`, `plat_name`, `level`, `sex`, `prof`, `post`, `gongxian`, `total_gongxian`, `zhangong`, `caifu`, `capability`, `vip_type`, `vip_level`, `join_time`, `last_login_time`, `guild_task_luck`, `blessing_count`, `be_blessing_count` FROM `arpg2`.`guildmember` WHERE 1;
INSERT INTO `arpg`.`guildstorage`(`guild_id`, `item_index`, `FOR_INDEX`, `item_id`, `item_is_bind`, `item_num`, `item_invalid_time`, `item_param`) SELECT `guild_id`, `item_index`, `FOR_INDEX`, `item_id`, `item_is_bind`, `item_num`, `item_invalid_time`, `item_param` FROM `arpg2`.`guildstorage` WHERE 1;
INSERT INTO `arpg`.`itemlist`(`role_id`, `itemlist_index`, `FOR_INDEX`, `item_id`, `is_bind`, `num`, `invalid_time`, `gold_price`, `param`, `special_param`) SELECT `role_id`, `itemlist_index`, `FOR_INDEX`, `item_id`, `is_bind`, `num`, `invalid_time`, `gold_price`, `param`, `special_param` FROM `arpg2`.`itemlist` WHERE 1;
INSERT INTO `arpg`.`login`(`plat_user_name`, `db_index`, `role_id_1`, `role_id_2`, `role_id_3`, `lastlogintime`, `createtime`, `forbidtime`, `is_anti_wallow`) SELECT `plat_user_name`, `db_index`, `role_id_1`, `role_id_2`, `role_id_3`, `lastlogintime`, `createtime`, `forbidtime`, `is_anti_wallow` FROM `arpg2`.`login` WHERE 1;
INSERT INTO `arpg`.`mount`(`role_id`, `mount_index`, `FOR_INDEX`, `mount_id`, `mount_name`, `strength_level`, `strength_lucky_val`, `grade`, `grade_bless_val`, `used_imageid`, `max_hp`, `gongji`, `fangyu`, `shanbi`, `mingzhong`, `baoji`, `jianren`, `movespeed`, `attr_flag`, `zz_maxhp`, `zz_gongji`, `zz_fangyu`, `zz_shanbi`, `zz_mingzhong`, `zz_baoji`, `zz_jianren`, `zz_up_val`, `zizhi`, `cur_liedan_index`, `today_liedan_times`, `liedanlist`) SELECT `role_id`, `mount_index`, `FOR_INDEX`, `mount_id`, `mount_name`, `strength_level`, `strength_lucky_val`, `grade`, `grade_bless_val`, `used_imageid`, `max_hp`, `gongji`, `fangyu`, `shanbi`, `mingzhong`, `baoji`, `jianren`, `movespeed`, `attr_flag`, `zz_maxhp`, `zz_gongji`, `zz_fangyu`, `zz_shanbi`, `zz_mingzhong`, `zz_baoji`, `zz_jianren`, `zz_up_val`, `zizhi`, `cur_liedan_index`, `today_liedan_times`, `liedanlist` FROM `arpg2`.`mount` WHERE 1;
INSERT INTO `arpg`.`pet`(`role_id`, `pet_index`, `FOR_INDEX`, `pet_id`, `pet_name`, `attr_id`, `image_pet_id`, `zizhi`, `jingli`, `level`, `exp`, `grow_level`, `grow_exp`, `hp`, `convert_bless_val`, `wuxing_level`, `wuxing_exp`, `liliang`, `jingzhun`, `tizhi`, `minjie`, `maxhp`, `maxmp`, `gongji`, `fangyu`, `shanbi`, `mingzhong`, `baoji`, `jianren`, `roll_info`, `passive_skill`, `active_skill`, `lingxue_ver`, `lingxue`) SELECT `role_id`, `pet_index`, `FOR_INDEX`, `pet_id`, `pet_name`, `attr_id`, `image_pet_id`, `zizhi`, `jingli`, `level`, `exp`, `grow_level`, `grow_exp`, `hp`, `convert_bless_val`, `wuxing_level`, `wuxing_exp`, `liliang`, `jingzhun`, `tizhi`, `minjie`, `maxhp`, `maxmp`, `gongji`, `fangyu`, `shanbi`, `mingzhong`, `baoji`, `jianren`, `roll_info`, `passive_skill`, `active_skill`, `lingxue_ver`, `lingxue` FROM `arpg2`.`pet` WHERE 1;
INSERT INTO `arpg`.`role`(`role_id`, `role_name`, `avatar`, `sex`, `scene_id`, `last_scene_id`, `level`, `professional`, `create_time`, `online_time`, `is_online`, `last_save_time`, `country`, `is_chongzhi`, `is_micro_pc`) SELECT `role_id`, `role_name`, `avatar`, `sex`, `scene_id`, `last_scene_id`, `level`, `professional`, `create_time`, `online_time`, `is_online`, `last_save_time`, `country`, `is_chongzhi`, `is_micro_pc` FROM `arpg2`.`role` WHERE 1;
INSERT INTO `arpg`.`roleskill`(`role_id`, `skill_index`, `FOR_INDEX`, `skill_level`, `skill_id`, `last_perform_time`) SELECT `role_id`, `skill_index`, `FOR_INDEX`, `skill_level`, `skill_id`, `last_perform_time` FROM `arpg2`.`roleskill` WHERE 1;
INSERT INTO `arpg`.`role_attr_detail`(`role_id`, `attr_data`, `role_name`, `level`, `sex`, `prof`, `camp`, `gold`, `gold_bind`, `coin`, `coin_bind`, `guild_id`, `guild_name`, `avatar`, `vip_type`, `evil`, `hp`, `max_hp`, `mp`, `max_mp`, `gongji`, `fangyu`, `mingzhong`, `shanbi`, `baoji`, `jianren`, `liliang`, `tizhi`, `jingzhun`, `minjie`, `feng_gongji`, `mu_gongji`, `shui_gongji`, `huo_gongji`, `feng_fangyu`, `mu_fangyu`, `shui_fangyu`, `huo_fangyu`, `baoshang`, `shouhu`, `chuantou`, `poji`, `capability`, `max_capability`, `all_charm`, `lover_uid`, `lover_name`, `authority_type`, `calling_petindex`, `forbid_talk_time`, `sublock_pw`, `rolechest_data_len`, `mentality_data`, `vip_data`, `active_degree_data`, `roleshop_data`, `welfare_data`, `rolehangup_data`, `rolecustom_data`, `itemcolddown_data`, `roleguildshop_data`, `evaluate_data`, `monitor_data`, `mounttime_data`, `mysteryshop_data`, `title_data`, `husongtask_data`, `xianbangtask_data`, `roleactivity_data`, `fbxianhunta_data`, `fbtowerdefend_data`, `guild_longhui_data`, `last_single_chat_monitor_time`, `last_single_chat_monitor_msg`, `last_world_chat_monitor_time`, `last_world_chat_monitor_msg`, `last_mail_monitor_time`, `last_mail_monitor_subject`, `today_online_time`, `lastday_online_time`, `xianjie_level`) SELECT `role_id`, `attr_data`, `role_name`, `level`, `sex`, `prof`, `camp`, `gold`, `gold_bind`, `coin`, `coin_bind`, `guild_id`, `guild_name`, `avatar`, `vip_type`, `evil`, `hp`, `max_hp`, `mp`, `max_mp`, `gongji`, `fangyu`, `mingzhong`, `shanbi`, `baoji`, `jianren`, `liliang`, `tizhi`, `jingzhun`, `minjie`, `feng_gongji`, `mu_gongji`, `shui_gongji`, `huo_gongji`, `feng_fangyu`, `mu_fangyu`, `shui_fangyu`, `huo_fangyu`, `baoshang`, `shouhu`, `chuantou`, `poji`, `capability`, `max_capability`, `all_charm`, `lover_uid`, `lover_name`, `authority_type`, `calling_petindex`, `forbid_talk_time`, `sublock_pw`, `rolechest_data_len`, `mentality_data`, `vip_data`, `active_degree_data`, `roleshop_data`, `welfare_data`, `rolehangup_data`, `rolecustom_data`, `itemcolddown_data`, `roleguildshop_data`, `evaluate_data`, `monitor_data`, `mounttime_data`, `mysteryshop_data`, `title_data`, `husongtask_data`, `xianbangtask_data`, `roleactivity_data`, `fbxianhunta_data`, `fbtowerdefend_data`, `guild_longhui_data`, `last_single_chat_monitor_time`, `last_single_chat_monitor_msg`, `last_world_chat_monitor_time`, `last_world_chat_monitor_msg`, `last_mail_monitor_time`, `last_mail_monitor_subject`, `today_online_time`, `lastday_online_time`, `xianjie_level` FROM `arpg2`.`role_attr_detail` WHERE 1;
INSERT INTO `arpg`.`role_attr_detail2`(`role_id`, `friendsetting_data`, `rolechest_data`, `effect_data`, `card_ver`, `card_data`, `equipfb_data`, `yuanlifb_common_data`, `yuanlifb_jingying_data`, `yuanlifb_autohook_data`, `vip_chest_data`, `equip_suit_data`, `pet_image_data`, `guild_task_data`, `xianjie_data`, `shenbing_data`, `gengu_data`, `autofb_data`, `newequipfb_data`, `xianjian_data`) SELECT `role_id`, `friendsetting_data`, `rolechest_data`, `effect_data`, `card_ver`, `card_data`, `equipfb_data`, `yuanlifb_common_data`, `yuanlifb_jingying_data`, `yuanlifb_autohook_data`, `vip_chest_data`, `equip_suit_data`, `pet_image_data`, `guild_task_data`, `xianjie_data`, `shenbing_data`, `gengu_data`, `autofb_data`, `newequipfb_data`, `xianjian_data` FROM `arpg2`.`role_attr_detail2` WHERE 1;
INSERT INTO `arpg`.`role_name_map`(`db_index`, `role_id`, `role_name`, `plat_user_name`) SELECT `db_index`, `role_id`, `role_name`, `plat_user_name` FROM `arpg2`.`role_name_map` WHERE 1;
INSERT INTO `arpg`.`shizhuang`(`role_id`, `part`, `FOR_INDEX`, `is_active`, `strength_level`, `lucky_val`, `select_seq`, `part_flag`, `is_active_part`, `active_sz_flag`, `history_active_sz_flag`, `time_sz_list`, `fulu_list`) SELECT `role_id`, `part`, `FOR_INDEX`, `is_active`, `strength_level`, `lucky_val`, `select_seq`, `part_flag`, `is_active_part`, `active_sz_flag`, `history_active_sz_flag`, `time_sz_list`, `fulu_list` FROM `arpg2`.`shizhuang` WHERE 1;
INSERT INTO `arpg`.`taskrecorder`(`role_id`, `task_id`, `FOR_INDEX`, `total_num`, `day_time`, `day_num`) SELECT `role_id`, `task_id`, `FOR_INDEX`, `total_num`, `day_time`, `day_num` FROM `arpg2`.`taskrecorder` WHERE 1;
Lệnh SQL Dọn rác server !
TRUNCATE `accountgold`;
TRUNCATE `accountidentity`;
TRUNCATE `achieve`;
TRUNCATE `blacklists`;
TRUNCATE `camp`;
TRUNCATE `command`;
TRUNCATE `content`;
TRUNCATE `crossrecord`;
TRUNCATE `crossstatus`;
TRUNCATE `cross_personrank`;
TRUNCATE `dailyfind`;
TRUNCATE `enemy`;
TRUNCATE `friends`;
TRUNCATE `guildachieve`;
TRUNCATE `guildapplyfor`;
TRUNCATE `guildunion`;
TRUNCATE `guildunion_applyfor`;
TRUNCATE `hotkey`;
TRUNCATE `lingmai`;
TRUNCATE `login_account`;
TRUNCATE `mail`;
TRUNCATE `offlineregister`;
TRUNCATE `personrank`;
TRUNCATE `publicnotice`;
TRUNCATE `publicsale`;
TRUNCATE `shop`;
TRUNCATE `shop_log`;
TRUNCATE `spread_ip`;
TRUNCATE `systemmail`;
TRUNCATE `systemmail_event`;
TRUNCATE `taskphase`;
TRUNCATE `teamrank`;
TRUNCATE `worldstatus`;
DELETE FROM `arpg`.`guild` WHERE `guild`.`guild_id` = 0;
DELETE FROM `arpg`.`guildevent` WHERE `guildevent`.`guild_id` = 0;
DELETE FROM `arpg`.`guildmember` WHERE `guildmember`.`guild_id` = 0;
DELETE FROM `arpg`.`guildstorage` WHERE `guildstorage`.`guild_id` = 0;
DELETE FROM `arpg`.`itemlist` WHERE `itemlist`.`role_id` = 0;
DELETE FROM `arpg`.`login` WHERE `login`.`role_id_1` = 0;
DELETE FROM `arpg`.`mount` WHERE `mount`.`role_id` = 0;
DELETE FROM `arpg`.`pet` WHERE `pet`.`role_id` = 0;
DELETE FROM `arpg`.`role` WHERE `role`.`role_id` = 0;
DELETE FROM `arpg`.`roleskill` WHERE `roleskill`.`role_id` = 0;
DELETE FROM `arpg`.`role_attr_detail` WHERE `role_attr_detail`.`role_id` = 0;
DELETE FROM `arpg`.`role_attr_detail2` WHERE `role_attr_detail2`.`role_id` = 0;
DELETE FROM `arpg`.`role_name_map` WHERE `role_name_map`.`role_id` = 0;
DELETE FROM `arpg`.`shizhuang` WHERE `shizhuang`.`role_id` = 0;
DELETE FROM `arpg`.`taskrecorder` WHERE `taskrecorder`.`role_id` = 0;
Powered by vBulletin® Version 4.2.0 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.