[魔力私服分享] 魔力宝贝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妖城在线论坛/ Y6 |5 i: L# ]9 s
删除帐户为 %s 且  注册序列为 %d  的所有名片内容

DELETE from tbl_character WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力宝贝私服技术交流7 O  M  \6 }# b+ Q0 l
删除角色信息  在表 tbl_character 中条件是帐户为 %s 人物注册序列为 %d魔力私服,最新魔力宝贝私服技术交流4 b8 v) o3 X% V  P# o6 A3 {

DELETE FROM tbl_guild WHERE guildID=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ I6 l: o1 R2 K; F4 I3 n
删除字段guildID(家族序号) 的所有信息在  tbl_guild 中 bbs.mocwww.com% ~1 x: V; t5 T# M/ f8 H
(删除家族的函数调用)—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート5 p% Q. }6 J4 D9 @
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 `5 x7 D& j4 l- u6 E2 T6 `
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: O, y1 \7 B8 d; g8 o3 s7 |4 y
在tbl_guild 中删除帐户为 %s  注册序列为 %d  的成员信息
(删除家族成员 )魔力私服,最新魔力宝贝私服技术交流, p  {4 F" r' F$ p4 e3 Y

以下略 ……
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
DELETE FROM tbl_guildItemBox WHERE GuildId=%d
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
DELETE FROM tbl_guildItemBox_bak WHERE GuildId=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表* I: {8 b5 `+ Z" g# w/ q
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表' b) `1 [3 S/ k9 t
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d AND roomID=%d/ N( N7 E2 `. w" A! y2 C: x
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d and roomID=%d and BoxPosition=%d妖城在线论坛4 N+ P/ e" b- g
DELETE FROM tbl_guildItemBoxPet_bak WHERE guildID=%d
DELETE FROM tbl_guildMonster WHERE guildID=%d妖城在线论坛; C& M3 @; m6 ]( P) I! o. Q3 @
DELETE FROM tbl_guildMonster WHERE GuildId=%dbbs.mocwww.com* Z  z+ w- }7 i" U
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
妖城在线论坛& J, c8 h8 X( D) B1 h% V

DELETE FROM tbl_item WHERE CdKey='%s' and RegistNumber=%d
删除帐户为%s  注册序列为%d  的角色所有物品信息2 O8 O4 U' G, C& O3 X' f6 {( }! ^
3 a8 U7 V: y: z3 G
DELETE FROM tbl_lock WHERE CdKey='%s'
在 tbl_lock 中删除  帐户为 %s的信息（踢号）

DELETE FROM tbl_pet WHERE CdKey='%s' and RegistNumber=%d
删除帐户为 %s  注册序列为 %d 的所有宠物信息
+ ]" Q% D; m2 p: [& ~3 M& q
DELETE FROM tbl_skill WHERE CdKey='%s' and RegistNumber=%d
同上  技能信息
bbs.mocwww.com4 W# b" c" e) Y, p- t& l
INSERT INTO tbl_addressbook VALUES
插入记录在 tbl_addressbook中值  （？未知）
$ P; T1 [  @" G0 I/ Z
以下错误太多略……
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
INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d
INSERT INTO tbl_item VALUES
INSERT INTO tbl_pet VALUES
INSERT INTO tbl_skill VALUES
INSERT tbl_lock SET CdKey='%s',ServerName='%s',RegistNumber=%d,LoginTime=%ld
REPLACE tbl_addressbook_bak SELECT * FROM tbl_addressbook WHERE CdKey='%s' and RegistNumber=%d
REPLACE tbl_character VALUES(妖城在线论坛" V, F9 I; ~0 X5 ?
REPLACE tbl_character_bak SELECT * FROM tbl_character WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% w8 i# J! ~% F8 W3 S: [# x! I6 H
REPLACE tbl_duelranking SET CdKey='%s',RegistNumber='%d',Name='%s', Lv=%d, DuelPoint=%d, Date=%d
REPLACE tbl_guild_bak SELECT * FROM tbl_guild WHERE guildID=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 [  t3 P/ N9 d: {
REPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) K& ^) P; [( v2 F3 I) b7 X; n; i
REPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d
REPLACE tbl_guildItemBoxPet_bak SELECT * FROM tbl_guildItemBoxPet WHERE guildID=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. ^3 o: K2 ^% e3 O6 X* I# U+ t9 F
REPLACE tbl_guildMonster VALUES (魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% {  i, h$ K" F4 \
REPLACE tbl_guildMonster_bak SELECT * FROM tbl_guildMonster WHERE guildID=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 |+ A. O" }& D8 a; F
REPLACE tbl_guildMonster_bak SELECT * FROM tbl_guildMonster WHERE guildID=%d妖城在线论坛# t: x1 F% @; f- _8 c" t
REPLACE tbl_item_bak SELECT * FROM tbl_item WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力宝贝私服技术交流+ a. E. {  p9 B* R* p. T
REPLACE tbl_pet_bak SELECT * FROM tbl_pet WHERE CdKey='%s' and RegistNumber=%d
REPLACE tbl_skill_bak SELECT * FROM tbl_skill WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 u, Y, Z3 l9 n4 @
3 p5 {. S0 s6 T8 t& H

SELECT * from %s WHERE CdKey='%s' and RegistNumber=%d
查询 %S 表条件是 cdkey为 %s  注册ID为 %d (这是个备用语句前面的%s不同就代表不同表，可以查到不同表的信息)魔力私服,最新魔力宝贝私服技术交流5 q' I1 C% d3 a' ?* |$ l
8 S+ F( U# _: O: \0 C
以下略……
SELECT * FROM %s WHERE CdKey='%s' and RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート7 b7 b2 H" |/ a# z" q: D
SELECT * from %s WHERE CdKey='%s' and RegistNumber='%d'魔力私服,最新魔力宝贝私服技术交流. d3 p( M( N5 c  I5 ~& o
SELECT * from %s WHERE guildID=%d and roomID=%d and BoxPosition=%d
SELECT * from tbl_魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表2 ^: g8 O& K& P5 Y+ G
SELECT * FROM tbl_character WHERE guildID=%d
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d妖城在线论坛* J+ i  U8 o8 E+ K
SELECT * FROM tbl_guild WHERE guildID=%d
SELECT * from tbl_guildItemBox WHERE GuildId=%d
SELECT * FROM tbl_guildItemBoxPet WHERE guildID=%d and RoomID=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ v( {4 a  Q2 @. f# Z8 _! L
SELECT * FROM tbl_guildMonster
SELECT * from tbl_lock WHERE CdKey='%s'" @: j2 S0 Y! f5 l2 @2 s
SELECT * from tbl_skillPopulation
SELECT * from tbl_user WHERE AccountID='%s'魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) U, L, f* }' v  D; Q5 F. }
SELECT * from tbl_user WHERE CdKey='%s'
select * from x_cash_list where result='1' and x_user_id='%s'bbs.mocwww.com9 F: h3 \0 z' A4 c8 d1 `9 _( S
select * from x_cashitem_list, x_cash_list where x_cashitem_list.hanafosID = %d魔力私服,最新魔力宝贝私服技术交流4 J) m! u: a+ n! ]
SELECT CdKey, Name, RegistNumber, Lv, Fame, MainJob, DuelPoint from tbl_character WHERE CdKey='%s'bbs.mocwww.com6 E' U; t0 e! \
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d
SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%dbbs.mocwww.com( P0 P: j; \  v  p2 A3 m
SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='%s' or AccountID='%s'bbs.mocwww.com- {, u7 L% O/ @5 W  Q. l( K1 l
SELECT COUNT(*) from tbl_character WHERE Debugger=0 and JobAncestry=%dbbs.mocwww.com  W, f$ ]( W0 o" D4 x: X8 |
SELECT COUNT(*) from tbl_character WHERE Debugger=0 and MainJob=%d1 L: g) e  @1 D0 s0 t. J0 n
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %dbbs.mocwww.com$ z# q" W( ]9 u6 Z# b; Z* S
select database...妖城在线论坛, y- p, o& y8 {' e
SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='%s'
select distinct guildID from tbl_character where guildID >=%d and guildID < %d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート- H4 ]4 e. n. ~4 O- g2 g- T
SELECT DISTINCT GuildId FROM tbl_guildItemBox
SELECT ExpFlg from tbl_user Where CdKey='%s' and AccountPassWord='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 t& V: a& R2 k, r" z
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
SELECT guildID,titleID,sequence,Name from tbl_character where CdKey = '%s' and RegistNumber = %d魔力私服,最新魔力宝贝私服技术交流" B9 z5 V4 F! O2 r
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d妖城在线论坛* s' J. q4 }  b4 K: ~1 K) T
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
SELECT Name, Lv, DuelPoint from tbl_duelranking Limit %d,%d
SELECT Name,RegistNumber,DataPlaceNumber,FaceImageNumber,Lv, Vital,Str,Tough,Quick,Magic,Attrib_Earth,Attrib_Water,Attrib_Fire,Attrib_Wind,LoginCount,
SELECT num from tbl_playernum魔力私服,最新魔力宝贝私服技术交流; X$ F/ X; S1 g; O7 `
SELECT ProductKey, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_product WHERE Kind = %d and ProductKey='%s'bbs.mocwww.com  T* P/ {7 o' y$ c
SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
SELECT Puk3Key, Kind, UseFlg, LinkCdKey, EnableFlgfrom tbl_puk3 WHERE Kind = %d and Puk3Key = '%s'
SELECT RegistNumber, DataPlaceNumber from tbl_character WHERE CdKey='%s'- Q5 d% O$ Y$ }1 e4 Y
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d妖城在线论坛" e3 K- ~, F8 N6 q) q8 R
SELECT SequenceNumber FROM tbl_user WHERE CdKey='%s'
SELECT SequenceNumber from tbl_user WHERE CdKey='%s'  X% v2 G+ w5 O9 C% b$ f
SELECT serverNumber FROM tbl_guild WHERE guildID=%d
SELECT SkillNum,SkillID,SkillLevel,SkillExp,SeqNo FROM %s WHERE CdKey='%s' and RegistNumber=%d/ G6 X' d; v& n3 l3 c8 k
SELECT titleID FROM tbl_character WHERE guildID=%d
SELECT TrialFlg from tbl_user WHERE CdKey='%s', J! `$ u' v. Y. y( s% [% K% U% N& h
SELECT TrialFlg,DownFlg from tbl_user Where CdKey='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート! Z+ h* B2 F9 p" o* m
SELECT TrialFlg,ExpFlg from tbl_user WHERE CdKey='%s'
select[
SELECT\tTrialFlg,DownFlg from tbl_user WHERE CdKey='%s'
update tbl_addressbook SET CdKey='%s',RegistNumber=%d Where CdKey='%s' and RegistNumber=%d: |. {  M  r0 U7 Q3 R* x
update tbl_character SET CdKey='%s',RegistNumber=%d,DataPlaceNumber=0 Where CdKey='%s' and RegistNumber=%d
UPDATE tbl_character SET closenessMonster%d=0 WHERE guildID=%d
update tbl_character SET DataPlaceNumber=%d Where CdKey='%s' and RegistNumber=%dbbs.mocwww.com+ H& r& N0 ?/ k3 U9 ~1 a
UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%dbbs.mocwww.com8 Y5 o, X7 M9 _' q) F# O
UPDATE tbl_guild SET CdKey='%s', RegistNumber=%d,roomType=%d, guildName='%s', roomName='%s', brief='%s', lastAccess=%d,guildMark=%d* Y; u4 r8 W! n! a9 w" h
update tbl_item SET CdKey='%s',RegistNumber=%d Where CdKey='%s' and RegistNumber=%d
update tbl_pet SET CdKey='%s',RegistNumber=%d,NamedCdKey='%s',OwnerCdKey='%s' Where CdKey='%s' and RegistNumber=%d
UPDATE tbl_product SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where ProductKey='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート+ B1 B9 x/ ~3 @( N6 B
UPDATE tbl_product SET UseFlg=0 WHERE ProductKey='%s'5 q" ?# J9 f/ n( J( g
UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'
UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'
update tbl_skill SET CdKey='%s',RegistNumber=%d Where CdKey='%s' and RegistNumber=%dbbs.mocwww.com" ~$ J4 V& Z9 H. y5 f  d4 ]
UPDATE tbl_user SET AccountID='%s' Where CdKey='%s'
UPDATE tbl_user SET BadMsg=0 Where CdKey='%s'
UPDATE tbl_user SET SequenceNumber=%d Where CdKey='%s'
update tbl_user SET SequenceNumber=%d Where CdKey='%s'魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 u( I! m* O: J; s7 g
UPDATE tbl_user SET TrialFlg=%d Where CdKey='%s'魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ k% H$ a% E4 S0 g* f" G: E. e
UPDATE tbl_user SET TrialFlg=%d where CdKey='%s'bbs.mocwww.com3 k8 N% h- ~4 F& u$ R
UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
UPDATE tbl_user SET TrialFlg='%d' Where CdKey='%s'

x_cash_list  未知表略……
update x_cash_list set result='0' where orderid=%d
update x_cash_list set result='1' where orderid=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 j7 t7 c( d$ {+ ^
update x_cash_list set result='-1' where orderid=%d

有事,请 -> 站内PM

TOP

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