打印

[魔力私服分享] 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,电影,黑客,网络,网吧,破解,入侵,注册表8 P" V4 p3 U. H# r5 }) U( f# j
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d
妖城在线论坛. @" R0 |( K5 X# D* G1 x, w
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            bbs.mocwww.com3 |8 a* `. D/ E0 ?$ t( a

select distinct guildID from tbl_character where guildID >=%d and guildID < %d
bbs.mocwww.com- D- z2 b/ @2 V* p
SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 u8 k; `4 z' r" j7 r* R

REPLACE tbl_guildMonster_bak ; H" m( B: E5 l! p) B
bbs.mocwww.com- u0 O6 `/ R# A/ l! E  B, U' Z% z: }: ]
SELECT * FROM  tbl_guildMonster WHERE guildID=%d                妖城在线论坛, J2 t7 N8 u8 i4 z% ^, z' g1 t
魔力私服,最新魔力宝贝私服技术交流1 e% u( P- Q. {# |* x( _( p% G
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d

DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
  E; m& Z1 p7 Q7 R  G
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d             bbs.mocwww.com( w8 u; o) H$ f/ @; ?

DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d             bbs.mocwww.com5 Z8 Q5 P; j. ^5 v* G5 D, _
bbs.mocwww.com, x8 P  u" ^$ S) H8 ?
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) B5 j9 a% |8 S+ V) m) o7 h
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d + ?( Z7 m0 {4 z, Y2 B* l
妖城在线论坛9 `1 o( o: n+ [: D
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d ) t$ V- Z0 Z& j/ {' @: C9 O& y6 ~

SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力宝贝私服技术交流1 K, T5 h+ Y8 i7 b& Q# R
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, a8 ]' F. u8 F2 {: e% m
                  %s:%d [7m guildIDOutOfRange

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d                               魔力私服,最新魔力宝贝私服技术交流: T/ H7 y" E, w/ n

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,电影,黑客,网络,网吧,破解,入侵,注册表/ B1 @2 j+ |: d

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

SELECT * FROM tbl_character WHERE guildID=%d                   bbs.mocwww.com+ z5 L! R' G- S. l$ X  H; G# r) U0 S
魔力私服,最新魔力宝贝私服技术交流! t) y/ x) I9 j
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, bbs.mocwww.com, G( `3 Y% r: p- W! j2 ~

OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d

SELECT * FROM tbl_guild WHERE guildID=%d

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
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: E3 B- I. v6 b: g7 ]$ n; v
DELETE FROM tbl_guildMonster WHERE GuildId=%d                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 r- O; q- R' {+ m
魔力私服,最新魔力宝贝私服技术交流+ r- G- q& n. u' F
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) 妖城在线论坛' V) p! u3 t/ g* K5 p) x
魔力私服,最新魔力宝贝私服技术交流8 z- E+ W5 O2 ^9 {" M
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d)
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 _7 X! M  d- \9 l- C
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)
               %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                0 q% H. o& ?, |/ f6 u

guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error妖城在线论坛$ @/ d" b$ u5 _
                           %s:%d [7m MySQL result error
# w1 I9 O3 \3 ^2 M3 K
SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num
         %s:%d [7m err: item full? —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 T, J' Y3 H& n- R+ f' w/ [- N" s. c
%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) bbs.mocwww.com, J+ |+ U' ~; t* 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
bbs.mocwww.com# {" D3 y5 A$ l: N  I- o, ~
SELECT TrialFlg from tbl_user WHERE CdKey='%s'                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 Q9 j+ a+ g3 O1 y

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* ]  m/ g+ n5 h0 W. u
  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         ) R8 I' i4 u/ {4 f, O- L) K2 R
妖城在线论坛# N& g1 I4 l7 G4 K* @) W. W! C# i
  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
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 b  B3 d" w6 u/ Y" V5 |  }
  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 魔力私服,最新魔力宝贝私服技术交流# l% h- t" Q) H4 L3 I, U3 F) O

下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。
要拿去就凑合着看看吧。
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 R) l$ W) q" H
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]