打印

[魔力私服分享] 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                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート% g( f1 n5 b4 ?" Z! r8 @) |) R
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段bbs.mocwww.com  i7 Y' L" y: y1 D& x
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d
妖城在线论坛& N* m& I& T+ _+ X+ x6 i: R+ i3 {
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            妖城在线论坛% @: S5 A4 t. Q. ~0 g5 x4 o/ \

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

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError" E! U7 [5 c8 P" u. _  f
魔力私服,最新魔力宝贝私服技术交流' B& m) z( b/ b; Z
REPLACE tbl_guildMonster_bak

SELECT * FROM  tbl_guildMonster WHERE guildID=%d                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表3 Y8 A  A$ o  F+ E
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表1 t, ]% N. |) t" X' Z% f3 @
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d
! @, i+ j2 l+ }/ g, N5 v
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d    妖城在线论坛) q, N1 s8 v) n! U/ T0 ?

DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
9 {: x$ ^, w7 K6 T/ r6 d/ f# B
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力宝贝私服技术交流! m3 \% {& ~/ _3 V; R
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. Q% z8 A  C+ Q: ~4 {

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 c  D& {1 J# y' t8 t# O
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d

SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d 魔力私服,最新魔力宝贝私服技术交流7 U7 U- B3 q3 y' U: z' D( G
( m6 v; Z1 [* O* A1 x, a
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d                         —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: s1 z4 J1 Y+ @/ P: J
妖城在线论坛, U/ d% p1 w& t+ D. L, 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) bbs.mocwww.com2 }( m1 N6 u% O4 }7 v+ O
                  %s:%d [7m guildIDOutOfRange

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d
妖城在线论坛3 G' C8 k8 o; Z, x; S  W: S
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# _/ n9 D1 H, f
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
妖城在线论坛, T: O/ x' t4 P9 r# B. L6 p
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,

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

SELECT * FROM tbl_guild WHERE guildID=%d                      2 X" x1 {, J3 @% `

UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d                      魔力私服,最新魔力宝贝私服技术交流% T& B& E! o( W0 f5 G2 T1 a9 r

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

DELETE FROM tbl_guildMonster WHERE GuildId=%d

REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 C# ^9 A" c" q- N5 I; ~3 H* |% Y  l2 r

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) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 o0 B0 |  B& y- ~" R/ X
bbs.mocwww.com) m1 W& I9 e; P4 E1 Z
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) 魔力私服,最新魔力宝贝私服技术交流+ d* [; ?6 v2 U9 [6 }2 x! x) ]" k4 ]

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) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 p. \+ B: R  l
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
                  %s:%d [7m err:delete guildItemBox(%s) bbs.mocwww.com2 n: Q9 W6 a+ v* q! F# k3 n

SELECT DISTINCT GuildId FROM tbl_guildItemBox                妖城在线论坛2 J- J! I. y/ p0 A) c  G
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: r* Y" g# S2 e
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表1 m3 a  S* W- l% y5 `8 e
                           %s:%d [7m MySQL result error魔力私服,最新魔力宝贝私服技术交流3 h1 d  Q+ ]# ^9 X+ C
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表- `- e, G. J6 y7 ~1 S5 _
SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 t1 B1 g  ?, ?
         %s:%d [7m err: item full? " u4 T7 c7 ]" j% s
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) / m4 E8 s; i. j
                  %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 D4 |3 i1 D4 V: w" H
                  %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m                               %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)
  %s:%d [7m err: get guildItemBox  query# Y$ E; V! `0 V) A, h! t% b, B
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. B; \; d. R; M6 r8 l0 E# a
SELECT TrialFlg from tbl_user WHERE CdKey='%s'

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'                            6 M  ?2 f3 |- [  V: ~

  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         * x9 t8 m/ a& i( m) s
妖城在线论坛- ?7 B' _' K6 Q$ J' ]1 \# 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 %sbbs.mocwww.com0 e( S5 D' ]" _' g/ `

  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'             妖城在线论坛( }) `: j2 @8 N' [( m
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート% s! |  f4 k& _' R3 D
  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c

下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート" o, Q) t# T1 f+ H9 ?& l( s* h
要拿去就凑合着看看吧。
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表& g( m; ~# s- ?+ b# i# {4 g7 Y7 a
[ 本帖最后由 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