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

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

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

SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d                9 n. X- Q' b: J! T8 W
解释：表结构 CdKey,registnumber 从主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
具体怎么写我也不知道8 h1 a& r3 v7 P3 C' E7 d
SELECT titleID FROM tbl_character WHERE guildID=%d          魔力私服,最新魔力宝贝私服技术交流& t. s' k( `* V6 L  l( {
魔力私服,最新魔力宝贝私服技术交流: f3 @! Q! M& h: U, W0 J
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d                            魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 t1 C  j1 L1 Q1 e9 n
妖城在线论坛9 B, o1 p( y3 a
select distinct guildID from tbl_character where guildID >=%d and guildID < %d                6 q! G! O1 N. P
) B' d3 g( |: X
SELECT * FROM tbl_guildMonster  %s:%d [7m guildMonsterDataReadError魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 i, h7 _! K+ o8 a
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: {3 w( k* C8 A( X
REPLACE tbl_guildMonster_bak bbs.mocwww.com" N* J+ s) n5 g  B$ k  q

SELECT * FROM  tbl_guildMonster WHERE guildID=%d

REPLACE tbl_guildItemBox_bak SELECT * FROM  tbl_guildItemBox WHERE GuildId=%d                魔力私服,最新魔力宝贝私服技术交流! q% t1 J5 S% n  C. q

DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d    —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート7 A# p, @; H/ _8 H0 H
+ H4 W( e/ |, E+ S
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d             ( F: b7 a3 v  g9 {: A) k" a7 k
bbs.mocwww.com8 ?, w! J# z" m' E) V$ U* t4 r
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d             魔力私服,最新魔力宝贝私服技术交流% t' S2 f7 S0 d/ {5 U& s
魔力私服,最新魔力宝贝私服技术交流" _/ z) E9 d8 b5 o; W  e% D" d
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d  %s:%d [7m backup error guildItemBox魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 `9 O' `6 P3 v

SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d       ) a$ c5 g3 y5 S: m

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                         bbs.mocwww.com/ A0 N( h6 i( P6 L: R
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表- ]: c* _' U7 i5 ^7 r. v
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魔力私服,最新魔力宝贝私服技术交流3 Z. {" u, [  R8 U

INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d

SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND  RegistNumber=%d bbs.mocwww.com, u) W" R) m+ W: j
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表8 u$ `3 R8 f# n: }. B( x( q$ s
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d                      %s:%d [7m err : canNotCreateBreedingRoom魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表* n- A4 K9 a3 ?% h+ e) S& a
魔力私服,最新魔力宝贝私服技术交流, d+ a! [3 m0 v$ [+ U
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d                            魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表9 v0 o  q! I& W, Q) x$ @- B6 D
* C) ^- |3 j; S3 y+ Q1 C/ u1 {" }
SELECT * FROM tbl_character WHERE guildID=%d                   bbs.mocwww.com3 a$ R8 K: a' x# s" {, T- Y
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表* I. u! J; g& {+ L' }5 C% a
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,

OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d                            魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表* e+ z8 ~/ b9 O2 u, n- i& l

SELECT * FROM tbl_guild WHERE guildID=%d

UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート% H( U( G; c7 ?. X7 ]- c( c( Z
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( Y/ `" r6 l- r' o6 `: W; w
DELETE FROM tbl_guildMonster WHERE GuildId=%d                妖城在线论坛7 Y! r7 z4 \( u
$ c9 s# o5 I- h6 W, [
REPLACE tbl_guildMonster VALUES (                            %s:%d [7m err:delete guildMonster(%s) 3 @+ x5 t# h! s; o$ {2 {% L; q, p
bbs.mocwww.com& ^5 o, y2 o+ T2 G
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) bbs.mocwww.com' \# X( a! U. @/ ^, D

INSERT INTO tbl_guildItemBox VALUES                            %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d) 1 ?# P3 i& v+ C! N
      %s:%d [7m err: insert guildItemBox (%s) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート' S2 A, p6 }: x; f2 ~  I4 t
               %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
                  %s:%d [7m err:delete guildItemBox(%s) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート0 ~# ?9 P# X3 h" l

SELECT DISTINCT GuildId FROM tbl_guildItemBox                bbs.mocwww.com& d" }$ M8 R* B3 N. `, l' q
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート9 I) \  |6 L- H
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID       %s:%d [7m GuildID malloc error—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート% x1 C, D" L) o- X, d* y
                           %s:%d [7m MySQL result error—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート& D0 G4 R0 _% ?* ~7 T: C, T. \

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) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: Q  t. m" Q0 f/ j, n  L4 H
                  %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 妖城在线论坛$ `, s% L! g0 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魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表* {( g% L( a0 e4 [
妖城在线论坛4 V7 A9 p: \5 n  y
SELECT TrialFlg from tbl_user WHERE CdKey='%s'                & S) [$ i4 o' y' ?- E/ J' @
魔力私服,最新魔力宝贝私服技术交流7 c. _( u( ^% B
  SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'

  UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s'  puk2/dataBase/toPuk2.c                         妖城在线论坛9 {' \, V9 l8 M0 h6 g1 @' y3 O3 ]9 l
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 y8 z; h! w7 e! m* O8 q
  SELECT Puk3Key, Kind, UseFlg, LinkCdKey, EnableFlgfrom tbl_puk3 WHERE Kind = %d and Puk3Key = '%s'                            %s:%d [7m err Graduation: already use ProductKey %s By %sbbs.mocwww.com( A# S/ l# B% g+ S  V; w
bbs.mocwww.com" l: a) O# g& |/ j; {
  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
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート0 I; S) k; h( e5 j- l3 B$ ?. }' r
下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。bbs.mocwww.com! E* G" J0 `7 l4 [3 N: J/ Z4 A/ {
要拿去就凑合着看看吧。

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

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

很好很强大

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

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

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

另外，偷偷的说一下....—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート, U+ k; U. ?! w
+ m6 y& `) L. Z+ A
“防复制只需要屏蔽掉一条明文既可”..% {7 Z) f7 j6 l2 U: s! {3 m% |

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

bbs.mocwww.com( e) {: `; h2 {7 X

这是某位朋友教我的

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

我没下载

..魔力私服,最新魔力宝贝私服技术交流* E6 R; ^& J8 A. s2 X2 u

对于这个不感兴趣.
魔力私服,最新魔力宝贝私服技术交流' y8 z+ ^8 j" F; r6 c ^
不如去研究研究封包

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

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

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

恩，是的...

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

也可以防复制的..~

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

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

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

超出新手范围看不懂

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