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

翼

WING

妖城汉化组成员

Rank: 12

汉化组成员

UID: 3794
精华: 3
积分: 842
威望: 5 度

妖城妖精勋章版主专用勋章优秀会员勋章妖城汉化组成员

阁楼大中小发表于 2008-10-31 15:06 显示全部帖子

魔力宝贝GMSV全部SQL语句

提取出来后仔细看了下，很多BUG可能是由于原来的端在别人错误的汉化下造成的
有些SQL语句不完整或畸形的都可能造成GMSV的不稳定妖城在线论坛4 u. v0 A4 ~* J9 k* @' b

DELETE FROM tbl_addressbook WHERE CdKey='%s' and RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート1 f) i, t3 d; }8 w
DELETE from tbl_character WHERE CdKey='%s' and RegistNumber=%dbbs.mocwww.com' C" @' B$ H1 \9 v) g: B$ t
DELETE FROM tbl_guild WHERE guildID=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ m  Z# p# Q% ^' q8 b4 c6 E; o
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d妖城在线论坛+ h/ Z( ]1 [% H
DELETE FROM tbl_guildItemBox WHERE GuildId=%d
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d3 l9 d* V8 M; y7 K3 M2 {
DELETE FROM tbl_guildItemBox_bak WHERE GuildId=%d魔力私服,最新魔力宝贝私服技术交流6 [% V3 ~$ a7 g' U* p! B
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d4 O' V( |$ z/ t0 ?
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d AND roomID=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表  j9 ]; @, {" z- g% b
DELETE FROM tbl_guildItemBoxPet WHERE guildID=%d and roomID=%d and BoxPosition=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート8 J. u2 h# B+ D0 Q  o; f0 w! J
DELETE FROM tbl_guildItemBoxPet_bak WHERE guildID=%d
DELETE FROM tbl_guildMonster WHERE guildID=%d
DELETE FROM tbl_guildMonster WHERE GuildId=%d妖城在线论坛3 r/ Q& T5 S8 o0 b- M! @
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d妖城在线论坛! `1 }4 W/ L" ]8 ?5 z7 \
DELETE FROM tbl_item WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力宝贝私服技术交流$ i# D5 D* n; ?# s
DELETE FROM tbl_lock WHERE CdKey='%s'妖城在线论坛$ P/ P8 U6 ^1 O  }/ J- T
DELETE FROM tbl_pet WHERE CdKey='%s' and RegistNumber=%d
DELETE FROM tbl_skill WHERE CdKey='%s' and RegistNumber=%d魔力私服,最新魔力宝贝私服技术交流; ~, r$ x9 d  R
INSERT INTO tbl_addressbook VALUES
INSERT INTO tbl_guild SET guildID = %d, CdKey='%s', RegistNumber=%d, serverNumber=%d, roomType=%d , guildName='%s', roomName='%s',createTime=%d, lastA妖城在线论坛' `- i# x" U8 w" E
INSERT INTO tbl_guildItemBox VALUES/ k) }. T1 b' E: M
INSERT INTO tbl_guildItemBoxPet VALUES
INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表- W9 I, A- ~! j3 T( t( O
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=%ld4 G3 i/ J0 K2 X" A" S% A, t8 c( ]
REPLACE tbl_addressbook_bak SELECT * FROM tbl_addressbook WHERE CdKey='%s' and RegistNumber=%d
REPLACE tbl_character VALUES(5 V3 K5 J7 l' v+ a' M0 c! G
REPLACE tbl_character_bak SELECT * FROM tbl_character WHERE CdKey='%s' and RegistNumber=%d+ g1 ?5 w( [( r! L  k" w
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,电影,黑客,网络,网吧,破解,入侵,注册表2 ?6 C' s" u6 Q# `8 b5 k8 h2 B. @- P9 V: ]
REPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d
REPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d
REPLACE tbl_guildItemBoxPet_bak SELECT * FROM tbl_guildItemBoxPet WHERE guildID=%d0 {1 P6 P/ |( {" A
REPLACE tbl_guildMonster VALUES (魔力私服,最新魔力宝贝私服技术交流" t% d9 T/ T, J
REPLACE tbl_guildMonster_bak SELECT * FROM tbl_guildMonster WHERE guildID=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 W  L5 v. `3 b: g+ M8 d1 L3 |
REPLACE tbl_guildMonster_bak SELECT * FROM tbl_guildMonster WHERE guildID=%dbbs.mocwww.com# Q0 E+ M4 b) ]0 J
REPLACE tbl_item_bak SELECT * FROM tbl_item WHERE CdKey='%s' and RegistNumber=%d
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
SELECT * from %s WHERE CdKey='%s' and RegistNumber=%d
SELECT * FROM %s WHERE CdKey='%s' and RegistNumber=%d
SELECT * from %s WHERE CdKey='%s' and RegistNumber='%d'妖城在线论坛; Q: ?  p- ^& @
SELECT * from %s WHERE guildID=%d and roomID=%d and BoxPosition=%d
SELECT * from tbl_" P" {. ]# S" F9 [
SELECT * FROM tbl_character WHERE guildID=%d
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d  Y7 Y5 Q: |' `9 i7 S
SELECT * FROM tbl_guild WHERE guildID=%dbbs.mocwww.com% D, i1 d3 X9 [7 g' n
SELECT * from tbl_guildItemBox WHERE GuildId=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表/ G$ e% [5 ]8 y; r8 C3 ~1 v
SELECT * FROM tbl_guildItemBoxPet WHERE guildID=%d and RoomID=%d
SELECT * FROM tbl_guildMonster; G& ]( S0 L, A
SELECT * from tbl_lock WHERE CdKey='%s'
SELECT * from tbl_skillPopulation
SELECT * from tbl_user WHERE AccountID='%s'妖城在线论坛( l5 n) V9 r5 N8 q$ Q' C7 Q
SELECT * from tbl_user WHERE CdKey='%s'
select * from x_cash_list where result='1' and x_user_id='%s'魔力私服,最新魔力宝贝私服技术交流8 v6 W" w1 h2 F$ b6 G9 z1 z
select * from x_cashitem_list, x_cash_list where x_cashitem_list.hanafosID = %d" m( K5 w4 L% g2 \8 L
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=%d
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=%dbbs.mocwww.com5 t+ a" M$ W8 X! `; Z3 u
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d
select database...bbs.mocwww.com1 V; u) G% @, T6 ~( ^; x
SELECT DataPlaceNumber,Name from tbl_character WHERE CdKey='%s'
select distinct guildID from tbl_character where guildID >=%d and guildID < %d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( U, X" Q+ I6 k1 S( @, s0 P' g
SELECT DISTINCT GuildId FROM tbl_guildItemBoxbbs.mocwww.com, E# A* Y, {1 @0 l
SELECT ExpFlg from tbl_user Where CdKey='%s' and AccountPassWord='%s'魔力私服,最新魔力宝贝私服技术交流1 V& V+ `. ~7 e+ `+ H
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d魔力私服,最新魔力宝贝私服技术交流. i# k8 _" b% l7 W2 e# _2 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
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妖城在线论坛- o; W! ~3 V+ D( R" 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—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート" u2 Y! q" R9 [. Y& M3 }$ N
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
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'妖城在线论坛% Z8 `; T: U, W+ }" z, B8 ]6 W
SELECT Puk3Key, Kind, UseFlg, LinkCdKey, EnableFlgfrom tbl_puk3 WHERE Kind = %d and Puk3Key = '%s'
SELECT RegistNumber, DataPlaceNumber from tbl_character WHERE CdKey='%s'魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表- b& \7 l5 e2 J' _% E8 `* e
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d9 q4 w3 h1 J$ N+ |$ N
SELECT SequenceNumber FROM tbl_user WHERE CdKey='%s'—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート4 j' z. q% e4 [. B/ l) z' t
SELECT SequenceNumber from tbl_user WHERE CdKey='%s'妖城在线论坛9 U# [" C, Z) e
SELECT serverNumber FROM tbl_guild WHERE guildID=%d魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表" q8 m, w: g4 w2 F8 F
SELECT SkillNum,SkillID,SkillLevel,SkillExp,SeqNo FROM %s WHERE CdKey='%s' and RegistNumber=%d
SELECT titleID FROM tbl_character WHERE guildID=%d妖城在线论坛5 Z# R0 z& b8 M% F' k6 w1 h
SELECT TrialFlg from tbl_user WHERE CdKey='%s'
SELECT TrialFlg,DownFlg from tbl_user Where CdKey='%s'
SELECT TrialFlg,ExpFlg from tbl_user WHERE CdKey='%s'bbs.mocwww.com9 A5 _( v: n2 J) ^' a& h
select[妖城在线论坛; m2 g5 U* a9 f" A4 v! D4 f
SELECT\tTrialFlg,DownFlg from tbl_user WHERE CdKey='%s'
update tbl_addressbook SET CdKey='%s',RegistNumber=%d Where CdKey='%s' and RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( S, Y. j  G5 n; q2 u9 f8 ?  Z( 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—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート& n1 A# }; F0 Z/ i+ c4 l6 H% y. y
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  F! |3 R  \. s
update tbl_item SET CdKey='%s',RegistNumber=%d Where CdKey='%s' and RegistNumber=%d—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 s% ^" r, T: 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'
UPDATE tbl_product SET UseFlg=0 WHERE ProductKey='%s'
UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'bbs.mocwww.com4 J+ f) Y5 U' g& a6 {) |7 r6 b( R$ q
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'
UPDATE tbl_user SET BadMsg=0 Where CdKey='%s'
UPDATE tbl_user SET SequenceNumber=%d Where CdKey='%s'bbs.mocwww.com1 m& O$ p" B" z! e* P
update tbl_user SET SequenceNumber=%d Where CdKey='%s'
UPDATE tbl_user SET TrialFlg=%d Where CdKey='%s'
UPDATE tbl_user SET TrialFlg=%d where CdKey='%s'
UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
UPDATE tbl_user SET TrialFlg='%d' Where CdKey='%s'
update x_cash_list set result='0' where orderid=%d
update x_cash_list set result='1' where orderid=%d妖城在线论坛+ Q( w. O+ Z& ^& g# `; w
update x_cash_list set result='-1' where orderid=%d

出售MLSV支持LX平台运行功能名片排行正常可订做各种附加功能！QQ329299845

TOP

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