GMSV提取出来的数据库表结构数据
SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d 妖城在线论坛. |+ b7 G+ l6 B
解释:表结构 CdKey,registnumber 从 主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段8 J# {2 S. u6 F
具体怎么写我也不知道妖城在线论坛' {/ c1 ?; R8 F6 `- V
SELECT titleID FROM tbl_character WHERE guildID=%d
; S# Q' T, i7 R% Z妖城在线论坛
0 J" q+ T% j( q) a! Y8 pbbs.mocwww.comSELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d
: s+ d1 _; `4 ]0 z魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
; i" B1 h5 o" P" n$ v: D, ~魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表select distinct guildID from tbl_character where guildID >=%d and guildID < %d
( [8 o9 y/ l. h7 x妖城在线论坛妖城在线论坛* X# p+ p/ |+ |6 Y7 n. u4 k W
SELECT * FROM tbl_guildMonster %s:%d [7m guildMonsterDataReadError妖城在线论坛/ Y9 y- y/ E: ]- Y2 H
! P0 f+ _' [: d* A& L% j1 R3 J—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートREPLACE tbl_guildMonster_bak 魔力私服,最新魔力宝贝私服技术交流2 J# E0 U7 E" q& M$ x. ^
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート- s, L \6 w( @( ~% a
SELECT * FROM tbl_guildMonster WHERE guildID=%d
1 j; }* N- Y1 r$ t) W6 x+ l妖城在线论坛
: p+ n N% L N—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートREPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d : D" k, H2 h( B
魔力私服,最新魔力宝贝私服技术交流& [5 M+ k+ @7 h5 q7 w5 F
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
& J8 K1 R' g4 I# v- B# o& nbbs.mocwww.com魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表; L) U% {. X5 U5 s. Y2 \" s& c* h
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表6 C2 ~; T8 |1 _5 }9 C0 H
& j% q; q& ~ R7 o' _
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
0 S" z9 P) |1 Qbbs.mocwww.com魔力私服,最新魔力宝贝私服技术交流2 t( H" Q/ Q% G1 l- x* J
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d %s:%d [7m backup error guildItemBox魔力私服,最新魔力宝贝私服技术交流+ Q9 q3 {; F+ v- j! J+ @
F+ n6 r5 L. w& r, x* S魔力私服,最新魔力宝贝私服技术交流SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d
/ e3 l1 W; n$ O* J2 n
, w4 M: M2 Z/ F1 r' G( O7 E+ h4 o魔力私服,最新魔力宝贝私服技术交流SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d 0 \& V# G3 _" K- u9 J" T1 S" {% l
9 t! G& e0 B! `" i8 o3 C魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
2 }% G3 B; b$ ?: ^% C$ G& J魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
# r, F9 x5 B8 u* `+ F7 r! \+ W( R7 vSELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d
9 U8 \3 y( p' J+ W1 i妖城在线论坛
, r7 p- M* B1 [/ |bbs.mocwww.comINSERT 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)
9 x" a7 J9 \% h# R2 u: x) g, p; i妖城在线论坛 %s:%d [7m guildIDOutOfRange
; j, F- Y4 t: `
1 _0 \: G9 q( W( q: h% dbbs.mocwww.comINSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d
7 x" y1 p- t4 {8 F, t4 O C魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
. X. Y9 F( y. s4 P( u' J魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d G8 C) _8 p" X% ^) d
3 M# l) [/ s- G—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートDELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d %s:%d [7m err : canNotCreateBreedingRoom妖城在线论坛0 E# S0 u5 _# x. e) y' W8 [, A
bbs.mocwww.com; U3 r. }3 p4 p. @3 y/ l" o( ~
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d 1 A* a; X/ r% C7 x$ X, ~
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 z, b7 X4 i8 H; q2 Y
SELECT * FROM tbl_character WHERE guildID=%d
& D2 x1 b8 x' u& e* s—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
! E# E. Z6 u) N3 o, }: { I魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, bbs.mocwww.com* C$ G5 n& n0 K2 C2 i; |
; v+ F. I' R( j! ^2 I& x妖城在线论坛OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d
3 m; S6 o; K- r9 ~bbs.mocwww.com/ d; e% V% o& p/ `0 y2 l0 q: O
SELECT * FROM tbl_guild WHERE guildID=%d ' g c* ^7 X) `7 b. p' x
: l0 }$ \& g. M1 ~妖城在线论坛UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d
+ a/ P; ^/ X" H( A9 I+ G1 |bbs.mocwww.com—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート4 c: k5 [. j& o+ A" q6 S6 t
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
$ w9 ~3 Y! q* }/ L% J$ j+ n: d妖城在线论坛
# C& Z. o5 w) u1 G/ Y! k' j魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表DELETE FROM tbl_guildMonster WHERE GuildId=%d 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 [ p6 D8 b' g/ A8 S
0 {9 m" m4 a+ k) MREPLACE tbl_guildMonster VALUES ( %s:%d [7m err:delete guildMonster(%s)
5 b* q* g0 l6 |4 B. n S; ]—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 `- `( w4 _* t' q* M
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)
( g# J& |2 R/ V8 {: h, |; w妖城在线论坛魔力私服,最新魔力宝贝私服技术交流5 G: w o8 F, f5 ~
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) ( v# t& C( O' h: l; e! ^
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート0 ^9 k: k$ m. N8 S4 S5 i
INSERT INTO tbl_guildItemBox VALUES %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d)
$ H4 X5 N8 _6 G! h妖城在线论坛 %s:%d [7m err: insert guildItemBox (%s) 妖城在线论坛% H. F k( |+ z8 J( P
%s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
$ c! B- s5 K; t- o; P. s魔力私服,最新魔力宝贝私服技术交流 %s:%d [7m err:delete guildItemBox(%s) * Y% ~3 J; P9 K, }
妖城在线论坛2 W4 @' h5 @- G
SELECT DISTINCT GuildId FROM tbl_guildItemBox 妖城在线论坛5 I! W" @; Q6 p; h
* g/ D0 ?& [1 G# B6 n妖城在线论坛guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID %s:%d [7m GuildID malloc error魔力私服,最新魔力宝贝私服技术交流3 U3 h* [2 _0 e1 q
%s:%d [7m MySQL result error
5 D: m" d3 [! R妖城在线论坛
5 l; q$ J P1 p+ C5 F* \5 Q' Fbbs.mocwww.comSELECT * from tbl_guildItemBox WHERE GuildId=%d %s:%d [7m err guildItemBox: invalid field num妖城在线论坛' |- | U5 |% V7 h4 _
%s:%d [7m err: item full? 7 P# N9 i5 |% `8 ]8 m6 C% b. }
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
2 R7 ~( E! [2 g) j/ W %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
}9 v% a1 D- r6 `3 G妖城在线论坛 %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)bbs.mocwww.com, C2 ~8 c, {& F5 D
%s:%d [7m err: get guildItemBox query
: z5 W2 ]" F" c$ k: X' p妖城在线论坛bbs.mocwww.com/ v2 c+ F: D5 D u7 E
SELECT TrialFlg from tbl_user WHERE CdKey='%s'
6 l5 u/ M1 W( F妖城在线论坛魔力私服,最新魔力宝贝私服技术交流4 M. w# q: Y. A! o3 |
SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
6 P: y! h0 U) x" W3 q魔力私服,最新魔力宝贝私服技术交流
; M3 Y3 e+ I- b UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s' puk2/dataBase/toPuk2.c 魔力私服,最新魔力宝贝私服技术交流! i, c) P: N1 e
bbs.mocwww.com! w7 o) d! }) x4 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 %s
$ ~; U2 c, K1 F0 S( j' t( E妖城在线论坛
3 }& y5 h) T- {bbs.mocwww.com UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
9 N/ v& k+ {9 h" L1 a- q妖城在线论坛
7 ~7 _" K. F2 g5 Q5 ^' wbbs.mocwww.com UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s' puk2/dataBase/toPuk3.c ! j/ T5 q$ ?! q; _8 Q8 a
妖城在线论坛6 q0 [0 z4 s+ U
下面我发附件,附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据,希望高手们有用。。菜鸟拿去没用的。。
0 C( u% L; e6 w+ T7 b' }& d3 u" l要拿去就凑合着看看吧。—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート" c, p- k4 o1 P; _" T9 t
7 U) y) i' V4 C2 f5 o0 {9 Hbbs.mocwww.com[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]