标题:
[讨论]
重名问题菜鸟做法，，
[打印本页]
作者:
ZhXand618
时间:
2016-10-16 04:24
标题:
重名问题菜鸟做法，，
最近下载了R大的纯净端~~~
妖城在线论坛8 z/ B: ~' ~2 ~; C
可惜我的mysql是4.1.22……不支持触发器
魔力私服,最新魔力宝贝私服技术交流, k9 |' P4 d' r3 }! x: U
但是作为一个菜鸟没把握升级mysql……怕升了又得各种调试
, r7 z w% e$ ]8 ^% o) o
( _; }: w% t$ \2 g魔力私服,最新魔力宝贝私服技术交流
% }, a% g# n* }6 g1 t: p) U( o
于是自以为是地尝试
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表3 v" C+ B1 k* `! d9 S4 a
alter table `tbl_user` change SequenceNumber SequenceNumber int not null auto_increment UNIQUE;
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表+ K; f* G( i: f# s: I7 c
妖城在线论坛# [6 O+ X; C. g
结果悲催地发现每次创建角色，tbl_user.SequenceNumber会加1，然后tbl_character.RegistNumber 等于加1后的tbl_user.SequenceNumber
1 i& N# t( U% h8 Y8 P( x魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
顺道还发现mysql4.1.22不支持自定义自增步长……
# P& T3 K, Z1 v5 R+ o
$ ?1 K& o/ C* h( \7 k( {4 w K魔力私服,最新魔力宝贝私服技术交流
在犹豫好久最终还是不敢升级mysql后，，突然有了个能凑合用的办法，，取消SequenceNumber的自增属性，然后写了这条丑的要命、乱的要死的sql……
, c' O, ^ @) E
Insert into tbl_user(AccountID,AccountPassword,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,CdKey,SequenceNumber)
1 {/ P% K. Z2 K- E7 N J# Obbs.mocwww.com
select $id,$pass,EnableFlg,TrialFlg,DownFlg,ExpFlg,UseFlg,BadMsg,$id,((SequenceNumber div 100)+1)*100 as SequenceNumber
0 M# G. p- j- M% y0 vbbs.mocwww.com
from tbl_user
魔力私服,最新魔力宝贝私服技术交流" q1 j# F* E1 K$ C2 ~! u; ]
where SequenceNumber in
c& a1 l! E- F2 c8 c7 U魔力私服,最新魔力宝贝私服技术交流
(select max(SequenceNumber) from tbl_user);
魔力私服,最新魔力宝贝私服技术交流4 s* N" r; B( ]! w! E; `
魔力私服,最新魔力宝贝私服技术交流# d- i, t% `+ W J0 F _/ U
然后得到了这个效果，其中SN=201是创建了一个角色得到的，我想每个账号约100次重复创建角色的机会，应该够我几个小伙伴霍霍的
。。。
魔力私服,最新魔力宝贝私服技术交流# ?* [' `1 m- U6 ]
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
6 N: J- |3 x+ ~6 ?
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
魔力私服,最新魔力宝贝私服技术交流6 R: C$ q2 W ^5 m% ^( e
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
- Y- I* R3 W* p+ }9 l" y( abbs.mocwww.com
| admin | 3 | admin | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
7 J3 l1 E+ g1 H( _7 p7 Zbbs.mocwww.com
| 1000 | 4 | 1000 | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
% [ Z, J7 p( Y& d5 Kbbs.mocwww.com
| 2000 | 6 | 2000 | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* `3 h8 I) I( N9 H, b
| --------- | 15 | --------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
7 s" ~4 ?8 a% a0 ?妖城在线论坛
| --------------- | 18 | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流' ~" B& \. ^0 Z. o
| ---- | 17 | ---- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
bbs.mocwww.com0 B, ^8 y9 ^' ?7 |8 X- s( c
| ------ | 100 | ------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
魔力私服,最新魔力宝贝私服技术交流. Z N4 e9 r& w0 Z5 z# d$ a" S$ w2 \
| ------------- | 201 | ------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
( P, e( @& i8 i: Q5 A—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
| ------------ | 300 | ------------ | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
- G! P* i& c! V2 B1 S9 fbbs.mocwww.com
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
ZhXand618
时间:
2016-10-16 04:28
为啥发出来后列表就乱了
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート" S& o9 ]2 l3 W) s0 I4 u3 H/ a5 Z
编辑时很整齐啊。。。
, P6 w/ A& D8 r
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
; t9 @- Q+ e' V6 ebbs.mocwww.com
| CdKey | SequenceNumber | AccountID | AccountPassWord | EnableFlg | UseFlg | BadMsg | TrialFlg | DownFlg | ExpFlg |
( Q7 `/ ]8 D4 T* o# `—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
bbs.mocwww.com& n$ X0 d% s6 Y$ U
| --------------- |--------------- | --------------- | 1234 | 1 | 1 | 0 | 8 | 0 | 0 |
' s( o! b. L% @- w. W* c5 [; S: I魔力私服,最新魔力宝贝私服技术交流
| --------------- |--------------- | --------------- | 1000 | 1 | 1 | 0 | 8 | 0 | 0 |
" E/ Y# v7 C8 C* i! Xbbs.mocwww.com
| --------------- |--------------- | --------------- | 2000 | 1 | 1 | 0 | 8 | 0 | 0 |
4 x$ E- J: R) O# K& P9 _, a5 u T
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
妖城在线论坛' E$ N- b P0 L6 I5 c
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
5 C( D( K" z( Rbbs.mocwww.com
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
1 d* L1 F6 y7 E& _. N0 c( C3 y+ o—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
# ~8 u2 T: i' @; r$ X
| --------------- |--------------- | --------------- | --------- | 1 | 1 | 0 | 8 | 0 | 0 |
9 _: O( I$ n6 _/ g& ~; ]' jbbs.mocwww.com
| --------------- |--------------- | --------------- | ------ | 1 | 1 | 0 | 8 | 0 | 0 |
" w5 A Z T( J2 B
+-----------------+----------------+-----------------+-----------------+-----------+--------+--------+----------+---------+--------+
作者:
易凡
时间:
2016-10-16 19:57
虽然看不懂，但还是要点个赞！！！
作者:
rolser
时间:
2016-10-16 22:09
我竟然看懂啦，哈哈~~
/ M8 i' ~! x/ `7 B' F
bbs.mocwww.com( \* `! B% o C" L4 i9 g6 e: t# f* m
redhat 6 系列和 centos 6 默认mysql 就是5版本了。
+ \; r. i/ b5 a; h$ j) V
7系列mysql版本更高。
作者:
ZhXand618
时间:
2016-10-17 00:05
标题:
回复 地板 的帖子
主要是我特别菜，默认的mysql5，没调通- -
魔力私服,最新魔力宝贝私服技术交流( j I8 U' Y, z0 v
后来下的4.1.22的rpm包……
作者:
ZhXand618
时间:
2016-10-17 03:01
昨天八成脑子混乱了。。今天发现只是解决了重名丢失问题……
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート, a( _# O' c3 o' T
对防重名的问题了解的太少啊
bbs.mocwww.com# r9 T' Y: p8 g
' g% {/ z6 Z0 m" a
【翻log拿到的创建账号时的SQL语句，原来是REPLACE……】
bbs.mocwww.com( Z, E6 ]( V3 s7 I/ V
161016 14:05:11 2 Query SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='1000' or AccountID='1000'
' N; {3 B$ D' Z8 \ R0 Z
161016 14:05:12 3 Query SELECT * from tbl_lock WHERE CdKey='1000'
. l5 C9 `8 h' b—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
! [+ q+ F8 K7 } }. \妖城在线论坛
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'
魔力私服,最新魔力宝贝私服技术交流! k* T K* i8 ]1 Y+ _# n
161016 14:05:47 3 Query SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='1000'
1 q% V' A2 J3 X) |$ U; V
3 Query SELECT SequenceNumber FROM tbl_user WHERE CdKey='1000'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% a9 T3 k4 @- X% B' w* w
3 Query UPDATE tbl_user SET SequenceNumber=5 Where CdKey='1000'
魔力私服,最新魔力宝贝私服技术交流) V( [- Q* N) y0 ? j- {- e
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)
0 y: M" g% j) {+ c M—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
3 Query DELETE FROM tbl_skill WHERE CdKey='1000' and RegistNumber=5
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート/ {5 X# T2 K4 I: ]1 U, M
3 Query DELETE FROM tbl_addressbook WHERE CdKey='1000' and RegistNumber=5
2 r- L4 p, w; R$ m$ a S5 N, [6 P4 t
3 Query DELETE FROM tbl_item WHERE CdKey='1000' and RegistNumber=5
/ z6 O: R+ I* X6 Y! N1 }+ l3 J
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)
* d2 b! P) t& ?6 p3 n7 |5 Z3 s. E
3 Query DELETE FROM tbl_pet WHERE CdKey='1000' and RegistNumber=5
/ k ?& e8 A' h2 o5 B7 r# Z
3 Query SELECT * from tbl_lock WHERE CdKey='1000'
魔力私服,最新魔力宝贝私服技术交流7 Z+ J& v: X) @2 h. C
3 Query SELECT TrialFlg,DownFlg from tbl_user WHERE CdKey='1000'
1 z5 v- l8 j/ n% C! d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
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
, r7 z w% e$ ]8 ^% o) o
。。。魔力私服,最新魔力宝贝私服技术交流# ?* [' `1 m- U6 ]
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート" S& o9 ]2 l3 W) s0 I4 u3 H/ a5 Z
bbs.mocwww.com# r9 T' Y: p8 g