[魔力私服分享] 魔力宝贝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  的所有名片内容魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表, u+ M# m0 ]1 I0 \- L  F! }

DELETE from tbl_character WHERE CdKey='%s' and RegistNumber=%d
删除角色信息  在表 tbl_character 中条件是帐户为 %s 人物注册序列为 %d
魔力私服,最新魔力宝贝私服技术交流; o3 e/ N* T6 u# X" t
DELETE FROM tbl_guild WHERE guildID=%d
删除字段guildID(家族序号) 的所有信息在  tbl_guild 中
(删除家族的函数调用)

DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ E/ N7 t' F# X) \' l  w7 z5 ^/ }
在tbl_guild 中删除帐户为 %s  注册序列为 %d  的成员信息
(删除家族成员 )

以下略 ……
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート# U, u$ ~. i( ]& b2 B2 O
DELETE FROM tbl_guildItemBox WHERE GuildId=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表& ]  }5 T8 A3 ~9 }! k0 S
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
DELETE FROM tbl_guildItemBox_bak WHERE GuildId=%d7 h5 v7 Z8 w  t6 h
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%dbbs.mocwww.com4 @' g6 g9 ^8 a% d, Z0 h/ j# G
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d AND roomID=%d
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d and roomID=%d and BoxPosition=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. }2 t1 _/ q% K5 O9 s; w+ k$ R7 c6 W
DELETE FROM tbl_guildItemBoxPet_bak WHERE guildID=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート# `5 E/ ?: d+ e- P/ A$ w
DELETE FROM tbl_guildMonster WHERE guildID=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 h- W3 H9 h' p* K( ?- |( _8 U
DELETE FROM tbl_guildMonster WHERE GuildId=%d
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d妖城在线论坛; Z5 p6 O) x$ Q5 S  r- E

DELETE FROM tbl_item WHERE CdKey='%s' and RegistNumber=%d
删除帐户为%s  注册序列为%d  的角色所有物品信息妖城在线论坛* q2 N2 C9 W9 X0 s4 R$ Z% ~
/ l& W9 [( x" o$ e' |, ^
DELETE FROM tbl_lock WHERE CdKey='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 h7 D# j/ l+ {9 Y
在 tbl_lock 中删除  帐户为 %s的信息（踢号）

DELETE FROM tbl_pet WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表- J6 r4 C% {2 W) E3 z
删除帐户为 %s  注册序列为 %d 的所有宠物信息魔力私服,最新魔力宝贝私服技术交流+ e/ F$ l. U! o" g" S" E. o6 f

DELETE FROM tbl_skill WHERE CdKey='%s' and RegistNumber=%d
同上  技能信息bbs.mocwww.com7 d% Q, Y" c+ e* U4 j! o) [6 E
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表1 O' O, Z- M0 N( j" ]
INSERT INTO tbl_addressbook VALUES魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表2 f7 E1 c6 P/ U  }
插入记录在 tbl_addressbook中值  （？未知）
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' K8 X0 j: M" G$ ~
以下错误太多略……4 V3 _& _- S5 b- e( \5 V5 p
INSERT INTO tbl_guild SET guildID = %d, CdKey='%s', RegistNumber=%d, serverNumber=%d, roomType=%d , guildName='%s', roomName='%s',createTime=%d, lastA魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 V% A$ q" h/ {, ^' u* x9 g: |/ z
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 VALUESbbs.mocwww.com6 P+ j3 h7 U+ o
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—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 N% z3 Y6 ~: |$ c1 F8 a! v
REPLACE tbl_character VALUES(魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表& Y( ]$ A& U1 k* o. P7 P
REPLACE tbl_character_bak SELECT * FROM tbl_character WHERE CdKey='%s' and RegistNumber=%dbbs.mocwww.com% ~" s0 h0 _( x4 W
REPLACE tbl_duelranking SET CdKey='%s',RegistNumber='%d',Name='%s', Lv=%d, DuelPoint=%d, Date=%d4 }3 }# F! l  I# C0 E. T/ T
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—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート+ @& Z- k7 s! W3 b) B
REPLACE tbl_guildItemBoxPet_bak SELECT * FROM tbl_guildItemBoxPet WHERE guildID=%d
REPLACE tbl_guildMonster VALUES (
REPLACE tbl_guildMonster_bak SELECT * FROM tbl_guildMonster WHERE guildID=%d- d' s% N; F* {4 y
REPLACE tbl_guildMonster_bak SELECT * FROM tbl_guildMonster WHERE guildID=%d魔力私服,最新魔力宝贝私服技术交流. q- U; r0 J: g
REPLACE tbl_item_bak SELECT * FROM tbl_item WHERE CdKey='%s' and RegistNumber=%d妖城在线论坛& G4 K6 p! \+ b  L0 o, R
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
妖城在线论坛0 Z7 K) P6 V  P: n' \: z# M

SELECT * from %s WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 @2 c1 @) x1 s
查询 %S 表条件是 cdkey为 %s  注册ID为 %d (这是个备用语句前面的%s不同就代表不同表，可以查到不同表的信息)
魔力私服,最新魔力宝贝私服技术交流( ^0 _' ~1 n7 K1 j6 M
以下略……
SELECT * FROM %s WHERE CdKey='%s' and RegistNumber=%d
SELECT * from %s WHERE CdKey='%s' and RegistNumber='%d'妖城在线论坛5 d: u4 m7 w* X
SELECT * from %s WHERE guildID=%d and roomID=%d and BoxPosition=%d
SELECT * from tbl_魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 Z- e6 r8 K0 V2 a. n' [. ^$ U
SELECT * FROM tbl_character WHERE guildID=%d魔力私服,最新魔力宝贝私服技术交流* C4 q& K9 {  B. U4 k
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
SELECT * FROM tbl_guild WHERE guildID=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( g2 a7 g- C9 ~3 T) e$ G0 N
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'
SELECT * from tbl_skillPopulation魔力私服,最新魔力宝贝私服技术交流3 Q: I" o9 }0 k7 W% v& q& Z3 W
SELECT * from tbl_user WHERE AccountID='%s'bbs.mocwww.com' S3 H/ |* p+ p9 s: u0 m; `% C
SELECT * from tbl_user WHERE CdKey='%s'
select * from x_cash_list where result='1' and x_user_id='%s'
select * from x_cashitem_list, x_cash_list where x_cashitem_list.hanafosID = %d
SELECT CdKey, Name, RegistNumber, Lv, Fame, MainJob, DuelPoint from tbl_character WHERE CdKey='%s'魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表! h$ t9 `* x3 t' l& {7 Q/ D
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d
SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 ]3 `) I0 G( h
SELECT CdKey,AccountID,AccountPassWord,EnableFlg,UseFlg,BadMsg from tbl_user Where CdKey='%s' or AccountID='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. y. g9 v" v$ h( z2 T" ~7 Q+ b
SELECT COUNT(*) from tbl_character WHERE Debugger=0 and JobAncestry=%d
SELECT COUNT(*) from tbl_character WHERE Debugger=0 and MainJob=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート# l& w2 ?% m2 z8 j" K( \
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d
select database...
SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; f0 ]7 ~$ V, m8 ^* F+ F# E
select distinct guildID from tbl_character where guildID >=%d and guildID < %d# s2 ?1 z& X. ?9 o' j( w" j
SELECT DISTINCT GuildId FROM tbl_guildItemBox
SELECT ExpFlg from tbl_user Where CdKey='%s' and AccountPassWord='%s'; L7 D2 P! a, q( w2 d
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) F1 w9 [% Y" o* z
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. C. I' o2 n# b/ A9 M
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( M# P  j5 o: I/ q/ d& m4 l" m
SELECT ProductKey, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_product WHERE Kind = %d and ProductKey='%s'
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'bbs.mocwww.com- H' g0 S1 [7 W( Y
SELECT RegistNumber, DataPlaceNumber from tbl_character WHERE CdKey='%s'bbs.mocwww.com7 |- T, {% }% N, [3 h
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d魔力私服,最新魔力宝贝私服技术交流6 u! ]5 M" @; p3 ]+ Q: b. ~
SELECT SequenceNumber FROM tbl_user WHERE CdKey='%s'
SELECT SequenceNumber from tbl_user WHERE CdKey='%s'
SELECT serverNumber FROM tbl_guild WHERE guildID=%d+ [* n$ E  j% q4 \
SELECT SkillNum,SkillID,SkillLevel,SkillExp,SeqNo FROM %s WHERE CdKey='%s' and RegistNumber=%dbbs.mocwww.com- O% D! P1 d0 z! f
SELECT titleID FROM tbl_character WHERE guildID=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* r1 p. k! I4 l1 i) y$ \
SELECT TrialFlg from tbl_user WHERE CdKey='%s'
SELECT TrialFlg,DownFlg from tbl_user Where CdKey='%s'魔力私服,最新魔力宝贝私服技术交流2 [. N3 t. T1 M% e' G1 v
SELECT TrialFlg,ExpFlg from tbl_user WHERE CdKey='%s'
select[
SELECT\tTrialFlg,DownFlg from tbl_user WHERE CdKey='%s'妖城在线论坛- s  t4 l' }$ \- N+ z" V
update tbl_addressbook SET CdKey='%s',RegistNumber=%d Where CdKey='%s' and RegistNumber=%d( i  Z$ S% Z! o( I  Y: M9 `
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=%dbbs.mocwww.com0 D  ?' I* z0 I7 k( k
update tbl_character SET DataPlaceNumber=%d Where CdKey='%s' and RegistNumber=%d
UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d
UPDATE tbl_guild SET CdKey='%s', RegistNumber=%d,roomType=%d, guildName='%s', roomName='%s', brief='%s', lastAccess=%d,guildMark=%d魔力私服,最新魔力宝贝私服技术交流& T: V! j/ k( l2 J) i
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妖城在线论坛- X6 _% F. \' X$ t& f, t4 ^6 s5 J0 O# ~
UPDATE tbl_product SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where ProductKey='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: J# d6 X* g/ L5 T/ _
UPDATE tbl_product SET UseFlg=0 WHERE ProductKey='%s'
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=%d
UPDATE tbl_user SET AccountID='%s' Where CdKey='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: M" d" J$ s3 [+ N4 G, j
UPDATE tbl_user SET BadMsg=0 Where CdKey='%s'魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: O! I7 M) \0 o4 w/ o$ i* l* b
UPDATE tbl_user SET SequenceNumber=%d Where CdKey='%s'; G2 c7 y) }  l- H0 h0 w
update tbl_user SET SequenceNumber=%d Where CdKey='%s'魔力私服,最新魔力宝贝私服技术交流8 @' c5 I6 C) C( \' |) \2 f. C' A
UPDATE tbl_user SET TrialFlg=%d Where CdKey='%s'
UPDATE tbl_user SET TrialFlg=%d where CdKey='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. O4 ~: ^; `$ T1 P2 l8 ?
UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
UPDATE tbl_user SET TrialFlg='%d' Where CdKey='%s'

x_cash_list  未知表略……, ?; Q4 d  `5 V
update x_cash_list set result='0' where orderid=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 D3 L4 A, \- d" u2 w% h
update x_cash_list set result='1' where orderid=%d& V0 v( {  A9 z! D6 y* n( [: `
update x_cash_list set result='-1' where orderid=%d

有事,请 -> 站内PM

TOP

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