GMSV提取出来的数据库表结构数据
SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
I* K5 ]) o+ r# b7 x G2 Bbbs.mocwww.com解释：表结构 CdKey,registnumber 从 主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段bbs.mocwww.com' b/ m& H7 W" o( p9 y8 W
具体怎么写我也不知道魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) p) q7 R' @ q( F4 w& O
SELECT titleID FROM tbl_character WHERE guildID=%d
7 S8 |( \8 e0 k魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表魔力私服,最新魔力宝贝私服技术交流) f8 k# ~5 O3 ?: U1 n4 M
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート5 }4 ~) L$ M- Z# g1 d4 ?
bbs.mocwww.com2 ^7 Y* t3 q8 |' ^/ u! j$ F. {
select distinct guildID from tbl_character where guildID >=%d and guildID < %d
( }8 G- Z, l- F$ O7 s/ w; x6 @魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ n' z# [3 U) F
SELECT * FROM tbl_guildMonster %s:%d [7m guildMonsterDataReadError妖城在线论坛+ b8 ?( D$ R, f/ Q6 J
8 \2 P }' [) Fbbs.mocwww.comREPLACE tbl_guildMonster_bak 妖城在线论坛. c) v2 X" N$ a+ O
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート! u. E6 e, y% P& v& b
SELECT * FROM tbl_guildMonster WHERE guildID=%d
: q; ~8 X% B3 g6 @' a! T ]妖城在线论坛
% e1 G; R' E) |& a- y魔力私服,最新魔力宝贝私服技术交流REPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d
6 @3 p3 d- O8 }1 q: Wbbs.mocwww.com+ q9 r: W0 F3 N! K
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート! R5 \2 R6 w* M: i$ `
bbs.mocwww.com$ \. S! a+ ~1 a1 g/ S
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
; s/ ^- c8 {2 V魔力私服,最新魔力宝贝私服技术交流- S) \* l. @5 i$ Y: v8 k9 h
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
& T; G" Z2 R/ M魔力私服,最新魔力宝贝私服技术交流魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表* ^. J x0 ]# r& l! C
SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d %s:%d [7m backup error guildItemBox妖城在线论坛1 W4 S! E3 i. ~
bbs.mocwww.com* D- H; h7 N8 Y4 U
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d
5 Q/ e" m8 P* t. R6 D& D
- Y( m8 k4 c: \ u魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d bbs.mocwww.com4 C$ i( b) }" |) T5 x1 S
0 X7 Z j6 }- B5 Z魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
! z P* ?+ p2 k& C( |9 I魔力私服,最新魔力宝贝私服技术交流
& V, n4 z4 `9 r- w, fbbs.mocwww.comSELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d 妖城在线论坛4 P/ T: i4 t% y* l5 J! f
魔力私服,最新魔力宝贝私服技术交流" J; r: h% b& ?1 c+ p/ y$ D7 |
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)
8 ?8 ^$ p4 U8 w6 D, c8 K9 Z- k妖城在线论坛 %s:%d [7m guildIDOutOfRange
O* \0 n) [' j" g—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート魔力私服,最新魔力宝贝私服技术交流2 Q/ I1 V- Y; V$ v9 U
INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d
* Z4 U) s% G2 p' Y1 o7 e V- e
! _$ |( G% e/ a: w9 ~. Zbbs.mocwww.comSELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
) h7 s* I" c* `bbs.mocwww.com
8 Z# v: N, `+ C! `1 }DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d %s:%d [7m err : canNotCreateBreedingRoom
# X0 T. ]+ i1 K; o/ H$ _7 l—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 g W3 @( t, h" @
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
) k% y5 k- P7 R, \! U+ z4 R妖城在线论坛
" \7 R/ b, U! Y/ G* C7 `& @! G魔力私服,最新魔力宝贝私服技术交流SELECT * FROM tbl_character WHERE guildID=%d 魔力私服,最新魔力宝贝私服技术交流' b# D- L" E1 v; _; q
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート p6 O' U! Z) T% O2 `" b, ~4 l& S
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,
& c' {+ X9 X. E" Sbbs.mocwww.com
( h* p* a1 H- [/ U8 v% T魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d
' r0 |; A" p- H魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表4 x& x5 r! [) U* [. T! N8 N
SELECT * FROM tbl_guild WHERE guildID=%d % S- ]; U7 a7 _0 `& D, ^
. V+ O5 l$ `3 B8 U( n3 C5 Q魔力私服,最新魔力宝贝私服技术交流UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d
- h7 X2 b5 I$ g6 M0 |0 v魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 y8 S% E9 R: X' F$ H) J1 ]0 b) b
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
- s4 M! L% K# L1 I6 t S4 `! r
; _* m7 L# M5 a7 {% \bbs.mocwww.comDELETE FROM tbl_guildMonster WHERE GuildId=%d bbs.mocwww.com3 W# M$ h) P+ N+ V9 g- I
1 u& E$ @- w* R
REPLACE tbl_guildMonster VALUES ( %s:%d [7m err:delete guildMonster(%s) bbs.mocwww.com4 r. t$ }! B( C# u
& T# [6 A* w/ l, Q5 t4 u1 R魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表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) bbs.mocwww.com2 b1 \+ _8 N- N Q3 D$ A+ a
妖城在线论坛4 D+ d$ x2 \$ e6 j0 ^( T$ H
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) bbs.mocwww.com n" O! s+ [7 k* @; G
# X% B. x# ]3 j: G- g9 s魔力私服,最新魔力宝贝私服技术交流INSERT INTO tbl_guildItemBox VALUES %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d)
* A) P8 u3 J6 |5 A %s:%d [7m err: insert guildItemBox (%s)
- x! o# N2 v( B1 n; {魔力私服,最新魔力宝贝私服技术交流 %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
, |: E5 }5 W1 H" P+ L! l- i, g" ^魔力私服,最新魔力宝贝私服技术交流 %s:%d [7m err:delete guildItemBox(%s) % F- {, W6 B0 l: n/ u# p+ L
( G" g5 e! Y5 P, \$ Q魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT DISTINCT GuildId FROM tbl_guildItemBox
, g5 [( i7 l' e) U—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
& t9 r, h" f+ c3 ~1 y1 O—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートguildItemBoxDBToMemory : tbl_guildItemBox Not GuildID %s:%d [7m GuildID malloc error魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# U' w& z8 _4 P( n
%s:%d [7m MySQL result errorbbs.mocwww.com' D% t7 j i. k* y# X$ v
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表- g( o T/ K, y5 @6 P7 H: ?
SELECT * from tbl_guildItemBox WHERE GuildId=%d %s:%d [7m err guildItemBox: invalid field num魔力私服,最新魔力宝贝私服技术交流1 v& \; P" A# H/ g1 q$ N( W
%s:%d [7m err: item full?
* h, @. }3 W/ v7 L6 L—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート %s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 0 h( u; ^' R% D( b" q
%s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: X4 x$ [! b2 n" F9 d
%s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)魔力私服,最新魔力宝贝私服技术交流6 ~( h8 f* T; ?7 a- n
%s:%d [7m err: get guildItemBox query+ e% I2 |. Y+ A! k, N7 T+ K& N
( |+ I! N. B. f" P' I魔力私服,最新魔力宝贝私服技术交流SELECT TrialFlg from tbl_user WHERE CdKey='%s'
3 F3 _) ^: Q8 [1 Q @魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表bbs.mocwww.com8 @! u, w+ l3 l, f
SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
, k; `: {4 `) r9 ]) ^; Gbbs.mocwww.com
9 H/ k% r0 n& L* @3 r( Ybbs.mocwww.com UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s' puk2/dataBase/toPuk2.c
+ x1 |# D* E2 Y* ^$ f1 L$ A4 h妖城在线论坛
9 t( R' I J5 r- z/ Mbbs.mocwww.com 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
: \/ s2 j9 A0 s' s4 K—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
1 O: ~( ]2 \* q, G# y3 s. F h魔力私服,最新魔力宝贝私服技术交流 UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
- s' W# Y% J9 I9 P4 @7 {; V魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート* ~9 I* s+ Y' ?! x% `' L
UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s' puk2/dataBase/toPuk3.c
3 j) d6 @& v+ c. U6 N—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 T4 y9 E) s5 Z" ^! {
下面我发附件，附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据，希望高手们有用。。菜鸟拿去没用的。。bbs.mocwww.com6 f# j9 V: w9 }4 D {5 O# u
要拿去就凑合着看看吧。
, C/ Z: [9 v X( n! X4 H# _+ e1 K妖城在线论坛魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表: L/ q+ |) g3 j$ k. f# _9 W0 x" {8 t
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]
