打印

[魔力私服分享] 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                bbs.mocwww.com4 e$ o. y$ Z: p3 V; j; o2 M
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段bbs.mocwww.com  Q: v/ {: J4 J; C# y( n
具体怎么写我也不知道—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート1 s/ d4 R. j* H' t+ M
SELECT titleID FROM tbl_character WHERE guildID=%d

SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            bbs.mocwww.com9 k; \7 c3 ~9 {1 Y' J) _

select distinct guildID from tbl_character where guildID >=%d and guildID < %d                魔力私服,最新魔力宝贝私服技术交流& ^+ ~: e, y3 Z' k7 j

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadErrorbbs.mocwww.com/ F1 K* i6 i: P9 e  t+ {
bbs.mocwww.com! K0 C& L9 _' B
REPLACE tbl_guildMonster_bak 3 y" o0 i3 N4 Q5 \6 q# G

SELECT * FROM  tbl_guildMonster WHERE guildID=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; t, h; `# o2 V# n5 u+ C% W& L) u
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                / z& n2 D: ]# v3 ~2 q, y( r

DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d    魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 \, ]/ X; H. h4 r, F! U& _' U
bbs.mocwww.com4 B1 m$ h! D3 }! N% g/ M' Z- V0 p
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d             —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. c: |( I- a% R  ]4 L

DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表+ ^- [8 z/ D9 N5 Z) h  c6 ]
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox
bbs.mocwww.com: p9 w1 P4 k+ q, c
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d
; c  B  O" i" ~, L& t
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d 妖城在线论坛, v6 r5 C$ Q: P0 j' y

SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d 妖城在线论坛: ^4 H. a) B: v+ t

SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d
bbs.mocwww.com( N! y! i2 n  `& g+ i2 Q! V* D+ h  n
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.com0 ~% L* ^; n# Y6 i- {+ X
                  %s:%d [7m guildIDOutOfRange
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: B" _; l  I+ A, d7 U
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编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; l& R4 O' h7 |; V  ^5 D- C
" t% ?* f6 v( M7 P& M$ O% Z
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d                            : _8 k. `* y' C( L

SELECT * FROM tbl_character WHERE guildID=%d                   % U* D6 R9 T$ Z. X* P  b
bbs.mocwww.com" l. @5 b1 _3 J8 Z
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: m( b; D. Z  S' c  J' S# L% e
OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d                            bbs.mocwww.com2 x4 S( s+ o# _! @  I4 f* ~

SELECT * FROM tbl_guild WHERE guildID=%d                      4 q) `' C; P6 C( N+ }% O

UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d                      魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表& O/ E6 A. u. Z+ g

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
妖城在线论坛+ ?# j) x6 g) F
DELETE FROM tbl_guildMonster WHERE GuildId=%d
bbs.mocwww.com! [1 r1 g) e0 Z* B- Y/ x$ M
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)
bbs.mocwww.com5 P" t! y2 g' G1 `  K% [
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) 妖城在线论坛7 @5 M$ U8 w- z! k& k! F
妖城在线论坛% A2 o' B0 _  d
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) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( m1 |& L5 |4 P7 S/ a5 V; }
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 妖城在线论坛- `; g( V# v, T1 }$ d& A
                  %s:%d [7m err:delete guildItemBox(%s) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表. I7 `$ L' r" k) B

SELECT DISTINCT GuildId FROM tbl_guildItemBox

guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error
                           %s:%d [7m MySQL result error
妖城在线论坛( i9 J' P% e) N' F/ Y( m3 ?
SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num魔力私服,最新魔力宝贝私服技术交流$ [3 J7 O/ Q! [6 W+ W& i. V0 }
         %s:%d [7m err: item full?
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) bbs.mocwww.com( Q9 e! j& M* V  X$ ^  e
                  %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)魔力私服,最新魔力宝贝私服技术交流3 G( x' G0 [, z% ?) k, A* k
  %s:%d [7m err: get guildItemBox  query
魔力私服,最新魔力宝贝私服技术交流; l5 W! _9 e, I( R  w1 `& a. J5 |  f
SELECT TrialFlg from tbl_user WHERE CdKey='%s'
魔力私服,最新魔力宝贝私服技术交流' L* N! a4 i5 G1 ?) ?  K
  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'                            魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表  X+ u3 X: ?1 i- e: E) ^) u  Z
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表, ^  m  I- s& N9 R2 G' V
  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         bbs.mocwww.com/ }+ ]' w+ z0 y

  SELECT Puk3Key, Kind, UseFlg, LinkCdKey, EnableFlgfrom tbl_puk3 WHERE Kind = %d and Puk3Key = '%s'                            %s:%d [7m err Graduation: already use ProductKey %s By %sbbs.mocwww.com' P' T4 S: n8 ^3 H' O- ^" K) w5 I
3 D3 _9 F$ E1 o
  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 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# A9 U1 g/ S, y
bbs.mocwww.com6 d& O( n$ ~: R- Z
下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。
要拿去就凑合着看看吧。

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

TOP

hotpursuit

妖精

Rank: 2 Rank: 2

UID: 2420
精华: 0
积分: 329
威望: 0 度
性别: 男

沙发大中小发表于 2008-4-29 14:56 显示全部帖子

单纯。从新下载附件，更新了。

TOP

hotpursuit

妖精

Rank: 2 Rank: 2

UID: 2420
精华: 0
积分: 329
威望: 0 度
性别: 男

板凳大中小发表于 2008-4-29 14:57 显示全部帖子

你说的复制是T掉LOCK下的。重复登陆的复制？

TOP