打印

[魔力私服分享] GMSV提取出来的数据库表结构数据

hotpursuit

妖精

Rank: 2 Rank: 2

UID: 2420
精华: 0
积分: 329
威望: 0 度
性别: 男

阁楼大中小发表于 2008-4-29 14:54 只看该作者

GMSV提取出来的数据库表结构数据

SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道妖城在线论坛- K8 f4 v8 L7 ^; |, A8 e8 ]
SELECT titleID FROM tbl_character WHERE guildID=%d

SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            妖城在线论坛3 w. P* v" y( z9 N& `/ F
魔力私服,最新魔力宝贝私服技术交流& H& y  x* c4 S, o! _- p* o
select distinct guildID from tbl_character where guildID >=%d and guildID < %d

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError
魔力私服,最新魔力宝贝私服技术交流( [+ B- {# H. h! d4 |
REPLACE tbl_guildMonster_bak
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 R- x, Y# ?6 D1 \$ L5 ?) A
SELECT * FROM  tbl_guildMonster WHERE guildID=%d
bbs.mocwww.com5 J& N! `# U7 K: Z3 B- A; Z
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d
魔力私服,最新魔力宝贝私服技术交流) t& _+ n0 R5 {! [
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
7 s0 u- U7 ?6 u4 M% f8 g
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d             魔力私服,最新魔力宝贝私服技术交流5 l( t# P- v  {# u  m3 f
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) }8 R4 g/ z4 h: r  O. L
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
4 N( _5 b% _: d3 h& Y& _
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox
魔力私服,最新魔力宝贝私服技术交流" |) b. [( H! s4 m, M* ~( |
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d

SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d

SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
bbs.mocwww.com- }: ]0 v4 l: e/ y
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d                         —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* R, ^$ n' M9 ?7 C/ ?
+ A7 l0 y9 o# d/ y! C
INSERT INTO tbl_guild SET guildID = %d, CdKey='%s', RegistNumber=%d, serverNumber=%d, roomType=%d , guildName='%s', roomName='%s',createTime=%d, lastAccess=%d, titleName0='%s', commition0=%d, floorID=%d                   %s:%d [7m createGuildQuery error (%s)
                  %s:%d [7m guildIDOutOfRange

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d

SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d
bbs.mocwww.com6 h0 C5 J! [" e5 O
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom
魔力私服,最新魔力宝贝私服技术交流. _1 ~; Q, c; m* Z
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表+ N, _4 _2 p; |  v& ?; Q
SELECT * FROM tbl_character WHERE guildID=%d                   魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 L- e6 r9 I3 J2 O/ ]! R9 r

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, 1 L# x& X1 X, q: s7 E

OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d                            妖城在线论坛* }, B. f" [5 t3 I

SELECT * FROM tbl_guild WHERE guildID=%d

UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d
妖城在线论坛& {7 ?. ~3 @9 D( c5 S6 q6 v7 I
UPDATE tbl_guild SET CdKey='%s', RegistNumber=%d,roomType=%d, guildName='%s', roomName='%s', brief='%s', lastAccess=%d,guildMark=%d                            , titleName%d='%s', commition%d=%d

DELETE FROM tbl_guildMonster WHERE GuildId=%d
bbs.mocwww.com  W0 u2 g3 k1 h  c- M1 z; `
REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s) bbs.mocwww.com: z3 Z) g9 o- f: ~( ~

UPDATE tbl_character SET closenessMonster%d=0 WHERE guildID=%d  %s:%d [7m make_guildItemBoxSql : char data failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 妖城在线论坛4 z* ~9 l! h7 _1 V

save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d)

INSERT INTO tbl_guildItemBox VALUES                            %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d)
      %s:%d [7m err: insert guildItemBox (%s) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* k  w* \- C7 r
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 魔力私服,最新魔力宝贝私服技术交流0 U* m" q* l7 p* H/ w# L2 b6 D8 }
                  %s:%d [7m err:delete guildItemBox(%s)
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( j" T4 \# ^( W$ g/ N7 Y
SELECT DISTINCT GuildId FROM tbl_guildItemBox
bbs.mocwww.com- W! ^+ s9 N( W# F
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error
                           %s:%d [7m MySQL result error魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% I1 W4 R0 o2 B
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 a, q0 G, J% t5 ?; \& l. X) U' a
SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num妖城在线论坛& p4 v+ x2 l) ~; f' n; F
         %s:%d [7m err: item full? 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) |+ }( Q) {* A, |, Z$ @7 s
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
                  %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: D% i' j6 W% d3 e5 E) Y
                  %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m                               %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)
  %s:%d [7m err: get guildItemBox  query) C2 I( Z% b% K7 m! h

SELECT TrialFlg from tbl_user WHERE CdKey='%s'

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'                            bbs.mocwww.com- y! I  L' B8 _8 O2 w
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; t3 A! a$ }: i
  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) [7 L  A% `( |; i# n
  SELECT Puk3Key, Kind, UseFlg, LinkCdKey, EnableFlgfrom tbl_puk3 WHERE Kind = %d and Puk3Key = '%s'                            %s:%d [7m err Graduation: already use ProductKey %s By %sbbs.mocwww.com" c  u' Q. Y! I' Z
妖城在线论坛5 t$ g- L) C( h$ R* C
  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート" L  h+ S" y3 ]
  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c 魔力私服,最新魔力宝贝私服技术交流) P2 K. e+ W/ {9 ?, A' k$ G
bbs.mocwww.com1 O6 P: j' @% u- ]) [. l0 k2 x
下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。+ R$ V6 ]5 H+ o+ [5 A: _
要拿去就凑合着看看吧。妖城在线论坛( T% F1 P: l$ G( R( T

[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]