打印

[讨论] 重名问题菜鸟做法，，

ZhXand618

小妖

Rank: 1

UID: 904
精华: 0
积分: 38
威望: 0 度
性别: 男

阁楼大中小发表于 2016-10-16 04:24 显示全部帖子

重名问题菜鸟做法，，

最近下载了R大的纯净端~~~
可惜我的mysql是4.1.22……不支持触发器
但是作为一个菜鸟没把握升级mysql……怕升了又得各种调试

" P& Q5 |. B& E; g4 u' k6 Q  ~  m

于是自以为是地尝试
alter table `tbl_user` change SequenceNumber SequenceNumber int not null auto_increment UNIQUE;bbs.mocwww.com) V: }1 n) R( a  X

结果悲催地发现每次创建角色，tbl_user.SequenceNumber会加1，然后tbl_character.RegistNumber 等于加1后的tbl_user.SequenceNumber

顺道还发现mysql4.1.22不支持自定义自增步长……妖城在线论坛- n, R! c' o* q: y

在犹豫好久最终还是不敢升级mysql后，，突然有了个能凑合用的办法，，取消SequenceNumber的自增属性，然后写了这条丑的要命、乱的要死的sql……妖城在线论坛0 m" N! C, b$ i! w; I
Insert into tbl_user(AccountID,AccountPassword,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,CdKey,SequenceNumber)
select $id,$pass,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,$id,((SequenceNumber div 100)+1)*100 as SequenceNumber 魔力私服,最新魔力宝贝私服技术交流. y. u6 }) I- |! z6 R
from tbl_user
where SequenceNumber in
(select max(SequenceNumber) from tbl_user);
bbs.mocwww.com. X% p+ f' h- Y- B% Y7 h* |
然后得到了这个效果，其中SN=201是创建了一个角色得到的，我想每个账号约100次重复创建角色的机会，应该够我几个小伙伴霍霍的

。。。妖城在线论坛! E6 e) c" j3 ]5 b& a; b/ P5 ^" _7 R
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表- F1 r2 |( ~. v, o) d8 P; ~, n
| CdKey          | SequenceNumber | AccountID    | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
| admin          |             3 | admin          | 1234          |       1 |    1 |    0 |       8 |    0 |    0 |妖城在线论坛1 f( R& r) w; G6 c7 W8 W7 c
| 1000          |             4 | 1000          | 1000          |       1 |    1 |    0 |       8 |    0 |    0 |魔力私服,最新魔力宝贝私服技术交流+ _+ a4 p9 j5 U4 A3 v
| 2000          |             6 | 2000          | 2000          |       1 |    1 |    0 |       8 |    0 |    0 |
| ---------    |          15 | ---------    | ------       |       1 |    1 |    0 |       8 |    0 |    0 |
| --------------- |          18 | --------------- | ------       |       1 |    1 |    0 |       8 |    0 |    0 |魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表/ z! Y4 e6 ]; _2 O$ F3 S
| ----          |          17 | ----          | ------       |       1 |    1 |    0 |       8 |    0 |    0 |
| ------       |          100 | ------       | ------       |       1 |    1 |    0 |       8 |    0 |    0 |
| ------------- |          201 | ------------- | ---------    |       1 |    1 |    0 |       8 |    0 |    0 |
| ------------ |          300 | ------------ | ------       |       1 |    1 |    0 |       8 |    0 |    0 |bbs.mocwww.com4 J, ~5 N$ K* D9 V/ u9 s9 Q
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+

TOP

ZhXand618

小妖

Rank: 1

UID: 904
精华: 0
积分: 38
威望: 0 度
性别: 男

沙发大中小发表于 2016-10-16 04:28 显示全部帖子

为啥发出来后列表就乱了

编辑时很整齐啊。。。魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ Q' `: @" q+ {5 W: n
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
| CdKey          | SequenceNumber | AccountID    | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
| --------------- |--------------- | --------------- | 1234          |       1 |    1 |    0 |       8 |    0 |    0 |1 Q/ p2 Q; J: h  j  }8 i
| --------------- |--------------- | --------------- | 1000          |       1 |    1 |    0 |       8 |    0 |    0 |
| --------------- |--------------- | --------------- | 2000          |       1 |    1 |    0 |       8 |    0 |    0 |
| --------------- |--------------- | --------------- | ------       |       1 |    1 |    0 |       8 |    0 |    0 |
| --------------- |--------------- | --------------- | ------       |       1 |    1 |    0 |       8 |    0 |    0 |妖城在线论坛; B$ G3 e0 Z$ d  U
| --------------- |--------------- | --------------- | ------       |       1 |    1 |    0 |       8 |    0 |    0 |魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: q# i) d/ N% i
| --------------- |--------------- | --------------- | ------       |       1 |    1 |    0 |       8 |    0 |    0 |
| --------------- |--------------- | --------------- | ---------    |       1 |    1 |    0 |       8 |    0 |    0 |
| --------------- |--------------- | --------------- | ------       |       1 |    1 |    0 |       8 |    0 |    0 |3 k( Q" H! ~: [8 Q8 A/ N$ ?1 s
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+

TOP

ZhXand618

小妖

Rank: 1

UID: 904
精华: 0
积分: 38
威望: 0 度
性别: 男

板凳大中小发表于 2016-10-17 00:05 显示全部帖子

回复地板的帖子

主要是我特别菜，默认的mysql5，没调通- -—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート, D' a ]1 V, n) J; D3 D
后来下的4.1.22的rpm包……

TOP

ZhXand618

小妖

Rank: 1

UID: 904
精华: 0
积分: 38
威望: 0 度
性别: 男

地板大中小发表于 2016-10-17 03:01 显示全部帖子

昨天八成脑子混乱了。。今天发现只是解决了重名丢失问题……—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 n$ _/ @5 C6 @) G
对防重名的问题了解的太少啊

魔力私服,最新魔力宝贝私服技术交流3 w2 C* A- ]  ?# ?" g5 _; s0 I! V; Q
妖城在线论坛2 L7 e1 C$ ^0 B) h  A
【翻log拿到的创建账号时的SQL语句，原来是REPLACE……】—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; k( r. B- o/ A1 W8 U2 ^
161016 14:05:11    2 Query    SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user  Where CdKey='1000' or AccountID='1000'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 U( s. d4 J, }2 o: Y
161016 14:05:12    3 Query    SELECT * from tbl_lock WHERE CdKey='1000'5 g, }4 D6 y5 p+ b- J
                  3 Query    SELECT    TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
                  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'
161016 14:05:47    3 Query    SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='1000'
                  3 Query    SELECT SequenceNumber FROM tbl_user WHERE CdKey='1000'
                  3 Query    UPDATE tbl_user SET SequenceNumber=5 Where CdKey='1000'妖城在线论坛6 Y9 M. ^* f4 w$ }
                  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,电影,黑客,网络,网吧,破解,入侵,注册表* M' \9 G; {* q9 g; C, M
                  3 Query    DELETE FROM tbl_skill WHERE CdKey='1000' and RegistNumber=50 a% U/ E( `* e
                  3 Query    DELETE FROM tbl_addressbook WHERE CdKey='1000' and RegistNumber=5魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 J$ a% u1 z0 q0 X* h/ ~- }
                  3 Query    DELETE FROM tbl_item WHERE CdKey='1000' and RegistNumber=5
                  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)魔力私服,最新魔力宝贝私服技术交流/ Y0 o. K6 [( \6 U7 R
                  3 Query    DELETE FROM tbl_pet WHERE CdKey='1000' and RegistNumber=5
                  3 Query    SELECT * from tbl_lock WHERE CdKey='1000'妖城在线论坛- |: d7 n) o) ]5 F6 b5 q- Z1 Q
                  3 Query    SELECT    TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
                  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'

TOP

[讨论] 重名问题菜鸟做法，，

重名问题菜鸟做法，，

回复 地板 的帖子

回复地板的帖子