标题:
[讨论]
重名问题菜鸟做法，，
[打印本页]
作者:
ZhXand618
时间:
2016-10-16 04:24
标题:
重名问题菜鸟做法，，
最近下载了R大的纯净端~~~
妖城在线论坛6 U0 l+ b+ _& {( i, b' E
可惜我的mysql是4.1.22……不支持触发器
妖城在线论坛% F% z1 E6 i0 ?8 U* g% o2 J
但是作为一个菜鸟没把握升级mysql……怕升了又得各种调试
. f* O) u9 }- Z; R
l# ~' B5 E1 \' gbbs.mocwww.com
/ q/ k2 B$ q6 q1 A+ p! y2 }1 \—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
于是自以为是地尝试
* e& U" p! U* j" K/ T) K7 z7 D0 B—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
alter table `tbl_user` change SequenceNumber SequenceNumber int not null auto_increment UNIQUE;
% Z+ b- D/ @' j, kbbs.mocwww.com
bbs.mocwww.com+ \) c0 s7 v' [; `
结果悲催地发现每次创建角色，tbl_user.SequenceNumber会加1，然后tbl_character.RegistNumber 等于加1后的tbl_user.SequenceNumber
3 B4 E! l! y! w1 n- Q! }
顺道还发现mysql4.1.22不支持自定义自增步长……
魔力私服,最新魔力宝贝私服技术交流" A0 [" [4 q3 |9 i
/ s8 u4 V$ D& u3 Q7 o4 D/ p$ u# e魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
在犹豫好久最终还是不敢升级mysql后，，突然有了个能凑合用的办法，，取消SequenceNumber的自增属性，然后写了这条丑的要命、乱的要死的sql……
9 L" ?+ T/ w3 f! n魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
Insert into tbl_user(AccountID,AccountPassword,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,CdKey,SequenceNumber)
魔力私服,最新魔力宝贝私服技术交流1 ^ i1 N+ B/ n
select $id,$pass,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,$id,((SequenceNumber div 100)+1)*100 as SequenceNumber
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表1 E ]; S/ r, \$ E; l* P$ S
from tbl_user
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表 U- @' E. D5 f$ f' D' l
where SequenceNumber in
妖城在线论坛3 d w! A% H4 g9 G% I9 ]( s0 A
(select max(SequenceNumber) from tbl_user);
+ y6 O! [0 t8 J& Gbbs.mocwww.com
' S6 q' ]3 U) S" N4 n—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
然后得到了这个效果，其中SN=201是创建了一个角色得到的，我想每个账号约100次重复创建角色的机会，应该够我几个小伙伴霍霍的
。。。
3 h" ^8 I9 `" O& A4 J- z
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
& T: X1 F/ v; W妖城在线论坛
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
' f# b' M$ b; U* {4 d
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
妖城在线论坛 Q! b W$ t. z, C
| admin | 3 | admin | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛8 J1 r8 ?8 I' K5 j
| 1000 | 4 | 1000 | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ c; a( w [ I2 O8 U/ }
| 2000 | 6 | 2000 | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
, }7 a; }8 w2 S9 q—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
| --------- | 15 | --------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 }& M% [+ Q5 m3 Y5 A# v2 `' ~
| --------------- | 18 | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
* J) C" H- p1 V' u2 S6 n- \bbs.mocwww.com
| ---- | 17 | ---- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛' U! W* l' X4 R
| ------ | 100 | ------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表" k% \7 ]" _& h i7 d |! }0 j
| ------------- | 201 | ------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
- p% ?( X" h2 z: I( g, H
| ------------ | 300 | ------------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表! l6 f# \- Z A) F
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
ZhXand618
时间:
2016-10-16 04:28
为啥发出来后列表就乱了
( Y- X% e# j$ w0 P魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
编辑时很整齐啊。。。
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: l q0 G) S/ S& ]
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
/ c: ?1 @7 y, m' V—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
& k# |% Y# N5 N7 |) B9 ~bbs.mocwww.com
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
. T/ [% M; a; v3 ~ z妖城在线论坛
| --------------- |--------------- | --------------- | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート- B9 o/ r. l& k3 m) b( ?/ y X K
| --------------- |--------------- | --------------- | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
! U' L+ c) ^: m# L5 _/ C
| --------------- |--------------- | --------------- | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com$ l: X1 @6 z0 V' ^- K' P' ~) U
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
5 y8 r2 X% X$ @6 I8 g' O; D—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
5 }1 H$ p0 O! J' L# Z, [: R' e: J妖城在线论坛
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
, }5 B% D% j* ?; g
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流3 \8 E9 t- f2 ? s+ s( s: y2 P0 ^; c( }
| --------------- |--------------- | --------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com: G6 ]2 N$ v+ t% k% R
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
- ]) V( S! w( Y妖城在线论坛
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
易凡
时间:
2016-10-16 19:57
虽然看不懂，但还是要点个赞！！！
作者:
rolser
时间:
2016-10-16 22:09
我竟然看懂啦，哈哈~~
) y* j* _% d/ W1 X* v: v—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
妖城在线论坛; J, q9 t4 y9 f
redhat 6 系列和 centos 6 默认mysql 就是5版本了。
$ I0 i% Y4 ?1 `" R2 X6 W8 x& F9 E妖城在线论坛
7系列mysql版本更高。
作者:
ZhXand618
时间:
2016-10-17 00:05
标题:
回复 地板 的帖子
主要是我特别菜，默认的mysql5，没调通- -
bbs.mocwww.com6 b- C9 H; N# R* Q" S% f
后来下的4.1.22的rpm包……
作者:
ZhXand618
时间:
2016-10-17 03:01
昨天八成脑子混乱了。。今天发现只是解决了重名丢失问题……
2 g. D8 O& _& X妖城在线论坛
对防重名的问题了解的太少啊
% T" h: e9 {& K8 N- {8 ^
bbs.mocwww.com" M2 P/ \: @9 F/ v
【翻log拿到的创建账号时的SQL语句，原来是REPLACE……】
* b( B- c6 F2 W# r) ? r9 n妖城在线论坛
161016 14:05:11 2 Query SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='1000' or AccountID='1000'
+ W. Q. i3 }5 i—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
161016 14:05:12 3 Query SELECT * from tbl_lock WHERE CdKey='1000'
妖城在线论坛4 d$ l. t& x& x, |
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
8 q( j$ B3 ]( x妖城在线论坛
3 Query SELECT Name,RegistNumber,DataPlaceNumber,FaceImageNumber,Lv, Vital,Str,Tough,Quick,Magic,Attrib_Earth,Attrib_Water,Attrib_Fire,Attrib_Wind,LoginCount,MainJob,RenewalFlg,BaseBaseImageNumber,titleID,guildID from tbl_character WHERE CdKey='1000'
# p# V4 C2 O. |. P. c" n; O- a9 {3 w魔力私服,最新魔力宝贝私服技术交流
161016 14:05:47 3 Query SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='1000'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表, j3 W7 u" V& O3 B( n+ f) s* q
3 Query SELECT SequenceNumber FROM tbl_user WHERE CdKey='1000'
0 {+ s% W D$ b% b魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
3 Query UPDATE tbl_user SET SequenceNumber=5 Where CdKey='1000'
5 R" W, Z# a6 W/ j$ L; [' T4 ]
3 Query REPLACE tbl_character VALUES(1,106352,106352,0,0,0,0,5,1,2147483647,2147483647,0,0,0,1500,1500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,28,10,0,0,0,0,0,250,0,0,0,0,0,975,0,0,5,1,0,-1,242500,0,0,50,50,50,60,1000,-1,0,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,10,100,0,0,0,0,0,0,1476641147,0,0,0,0,0,0,0,0,0,0,'12321','','1000',0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1, -1, -1, 0, 0, 0, 0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0)
( I O4 S- K3 ?, p1 h) e. y! I
3 Query DELETE FROM tbl_skill WHERE CdKey='1000' and RegistNumber=5
3 D; T$ L: ?! v+ zbbs.mocwww.com
3 Query DELETE FROM tbl_addressbook WHERE CdKey='1000' and RegistNumber=5
: d2 e+ B( c% Z. ~) _7 [魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
3 Query DELETE FROM tbl_item WHERE CdKey='1000' and RegistNumber=5
8 [- l4 H) H0 Q$ L. `& u$ o( k
3 Query INSERT INTO tbl_item VALUES (9200,27509,0,22,0,0,1,2,0,1,1,1,0,1000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,4,0,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,140000,179200,100,0,0,0,1,0,1000,0,1476641147,-1,0,0,0,0,0,0,'水晶','水晶','','','','','ITEM_DeleteTimeWatched','','','','','','',0,'1000',5,7,-1)
魔力私服,最新魔力宝贝私服技术交流/ w% z% e: U. u* Z
3 Query DELETE FROM tbl_pet WHERE CdKey='1000' and RegistNumber=5
+ O" j9 e; a9 A* s2 v- X* Z妖城在线论坛
3 Query SELECT * from tbl_lock WHERE CdKey='1000'
, b, r: V# d6 A: N- o妖城在线论坛
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
r6 `6 |; j" Q. c2 lbbs.mocwww.com
3 Query SELECT Name,RegistNumber,DataPlaceNumber,FaceImageNumber,Lv, Vital,Str,Tough,Quick,Magic,Attrib_Earth,Attrib_Water,Attrib_Fire,Attrib_Wind,LoginCount,MainJob,RenewalFlg,BaseBaseImageNumber,titleID,guildID from tbl_character WHERE CdKey='1000'
作者:
rolser
时间:
2016-10-17 08:59
防重名 应该是gmsv处理的问题，交给mysql 来做本来就不对，只是这个bug暂时没有人修复，只能通过其他方法了。。。
欢迎光临 妖城在线论坛 (http://bbs.mocwww.com/)
Powered by Discuz! 6.0.0
. f* O) u9 }- Z; R
3 B4 E! l! y! w1 n- Q! }
。。。3 h" ^8 I9 `" O& A4 J- z
% T" h: e9 {& K8 N- {8 ^