打印

[魔力私服分享] 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 段1 C9 H& P9 J- S% T2 }" S2 M
具体怎么写我也不知道bbs.mocwww.com0 N& K0 q1 m" E9 X
SELECT titleID FROM tbl_character WHERE guildID=%d          —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート5 O3 a4 m, i: r6 k) Z2 F
魔力私服,最新魔力宝贝私服技术交流  F$ t# b( V# c  A- L7 x1 y
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 N, O& z1 F$ N, [! R9 }" f" \
select distinct guildID from tbl_character where guildID >=%d and guildID < %d

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError$ e: j4 u. l! I" A& k% p' [' }! k
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート  D9 D/ Y1 q$ G2 H* x6 V
REPLACE tbl_guildMonster_bak

SELECT * FROM  tbl_guildMonster WHERE guildID=%d
bbs.mocwww.com6 H6 v, s4 v4 ^; m- ~
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                魔力私服,最新魔力宝贝私服技术交流9 z( p* ^2 i1 F0 V

DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d

DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d

DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d             妖城在线论坛* D) u# n+ s' E$ O: {' H( c
魔力私服,最新魔力宝贝私服技术交流" E* M( p6 `* ^  V
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox魔力私服,最新魔力宝贝私服技术交流5 d" r4 X- K% R/ ]" T
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ D8 ^" r& x) ~: b9 f
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d       bbs.mocwww.com& }1 ?5 X1 [0 c1 `1 z
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート1 L$ k5 y& e$ a% q4 v
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d

SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d bbs.mocwww.com0 R4 v1 d* Z# ^1 }! Y1 G9 e+ x/ Q

SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d                         魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 ]& v, d+ E& h; L
妖城在线论坛! \0 s% n5 ?5 q1 w, S/ b! {8 ?2 h
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,电影,黑客,网络,网吧,破解,入侵,注册表* k5 M: K% O/ T7 p  {4 r* q: F/ p
                  %s:%d [7m guildIDOutOfRangebbs.mocwww.com1 b$ Z3 v5 P5 l: C# O  m. N& m& g- B
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; w6 K( P% b- p1 `
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

DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( z3 e( E) ^! I- H7 n* x
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d                            魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( S9 ^( H# `' u! {4 u7 n
bbs.mocwww.com* |' F5 T! e9 I3 t) o* G. ?
SELECT * FROM tbl_character WHERE guildID=%d                   * C1 r/ T! j* x3 L2 a( s$ G

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表1 m5 P/ l9 N1 @7 b. ?. u

OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力宝贝私服技术交流  D; I6 e/ Q6 ]8 w' m6 D8 k! \
SELECT * FROM tbl_guild WHERE guildID=%d                      魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 n" r* ~0 a* @0 m
妖城在线论坛' n, {! Z0 C) q3 F( e+ f! W
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                            , titleName%d='%s', commition%d=%d
. w4 w& _+ E7 S3 Z4 I5 T$ b5 R: i/ A% K
DELETE FROM tbl_guildMonster WHERE GuildId=%d                5 O& U' K1 \+ L( E5 d
妖城在线论坛1 Z" V0 u& ]; e; p0 E/ t4 A+ J
REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s)
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表. c& `4 j9 J* D" x2 w; g6 K
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) 魔力私服,最新魔力宝贝私服技术交流& R8 S% v; `2 H% s& C3 X

save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 ?! B' h( f# C1 L  X. R2 O( r$ ^
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 @, X. X) G1 _5 P5 [8 [
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) ' I* m: _6 s6 q( V
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
                  %s:%d [7m err:delete guildItemBox(%s)

SELECT DISTINCT GuildId FROM tbl_guildItemBox
妖城在线论坛# v. J3 t+ |4 K: i* R: I! r
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error
                           %s:%d [7m MySQL result error

SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表4 q0 Q* Z% G: g- ], t5 |. [# j
         %s:%d [7m err: item full?
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 k& n. F7 Y% i2 P4 E. m8 z3 f/ j5 h3 ?* k
                  %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ U, _% N* w6 x% D2 c7 ]& }8 u! J, W% Q8 O
                  %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m                               %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)# A  T$ M6 g2 l/ R
  %s:%d [7m err: get guildItemBox  query7 o* o& Z  D2 x4 k, B4 n% j
1 B0 ^: h, P+ n, x8 J& N# L, k( ^
SELECT TrialFlg from tbl_user WHERE CdKey='%s'                bbs.mocwww.com; i7 N" p. Z$ V: }# t

  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

  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
bbs.mocwww.com+ |$ @% _0 J/ |9 G% ]
  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
bbs.mocwww.com; j- w+ c4 N  [" |4 R
  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c
bbs.mocwww.com3 x2 H$ w5 W1 n
下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。8 u: d% B( h9 Z+ S7 K7 N$ C; e$ s: B
要拿去就凑合着看看吧。魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 B2 \9 i- h/ k

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