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

软件简介：
. M: [: v' X& ]6 O* X; C3 ~===================================第一步：准备数据================================
7 E: L) B/ m5 y6 o- }) C* G: }首先将两个区的数据库按以下方式放在一个sql服务器下：
源帐号数据库：db_account
源角色数据库：db_game
, f2 V/ q8 j0 o4 X  z目标帐号数据库：db_account2
目标角色数据库：db_game2
/ J8 L0 t4 H# ~! T, }====================================第二步：清理数据================================
2 W, s& O4 ~3 z4 J9 W--清理30级以下的角色
3 X  m$ h0 [+ F. c" c+ Odelete from db_game.t_user where level=30;
delete from db_game2.t_user where level=30;
; n$ ~+ A' x4 J+ c0 |--清理没有建立角色的帐号
DELETE FROM db_account.t_account WHERE NOT accountid IN (
8 K! W. j* G% `5 lSELECT DISTINCT accountid
* m. I3 w# w# t: i& Q- aFROM db_game.t_user);
: j! M. b. D3 CDELETE FROM db_account2.t_account WHERE NOT accountid IN (
* D1 @# v: C8 z0 [) TSELECT DISTINCT accountid
- W7 p- q8 V( @2 Y6 x! V' R4 fFROM db_game2.t_user);
* M* I  \3 R5 Q) E1 @# z--清理帐号钻石消费记录 t_gold_used
" E& {, t' C, Q( j' \delete from db_account.t_gold_used;
delete from db_account2.t_gold_used;
--清理登陆日志t_login
delete from db_account.t_login;
+ J8 T0 {/ x5 _' c2 Rdelete from db_account2.t_login;
9 n8 [. F  s6 A% M, D* h--清理正在删除的行会
delete from db_game.t_user_guild where deleted=1;
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;
--清理行会杀人数据
7 i3 O- S) c7 o5 t; D7 c- u) w# ~6 ^delete from db_game.t_guild_kill_record;
delete from db_game2.t_guild_kill_record;
0 ^) \- x2 W- r- P# r--清理行会对战数据
delete from db_game.t_guild_war_pair;
9 f, b. _" y2 cdelete from db_game2.t_guild_war_pair;
--清理拜师数据
" }1 T* {# A* r7 e/ @3 Hdelete from db_game.request_teacher_list;
& x& @2 q7 P# Q3 K( Zdelete from db_game2.request_teacher_list;
--清理杀人数据
, r& [. Y. R: bdelete from db_game.t_murder;
. p+ g$ k8 i! b3 _delete from db_game2.t_murder;
( M8 S  a  x' d; s4 s7 b--清理pve排行数据
delete from db_game.t_pve_rank;
8 u  k2 o/ Q* c, z. m0 gdelete from db_game2.t_pve_rank;
6 m7 P& C5 M4 N====================================第二步：整理源数据================================
查询重复帐号id
8 l! A0 l* r, o9 Dselect accountid from db_account.t_account order by accountid asc;
select accountid from db_account2.t_account order by accountid desc;
0 q2 n7 s8 K( T- U7 }$ d查看accountid最小值为: n1
查看accountid2最大值为: n2
N = n2 - n1 + 1
  a1 a, x7 w% A  V! F. k修改重复帐号id（操作之前需要取消源数据的t_account主键和自动递增）
) }6 t3 a6 s" w. K# pupdate db_account.t_account set accountid=accountid+N;
update db_game.t_user set accountid=accountid+N;
--查询重复帐号名称
; X+ O1 n  e* n/ |  u+ Q3 oSELECT name FROM db_account.t_account WHERE name IN (SELECT name FROM db_account2.t_account);
  f6 W4 T+ \/ f' V" g7 r4 \--修改重复帐号名称+a
  n* u- d, X  \' lupdate 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);
--查询重复角色名称
6 _4 d! F' `1 @. Y1 L  eSELECT name FROM db_game.t_user WHERE name IN (SELECT name FROM db_game2.t_user);
--修改重复角色可以改名
* V: {" b. |' g4 oupdate db_game.t_user set changename=1 WHERE name IN (SELECT name FROM db_game2.t_user);
--修改重复角色名称+★（可以不改。玩家上线必须改名才允许进入游戏）
4 M- e. w) B" T! C6 g3 q* Gupdate db_game.t_user set name= Concat(name,'★') WHERE name IN (SELECT name FROM db_game2.t_user);
: q- _# B2 P, f9 y( D8 F, y--查询重复行会id
/ R" E0 ]# g( C, wSELECT guildid FROM db_game.t_user_guild WHERE guildid IN (SELECT guildid FROM db_game2.t_user_guild);
--查询重复行会名
SELECT name FROM db_game.t_user_guild WHERE name IN (SELECT name FROM db_game2.t_user_guild);
8 B$ z' K: I. D1 \SELECT guild FROM db_game.t_user WHERE guild IN (SELECT guild FROM db_game2.t_user);
! d  s. r+ I2 Q. q3 H" k  A--修改重复行会名+
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);
- a$ m8 D9 q: V2 W====================================第三步：处理角色名称数据(可选)================================
# |1 l6 p( u3 i) V--查询重复拍卖id
+ I, J+ R4 ?- I! h6 }' x* d4 i( \SELECT auctionitemid FROM db_game.t_auction_item WHERE auctionitemid IN (SELECT auctionitemid FROM db_game2.t_auction_item);
/ ~& d( J* T, O: d--查询重复邮件id
% i- i" L; a. Z$ P1 QSELECT mailid FROM db_game.t_user_mail WHERE mailid IN (SELECT mailid FROM db_game2.t_user_mail);
--修改相关重复角色名称+★（可以不改。玩家上线必须改名才允许进入游戏）
3 ]( T( `8 j" I# a, Qupdate db_game.t_auction_item set ownername= Concat(ownername,'★') WHERE ownername IN (SELECT name FROM db_game2.t_user);
6 F' \# e4 X  ~1 }7 Q6 S7 pupdate db_game.t_defend_equip_rank set ownername= Concat(ownername,'★') WHERE ownername IN (SELECT name FROM db_game2.t_user);
) s9 {) g7 ?, i8 ~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);
update db_game.t_user_mail set recvname= Concat(recvname,'★') WHERE recvname IN (SELECT name FROM db_game2.t_user);
update db_game.t_student set studentname= Concat(studentname,'★') WHERE studentname IN (SELECT name FROM db_game2.t_user);
- C( L. v% F6 o  Kupdate db_game.t_teacher set teachername= Concat(teachername,'★') WHERE teachername IN (SELECT name FROM db_game2.t_user);
====================================第四步：开始将源数据合并到目标数据================================
开始合并：
使用Navicat for MySQL的数据传输方式：
将源帐号数据db_account通过直接传输的方式合并到db_account2，数据库物件只选t_account表格，其它的不用选
将源角色数据db_game通过直接传输的方式合并到db_game2，数据库物件取消t_user_dungeon_team,t_vars,t_war_area表格，其它全选
/ F+ B' w8 n1 Q- f: }注意：传输数据前要将 高级菜单==创建表 选项取消
====================================合并结束，db_account2与db_game2数据为最终一二区合并数据================================
6 Q- n. a6 |4 ~9 f* h* o; q1 vby Siline 2010.7.1


3 i: b* o7 G; y下载地址：

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

文件大小:

未知

下载次数:

0

下载权限:

版本vip会员

VIP专享 检测资源

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

VIP专享,点击开通vip

确认