打印

[魔力私服分享] 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,电影,黑客,网络,网吧,破解,入侵,注册表: s& B0 ?% R! I4 P8 @: \+ r
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道妖城在线论坛$ m7 x  ]5 p- [7 |
SELECT titleID FROM tbl_character WHERE guildID=%d

SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表. z4 k0 e, B: p( p! k! t
select distinct guildID from tbl_character where guildID >=%d and guildID < %d

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

REPLACE tbl_guildMonster_bak 魔力私服,最新魔力宝贝私服技术交流3 n; G. a* \* ?  B

SELECT * FROM  tbl_guildMonster WHERE guildID=%d

REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                魔力私服,最新魔力宝贝私服技术交流; E7 V' ^+ P' ^" K$ N$ c
魔力私服,最新魔力宝贝私服技术交流9 |9 e, t! t3 {9 ?, Q
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d    —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート8 o4 U, T- F' n( @6 K) w

DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力宝贝私服技术交流* {1 h5 }% v4 z. a& y; l
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d             —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( L* S* w$ E. M' E" j

SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox妖城在线论坛' T6 m) e$ f. b5 O, a8 N
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 y' u1 h2 Z6 b% s
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d       妖城在线论坛  ^8 ?7 m+ q9 |9 y" j
魔力私服,最新魔力宝贝私服技术交流9 k# v2 @/ T' a2 Q, @* J% T
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d

SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: z, z5 W3 R4 d6 `
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d                         妖城在线论坛+ l4 h! w+ d- i; B

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—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート7 W7 y* z5 k& X1 @# ~& x/ y

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d                               2 G4 H4 q1 J7 G. }, @8 n

SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d 妖城在线论坛! n5 V- r6 O. f3 B

DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表3 _) Y8 g2 d+ ~# Z) f* y: h* A
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d                            7 t# P% M3 |, B; F
魔力私服,最新魔力宝贝私服技术交流( b& A3 F% [& B
SELECT * FROM tbl_character WHERE guildID=%d                   —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート7 v- ?; W# x0 x* E% v, }( @6 K

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,

OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d                            —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート, D, c- ~0 S5 j: O. O& M

SELECT * FROM tbl_guild WHERE guildID=%d
bbs.mocwww.com  g% c; v& X) o; E+ }4 c
UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d                      # l5 I7 R4 Q+ J" j' f+ N: u2 k

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                            bbs.mocwww.com: M6 x" T9 F& J. J. S

DELETE FROM tbl_guildMonster WHERE GuildId=%d                5 o# b! r- ]; n
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート) p& v% l( B  p' @
REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s)
妖城在线论坛3 [: s  ^( f/ _$ f6 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) ) ^3 T- b' v' i" Q% J8 [0 w5 N

save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d)
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表" R) e2 t* F5 `  _. u; t
INSERT INTO tbl_guildItemBox VALUES                            %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d) 妖城在线论坛: r$ F6 f9 i& R* e& f, v
      %s:%d [7m err: insert guildItemBox (%s)
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 F/ j- M9 e, o) w# z
                  %s:%d [7m err:delete guildItemBox(%s)

SELECT DISTINCT GuildId FROM tbl_guildItemBox                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表& M2 a( g1 g4 r4 K4 o4 _% i
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' V' O9 |4 b, [2 r) D& e8 G
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error魔力私服,最新魔力宝贝私服技术交流3 J0 v7 K+ d. A. I# l4 Y8 e
                           %s:%d [7m MySQL result error
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート4 c9 T  c& F6 H2 {
SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num
         %s:%d [7m err: item full? 魔力私服,最新魔力宝贝私服技术交流/ ]2 B* Y3 c: |5 A- b( a
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 4 `1 s6 k  l) x( e2 R( k9 V" ^) r
                  %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)—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. Y) y+ `8 |8 r
  %s:%d [7m err: get guildItemBox  query魔力私服,最新魔力宝贝私服技术交流6 ^0 R1 I. l& J/ K0 U* p+ U' W# {

SELECT TrialFlg from tbl_user WHERE CdKey='%s'

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'                            魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% s& F  N/ W8 S

  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         妖城在线论坛& ]: ?  K  U" a% P
魔力私服,最新魔力宝贝私服技术交流2 b1 L: n, c1 k2 G* l4 T; V+ x
  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
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 [  ~+ _8 M. K
  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
4 l# E% \( K8 E% R3 X/ J
  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c
妖城在线论坛& h1 e* O" i% G5 u6 P
下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。8 U$ j4 v( j8 E: K4 @# v' k
要拿去就凑合着看看吧。魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表. O( J/ ]# T, a
魔力私服,最新魔力宝贝私服技术交流$ x  b$ f( \# o, b- H  e1 q$ g& H
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]