打印

[魔力私服分享] 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                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート1 N6 D$ k  h5 `
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段bbs.mocwww.com; x" q, E- ?* [
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d          魔力私服,最新魔力宝贝私服技术交流" }' t! f: i3 P6 ?4 j

SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( H* M+ Z4 }3 e$ j' b: U
select distinct guildID from tbl_character where guildID >=%d and guildID < %d
妖城在线论坛/ z6 @( Z* D4 l4 U
SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError

REPLACE tbl_guildMonster_bak
* b3 J9 R6 _3 M+ d$ l
SELECT * FROM  tbl_guildMonster WHERE guildID=%d                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート5 t# _4 Z# F* |* ?! B( n

REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d
bbs.mocwww.com" k/ k* ^% J: o( w- P$ E6 ^
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
! _. N) E5 O. |( w) B& R" D  b
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
bbs.mocwww.com$ s$ _: z% ], X$ T0 b* O/ K
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
, R9 m! }; @! R$ V: ^
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; O* }# q  Y( @' ~# M
妖城在线论坛8 a3 p  w/ y( y4 _4 }* t* Z* n
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d       8 ^* i1 ~# z+ y5 X, k) J  }
' M" _4 v7 z# \5 E0 r6 K
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d 6 J0 U- ~% {7 Q* J7 }& \
魔力私服,最新魔力宝贝私服技术交流8 B) T$ r# d2 M% a1 ~
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
妖城在线论坛7 a7 H6 a6 Q1 C
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d

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) bbs.mocwww.com# {/ [) h/ A, m' k: ?+ m" i# m6 L
                  %s:%d [7m guildIDOutOfRange

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d
妖城在线论坛  M, ^& r1 Y, x) O
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d

DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom

SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% Y# P1 w* L# c1 b" A0 M
SELECT * FROM tbl_character WHERE guildID=%d                   妖城在线论坛( O. T/ W6 G2 g4 G0 N

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, 8 K( R6 q3 u! i6 ~5 ?
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) h8 T3 h8 c9 U* w4 d9 |
OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d

SELECT * FROM tbl_guild WHERE guildID=%d                      bbs.mocwww.com) G! ]9 Q' m; I+ J& G" a* L

UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 e+ W% ?( x+ L9 c" }' T9 J
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                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' Y4 _# C% J3 n( s
" k1 Z7 ?( o4 d  H: {. k
REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s)

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)

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) bbs.mocwww.com' c( N/ A8 \6 [5 u
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 6 W9 a; c1 K' @5 w' W
                  %s:%d [7m err:delete guildItemBox(%s)
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表; f& C! Z% s6 ?" z3 c8 `
SELECT DISTINCT GuildId FROM tbl_guildItemBox                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表2 a' S0 N. N  ]3 p: Y  X- ~5 f

guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error妖城在线论坛& s' t7 e# ~' s+ Z' W/ \
                           %s:%d [7m MySQL result error
9 D: [% s0 T: g0 j; b0 ]
SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num
         %s:%d [7m err: item full? —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; C* L9 I6 F5 D$ T/ k/ B1 U
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 9 t, ~2 y% W* a# v5 I
                  %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
                  %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m                               %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)
  %s:%d [7m err: get guildItemBox  query' S' s* R% B9 A6 I7 x- i" M2 ]

SELECT TrialFlg from tbl_user WHERE CdKey='%s'
魔力私服,最新魔力宝贝私服技术交流; M1 }: s( A+ }, W4 H* F3 v/ \
  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'

  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c
妖城在线论坛  V- s. q& `. c7 O0 c  D$ T
  SELECT Puk3Key, Kind, UseFlg, LinkCdKey, EnableFlgfrom tbl_puk3 WHERE Kind = %d and Puk3Key = '%s'                            %s:%d [7m err Graduation: already use ProductKey %s By %s

  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
bbs.mocwww.com5 n. L# f9 Q1 U+ E( M
  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c bbs.mocwww.com; e# J1 q8 C  F) w4 s! G" y

下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。
要拿去就凑合着看看吧。魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表  \! D( o* P$ f; b7 Q5 w) E4 ]
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* X/ t" c) ]" Y( t+ h- Q  E
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]