标题:
[讨论]
重名问题菜鸟做法，，
[打印本页]
作者:
ZhXand618
时间:
2016-10-16 04:24
标题:
重名问题菜鸟做法，，
最近下载了R大的纯净端~~~
6 `; e; p2 n5 f" x6 G0 R) q7 k
可惜我的mysql是4.1.22……不支持触发器
2 `" M6 d& u* G- h4 |; c8 w妖城在线论坛
但是作为一个菜鸟没把握升级mysql……怕升了又得各种调试
, ?! Q) g( @1 M9 k0 ?2 B( R4 r2 F魔力私服,最新魔力宝贝私服技术交流
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 y# q. e+ o+ G" w8 T& y; ?# ]- o) k
6 e j7 q T; l8 U—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
于是自以为是地尝试
魔力私服,最新魔力宝贝私服技术交流5 U' [0 j4 y& z) F
alter table `tbl_user` change SequenceNumber SequenceNumber int not null auto_increment UNIQUE;
魔力私服,最新魔力宝贝私服技术交流& R1 a8 [: E* I9 x. d& M: c5 C6 g
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表3 r" m- M8 x5 C8 C& n. _: r
结果悲催地发现每次创建角色，tbl_user.SequenceNumber会加1，然后tbl_character.RegistNumber 等于加1后的tbl_user.SequenceNumber
, d" b# B. l" H/ O8 H- @" B: X妖城在线论坛
顺道还发现mysql4.1.22不支持自定义自增步长……
魔力私服,最新魔力宝贝私服技术交流0 H4 _4 @/ H; l: F) d/ i2 d3 Y
+ k# [6 k% l1 X/ h" A妖城在线论坛
在犹豫好久最终还是不敢升级mysql后，，突然有了个能凑合用的办法，，取消SequenceNumber的自增属性，然后写了这条丑的要命、乱的要死的sql……
" [5 A- b" u/ d8 J; w$ v妖城在线论坛
Insert into tbl_user(AccountID,AccountPassword,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,CdKey,SequenceNumber)
bbs.mocwww.com- e. ] z9 ~( r& O3 f* ]/ f
select $id,$pass,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,$id,((SequenceNumber div 100)+1)*100 as SequenceNumber
1 f( m4 b3 u. a. j2 }8 F, n
from tbl_user
! L r0 u$ S) f; U% X$ `3 ?! t妖城在线论坛
where SequenceNumber in
8 d& E, u: F4 a, M0 f7 P
(select max(SequenceNumber) from tbl_user);
2 i- R* F3 \4 G0 S/ l, W2 xbbs.mocwww.com
' G- `2 E9 a. [$ n: P+ j妖城在线论坛
然后得到了这个效果，其中SN=201是创建了一个角色得到的，我想每个账号约100次重复创建角色的机会，应该够我几个小伙伴霍霍的
。。。
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表2 A+ W' ], r4 W3 m8 k
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
妖城在线论坛! ^8 G8 X7 c5 h+ |. L) m
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
bbs.mocwww.com5 Y8 S0 K6 \: l. L. [& s0 ^
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
6 N; R+ [2 q3 S6 {+ _1 s
| admin | 3 | admin | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流1 k% Q2 E' |" Q/ T$ k4 z
| 1000 | 4 | 1000 | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛$ b) c0 `9 j; W) G; z* S
| 2000 | 6 | 2000 | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
: z% ]& P) i9 }8 d- S5 l魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| --------- | 15 | --------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
0 ]! H7 E0 ?$ ?) e% W2 n
| --------------- | 18 | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
5 {: g; X+ C; A8 O- u# B魔力私服,最新魔力宝贝私服技术交流
| ---- | 17 | ---- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
2 n/ l; G2 ^/ U魔力私服,最新魔力宝贝私服技术交流
| ------ | 100 | ------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表* [; E5 w K4 q. u1 y6 v" n
| ------------- | 201 | ------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
( Z$ N/ G3 d/ {
| ------------ | 300 | ------------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
8 U4 `' W, E2 U, T( u魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
ZhXand618
时间:
2016-10-16 04:28
为啥发出来后列表就乱了
" h# f. E$ P, v2 bbbs.mocwww.com
编辑时很整齐啊。。。
X8 x% e9 L4 o9 n* s$ g4 R魔力私服,最新魔力宝贝私服技术交流
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
妖城在线论坛7 \, Z( r- L$ ]" u" {7 @8 z0 _
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
. D9 B2 @' I* g8 ~# b: x3 V0 C
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
% i1 z1 P$ S" S+ s; n6 J+ ]
| --------------- |--------------- | --------------- | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
' D: e% J% C9 F3 }( v2 l6 u mbbs.mocwww.com
| --------------- |--------------- | --------------- | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com4 j! X, s4 g2 N
| --------------- |--------------- | --------------- | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
0 j, T/ ~, [) `" t/ E+ \/ B% j
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; v" D$ Z% b6 ?) N# f+ V
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( e/ R& X! z4 x
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
2 I/ _, p1 b: e0 |+ f1 k魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
- K @6 J) z& A# m2 X$ P魔力私服,最新魔力宝贝私服技术交流
| --------------- |--------------- | --------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
9 r/ b5 |' a! \! E+ k6 Y- v妖城在线论坛
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( o& B! x: G w. B1 j" m, Q
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
易凡
时间:
2016-10-16 19:57
虽然看不懂，但还是要点个赞！！！
作者:
rolser
时间:
2016-10-16 22:09
我竟然看懂啦，哈哈~~
7 P% p- \- J; R—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 I) l% X% h- e- L3 x0 C5 ?7 Q
redhat 6 系列和 centos 6 默认mysql 就是5版本了。
3 d& A$ s/ \1 |9 O& O* W7 v妖城在线论坛
7系列mysql版本更高。
作者:
ZhXand618
时间:
2016-10-17 00:05
标题:
回复 地板 的帖子
主要是我特别菜，默认的mysql5，没调通- -
魔力私服,最新魔力宝贝私服技术交流( c" [9 ?9 z- P, ^
后来下的4.1.22的rpm包……
作者:
ZhXand618
时间:
2016-10-17 03:01
昨天八成脑子混乱了。。今天发现只是解决了重名丢失问题……
% G5 J/ | e$ W2 m) \bbs.mocwww.com
对防重名的问题了解的太少啊
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート) M& b2 T) p: B) e
4 X, N% {" N; V* qbbs.mocwww.com
【翻log拿到的创建账号时的SQL语句，原来是REPLACE……】
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表1 L+ S6 u& g+ C* F5 C9 u* E
161016 14:05:11 2 Query SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='1000' or AccountID='1000'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表' n% f6 M `8 i5 i, _! O
161016 14:05:12 3 Query SELECT * from tbl_lock WHERE CdKey='1000'
魔力私服,最新魔力宝贝私服技术交流2 G+ X; _& w9 U" _* L
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
魔力私服,最新魔力宝贝私服技术交流" B0 }& n3 }' o
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'
6 }' |# \7 c/ l0 N' Qbbs.mocwww.com
161016 14:05:47 3 Query SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='1000'
) x7 h2 D2 ^7 P% A* y: a
3 Query SELECT SequenceNumber FROM tbl_user WHERE CdKey='1000'
9 K8 l+ N& f! E* |6 t& t4 b—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
3 Query UPDATE tbl_user SET SequenceNumber=5 Where CdKey='1000'
& J2 p5 p- D7 S9 h! U# x—魔力私服,魔力宝贝私服技术,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)
, ?) z. K! r R, M3 Y—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
3 Query DELETE FROM tbl_skill WHERE CdKey='1000' and RegistNumber=5
$ Y5 @9 E7 C1 ^, g/ T) N: F) y9 j魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
3 Query DELETE FROM tbl_addressbook WHERE CdKey='1000' and RegistNumber=5
- |3 \- G8 t/ D+ P! A6 P妖城在线论坛
3 Query DELETE FROM tbl_item WHERE CdKey='1000' and RegistNumber=5
) @1 [" K8 l( ]4 K0 ^" f2 c—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
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)
妖城在线论坛* T, W" ^/ E9 a' @- A
3 Query DELETE FROM tbl_pet WHERE CdKey='1000' and RegistNumber=5
- ^7 U( A; E) z! G
3 Query SELECT * from tbl_lock WHERE CdKey='1000'
bbs.mocwww.com4 n+ M- d4 k2 G( q; C+ {8 p
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
# @+ r5 p* f# t' y% d6 @魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,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'
作者:
rolser
时间:
2016-10-17 08:59
防重名 应该是gmsv处理的问题，交给mysql 来做本来就不对，只是这个bug暂时没有人修复，只能通过其他方法了。。。
欢迎光临 妖城在线论坛 (http://bbs.mocwww.com/)
Powered by Discuz! 6.0.0
。。。魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表2 A+ W' ], r4 W3 m8 k
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート) M& b2 T) p: B) e