打印

[魔力私服分享] 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                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% C& m/ H/ h" q5 s9 P( [% _
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d          3 ^" G. ^; ^8 I& M* z
bbs.mocwww.com  v$ @( S& F2 i/ b
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: j+ W+ ?( n. Y6 t  C

select distinct guildID from tbl_character where guildID >=%d and guildID < %d                bbs.mocwww.com+ o1 d, B8 J/ }1 C" h7 I

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError

REPLACE tbl_guildMonster_bak —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* n, R/ G+ h' D& D( P' ~9 Y; {  I/ R) U

SELECT * FROM  tbl_guildMonster WHERE guildID=%d
妖城在线论坛' y) p$ x1 ~# X( ?
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ e* \) Y. X5 H; u5 N) K
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 @1 W. R% T3 Q' C6 S; e
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
* s' t+ v% T5 ^' v* Y3 ?! n
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
bbs.mocwww.com% S! f, s" C; s
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d

SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' s. p7 m0 Q3 f, Y) F# ^9 T
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d
魔力私服,最新魔力宝贝私服技术交流9 z3 O1 u/ ^! ~; V1 h8 J
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d
妖城在线论坛7 s3 O- j5 ~/ z" d. @8 s6 {
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d

SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート+ u9 {9 y1 U& K
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) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 d+ l/ W  ~. F! ], s
                  %s:%d [7m guildIDOutOfRange—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート! ?4 i; Z2 t' W; d8 ]

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d                               魔力私服,最新魔力宝贝私服技术交流3 p2 e9 ~& o" v$ S8 m

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魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( ~4 S; X6 L6 X# `" S1 o5 k

SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d

SELECT * FROM tbl_character WHERE guildID=%d
bbs.mocwww.com. d2 e6 F% o/ b6 }: B
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 k" T* ]3 L, ?) B

OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d                            —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート8 @; x1 y$ D& h- A& a9 w, Q
% E# B# z/ j3 Y5 Y1 x* O1 L
SELECT * FROM tbl_guild WHERE guildID=%d                      魔力私服,最新魔力宝贝私服技术交流( _  w( g2 ?6 W& K, v% v
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表! t0 p/ m8 m! ^8 c7 [. D
UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d                      妖城在线论坛! z9 R1 L! x' P# D/ {4 q$ u

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                魔力私服,最新魔力宝贝私服技术交流4 n) O7 b2 e2 F  q

REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s) ; Z8 G+ r) e2 T0 ~; \: 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) 妖城在线论坛) m$ F& `" f( e4 ~
魔力私服,最新魔力宝贝私服技术交流/ _, u) E! i2 w/ ^
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) 妖城在线论坛. Q7 `$ ~1 ^7 @5 Z. h9 s* W

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) 魔力私服,最新魔力宝贝私服技术交流: L/ |2 d( e: ]8 p4 u6 Z+ m: n
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
                  %s:%d [7m err:delete guildItemBox(%s) ! e0 u3 @0 V! b- B6 O6 ~

SELECT DISTINCT GuildId FROM tbl_guildItemBox

guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error
                           %s:%d [7m MySQL result error妖城在线论坛0 J1 `! V/ b3 r% G, `

SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num
         %s:%d [7m err: item full?
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 妖城在线论坛% N2 [4 c; f' e. [6 G: n$ a
                  %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 2 {0 O. ^& Z+ {1 g  Z* Y. ~1 ]
                  %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m                               %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% T7 l2 M6 B) z+ H6 A
  %s:%d [7m err: get guildItemBox  query

SELECT TrialFlg from tbl_user WHERE CdKey='%s'

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
魔力私服,最新魔力宝贝私服技术交流7 t- u: B* w- c: T  b
  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート4 l9 t. v- s$ h. ^1 s- D. m
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表! I, n$ p, [- U' O; 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 %s

  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'

  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c 魔力私服,最新魔力宝贝私服技术交流* a. S) @# m. Z; ?* N  s: G
魔力私服,最新魔力宝贝私服技术交流$ A" k1 R! P# D' P7 g
下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。魔力私服,最新魔力宝贝私服技术交流7 c8 {8 z! K( u, d
要拿去就凑合着看看吧。

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