标题:
[讨论]
重名问题菜鸟做法，，
[打印本页]
作者:
ZhXand618
时间:
2016-10-16 04:24
标题:
重名问题菜鸟做法，，
最近下载了R大的纯净端~~~
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表4 d9 Y3 C% q7 I* _2 r# d. V
可惜我的mysql是4.1.22……不支持触发器
( J* X1 _+ C# }8 o) F, Gbbs.mocwww.com
但是作为一个菜鸟没把握升级mysql……怕升了又得各种调试
& b) O/ b# O; Lbbs.mocwww.com
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表/ t& G! V: l( U, b9 j; M
bbs.mocwww.com$ n S5 E$ X& ~. ?
于是自以为是地尝试
# v% b/ z! g( R妖城在线论坛
alter table `tbl_user` change SequenceNumber SequenceNumber int not null auto_increment UNIQUE;
; {5 A3 F, D ^' m8 X魔力私服,最新魔力宝贝私服技术交流
7 b* u! O" [- F& z3 t xbbs.mocwww.com
结果悲催地发现每次创建角色，tbl_user.SequenceNumber会加1，然后tbl_character.RegistNumber 等于加1后的tbl_user.SequenceNumber
8 x+ t- d8 b {4 b3 H& m) A妖城在线论坛
顺道还发现mysql4.1.22不支持自定义自增步长……
- Y% Y: f% |+ x2 {) }" b妖城在线论坛
/ \/ f& e3 H7 N V魔力私服,最新魔力宝贝私服技术交流
在犹豫好久最终还是不敢升级mysql后，，突然有了个能凑合用的办法，，取消SequenceNumber的自增属性，然后写了这条丑的要命、乱的要死的sql……
! f8 M0 M% c. V魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
Insert into tbl_user(AccountID,AccountPassword,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,CdKey,SequenceNumber)
D7 f0 H" @/ b- k5 S& G% X ]魔力私服,最新魔力宝贝私服技术交流
select $id,$pass,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,$id,((SequenceNumber div 100)+1)*100 as SequenceNumber
5 x+ S, h$ Q6 a6 }# W! q% ]
from tbl_user
bbs.mocwww.com- Y) l+ h/ q; h9 ]" I
where SequenceNumber in
- f5 [7 V: U0 L" t1 w3 k魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
(select max(SequenceNumber) from tbl_user);
4 `9 r, W _5 k: V7 }. _2 t! N2 z
bbs.mocwww.com1 X3 B. T- ~+ C$ t$ q
然后得到了这个效果，其中SN=201是创建了一个角色得到的，我想每个账号约100次重复创建角色的机会，应该够我几个小伙伴霍霍的
。。。
6 n1 _# G6 S3 e5 M妖城在线论坛
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
7 w% V' Y# c2 d- `) ^$ U
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
+ o" Y+ F& U4 u J- e- K U# ^妖城在线论坛
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表1 l: m2 t9 `* r7 v/ D1 J: t, E# m
| admin | 3 | admin | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
! h7 j4 q& c" P2 F% @
| 1000 | 4 | 1000 | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流) |0 I: U j" J2 W
| 2000 | 6 | 2000 | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表/ a0 n9 V# o. N! ^& ~' L8 ]
| --------- | 15 | --------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ v2 K$ e" `" j! J% }/ l
| --------------- | 18 | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com3 ^ t! w& M# R0 C- Y
| ---- | 17 | ---- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com% E# d4 k5 |2 f) V3 C4 z# M8 i& {) V
| ------ | 100 | ------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
* q' @! G$ j5 p3 Q! V$ n# q. r; q/ U魔力私服,最新魔力宝贝私服技术交流
| ------------- | 201 | ------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
8 L4 C* q/ x4 P2 A9 m; {1 }魔力私服,最新魔力宝贝私服技术交流
| ------------ | 300 | ------------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表& h, ^7 g4 ? O
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
ZhXand618
时间:
2016-10-16 04:28
为啥发出来后列表就乱了
8 Q9 o& ]5 Y s' g* W, c妖城在线论坛
编辑时很整齐啊。。。
+ W! z0 [$ c3 y1 F
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
+ i# O W% h% r* F B5 m$ l; d7 ]魔力私服,最新魔力宝贝私服技术交流
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
魔力私服,最新魔力宝贝私服技术交流( j7 H7 n. a6 I2 E4 I2 U
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
- J! F6 {- R d( \) R* F妖城在线论坛
| --------------- |--------------- | --------------- | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
9 A! U+ r) q- U/ _/ O' n, k9 s魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| --------------- |--------------- | --------------- | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 P8 H* | e) A, N
| --------------- |--------------- | --------------- | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( {' y/ ^( S) R0 A1 Z# }
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流7 f# D, ]; w1 G' M2 ?
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
# T* t) P5 c+ ]5 G
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
: x5 j8 ^2 n) L+ p( l+ L& e—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 j9 ^) |, }* W- Q& ]
| --------------- |--------------- | --------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛; Z+ E6 J/ k O0 @: n
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流( q' H& ^' |4 k0 Q
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
易凡
时间:
2016-10-16 19:57
虽然看不懂，但还是要点个赞！！！
作者:
rolser
时间:
2016-10-16 22:09
我竟然看懂啦，哈哈~~
' {- P5 S+ O5 @, J) e& q5 F+ {bbs.mocwww.com
# S" R( b; a0 ~6 ], x! O魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
redhat 6 系列和 centos 6 默认mysql 就是5版本了。
bbs.mocwww.com0 q" L! l/ ]6 y% Z. o3 `: ] o
7系列mysql版本更高。
作者:
ZhXand618
时间:
2016-10-17 00:05
标题:
回复 地板 的帖子
主要是我特别菜，默认的mysql5，没调通- -
& @& B2 [$ r) b3 n魔力私服,最新魔力宝贝私服技术交流
后来下的4.1.22的rpm包……
作者:
ZhXand618
时间:
2016-10-17 03:01
昨天八成脑子混乱了。。今天发现只是解决了重名丢失问题……
, @; y/ z' e. p4 b) I8 f# a6 q魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
对防重名的问题了解的太少啊
魔力私服,最新魔力宝贝私服技术交流* i- b: ^6 j4 p) i+ n
d! _# k! w. H" d, S, K魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
【翻log拿到的创建账号时的SQL语句，原来是REPLACE……】
# W0 d% K: t0 s: c- q4 p0 W' D—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
161016 14:05:11 2 Query SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='1000' or AccountID='1000'
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ M" v# E! Y6 r# S7 n$ [# z
161016 14:05:12 3 Query SELECT * from tbl_lock WHERE CdKey='1000'
4 N4 \7 l ^7 [) ]# U妖城在线论坛
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表! @ C/ I- w. q& d# i* L
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'
7 G0 A7 r8 x! c7 H* N5 o+ h妖城在线论坛
161016 14:05:47 3 Query SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='1000'
, G* U5 d, _7 C2 F魔力私服,最新魔力宝贝私服技术交流
3 Query SELECT SequenceNumber FROM tbl_user WHERE CdKey='1000'
& t/ B! d! M/ N$ \0 W: [bbs.mocwww.com
3 Query UPDATE tbl_user SET SequenceNumber=5 Where CdKey='1000'
/ H+ {5 S6 _( k+ K& p! x( O—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
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)
bbs.mocwww.com# p p9 x2 M" h5 v* S" E% h! z- f
3 Query DELETE FROM tbl_skill WHERE CdKey='1000' and RegistNumber=5
. r/ \# d' z9 G7 L( }) Y6 H妖城在线论坛
3 Query DELETE FROM tbl_addressbook WHERE CdKey='1000' and RegistNumber=5
! D+ z6 B |1 b' ^: p: r2 D7 |魔力私服,最新魔力宝贝私服技术交流
3 Query DELETE FROM tbl_item WHERE CdKey='1000' and RegistNumber=5
1 U1 {! Y3 r& L. J. Z5 H. \2 s/ o妖城在线论坛
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)
7 q0 E6 P9 v7 I1 b* [bbs.mocwww.com
3 Query DELETE FROM tbl_pet WHERE CdKey='1000' and RegistNumber=5
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表 Q* Q I% B) g6 A
3 Query SELECT * from tbl_lock WHERE CdKey='1000'
妖城在线论坛) Y: K! U& K( W: S
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
. ~' s; A) I/ C- J, i
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
。。。
魔力私服,最新魔力宝贝私服技术交流* i- b: ^6 j4 p) i+ n