打印

[魔力私服分享] 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                魔力私服,最新魔力宝贝私服技术交流& v5 {1 u! p" a
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d          bbs.mocwww.com* h/ L* J2 _/ G3 e
bbs.mocwww.com: [; A$ G! a5 l" w1 S0 x
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            魔力私服,最新魔力宝贝私服技术交流4 J* x$ ]4 l: J) [  U# o

select distinct guildID from tbl_character where guildID >=%d and guildID < %d

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError/ d- u" }4 d4 r( {. |+ N' {
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 l6 W9 l8 B0 B! A2 X' d
REPLACE tbl_guildMonster_bak
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 V' ]/ t! P2 p1 m0 h
SELECT * FROM  tbl_guildMonster WHERE guildID=%d                妖城在线论坛/ }% E0 t9 T. b) z! I" W
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート  ?  W) j) }! H/ O0 f" u: M& g" l- r
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                bbs.mocwww.com* o$ K) I, D! s6 v

DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d    魔力私服,最新魔力宝贝私服技术交流3 G5 @& A  M7 L  X; s: C" i

DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d             魔力私服,最新魔力宝贝私服技术交流5 n, ]8 D. i1 v% L
5 a: j+ C. {' u' n1 e& d" P9 z; [; y
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力宝贝私服技术交流& r9 ~! h7 y+ \$ U& t( V" n1 T
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,电影,黑客,网络,网吧,破解,入侵,注册表. p* ^  A. a5 @, P0 U+ v

SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d

SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d

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)
                  %s:%d [7m guildIDOutOfRange

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d
bbs.mocwww.com( O) x4 K% V1 ~& H- F% `, ?
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d 妖城在线论坛  z$ y( a1 w$ U. ?' y$ S% ?0 g" O* v2 q, |

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

SELECT * FROM tbl_character WHERE guildID=%d                   , K. n* E: W- i5 J7 L
妖城在线论坛( u9 y% D  X: v% J  y" E
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート7 F  r- _  X* n
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 r8 A0 t  R, K. G% L$ P! J$ Q
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                      妖城在线论坛5 S9 j5 `: D9 f8 f

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,电影,黑客,网络,网吧,破解,入侵,注册表& X% ]0 J5 P3 Y9 u$ ~0 J; {& F

DELETE FROM tbl_guildMonster WHERE GuildId=%d                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 [2 R5 Z! H5 }# x2 W" A

REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表3 n+ }& {( x. G6 Z
妖城在线论坛2 E# k" l& f# A$ c, E( B
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) 魔力私服,最新魔力宝贝私服技术交流5 N/ s5 X  _( C2 c0 R, X8 [0 r
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 E4 @4 w4 p3 A! C4 }
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表/ h# d  J$ w: k1 x

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) 妖城在线论坛* U1 u) B" {5 f- }  `/ l9 G5 }0 h
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
                  %s:%d [7m err:delete guildItemBox(%s) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 j; k3 q2 J2 x7 Q
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' M) e* F" Y9 P) B( Q# E( X' y# J  M/ ~
SELECT DISTINCT GuildId FROM tbl_guildItemBox
魔力私服,最新魔力宝贝私服技术交流5 t; {. B5 `$ h" [! J4 {9 d, w
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error
                           %s:%d [7m MySQL result error妖城在线论坛) {' @# g: o( _1 c. |

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)
                  %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 妖城在线论坛% t6 S) B) r0 V% d1 U3 q* a
                  %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m                               %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)bbs.mocwww.com7 H* u- Q5 s2 {0 q' `. w9 O) s
  %s:%d [7m err: get guildItemBox  query妖城在线论坛7 O4 P: P+ |) E( W8 S

SELECT TrialFlg from tbl_user WHERE CdKey='%s'
魔力私服,最新魔力宝贝私服技术交流& S/ N- ~' e! w- u
  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'                            魔力私服,最新魔力宝贝私服技术交流1 c; u0 p3 n* k' U
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# \) ~1 t4 |# t5 ]$ J. |
  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         魔力私服,最新魔力宝贝私服技术交流6 }* Y! B# 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魔力私服,最新魔力宝贝私服技术交流! ?! d+ w1 C8 U
bbs.mocwww.com: i+ N, h% V/ k- u" N9 ?
  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'             魔力私服,最新魔力宝贝私服技术交流2 j3 z* J1 ^+ \

  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c

下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。
要拿去就凑合着看看吧。
妖城在线论坛4 _' _' e7 e* Z, _
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]