[魔力私服分享] 魔力宝贝GMSV全部SQL语句

叶子

妖使

Rank: 3 Rank: 3 Rank: 3

UID: 3172
精华: 8
积分: 731
威望: 0 度

阁楼大中小发表于 2009-5-27 00:39 显示全部帖子

DELETE FROM tbl_addressbook WHERE CdKey='%s' and RegistNumber=%d
删除帐户为 %s 且  注册序列为 %d  的所有名片内容妖城在线论坛$ }/ g# o# U! f+ ^$ q$ M. ~$ a

DELETE from tbl_character WHERE CdKey='%s' and RegistNumber=%d
删除角色信息  在表 tbl_character 中条件是帐户为 %s 人物注册序列为 %d. `7 X% z; [0 V. ~1 t4 Q
魔力私服,最新魔力宝贝私服技术交流! [, q! [5 e8 u* ~
DELETE FROM tbl_guild WHERE guildID=%d
删除字段guildID(家族序号) 的所有信息在  tbl_guild 中魔力私服,最新魔力宝贝私服技术交流3 {' v  X$ R1 m8 \. R
(删除家族的函数调用), |4 I1 y( l. f( v9 N6 O8 ]2 @7 X( L
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ u5 L9 t: [' v# u1 R& O
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
在tbl_guild 中删除帐户为 %s  注册序列为 %d  的成员信息
(删除家族成员 )

以下略 ……
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d妖城在线论坛# V9 ~8 N' u& V$ f2 l
DELETE FROM tbl_guildItemBox WHERE GuildId=%d
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 ?+ X% F" _9 G2 q( {* {
DELETE FROM tbl_guildItemBox_bak WHERE GuildId=%d
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d AND roomID=%d
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d and roomID=%d and BoxPosition=%d
DELETE FROM tbl_guildItemBoxPet_bak WHERE guildID=%d
DELETE FROM tbl_guildMonster WHERE guildID=%dbbs.mocwww.com. L' N% I8 W) W
DELETE FROM tbl_guildMonster WHERE GuildId=%d魔力私服,最新魔力宝贝私服技术交流$ q- x. ~/ O) K, {/ k5 X
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力宝贝私服技术交流" ^& g& b; h9 y6 f& ]  K6 L

DELETE FROM tbl_item WHERE CdKey='%s' and RegistNumber=%d妖城在线论坛& P$ m  S0 u  U6 [5 V
删除帐户为%s  注册序列为%d  的角色所有物品信息
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 G; m$ A7 p1 P6 |
DELETE FROM tbl_lock WHERE CdKey='%s'妖城在线论坛- Y) a+ `& t$ r8 d% F9 |
在 tbl_lock 中删除  帐户为 %s的信息（踢号）
妖城在线论坛' B# I: c# d" o3 v1 c
DELETE FROM tbl_pet WHERE CdKey='%s' and RegistNumber=%d
删除帐户为 %s  注册序列为 %d 的所有宠物信息0 T; Z" j5 r9 U# S+ w

DELETE FROM tbl_skill WHERE CdKey='%s' and RegistNumber=%d% B8 V9 y, g$ K* @# ]8 G. b
同上  技能信息. X- {, P" z8 q
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表+ s5 P2 H) a. q# R
INSERT INTO tbl_addressbook VALUESbbs.mocwww.com& g% u7 U. ~1 n2 z+ S6 j
插入记录在 tbl_addressbook中值  （？未知）—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート& p; c4 M- H9 M, H6 ^9 P, T

以下错误太多略……. S, q1 F) f' N3 \
INSERT INTO tbl_guild SET guildID = %d, CdKey='%s', RegistNumber=%d, serverNumber=%d, roomType=%d , guildName='%s', roomName='%s',createTime=%d, lastA
INSERT INTO tbl_guildItemBox VALUES
INSERT INTO tbl_guildItemBoxPet VALUES—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 P. a. e3 F& Y& F( I
INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%dbbs.mocwww.com8 D5 U0 E. E% n, h! |( f1 _, T
INSERT INTO tbl_item VALUES—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 e1 W& t+ }5 }8 ^
INSERT INTO tbl_pet VALUES
INSERT INTO tbl_skill VALUES
INSERT tbl_lock SET CdKey='%s',ServerName='%s',RegistNumber=%d,LoginTime=%ld—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート  w4 C/ q4 I8 @! J0 g
REPLACE tbl_addressbook_bak SELECT * FROM tbl_addressbook WHERE CdKey='%s' and RegistNumber=%d
REPLACE tbl_character VALUES(
REPLACE tbl_character_bak SELECT * FROM tbl_character WHERE CdKey='%s' and RegistNumber=%d& m5 t2 j" [% K: d- d
REPLACE tbl_duelranking SET CdKey='%s',RegistNumber='%d',Name='%s', Lv=%d, DuelPoint=%d, Date=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート5 [* e; _9 ?: O
REPLACE tbl_guild_bak SELECT * FROM tbl_guild WHERE guildID=%d
REPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d
REPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d& k% t% c1 W5 r
REPLACE tbl_guildItemBoxPet_bak SELECT * FROM tbl_guildItemBoxPet WHERE guildID=%d
REPLACE tbl_guildMonster VALUES (& k0 b) r# d& t
REPLACE tbl_guildMonster_bak SELECT * FROM tbl_guildMonster WHERE guildID=%d' U; f7 H' g" e/ l7 K7 z' ^  |
REPLACE tbl_guildMonster_bak SELECT * FROM tbl_guildMonster WHERE guildID=%d
REPLACE tbl_item_bak SELECT * FROM tbl_item WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力宝贝私服技术交流$ J- |% W! \1 t3 \1 s' K% l/ d7 K
REPLACE tbl_pet_bak SELECT * FROM tbl_pet WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% F, g: s1 C, ^# s/ O1 \9 a
REPLACE tbl_skill_bak SELECT * FROM tbl_skill WHERE CdKey='%s' and RegistNumber=%d

SELECT * from %s WHERE CdKey='%s' and RegistNumber=%d
查询 %S 表条件是 cdkey为 %s  注册ID为 %d (这是个备用语句前面的%s不同就代表不同表，可以查到不同表的信息)魔力私服,最新魔力宝贝私服技术交流7 u$ K  d! X2 M  g7 z

以下略……魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表' j6 X9 \# C# Z/ q9 c7 I- _
SELECT * FROM %s WHERE CdKey='%s' and RegistNumber=%d
SELECT * from %s WHERE CdKey='%s' and RegistNumber='%d'魔力私服,最新魔力宝贝私服技术交流5 b+ s) U* c' {: ?  x
SELECT * from %s WHERE guildID=%d and roomID=%d and BoxPosition=%d妖城在线论坛* a/ p/ A' W* L: D8 R
SELECT * from tbl_—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( l4 J) d/ V# j9 _6 D
SELECT * FROM tbl_character WHERE guildID=%d
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' |0 d: y5 O9 i  G
SELECT * FROM tbl_guild WHERE guildID=%d妖城在线论坛% x1 J& O" B0 e. {5 \+ G
SELECT * from tbl_guildItemBox WHERE GuildId=%d
SELECT * FROM tbl_guildItemBoxPet WHERE guildID=%d and RoomID=%d
SELECT * FROM tbl_guildMonster
SELECT * from tbl_lock WHERE CdKey='%s'妖城在线论坛4 n# e1 d0 d- J" }
SELECT * from tbl_skillPopulation魔力私服,最新魔力宝贝私服技术交流) x$ o3 X, }  J  ^) b3 H$ j
SELECT * from tbl_user WHERE AccountID='%s'
SELECT * from tbl_user WHERE CdKey='%s'bbs.mocwww.com: q9 G3 e. @$ d6 A, g
select * from x_cash_list where result='1' and x_user_id='%s'魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 N* D1 n! [0 u
select * from x_cashitem_list, x_cash_list where x_cashitem_list.hanafosID = %d魔力私服,最新魔力宝贝私服技术交流& Q) C. F" H1 T
SELECT CdKey, Name, RegistNumber, Lv, Fame, MainJob, DuelPoint from tbl_character WHERE CdKey='%s'
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d
SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d3 w2 u: P6 {5 P) M1 q4 q
SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='%s' or AccountID='%s'
SELECT COUNT(*) from tbl_character WHERE Debugger=0 and JobAncestry=%d
SELECT COUNT(*) from tbl_character WHERE Debugger=0 and MainJob=%d
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d
select database...
SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='%s'
select distinct guildID from tbl_character where guildID >=%d and guildID < %d% g, S5 I" v  Z
SELECT DISTINCT GuildId FROM tbl_guildItemBox魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( p$ w# Z) H) c- J' d0 b: j
SELECT ExpFlg from tbl_user Where CdKey='%s' and AccountPassWord='%s'
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート1 W, b/ _% a# h  {' Z3 C
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%dbbs.mocwww.com: C5 l+ b1 F4 e8 X7 n7 I
SELECT guildID,titleID,sequence,Name from tbl_character where CdKey = '%s' and RegistNumber = %d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 v1 w* s) V5 h) f, Z
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d妖城在线论坛( _" f# U" n. e1 Q: ~
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート% d+ R( Z9 \! Y  ?; O
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. A1 k3 u, M+ U% H9 N, y1 H
SELECT Name, Lv, DuelPoint from tbl_duelranking Limit %d,%dbbs.mocwww.com+ d- K2 j2 X4 M9 i5 A
SELECT Name,RegistNumber,DataPlaceNumber,FaceImageNumber,Lv, Vital,Str,Tough,Quick,Magic,Attrib_Earth,Attrib_Water,Attrib_Fire,Attrib_Wind,LoginCount,bbs.mocwww.com; z6 n. u' g5 J9 Z1 Q; z+ I
SELECT num from tbl_playernum
SELECT ProductKey, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_product WHERE Kind = %d and ProductKey='%s': v( V( h+ B" v
SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'妖城在线论坛8 y- m9 g- E; \
SELECT Puk3Key, Kind, UseFlg, LinkCdKey, EnableFlgfrom tbl_puk3 WHERE Kind = %d and Puk3Key = '%s'妖城在线论坛$ W( M0 {: \6 x
SELECT RegistNumber, DataPlaceNumber from tbl_character WHERE CdKey='%s'
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
SELECT SequenceNumber FROM tbl_user WHERE CdKey='%s'
SELECT SequenceNumber from tbl_user WHERE CdKey='%s'妖城在线论坛' D9 Q; N8 {/ `" [! x
SELECT serverNumber FROM tbl_guild WHERE guildID=%d
SELECT SkillNum,SkillID,SkillLevel,SkillExp,SeqNo FROM %s WHERE CdKey='%s' and RegistNumber=%d4 ?% H$ m5 T! z9 i
SELECT titleID FROM tbl_character WHERE guildID=%d; l) F) t0 W6 Q& q, B
SELECT TrialFlg from tbl_user WHERE CdKey='%s'魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表* {8 w: L1 h- `, T- j9 ]
SELECT TrialFlg,DownFlg from tbl_user Where CdKey='%s'
SELECT TrialFlg,ExpFlg from tbl_user WHERE CdKey='%s'
select[
SELECT\tTrialFlg,DownFlg from tbl_user WHERE CdKey='%s'1 T( L: {& i6 s% m) r3 q- x1 x" w
update tbl_addressbook SET CdKey='%s',RegistNumber=%d Where CdKey='%s' and RegistNumber=%dbbs.mocwww.com3 J/ h- A; O9 z$ M
update tbl_character SET CdKey='%s',RegistNumber=%d,DataPlaceNumber=0 Where CdKey='%s' and RegistNumber=%d; d* A  [! p% `; Z/ n
UPDATE tbl_character SET closenessMonster%d=0 WHERE guildID=%d
update tbl_character SET DataPlaceNumber=%d Where CdKey='%s' and RegistNumber=%d
UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d& c. l$ l. @# q. f) @) E5 n" V
UPDATE tbl_guild SET CdKey='%s', RegistNumber=%d,roomType=%d, guildName='%s', roomName='%s', brief='%s', lastAccess=%d,guildMark=%d魔力私服,最新魔力宝贝私服技术交流% }9 s1 ?; a9 N3 x
update tbl_item SET CdKey='%s',RegistNumber=%d Where CdKey='%s' and RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 |' U" ]  {8 Z
update tbl_pet SET CdKey='%s',RegistNumber=%d,NamedCdKey='%s',OwnerCdKey='%s' Where CdKey='%s' and RegistNumber=%d% Q$ n& h5 R# @7 ?9 J- S) H4 t9 @: b
UPDATE tbl_product SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where ProductKey='%s'
UPDATE tbl_product SET UseFlg=0 WHERE ProductKey='%s'
UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'魔力私服,最新魔力宝贝私服技术交流& F  _* s! a1 D
UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'; A+ _) ?$ Y3 {6 o
update tbl_skill SET CdKey='%s',RegistNumber=%d Where CdKey='%s' and RegistNumber=%d7 N- T5 {- Z; Y* M/ Q$ u) Q
UPDATE tbl_user SET AccountID='%s' Where CdKey='%s'bbs.mocwww.com4 I6 x2 D; C/ ^6 j4 c8 Q
UPDATE tbl_user SET BadMsg=0 Where CdKey='%s'
UPDATE tbl_user SET SequenceNumber=%d Where CdKey='%s'# E  b: X* s3 ?6 V" j$ W# h  i
update tbl_user SET SequenceNumber=%d Where CdKey='%s'( r! ~/ M: E; ~! a9 D
UPDATE tbl_user SET TrialFlg=%d Where CdKey='%s'魔力私服,最新魔力宝贝私服技术交流3 }2 |7 T) Z! ^, b! U6 g. t6 h
UPDATE tbl_user SET TrialFlg=%d where CdKey='%s'. h2 E& s1 D. g% ~% N( ]2 x. B) j* J
UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
UPDATE tbl_user SET TrialFlg='%d' Where CdKey='%s'
妖城在线论坛# T/ r2 M3 @/ k/ K* T3 ^
x_cash_list  未知表略……
update x_cash_list set result='0' where orderid=%d, o  h$ S) v" z. \
update x_cash_list set result='1' where orderid=%d
update x_cash_list set result='-1' where orderid=%d

有事,请 -> 站内PM

TOP

‹‹ 上一主题 | 下一主题 ››