打印

[魔力私服分享] 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                妖城在线论坛7 R) q  U/ p) S* d4 I
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道妖城在线论坛8 V4 Q2 U, n' {3 J' V1 B
SELECT titleID FROM tbl_character WHERE guildID=%d

SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
) O& |/ X+ `/ \. o6 \" p) m
select distinct guildID from tbl_character where guildID >=%d and guildID < %d                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ d! ~& [# }7 M

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError9 m- P( p% O' `* Q5 W
魔力私服,最新魔力宝贝私服技术交流! _0 X/ t: {: N7 Z3 V' _3 j7 F
REPLACE tbl_guildMonster_bak
魔力私服,最新魔力宝贝私服技术交流0 F  y8 g+ _3 S2 O0 x
SELECT * FROM  tbl_guildMonster WHERE guildID=%d                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ l0 e2 H  B: |6 y
妖城在线论坛( I$ b1 s; a, ]9 Q/ [" e8 F" ^
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d
bbs.mocwww.com2 j, S" L3 N  }4 n% D# k# p
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

SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox/ s$ c# a4 ~% T& s! L3 e9 N

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

SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d 魔力私服,最新魔力宝贝私服技术交流: V$ I& L) n# i) K3 U
妖城在线论坛2 P$ x: ]0 m1 i) e! U
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d 妖城在线论坛( ^3 a* }) C1 j" g& v
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ N( j% ?7 J  |' [0 V; y1 z7 c
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d
妖城在线论坛! L# K, X% A/ H
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% R$ F* D) r. g, w8 r+ I7 X; M% E
妖城在线论坛9 w  \  h* _  |# s( Z, I3 t
INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d
魔力私服,最新魔力宝贝私服技术交流7 l* j: s% s% [! H) e
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d bbs.mocwww.com  S3 p4 B6 T2 h5 y7 {

DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom妖城在线论坛1 o: {. ~- r% ^6 n( `! ]
魔力私服,最新魔力宝贝私服技术交流2 o8 f: T" N* e1 E4 S. d$ g6 B  b
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート) M, y% a5 r0 z- d
SELECT * FROM tbl_character WHERE guildID=%d                   bbs.mocwww.com6 I; M" Q( z6 d8 p) Y; o( n
, M3 m7 J; P1 @: p% O, p8 m
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, 魔力私服,最新魔力宝贝私服技术交流9 s: \9 d" n% `

OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d                            bbs.mocwww.com1 f3 A/ [" [0 \( d3 i& j
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表3 X, ]. R* s; I' i
SELECT * FROM tbl_guild WHERE guildID=%d

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
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表+ x! @' n- l: [  K7 [' c( U$ X
DELETE FROM tbl_guildMonster WHERE GuildId=%d                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート! g4 s& t4 O3 K8 P; `* w

REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s)
魔力私服,最新魔力宝贝私服技术交流  l6 P- ^% Q& x+ v( C! n4 Z
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)

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+ Z+ T0 X* q
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) " j" G! C6 x6 O
                  %s:%d [7m err:delete guildItemBox(%s)

SELECT DISTINCT GuildId FROM tbl_guildItemBox                9 Z: {4 }! `! |( n$ w
bbs.mocwww.com& u; b: s5 ?' `0 K
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error魔力私服,最新魔力宝贝私服技术交流$ r3 J- P' M! L1 Q+ P3 O9 r5 T
                           %s:%d [7m MySQL result error魔力私服,最新魔力宝贝私服技术交流' ^0 X$ ]' L/ {: X3 B& x

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)
                  %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m                               %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)
  %s:%d [7m err: get guildItemBox  query

SELECT TrialFlg from tbl_user WHERE CdKey='%s'                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. ]  s/ B1 u4 V. Z& c$ x

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
妖城在线论坛* E( j% B; W* u# T% v& I# o
  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魔力私服,最新魔力宝贝私服技术交流; s# l5 Z' L; b9 j8 ^: L" j
9 f9 g( {& C* u/ Y+ W
  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表, N6 G  Z$ ^5 s7 M' Z1 c6 X
  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c

下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。
要拿去就凑合着看看吧。妖城在线论坛$ F8 W9 J9 F9 t2 ~: N

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