打印

[魔力私服分享] 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
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 k: Z& l4 @+ `+ Y
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d

SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            & D" j4 t4 f" l" u& {0 J
bbs.mocwww.com3 H3 H# H/ R, Q7 C: S9 K1 @
select distinct guildID from tbl_character where guildID >=%d and guildID < %d                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 t% d3 i( g+ s  t7 h4 \
! B/ V% Y) Q& g: q
SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 D4 r3 F, c) y! g& K  K$ z
REPLACE tbl_guildMonster_bak
魔力私服,最新魔力宝贝私服技术交流5 f% a0 T5 P) w; Z' F( b& W
SELECT * FROM  tbl_guildMonster WHERE guildID=%d
魔力私服,最新魔力宝贝私服技术交流) a; D1 ?3 G2 v* f# A
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d

DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d

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             bbs.mocwww.com5 a6 m  ~/ M2 B+ t/ N
; S+ W8 g0 K# _7 Y
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       : ?/ G$ {. h% y- S* b" ]7 O7 ?; G% }* i

SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d 魔力私服,最新魔力宝贝私服技术交流7 T, X8 k6 H4 O$ V4 a" y3 c) @

SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
妖城在线论坛, l. `1 J9 z* @+ T: b2 z9 b+ t
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d                         bbs.mocwww.com; U. y) n7 @. u  K8 o: p$ L# D
魔力私服,最新魔力宝贝私服技术交流7 E7 f( c' S" i6 {
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 guildIDOutOfRangebbs.mocwww.com& P+ t6 J9 ~$ J+ x
bbs.mocwww.com' f! E; X0 ]4 Z. t; e" I
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 bbs.mocwww.com4 N' Z& ?) z% B' J& ]; l# s, d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( q' o: a7 q: a+ `4 y! T
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom0 [* t' _' j; L4 X: ]
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表+ @+ y: K7 a( n8 c2 y3 G" d
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 \, {8 m) T9 D: w
SELECT * FROM tbl_character WHERE guildID=%d

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, 妖城在线论坛9 i3 E: V3 W2 N8 c6 p  Q/ ?

OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d
妖城在线论坛2 }# {7 Z7 Y4 f+ o& |1 N
SELECT * FROM tbl_guild WHERE guildID=%d                      ' f" |: z3 u/ Z7 g
魔力私服,最新魔力宝贝私服技术交流7 u8 V# r3 g0 {( R$ x8 Z( ]
UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d                      魔力私服,最新魔力宝贝私服技术交流/ d9 G- X" ]1 n& X: k; O5 ]

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                魔力私服,最新魔力宝贝私服技术交流2 v( A/ V9 I* o' i: X
魔力私服,最新魔力宝贝私服技术交流& J& |$ t/ y; `0 g: B
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)

save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d)
# v3 z% k# Z6 x4 s/ y9 c0 B9 _
INSERT INTO tbl_guildItemBox VALUES                            %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d) 妖城在线论坛# N9 o& n) D! U  b/ n
      %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                bbs.mocwww.com: E% F+ V( I( h# ^
魔力私服,最新魔力宝贝私服技术交流  M; g: u; X7 p) T( Y+ L
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error
                           %s:%d [7m MySQL result error魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表2 A* R) U" r% A2 v

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) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 W& U; I' R+ Y/ A1 C( [+ a# u+ N; ]
                  %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m                               %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)魔力私服,最新魔力宝贝私服技术交流  r) U/ c. \. m$ z# Q: V8 r1 o7 [
  %s:%d [7m err: get guildItemBox  query

SELECT TrialFlg from tbl_user WHERE CdKey='%s'

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'

  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         bbs.mocwww.com  J& a, s8 B1 ^0 L$ U
妖城在线论坛$ b+ l7 k1 K' j* U
  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,电影,黑客,网络,网吧,破解,入侵,注册表; n* z2 ]3 r9 J; o$ H
  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表, F+ `+ b8 J, c# w. b- A7 h
  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c 魔力私服,最新魔力宝贝私服技术交流% Y# q( @; c( s1 @* v
妖城在线论坛4 w  h. d" |% n7 y8 n$ M9 m
下面我发附件，附件内包含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