标题:
[讨论]
重名问题菜鸟做法，，
[打印本页]
作者:
ZhXand618
时间:
2016-10-16 04:24
标题:
重名问题菜鸟做法，，
最近下载了R大的纯净端~~~
0 d9 d$ }$ J' g: c5 c! Sbbs.mocwww.com
可惜我的mysql是4.1.22……不支持触发器
% l/ ?' e1 s; ^, c2 d; g4 V' z魔力私服,最新魔力宝贝私服技术交流
但是作为一个菜鸟没把握升级mysql……怕升了又得各种调试
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 w# o& K' I$ p0 J/ D, r% ?
! k" l' q4 N2 C+ P4 O魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
妖城在线论坛- V5 X+ j) s$ O5 t" Y
于是自以为是地尝试
魔力私服,最新魔力宝贝私服技术交流4 k% ]" [0 ^' {
alter table `tbl_user` change SequenceNumber SequenceNumber int not null auto_increment UNIQUE;
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 j& N! D+ k# ~* H
bbs.mocwww.com7 f& o& y E* J( C2 _& G" u
结果悲催地发现每次创建角色，tbl_user.SequenceNumber会加1，然后tbl_character.RegistNumber 等于加1后的tbl_user.SequenceNumber
2 H7 g! E" P& j/ v
顺道还发现mysql4.1.22不支持自定义自增步长……
bbs.mocwww.com4 S' {. I5 ]& ~! `
8 b8 R; B: T8 w. x' C2 m9 u- U( s: X
在犹豫好久最终还是不敢升级mysql后，，突然有了个能凑合用的办法，，取消SequenceNumber的自增属性，然后写了这条丑的要命、乱的要死的sql……
+ k% ~; Y4 H' V7 W6 ?8 ^ F
Insert into tbl_user(AccountID,AccountPassword,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,CdKey,SequenceNumber)
魔力私服,最新魔力宝贝私服技术交流9 r% a6 g5 O& T' E, n2 ?7 f* Z$ A
select $id,$pass,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,$id,((SequenceNumber div 100)+1)*100 as SequenceNumber
, W% X( l7 P) v. }( P& @0 y—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
from tbl_user
妖城在线论坛( S Q5 @4 m9 U2 h
where SequenceNumber in
+ e$ ~" ^' v7 f; E
(select max(SequenceNumber) from tbl_user);
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 Q- b- N' q- a: j- T8 |
bbs.mocwww.com0 C0 e# }) U" R+ N2 J% J3 e4 Y
然后得到了这个效果，其中SN=201是创建了一个角色得到的，我想每个账号约100次重复创建角色的机会，应该够我几个小伙伴霍霍的
。。。
' C! D2 A, ~. Z: ]% e) z: jbbs.mocwww.com
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
: k4 l+ e$ W# `3 I3 W妖城在线论坛
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
3 X C8 y1 g! [' t l D& m3 P; Z5 v; Hbbs.mocwww.com
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
魔力私服,最新魔力宝贝私服技术交流6 N9 U! q* ~& O7 A# J1 [ b0 D' W
| admin | 3 | admin | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛$ g, A# b5 z1 T. j0 c
| 1000 | 4 | 1000 | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 ^! A- [) j/ _( S% g/ Q T
| 2000 | 6 | 2000 | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
; p# E/ L$ E- ^) R2 G! Z6 O
| --------- | 15 | --------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
1 \7 ~9 u; q' _* B' M6 y魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| --------------- | 18 | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 C7 b! e3 h" v% j! G( n" C% l/ M
| ---- | 17 | ---- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
4 P u% A% p7 U* {/ m5 {魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| ------ | 100 | ------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表. e- q1 u' l+ [" [( r4 Q
| ------------- | 201 | ------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
6 j7 O# G9 Q' O) m# I+ X" w) ~
| ------------ | 300 | ------------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com+ Z5 y2 O! q' x) N* f7 Q" M3 \
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
ZhXand618
时间:
2016-10-16 04:28
为啥发出来后列表就乱了
. ?# O4 }- |+ k3 h8 `4 x% e& }( q
编辑时很整齐啊。。。
妖城在线论坛* I! u- h1 ], u N6 ]7 P
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
5 d! A% U3 Q+ o6 ]/ N9 j5 }: f; W
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
8 T5 V( Y# n: ~2 u; u/ P7 Z
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( M5 H6 Z5 A2 \2 e/ Y$ G% w
| --------------- |--------------- | --------------- | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛' K1 _. Z: @# n6 B
| --------------- |--------------- | --------------- | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛& E0 n4 j$ H$ R6 D% R
| --------------- |--------------- | --------------- | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
/ ]2 c4 R3 A$ r$ M$ [ d: b/ R; e
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
8 o, G( K5 } n c* E7 Y
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
: Y& `, k( s0 B R' L% T魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com7 |. |0 B0 o3 ]7 `
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
% w% T* v* j' f Z2 B妖城在线论坛
| --------------- |--------------- | --------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
8 z D, A9 b6 R# M魔力私服,最新魔力宝贝私服技术交流
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート0 v+ Y' P& G& p: S' i6 a
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
易凡
时间:
2016-10-16 19:57
虽然看不懂，但还是要点个赞！！！
作者:
rolser
时间:
2016-10-16 22:09
我竟然看懂啦，哈哈~~
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート# G9 r8 @1 V' l% d6 [- g
妖城在线论坛2 n8 j" I( g# v! h( m8 H; _
redhat 6 系列和 centos 6 默认mysql 就是5版本了。
% |" N7 M b1 |. K4 K' G" b Q
7系列mysql版本更高。
作者:
ZhXand618
时间:
2016-10-17 00:05
标题:
回复 地板 的帖子
主要是我特别菜，默认的mysql5，没调通- -
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 M/ c. {) R, {6 @! J3 {! t5 l
后来下的4.1.22的rpm包……
作者:
ZhXand618
时间:
2016-10-17 03:01
昨天八成脑子混乱了。。今天发现只是解决了重名丢失问题……
& }6 U, `# M" Q, z妖城在线论坛
对防重名的问题了解的太少啊
" t1 _0 T. B( G" {% r魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
9 ~. s+ C* J$ B! f& }5 N—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
【翻log拿到的创建账号时的SQL语句，原来是REPLACE……】
( ?8 a b7 d0 Bbbs.mocwww.com
161016 14:05:11 2 Query SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='1000' or AccountID='1000'
魔力私服,最新魔力宝贝私服技术交流 ?" Z- O( Y4 u, s
161016 14:05:12 3 Query SELECT * from tbl_lock WHERE CdKey='1000'
7 S5 s; v7 M3 @1 A8 P% o0 f—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
3 P4 ]* v" \! y7 m& Ibbs.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'
魔力私服,最新魔力宝贝私服技术交流: J1 e9 F8 N: a+ C
161016 14:05:47 3 Query SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='1000'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表/ v1 w ?% I3 v V; e# U
3 Query SELECT SequenceNumber FROM tbl_user WHERE CdKey='1000'
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート4 L2 n) F; e. A m
3 Query UPDATE tbl_user SET SequenceNumber=5 Where CdKey='1000'
5 ]8 N. Z5 |5 m& Z4 F
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)
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 N u9 U. c6 r, }8 A( W' ?
3 Query DELETE FROM tbl_skill WHERE CdKey='1000' and RegistNumber=5
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表& h( i+ J/ {3 {% z
3 Query DELETE FROM tbl_addressbook WHERE CdKey='1000' and RegistNumber=5
妖城在线论坛. q- ?" a# B# D& B: a3 W
3 Query DELETE FROM tbl_item WHERE CdKey='1000' and RegistNumber=5
) g" S j- S8 j1 t—魔力私服,魔力宝贝私服技术,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)
) @; }9 z ~* J3 n2 O% E `妖城在线论坛
3 Query DELETE FROM tbl_pet WHERE CdKey='1000' and RegistNumber=5
. N' r. H h$ n—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
3 Query SELECT * from tbl_lock WHERE CdKey='1000'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表2 j/ r5 H2 j4 {- @+ m- ~
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: O0 O9 e( u5 h4 D
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,电影,黑客,网络,网吧,破解,入侵,注册表0 w# o& K' I$ p0 J/ D, r% ?
。。。
. ?# O4 }- |+ k3 h8 `4 x% e& }( q