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

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

作者: hotpursuit 时间: 2008-4-29 14:54 标题: GMSV提取出来的数据库表结构数据

SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表. h7 L3 O( I: K. `3 B9 T
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d          妖城在线论坛& I" P) h' Q  C, O& ]/ O

SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            ; s) t# b+ X7 s, _* _! P$ }4 g
bbs.mocwww.com. A' ?6 @1 W; k9 @# ~: {4 x; m1 s& f" W$ O
select distinct guildID from tbl_character where guildID >=%d and guildID < %d

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError
妖城在线论坛' x) ]" [4 t* j+ ?
REPLACE tbl_guildMonster_bak bbs.mocwww.com# i3 m$ `- v! f

SELECT * FROM  tbl_guildMonster WHERE guildID=%d
, N0 \' L/ ^( S$ U5 \; i
REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                魔力私服,最新魔力宝贝私服技术交流* D" m. b! p! n8 Y, i
' {, ~5 Q( ]( D0 E
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d

DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力宝贝私服技术交流5 U) d* _( }1 W7 y3 d2 w0 y
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 guildItemBox8 U6 \/ V, e" Z, p- q- Z
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: ~4 t6 ~, ]) Y0 {- P4 o
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d       魔力私服,最新魔力宝贝私服技术交流- e3 h" D9 C1 V4 L7 u% b/ e

SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d 妖城在线论坛( R- a2 {% ~5 B' f9 ?& J

SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 J  X4 N/ ]& H# ^% B
SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d                         妖城在线论坛( @' @* j1 Z* O

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) 妖城在线论坛3 \# }  S8 i: @8 Q: v/ {
                  %s:%d [7m guildIDOutOfRange

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d                               魔力私服,最新魔力宝贝私服技术交流3 f' t; I7 P( J
0 g" s7 {; R# D8 I* e
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: h/ m: T% @7 d& N: N3 ]

DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート7 h6 {5 ^2 n4 e

SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
妖城在线论坛: h! L$ s% r& j( s( T
SELECT * FROM tbl_character WHERE guildID=%d

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,

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

SELECT * FROM tbl_guild WHERE guildID=%d

UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d                      魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 z* w# I1 \. Y. ~

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
妖城在线论坛# ?. C. s) s2 ~' ^; ?
DELETE FROM tbl_guildMonster WHERE GuildId=%d                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 S& k8 n% [2 o0 B8 G2 F
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 i5 v/ W; ]: v% x# a. R4 k1 T
REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート  r, p! m' g* p! K$ Q+ e+ e
bbs.mocwww.com7 a" E5 U: y( ~9 m( Z; d
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,电影,黑客,网络,网吧,破解,入侵,注册表) i% p: q( L) Z3 W
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' w8 r2 _" ?+ Q9 U, ]0 }2 ]

INSERT INTO tbl_guildItemBox VALUES                            %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表; R$ F7 b4 o8 x. i/ M0 l
      %s:%d [7m err: insert guildItemBox (%s) bbs.mocwww.com; C9 o/ B( c8 ?
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 8 I* B) C! _4 Q4 n" Y0 `' {
                  %s:%d [7m err:delete guildItemBox(%s) 魔力私服,最新魔力宝贝私服技术交流) M$ c" w! F& A' n/ U; f
魔力私服,最新魔力宝贝私服技术交流% X$ ?, L& n7 C
SELECT DISTINCT GuildId FROM tbl_guildItemBox

guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error妖城在线论坛: g4 U. F2 {* [% K1 |9 B0 y) \
                           %s:%d [7m MySQL result error
3 L, R$ X% a6 |
SELECT * from tbl_guildItemBox WHERE GuildId=%d                %s:%d [7m err guildItemBox: invalid field num
         %s:%d [7m err: item full? 妖城在线论坛8 \  o0 `+ m0 A0 V5 \4 r
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) bbs.mocwww.com! s; _( p" d9 Z: a
                  %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) bbs.mocwww.com& |: b0 c2 B" \- N
                  %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'                bbs.mocwww.com+ Z. t1 [( Y- \. e  X

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'                            —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート, z, a8 }# q8 d6 }5 X

  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         妖城在线论坛7 z3 E6 E7 A, f" s3 u
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表3 @6 c# s9 `$ L; e8 A
  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妖城在线论坛5 O% t8 I$ }7 b8 r

  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 魔力私服,最新魔力宝贝私服技术交流% w& g6 ~7 \6 n9 w# C* q

下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。
要拿去就凑合着看看吧。—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート6 J; B/ x  U4 r% p  F2 a

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

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

很好很强大

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

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

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

另外，偷偷的说一下....

“防复制只需要屏蔽掉一条明文既可”..
妖城在线论坛9 A; X/ O. _5 K
当然，我还没去做,至于具体效果也不知道

bbs.mocwww.com C& x9 Q- N$ X3 s, r% w. u
& `8 v% P/ V' G [$ f0 B$ ~
这是某位朋友教我的

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

我没下载

..

对于这个不感兴趣.bbs.mocwww.com E3 `) L- Y3 O$ t/ m0 }- D
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート% Z0 \: w( }: e5 ^, h
不如去研究研究封包

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

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

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

恩，是的...魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表+ M6 P) J Z$ D3 A0 F$ a
妖城在线论坛1 f, ]2 G0 K( h6 U/ w7 @
可以屏蔽掉某明文，防止2次生成.
妖城在线论坛! s$ L4 I& X! h, |- D: k8 n& k( d
也可以防复制的..~

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

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

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

超出新手范围看不懂

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