妖城在线论坛 - Powered by Discuz! Board

标题: [魔力私服分享] GMSV提取出来的数据库表结构数据 [打印本页]

作者: hotpursuit 时间: 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 段
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d

SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            bbs.mocwww.com8 N0 A- O$ h1 v; n& M" d- q9 x

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

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError

REPLACE tbl_guildMonster_bak 妖城在线论坛/ R: P) o, o; c2 f$ B% f# p

SELECT * FROM  tbl_guildMonster WHERE guildID=%d                bbs.mocwww.com/ r3 N8 C" k& O: {: f5 b$ L9 Y4 N

REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                魔力私服,最新魔力宝贝私服技术交流' w, L) `: w) J# \( U9 Q+ d

DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d    妖城在线论坛) e1 p' X( E& Q) l' `1 F" Z! K
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 d' _$ Z; `: W! N4 A; }2 F9 F
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d             —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 N' a3 b1 z# h+ O
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 q8 d3 l; e' l+ }$ N$ Z4 e
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
魔力私服,最新魔力宝贝私服技术交流0 p( W) N4 ?2 G2 P6 _
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d       魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 \5 ^8 w! ~/ K) F; L+ Q
, A3 U' p$ q5 n2 C
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 f& e/ c: v$ y  A% t3 z
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート7 j, y$ {2 Q2 a/ Z* Z) z
bbs.mocwww.com! @, n* e% g$ F8 w5 Y4 J# E
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d                         —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; ]: O* ?) s2 h' q# J/ t
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 @1 j0 W8 ?4 V2 ]2 D
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
魔力私服,最新魔力宝贝私服技术交流6 C: N) s) Q4 y' v
INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d                               bbs.mocwww.com% [% T' [; [9 N

SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d 妖城在线论坛8 ]1 M6 n& K; x

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

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ S0 M" p* M% `; w/ \0 [3 A

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

SELECT * FROM tbl_guild WHERE guildID=%d
bbs.mocwww.com: E# A7 D8 b) Q. |& h- B9 Y" X
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                            bbs.mocwww.com9 _/ q7 _( Z: E

DELETE FROM tbl_guildMonster WHERE GuildId=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' t3 Z; T4 L& L3 j# C1 Q7 M- t5 `+ O
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.com! v2 \1 s2 \* @0 L  V; q% R

save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) bbs.mocwww.com+ k1 `4 f# c) d7 F7 q! i4 y

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) , ]: k$ m! G% t- o- l7 |8 t- Q% E
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 5 }1 r& v' y1 T- V" O1 i( ^4 u
                  %s:%d [7m err:delete guildItemBox(%s)
bbs.mocwww.com$ M& {9 K6 ]1 A3 k/ \6 [3 l, s
SELECT DISTINCT GuildId FROM tbl_guildItemBox
3 j) U7 z4 a8 U$ U
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error妖城在线论坛7 F* C. F7 n* `2 Y% x0 X6 Q
                           %s:%d [7m MySQL result error魔力私服,最新魔力宝贝私服技术交流- r* E' f8 X) L7 c% o* n3 v1 G

SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num
         %s:%d [7m err: item full? 魔力私服,最新魔力宝贝私服技术交流2 r1 H9 G2 C) Z- I
%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编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート+ F. j+ ?2 u6 [1 p; v) X
                  %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编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート+ C9 H; c  C$ t, S6 @  M7 o

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'                            —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート! c4 l" r; g  W2 ^* s
妖城在线论坛, [0 g" T% v$ F3 _4 M2 x3 i
  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c
bbs.mocwww.com# T& E' a1 g4 o1 j! d( O
  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

  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'             妖城在线论坛6 R$ ?, c0 k/ v! G  w

  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート) L- A. R' S8 v+ ]1 }6 C

下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。
要拿去就凑合着看看吧。妖城在线论坛/ e: b: V- p8 z3 W- V; V+ g
bbs.mocwww.com) z! M+ _6 S( B+ f$ a& t- d$ D
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]

作者: ﹎▓ヾ僤莼べ 时间: 2008-4-29 14:55

很好很强大

作者: hotpursuit 时间: 2008-4-29 14:56

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

作者: ﹎▓ヾ僤莼べ 时间: 2008-4-29 14:56

另外，偷偷的说一下....妖城在线论坛: G2 p% a+ T4 g

“防复制只需要屏蔽掉一条明文既可”..魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 K: f, q1 V5 A* T7 d! H7 R/ J
3 F8 F# ?6 X4 i/ Q
当然，我还没去做,至于具体效果也不知道

这是某位朋友教我的

作者: ﹎▓ヾ僤莼べ 时间: 2008-4-29 14:57

我没下载

..
* J! }* a+ O8 \! P& o0 U; U
对于这个不感兴趣.bbs.mocwww.com5 S+ s) |9 E v# O/ l0 s, a8 e$ b" e" l
0 `/ Q1 y7 y) Z L
不如去研究研究封包

作者: hotpursuit 时间: 2008-4-29 14:57

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

作者: ﹎▓ヾ僤莼べ 时间: 2008-4-29 14:58

恩，是的...魔力私服,最新魔力宝贝私服技术交流- U$ [3 p/ A- b# |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 j& y9 G& \" }! l- v0 R7 P5 @
可以屏蔽掉某明文，防止2次生成.bbs.mocwww.com! C( U: P- ]7 f6 E
bbs.mocwww.com1 n* \1 y7 s0 }/ a
也可以防复制的..~

作者: FGMAX 时间: 2008-4-29 20:46

直接在登陆帐号时候做钩子，即能检查多重登陆，又能检查是否已经在线自动踢掉卡号…

作者: 31558770a 时间: 2008-4-30 15:26

超出新手范围看不懂

欢迎光临妖城在线论坛 (http://bbs.mocwww.com/)