标题:
[讨论]
重名问题菜鸟做法,,
[打印本页]
作者:
ZhXand618
时间:
2016-10-16 04:24
标题:
重名问题菜鸟做法,,
最近下载了R大的纯净端~~~
2 ^* z8 K2 n! n9 o1 t. ^bbs.mocwww.com
可惜我的mysql是4.1.22……不支持触发器
+ B) v! u$ I, c1 U$ n
但是作为一个菜鸟没把握升级mysql……怕升了又得各种调试
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 h! Z. w9 Q; N! ?* b
& }4 M3 x$ d. a! ~ B1 j
! A& O, _! H9 ~: I& R4 v L! R" Z4 ^4 n
于是自以为是地尝试
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表! ^4 [: o( t3 z! [# ]8 a& V
alter table `tbl_user` change SequenceNumber SequenceNumber int not null auto_increment UNIQUE;
. r9 n5 q% g% I) E/ t' p5 Lbbs.mocwww.com
8 P* a' V2 m; d4 S3 K3 T—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
结果悲催地发现每次创建角色,tbl_user.SequenceNumber会加1,然后tbl_character.RegistNumber 等于加1后的tbl_user.SequenceNumber
bbs.mocwww.com8 F; p6 \, b" f. h E
顺道还发现mysql4.1.22不支持自定义自增步长……
1 O2 {. Y4 d/ D# \5 Y& ]5 jbbs.mocwww.com
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 a: S* U- y0 z0 n' o8 q4 Y
在犹豫好久最终还是不敢升级mysql后,,突然有了个能凑合用的办法,,取消SequenceNumber的自增属性,然后写了这条丑的要命、乱的要死的sql……
妖城在线论坛6 n( R4 S; b% G# C% ^2 Z1 O
Insert into tbl_user(AccountID,AccountPassword,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,CdKey,SequenceNumber)
妖城在线论坛9 y! f7 v0 p+ \7 m# x
select $id,$pass,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,$id,((SequenceNumber div 100)+1)*100 as SequenceNumber
魔力私服,最新魔力宝贝私服技术交流5 E5 x0 T0 B5 t/ v% m5 Z% E0 F
from tbl_user
E/ N* `* K- Z/ N魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
where SequenceNumber in
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 ~5 i6 l5 ?4 ^7 E7 r: H* x
(select max(SequenceNumber) from tbl_user);
; w& ^. C/ X9 p
+ t) F+ S0 l: R, p! W. w$ H- m妖城在线论坛
然后得到了这个效果,其中SN=201是创建了一个角色得到的,我想每个账号约100次重复创建角色的机会,应该够我几个小伙伴霍霍的
。。。
: a2 i( a3 J" R3 x妖城在线论坛
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
0 e6 J8 w4 }: Y5 z# c+ f' ~bbs.mocwww.com
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
1 s) X* C" ~1 N3 W. s I, F% x妖城在线论坛
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
. `4 x6 O, \4 N# o- x3 u) c& n4 v' Z }/ u
| admin | 3 | admin | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
8 v; l) u8 Y0 v1 Z$ ^% x' c
| 1000 | 4 | 1000 | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
+ g$ a2 t7 p. c% h4 i
| 2000 | 6 | 2000 | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
: v* M4 k4 C3 W, `% d! A2 S! A5 Abbs.mocwww.com
| --------- | 15 | --------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
$ c) Y% Y, e7 p$ Z2 v5 k魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| --------------- | 18 | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート) s! F' ~, I8 C5 \/ T' E
| ---- | 17 | ---- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% t3 b8 s" Q0 g
| ------ | 100 | ------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛5 K; u. U% T1 M" \$ K8 o5 W
| ------------- | 201 | ------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
2 h1 J9 V+ e8 f魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| ------------ | 300 | ------------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( i- t" B B+ i' E
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
ZhXand618
时间:
2016-10-16 04:28
为啥发出来后列表就乱了
! a$ [8 a7 N7 D' Y& `魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
编辑时很整齐啊。。。
妖城在线论坛+ s; A1 a. I4 K) q4 P7 G0 A5 A- p
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
/ a; l/ Q: S9 e3 \妖城在线论坛
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
" O. L# l& S6 Z# ]bbs.mocwww.com
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
; X: k) F L( _4 j+ ~+ q
| --------------- |--------------- | --------------- | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛5 ]/ J* i& E$ \$ E' R" ?6 {
| --------------- |--------------- | --------------- | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流$ t/ _9 k4 ]. \9 b
| --------------- |--------------- | --------------- | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
) C8 c: M9 K! J; x, Sbbs.mocwww.com
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com: x, M: m' g5 F c& [1 f
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com8 C( Q8 ]4 K: |+ a+ `# [
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
5 Y$ R# b9 @) }$ J4 r1 Q/ E7 S魔力私服,最新魔力宝贝私服技术交流
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流9 _5 n& i- m3 d+ W# G% z
| --------------- |--------------- | --------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
! P1 D) ?$ p: o魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛: b7 z$ _: S& F% k1 }
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
易凡
时间:
2016-10-16 19:57
虽然看不懂,但还是要点个赞!!!
作者:
rolser
时间:
2016-10-16 22:09
我竟然看懂啦,哈哈~~
9 C/ ~! a" ]$ X* p9 l9 I—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
bbs.mocwww.com" v B4 `4 w( p
redhat 6 系列和 centos 6 默认mysql 就是5版本了。
& F0 C# q' \4 Z( l" A/ |
7系列mysql版本更高。
作者:
ZhXand618
时间:
2016-10-17 00:05
标题:
回复 地板 的帖子
主要是我特别菜,默认的mysql5,没调通- -
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 h f' ~1 R2 z. Q5 G- s
后来下的4.1.22的rpm包……
作者:
ZhXand618
时间:
2016-10-17 03:01
昨天八成脑子混乱了。。今天发现只是解决了重名丢失问题……
2 C# I+ \" e2 M* x—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
对防重名的问题了解的太少啊
! V( m& [+ W! p$ P2 w8 d6 y( Kbbs.mocwww.com
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表4 M5 Y' b/ s! U5 `, z) w
【翻log拿到的创建账号时的SQL语句,原来是REPLACE……】
bbs.mocwww.com9 [3 @) N E# T3 ~# [9 y8 }
161016 14:05:11 2 Query SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='1000' or AccountID='1000'
\& y+ R- _. c2 K' g) c8 D% |
161016 14:05:12 3 Query SELECT * from tbl_lock WHERE CdKey='1000'
魔力私服,最新魔力宝贝私服技术交流- p# S* d9 y' v: B% m: O; a* V
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
/ n! H9 e! _! T' u( ~% q3 k( L9 t
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'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表" r! k' H3 p& A
161016 14:05:47 3 Query SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='1000'
( r! N7 p' y0 m8 {0 S6 Wbbs.mocwww.com
3 Query SELECT SequenceNumber FROM tbl_user WHERE CdKey='1000'
. s4 _$ d' W' ~: C- V( m
3 Query UPDATE tbl_user SET SequenceNumber=5 Where CdKey='1000'
/ U2 |; F0 b0 D! N+ @ [' i- p- a# H妖城在线论坛
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)
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: H, R. D0 ^4 W a
3 Query DELETE FROM tbl_skill WHERE CdKey='1000' and RegistNumber=5
. k5 p/ M" E- i" E2 O$ }魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
3 Query DELETE FROM tbl_addressbook WHERE CdKey='1000' and RegistNumber=5
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート8 R4 i. ?. G( O9 e; F3 B" R( h; b
3 Query DELETE FROM tbl_item WHERE CdKey='1000' and RegistNumber=5
魔力私服,最新魔力宝贝私服技术交流1 p* |, m9 G. z. a
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)
( ~) P( G, h, Z5 ~5 O7 @
3 Query DELETE FROM tbl_pet WHERE CdKey='1000' and RegistNumber=5
妖城在线论坛6 e L; i; G h8 c$ _% r' r
3 Query SELECT * from tbl_lock WHERE CdKey='1000'
6 R0 \8 j! ]& x: _( N: a—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表/ Z8 X; K; a# ]7 s, ^6 S! J
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