标题:
[讨论]
重名问题菜鸟做法，，
[打印本页]
作者:
ZhXand618
时间:
2016-10-16 04:24
标题:
重名问题菜鸟做法，，
最近下载了R大的纯净端~~~
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート/ Z& N6 m# J0 B+ L' x* N0 ^
可惜我的mysql是4.1.22……不支持触发器
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 z! p% ]8 p" d0 I6 _: E
但是作为一个菜鸟没把握升级mysql……怕升了又得各种调试
bbs.mocwww.com' ?/ Q8 v" w9 G; U
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( a. i& l L3 \( }8 D2 ]( Z8 [
妖城在线论坛1 n) q5 v& ^ p) i' }# q
于是自以为是地尝试
# b. r( z/ {/ O7 q+ ]bbs.mocwww.com
alter table `tbl_user` change SequenceNumber SequenceNumber int not null auto_increment UNIQUE;
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# c e& n7 V8 _* k1 S1 [4 e; Y
魔力私服,最新魔力宝贝私服技术交流+ {3 J8 S1 a3 I: Z$ z
结果悲催地发现每次创建角色，tbl_user.SequenceNumber会加1，然后tbl_character.RegistNumber 等于加1后的tbl_user.SequenceNumber
7 b! P X2 q' w+ l# m# |9 i! ^
顺道还发现mysql4.1.22不支持自定义自增步长……
; [' O$ F r9 m" K( Z. y魔力私服,最新魔力宝贝私服技术交流
魔力私服,最新魔力宝贝私服技术交流! o+ U3 R+ ^$ V& Q+ ^) j
在犹豫好久最终还是不敢升级mysql后，，突然有了个能凑合用的办法，，取消SequenceNumber的自增属性，然后写了这条丑的要命、乱的要死的sql……
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート P3 j+ ]9 I" X+ f( x
Insert into tbl_user(AccountID,AccountPassword,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,CdKey,SequenceNumber)
bbs.mocwww.com* x/ |0 T6 ]3 g- O" @( @2 F
select $id,$pass,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,$id,((SequenceNumber div 100)+1)*100 as SequenceNumber
+ ?2 m- [1 E/ m5 ~& S; n妖城在线论坛
from tbl_user
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# f4 O7 s* i4 G' d
where SequenceNumber in
魔力私服,最新魔力宝贝私服技术交流$ G# `7 Z1 A* I- v. Q
(select max(SequenceNumber) from tbl_user);
魔力私服,最新魔力宝贝私服技术交流% P: h' O/ b T3 N/ J
9 n5 C- n$ ?+ n! R; ?bbs.mocwww.com
然后得到了这个效果，其中SN=201是创建了一个角色得到的，我想每个账号约100次重复创建角色的机会，应该够我几个小伙伴霍霍的
。。。
魔力私服,最新魔力宝贝私服技术交流, G1 V. j) @2 _8 ^; n. g
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 ~- P& U6 e' X
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
- |* p3 H# X% W7 C6 G/ m. @9 n
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
$ B, `7 b* j' F4 u- C魔力私服,最新魔力宝贝私服技术交流
| admin | 3 | admin | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
" ?( y3 L' \+ |
| 1000 | 4 | 1000 | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛! e8 X8 y2 O6 V6 A- L, u2 |6 v' [ @8 ?
| 2000 | 6 | 2000 | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流6 k" ~4 ?* E/ l. p6 x
| --------- | 15 | --------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
8 ]; f- V+ o6 Z! h; t3 C3 o
| --------------- | 18 | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表, _9 m; F; A I' F) h& N# M- o) D) @; T
| ---- | 17 | ---- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com- n" I8 E) J8 r4 ~. F. J
| ------ | 100 | ------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表' G3 }/ \. _7 ]9 D F' H9 m" ^; `
| ------------- | 201 | ------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流" [' L! [5 j+ `) d k; E" Y. ]
| ------------ | 300 | ------------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
2 @+ R6 z4 `; P, X, j5 l魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
ZhXand618
时间:
2016-10-16 04:28
为啥发出来后列表就乱了
魔力私服,最新魔力宝贝私服技术交流- E5 x: |# M2 X* f
编辑时很整齐啊。。。
! g+ {) N2 {3 u' |* n
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
" N3 r; E9 |$ E! C
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
妖城在线论坛1 i2 a) f+ Z" _$ F K4 F
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
魔力私服,最新魔力宝贝私服技术交流0 ^1 `* D& `; A, l' n
| --------------- |--------------- | --------------- | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
$ N% a) S" s) W3 A魔力私服,最新魔力宝贝私服技术交流
| --------------- |--------------- | --------------- | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
" b5 { n& J; S! O—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
| --------------- |--------------- | --------------- | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
% K+ d+ S3 ~: P! i- s B E
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
! W$ c ?' Q' z& v( t) f
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
& n: i7 Z( d! \bbs.mocwww.com
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
6 C; Q' y' O( w; i$ Y7 E, Y
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
. y, }" ?- w, h' k, W魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| --------------- |--------------- | --------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛1 ?7 m8 O9 V+ a: A8 ~% {- o$ }
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
" i8 E4 {- ^! |% J1 P7 C+ i- J
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
易凡
时间:
2016-10-16 19:57
虽然看不懂，但还是要点个赞！！！
作者:
rolser
时间:
2016-10-16 22:09
我竟然看懂啦，哈哈~~
s8 G; ?+ A' G—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
魔力私服,最新魔力宝贝私服技术交流 a1 m R/ h, B
redhat 6 系列和 centos 6 默认mysql 就是5版本了。
2 a! v3 \# W" o+ L% M& b+ L0 ~6 l1 t魔力私服,最新魔力宝贝私服技术交流
7系列mysql版本更高。
作者:
ZhXand618
时间:
2016-10-17 00:05
标题:
回复 地板 的帖子
主要是我特别菜，默认的mysql5，没调通- -
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. h, o, S6 a7 ~; W1 p3 r, d
后来下的4.1.22的rpm包……
作者:
ZhXand618
时间:
2016-10-17 03:01
昨天八成脑子混乱了。。今天发现只是解决了重名丢失问题……
bbs.mocwww.com( ^* |) y! \2 j" C3 U
对防重名的问题了解的太少啊
魔力私服,最新魔力宝贝私服技术交流4 N8 v, z$ e! D. d9 |9 p! N1 r
bbs.mocwww.com& O# i. y# Q) a2 n, _
【翻log拿到的创建账号时的SQL语句，原来是REPLACE……】
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート ?! p# o' Y- O+ j+ l' Q
161016 14:05:11 2 Query SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='1000' or AccountID='1000'
* Y: I+ B/ }, k魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
161016 14:05:12 3 Query SELECT * from tbl_lock WHERE CdKey='1000'
9 Z6 r, ^6 s5 m魔力私服,最新魔力宝贝私服技术交流
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
! e% Z8 `0 \- ~1 _0 b魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
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'
8 E+ K$ ^# Z3 ]
161016 14:05:47 3 Query SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='1000'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表- A9 d* Z8 v& m7 G; ~' y. X/ C
3 Query SELECT SequenceNumber FROM tbl_user WHERE CdKey='1000'
bbs.mocwww.com& ~4 |- Y/ V! x& s6 f
3 Query UPDATE tbl_user SET SequenceNumber=5 Where CdKey='1000'
bbs.mocwww.com/ H; p1 x$ W# L: L0 J
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)
魔力私服,最新魔力宝贝私服技术交流2 K) N1 {9 ]6 ~+ a' q ]' \5 K
3 Query DELETE FROM tbl_skill WHERE CdKey='1000' and RegistNumber=5
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 S2 J4 @. e p
3 Query DELETE FROM tbl_addressbook WHERE CdKey='1000' and RegistNumber=5
魔力私服,最新魔力宝贝私服技术交流- m* g0 q% O( m _0 |# Y$ h+ V
3 Query DELETE FROM tbl_item WHERE CdKey='1000' and RegistNumber=5
5 Q, @+ F' O7 f8 e& |' 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)
妖城在线论坛$ A% r" Z* X7 \3 C& w
3 Query DELETE FROM tbl_pet WHERE CdKey='1000' and RegistNumber=5
6 k4 v" n4 d8 ]: K
3 Query SELECT * from tbl_lock WHERE CdKey='1000'
( h3 @8 l: K7 H. U2 W妖城在线论坛
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
) P: F* c5 `' Z8 K" l# r6 H! U妖城在线论坛
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
bbs.mocwww.com' ?/ Q8 v" w9 G; U
。。。魔力私服,最新魔力宝贝私服技术交流, G1 V. j) @2 _8 ^; n. g
魔力私服,最新魔力宝贝私服技术交流- E5 x: |# M2 X* f
魔力私服,最新魔力宝贝私服技术交流4 N8 v, z$ e! D. d9 |9 p! N1 r