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

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

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

SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d                —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート0 @$ x' X+ U- a. F1 `
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段+ Q% E  T- c. M" R3 t6 ^+ }- e
具体怎么写我也不知道—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. F6 [2 ~7 j- d7 R" n
SELECT titleID FROM tbl_character WHERE guildID=%d          妖城在线论坛+ O+ T+ q, s, t' Y
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' @2 z8 ~2 z* y4 l6 I: `2 R
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d

select distinct guildID from tbl_character where guildID >=%d and guildID < %d                魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表! {2 ~+ E0 u) M9 W7 g; l7 g% z! H
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# d2 i9 p; A# ]8 X% p# h
SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError

REPLACE tbl_guildMonster_bak 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表' `4 H3 a- i; H

SELECT * FROM  tbl_guildMonster WHERE guildID=%d                妖城在线论坛# d- T3 V4 e/ h

REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                - ]% ~5 s5 z% N, ?& i! N/ t

DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d    魔力私服,最新魔力宝贝私服技术交流; a, J+ s5 K  U  |, @

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             妖城在线论坛$ a- D" d; u7 t& Q
妖城在线论坛: U9 l8 f- r2 t3 U& E& [
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       —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' g2 w0 ~+ E1 t5 r$ ^

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                         妖城在线论坛- ~9 A- D) \1 o! C# L) U& @8 O, w

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

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d                               —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート/ t  ^$ v1 y, {7 M/ n" }1 ?
魔力私服,最新魔力宝贝私服技术交流+ {' G* d' e. A, c* S6 p. p
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d
妖城在线论坛, |3 p9 a/ ^  C
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom妖城在线论坛1 v* Y# N" n4 p$ |3 e( I9 K& q$ h

SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d

SELECT * FROM tbl_character WHERE guildID=%d                   bbs.mocwww.com' f3 l$ Q$ w& o* p& K1 r# I4 |
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表% k4 h$ c, y; c3 N2 w+ M$ R+ M
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表2 P8 `& w+ p* s* P
OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d

SELECT * FROM tbl_guild WHERE guildID=%d
妖城在线论坛2 }5 u9 m! E& W$ l0 `
UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d
魔力私服,最新魔力宝贝私服技术交流# c2 |3 E! S2 b+ u- s9 L
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.com2 i* L) E8 g5 k! z
DELETE FROM tbl_guildMonster WHERE GuildId=%d
bbs.mocwww.com. n5 [: n1 |$ m- W9 |( }4 w) u2 H; Q
REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s) $ T# q/ O- g- k& X

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)
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート& m9 P0 O1 V2 P
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)
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
                  %s:%d [7m err:delete guildItemBox(%s) 魔力私服,最新魔力宝贝私服技术交流6 }2 X4 `8 d. J; S) j) F

SELECT DISTINCT GuildId FROM tbl_guildItemBox                  T0 m" b/ v& N3 z% C& X
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 y! S4 P% T; W( k0 {
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error
                           %s:%d [7m MySQL result error- o! I6 w3 L( q. C0 `

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) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表1 B  b# r/ g- \4 W8 H4 C
                  %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
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 V. e& M) p. p
SELECT TrialFlg from tbl_user WHERE CdKey='%s'

  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
妖城在线论坛7 H& ?/ p! w/ N! ?1 ]
  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         bbs.mocwww.com* V4 _3 J9 r- X2 i, {0 W
% \3 m# I! O; d# Y: i! W4 U, j# B' 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妖城在线论坛0 ^8 ^0 }5 G: y4 F

  UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'             bbs.mocwww.com8 z' R: h( r8 V. D9 J
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表3 J7 k; k6 I: L5 z* q5 k% L! W
  UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s'  puk2/dataBase/toPuk3.c

下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。: a4 I4 u, f+ B9 u) E0 ^* T" J+ C
要拿去就凑合着看看吧。魔力私服,最新魔力宝贝私服技术交流6 E# }/ S  H1 X1 O- ?0 G
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート, R9 n9 k- ]+ E$ u8 A
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]

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

很好很强大

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

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

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

另外，偷偷的说一下....bbs.mocwww.com$ R! o6 o' u# ]4 Q) s

“防复制只需要屏蔽掉一条明文既可”..

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

妖城在线论坛& L; y; [; r! V1 F4 U

这是某位朋友教我的

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

我没下载

..妖城在线论坛* t) Y+ `9 d2 @ l$ _) g

对于这个不感兴趣.bbs.mocwww.com1 y |; A1 L# v( u- I
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート1 {) D( c8 O9 J
不如去研究研究封包

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

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

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

恩，是的...魔力私服,最新魔力宝贝私服技术交流( x, A6 o; ?" U8 ?

可以屏蔽掉某明文，防止2次生成.

也可以防复制的..~

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

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

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

超出新手范围看不懂

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