打印

[魔力私服分享] 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                魔力私服,最新魔力宝贝私服技术交流  I! M5 k; e# C" O3 B) n- d
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d          妖城在线论坛7 a* i( q% ?8 S& p

SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
! R" _: w2 [% U# {
select distinct guildID from tbl_character where guildID >=%d and guildID < %d
# Z* S2 I+ h0 b+ L1 N, \& A
SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError
2 B& _$ M5 W  h1 `, H/ U! K
REPLACE tbl_guildMonster_bak

SELECT * FROM  tbl_guildMonster WHERE guildID=%d
妖城在线论坛- K2 [! Z/ q1 B
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d

DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d    - ?) B. ^5 p6 @

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             妖城在线论坛) H0 h) ^1 v; O6 C( e! o' b# m

SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBoxbbs.mocwww.com0 c5 o/ w, H  `$ T) l2 k0 i9 G

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d

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                         ' P  }5 t) x% K2 T  K
魔力私服,最新魔力宝贝私服技术交流7 X0 m2 V. L2 c, ]
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妖城在线论坛- j% x; K5 S( ]! s) a5 Z
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 m1 J* l! |1 m" U4 N" E
INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d                               魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: Q* O* W5 n* R7 Y+ v" R
6 f9 i* O% o- Q0 _
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d $ p* U# J0 h& Q+ P* G
妖城在线论坛# c4 \, Z) y1 x. d  _
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 S5 |* {3 \. r8 F& n

SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
妖城在线论坛3 F: {+ u, u0 S4 z* r
SELECT * FROM tbl_character WHERE guildID=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート) y! P: e9 S4 ]4 g/ _2 |" h0 q5 e
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,
妖城在线论坛# E5 Z* S# w) {, C3 E0 ^) a
OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d

SELECT * FROM tbl_guild WHERE guildID=%d                      魔力私服,最新魔力宝贝私服技术交流6 O3 J$ x9 Q9 K/ p& o  J% y

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                            —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート  J4 O% G6 x& P' J: Y9 ^- l
妖城在线论坛8 @" Y; j' r1 t/ ?8 W. w& B; J
DELETE FROM tbl_guildMonster WHERE GuildId=%d

REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s) bbs.mocwww.com# H! l1 }9 @# w7 G7 |3 `

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)
6 e! G: _& `" O6 r+ ^
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート5 F7 E' P0 a* m4 x' Y  P1 ~; P; h
4 W8 L* e8 y2 `# g3 v) q
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) 妖城在线论坛; R- V; }; F# h0 F% ]9 h9 `8 x0 R
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)   y8 \/ o& P1 q2 a) f* X
                  %s:%d [7m err:delete guildItemBox(%s)

SELECT DISTINCT GuildId FROM tbl_guildItemBox
bbs.mocwww.com4 `/ Y1 B* j( X5 V
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error
                           %s:%d [7m MySQL result errorbbs.mocwww.com- @' |6 ]' I1 @# ^7 [7 o

SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート4 C: W4 _! Z  D, ]5 S
         %s:%d [7m err: item full? —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート" l5 o0 Y5 J, |* E; @
%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)
                  %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m                               %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)  O" J( G2 l2 r7 H4 x
  %s:%d [7m err: get guildItemBox  query魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 F* l. K8 c! W2 U- U/ i; r
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: _8 _- l( Q/ X6 F6 f
SELECT TrialFlg from tbl_user WHERE CdKey='%s'

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'                            魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( D- \/ S4 [1 @& W) z

  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魔力私服,最新魔力宝贝私服技术交流1 D  V4 h2 C" [( X) _6 _2 N
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 o2 Z$ l+ @& E& _, ~0 s
  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

下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。
要拿去就凑合着看看吧。—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート7 ?. O: B  x5 d5 o4 ]; `6 t
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート  J, Q- J8 [" p& H; L
[ 本帖最后由 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