蜀门EVP工具+各种管理工具、网页、补丁

软件简介：
/ W. ^% L- H% x2 ^# T8 i+ W===================================第一步：准备数据================================
首先将两个区的数据库按以下方式放在一个sql服务器下：
, L) a/ E9 V5 F4 ^& [源帐号数据库：db_account
源角色数据库：db_game
; r# P! B- j1 y& Y! q' y2 E& B! m目标帐号数据库：db_account2
目标角色数据库：db_game2
====================================第二步：清理数据================================
$ p& k* @  `! U1 h9 m# K--清理30级以下的角色
( b+ D. Y- {/ k3 y7 [1 L4 Q/ kdelete from db_game.t_user where level=30;
/ {$ z" G$ s, ldelete from db_game2.t_user where level=30;
% {3 E9 W& I+ {" L--清理没有建立角色的帐号
, I+ K6 X# z& z( nDELETE FROM db_account.t_account WHERE NOT accountid IN (
% C- |: d; |7 S7 s0 J8 s# Y2 MSELECT DISTINCT accountid
9 S" w; q. T, oFROM db_game.t_user);
DELETE FROM db_account2.t_account WHERE NOT accountid IN (
# I3 z- s9 [$ N8 }8 }" HSELECT DISTINCT accountid
FROM db_game2.t_user);
: |; x$ g0 V, y--清理帐号钻石消费记录 t_gold_used
delete from db_account.t_gold_used;
' s  ]9 Q5 ~  i2 [; L7 hdelete from db_account2.t_gold_used;
--清理登陆日志t_login
0 w% j5 [" A9 M$ b' ?delete from db_account.t_login;
delete from db_account2.t_login;
--清理正在删除的行会
delete from db_game.t_user_guild where deleted=1;
( m/ f  g) G3 u; \delete from db_game2.t_user_guild where deleted=1;
delete from db_game.t_user_guild_terr where deleted=1;
delete from db_game2.t_user_guild_terr where deleted=1;
--清理行会杀人数据
6 i* O* d0 K: _# D0 m9 v% B7 Pdelete from db_game.t_guild_kill_record;
4 w) t3 H& F$ Y; r* w+ Adelete from db_game2.t_guild_kill_record;
--清理行会对战数据
) h% g1 j1 |8 a+ fdelete from db_game.t_guild_war_pair;
8 P7 [0 E% Z) Pdelete from db_game2.t_guild_war_pair;
--清理拜师数据
4 y) k( D, m) u5 ?; wdelete from db_game.request_teacher_list;
delete from db_game2.request_teacher_list;
. P. E$ @8 I, Z, ?--清理杀人数据
delete from db_game.t_murder;
" B4 G) Z5 g4 J) m  M5 vdelete from db_game2.t_murder;
--清理pve排行数据
# F* T: R2 c- Odelete from db_game.t_pve_rank;
delete from db_game2.t_pve_rank;
, i9 d, d& V5 d. d! l, }====================================第二步：整理源数据================================
9 F9 _8 D9 P2 D/ N0 H0 W. X查询重复帐号id
select accountid from db_account.t_account order by accountid asc;
select accountid from db_account2.t_account order by accountid desc;
2 i8 U# R5 Q6 ]6 b2 }9 b% K查看accountid最小值为: n1
查看accountid2最大值为: n2
N = n2 - n1 + 1
修改重复帐号id（操作之前需要取消源数据的t_account主键和自动递增）
update db_account.t_account set accountid=accountid+N;
& Y5 l$ [. X& H, }8 h0 ~& T, Nupdate db_game.t_user set accountid=accountid+N;
3 k, P* m! h3 b0 N; Q( i4 g" \/ h--查询重复帐号名称
SELECT name FROM db_account.t_account WHERE name IN (SELECT name FROM db_account2.t_account);
3 ^9 i; l. H9 q9 G: X--修改重复帐号名称+a
9 W9 ]( S# F( vupdate db_account.t_account set name= Concat(name,'a') WHERE name IN (SELECT name FROM db_account2.t_account);
查询重复角色id
SELECT dbid FROM db_game.t_user WHERE dbid IN (SELECT dbid FROM db_game2.t_user);
--查询重复角色名称
SELECT name FROM db_game.t_user WHERE name IN (SELECT name FROM db_game2.t_user);
2 I+ X* `! U) d4 h  b--修改重复角色可以改名
update db_game.t_user set changename=1 WHERE name IN (SELECT name FROM db_game2.t_user);
/ ^( x% M" p& r  T7 k4 w' z--修改重复角色名称+★（可以不改。玩家上线必须改名才允许进入游戏）
update db_game.t_user set name= Concat(name,'★') WHERE name IN (SELECT name FROM db_game2.t_user);
--查询重复行会id
SELECT guildid FROM db_game.t_user_guild WHERE guildid IN (SELECT guildid FROM db_game2.t_user_guild);
6 [, s+ O3 V& G" g! H--查询重复行会名
SELECT name FROM db_game.t_user_guild WHERE name IN (SELECT name FROM db_game2.t_user_guild);
SELECT guild FROM db_game.t_user WHERE guild IN (SELECT guild FROM db_game2.t_user);
--修改重复行会名+
update db_game.t_user_guild set name= Concat(name,'') WHERE name IN (SELECT name FROM db_game2.t_user_guild);
update db_game.t_user set guild= Concat(guild,'') WHERE guild IN (SELECT guild FROM db_game2.t_user);
====================================第三步：处理角色名称数据(可选)================================
! ^/ j4 P8 r9 u! u& y& r--查询重复拍卖id
9 w) y( d2 x% X* `# _SELECT auctionitemid FROM db_game.t_auction_item WHERE auctionitemid IN (SELECT auctionitemid FROM db_game2.t_auction_item);
--查询重复邮件id
SELECT mailid FROM db_game.t_user_mail WHERE mailid IN (SELECT mailid FROM db_game2.t_user_mail);
--修改相关重复角色名称+★（可以不改。玩家上线必须改名才允许进入游戏）
update db_game.t_auction_item set ownername= Concat(ownername,'★') WHERE ownername IN (SELECT name FROM db_game2.t_user);
# L4 U; {+ ]9 u+ ~+ w9 pupdate db_game.t_defend_equip_rank set ownername= Concat(ownername,'★') WHERE ownername IN (SELECT name FROM db_game2.t_user);
update db_game.t_main_trump_rank set ownername= Concat(ownername,'★') WHERE ownername IN (SELECT name FROM db_game2.t_user);
update db_game.t_user_mail set sendername= Concat(sendername,'★') WHERE sendername IN (SELECT name FROM db_game2.t_user);
0 z$ _' x8 _( q3 Xupdate db_game.t_user_mail set recvname= Concat(recvname,'★') WHERE recvname IN (SELECT name FROM db_game2.t_user);
/ k6 B2 M0 x" }! w# ^# ^) ~& Rupdate db_game.t_student set studentname= Concat(studentname,'★') WHERE studentname IN (SELECT name FROM db_game2.t_user);
8 V) B  i& {3 d4 v% h+ x6 Lupdate db_game.t_teacher set teachername= Concat(teachername,'★') WHERE teachername IN (SELECT name FROM db_game2.t_user);
====================================第四步：开始将源数据合并到目标数据================================
开始合并：
, b% k: ]; u' l2 [! H1 I# s使用Navicat for MySQL的数据传输方式：
: d9 l; j" l& s  I2 O- o$ U/ q! V将源帐号数据db_account通过直接传输的方式合并到db_account2，数据库物件只选t_account表格，其它的不用选
  ]5 x2 u2 N8 ~7 K8 H5 o% C将源角色数据db_game通过直接传输的方式合并到db_game2，数据库物件取消t_user_dungeon_team,t_vars,t_war_area表格，其它全选
注意：传输数据前要将 高级菜单==创建表 选项取消
9 Z2 |/ o- u" k2 Y. y; M====================================合并结束，db_account2与db_game2数据为最终一二区合并数据================================
by Siline 2010.7.1


下载地址：

2011-7-4 18:12 上传 蜀门EVP工具+各种管理工具、网页、补丁.rar

文件大小:

未知

下载次数:

0

下载权限:

版本vip会员

VIP专享 检测资源

有些游戏资源需要vip下载开通请点击开通vip

VIP专享,点击开通vip

确认