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

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

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

SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d                妖城在线论坛; d/ A/ T  H: l$ R- l/ }: d
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道
SELECT titleID FROM tbl_character WHERE guildID=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート  B3 q# c: U( `7 n$ v  D' w
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
妖城在线论坛+ v- K% V5 f( X5 S  W4 e
select distinct guildID from tbl_character where guildID >=%d and guildID < %d

SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表" \/ f$ ]( K4 }. y- l! o

REPLACE tbl_guildMonster_bak 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) y9 z6 G, A- [# M4 Y( S

SELECT * FROM  tbl_guildMonster WHERE guildID=%d                & c' |: `$ k+ W) ^

REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                   h4 ^( c+ w& X9 M" m0 P$ ?4 [
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表* Y, i$ z4 |5 q$ q( _
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
( l4 B; H" r" e, ]2 u) ]
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d             bbs.mocwww.com+ T! b' q: N5 I( |" i3 m: i1 c

DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d             bbs.mocwww.com: Y1 r7 K9 `* h* p

SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox魔力私服,最新魔力宝贝私服技术交流0 H$ I0 ]4 a' j, z! c
妖城在线论坛" h. V5 r0 m0 r6 C* `
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d       # }' T1 _8 V: I: |

SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d

SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d

SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%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魔力私服,最新魔力宝贝私服技术交流" V; U* w8 r$ r: X6 a7 W8 ?: \
妖城在线论坛* Q* w3 d# V% |4 ?& Y1 G1 G
INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d                               & ^8 }( y( h8 l7 \9 S2 n; ?
妖城在线论坛; n+ f$ m7 ?8 P6 j0 P
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d
妖城在线论坛) L! ?( e5 d3 L9 V- v' v% 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                   —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート! o  E0 ~1 e/ V
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表& Y9 o: @5 k- r$ ?- @/ T. O$ T& y! u
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,
' y0 M3 G$ i4 _5 R
OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d                            bbs.mocwww.com7 o  {5 @3 Z! x2 A5 T* U

SELECT * FROM tbl_guild WHERE guildID=%d                      妖城在线论坛2 p+ A% g$ F0 o

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.com( a0 d" h" ~8 C
DELETE FROM tbl_guildMonster WHERE GuildId=%d                妖城在线论坛2 `) ?6 K: {' {  d5 s2 r( V

REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表" y9 x% m5 O1 j# J: ~  B
魔力私服,最新魔力宝贝私服技术交流! M+ p4 H+ O1 {: c" r4 @
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) 妖城在线论坛( i2 d0 u: k5 l; m( ~
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート7 _! @% I; N! V6 P; G
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)
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
                  %s:%d [7m err:delete guildItemBox(%s) 妖城在线论坛" C! S  g* K' d) M
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ u0 j( l# j8 r2 N
SELECT DISTINCT GuildId FROM tbl_guildItemBox

guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error
                           %s:%d [7m MySQL result error

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) bbs.mocwww.com( S2 u# S: n/ ~$ M, k* q" ~
                  %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'
; j9 _- f' S( B% w" M
  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
bbs.mocwww.com8 T1 Z7 a/ P6 a
  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—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* {  m* `" m1 k$ I7 z) n6 Z
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート# O# h% T) Y1 \* L4 B4 Z! J( U/ b
  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* u3 l2 _' M+ \
  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート) c' w0 m' ]1 U( H
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート; p7 J" s2 @9 r! q" |
下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。
要拿去就凑合着看看吧。
bbs.mocwww.com" i+ @; x0 K, S# n$ C  G
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]

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

很好很强大

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

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

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

另外，偷偷的说一下....
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート/ V) ^% [) n7 K. B$ e% [( d% L
“防复制只需要屏蔽掉一条明文既可”..魔力私服,最新魔力宝贝私服技术交流- Y: x- Z/ p" u" @7 n; [

当然，我还没去做,至于具体效果也不知道

这是某位朋友教我的

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

我没下载

..—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 T) @ W# U; v' v' \0 j8 q

对于这个不感兴趣.

不如去研究研究封包

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

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

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

恩，是的...魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表/ @9 ]+ o7 f+ s1 C' z2 a
妖城在线论坛$ F- u, C/ Q' Q+ y7 S
可以屏蔽掉某明文，防止2次生成.
3 b: u( o1 Y+ u
也可以防复制的..~

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

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

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

超出新手范围看不懂

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