GMSV提取出来的数据库表结构数据
SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d 妖城在线论坛# j+ [, V: \; d
解释:表结构 CdKey,registnumber 从 主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段魔力私服,最新魔力宝贝私服技术交流+ x/ R3 a/ M$ F ]/ ~) u! ~
具体怎么写我也不知道
2 h9 N2 p+ j8 }8 JSELECT titleID FROM tbl_character WHERE guildID=%d bbs.mocwww.com* I. h$ I1 S+ d% r3 ^
妖城在线论坛& d( M4 J) n. e$ V2 }. e
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d bbs.mocwww.com5 e! Z5 r5 p& v4 o
bbs.mocwww.com2 D+ j+ D2 J# _5 J
select distinct guildID from tbl_character where guildID >=%d and guildID < %d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート" K& g% w+ r# F: V ?, ~) Y4 M
) ?! c- ^1 v& i& ]) R) ySELECT * FROM tbl_guildMonster %s:%d [7m guildMonsterDataReadError魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表$ _8 Y5 }" o! U- }
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表1 z* \2 F5 T( s/ f" |; I2 `0 M
REPLACE tbl_guildMonster_bak
( Q7 z# f0 B( mbbs.mocwww.com魔力私服,最新魔力宝贝私服技术交流$ E. L3 o+ R. d* O, N7 v" k" Q2 m( ?6 {" r& k
SELECT * FROM tbl_guildMonster WHERE guildID=%d 妖城在线论坛: X# o3 u/ ~- N9 M- y5 n
bbs.mocwww.com* H8 r, j: ^- K2 @
REPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d
, B# c( N4 z! s; I0 w! @# o. ~魔力私服,最新魔力宝贝私服技术交流
- \: j. Q( U1 r }) m8 f& U. [' iDELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d $ R U9 q) m/ q0 ^
C0 D0 [# W3 o, Y N- E—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートDELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d 妖城在线论坛/ X$ ~7 u+ |9 E7 k
bbs.mocwww.com7 S) H, J. E. v+ O3 d2 Z# {
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d
2 [8 y. _. |- @—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
. l* T R5 f& `7 A妖城在线论坛SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d %s:%d [7m backup error guildItemBox
' J4 ?1 c) O4 W6 t" P魔力私服,最新魔力宝贝私服技术交流
/ a' T2 e1 P% R( Q" t妖城在线论坛SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d bbs.mocwww.com; k8 Z8 k$ h' ~' q% g, F4 {
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ ]6 l. K0 X+ c' k) z, p
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d
' E# i9 \" K( S魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表! d6 X( }- Y* {7 U: h: l0 ^% H
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. P7 v& w6 @! R6 D6 B4 h/ n
7 U$ m9 c9 v8 h& e6 K( u7 pbbs.mocwww.comSELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d
5 }& M# B: P# u C r0 l1 k3 {, Vbbs.mocwww.com$ I6 T7 d" Q' f; \2 P% f
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)
& t6 G- r- Y$ O6 z—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート %s:%d [7m guildIDOutOfRange
; A8 U D" H! I& x
+ B9 Q0 @# C$ A) x; i C魔力私服,最新魔力宝贝私服技术交流INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d 5 A+ {* R, |$ y6 t, r" n
0 V2 c, O4 ^+ K, ~& L—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートSELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d bbs.mocwww.com/ `7 m2 N$ B* N6 ^* O
魔力私服,最新魔力宝贝私服技术交流. a- q6 V( X+ x0 ]+ Z1 u e
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d %s:%d [7m err : canNotCreateBreedingRoom妖城在线论坛 c: Q) ?; ` ]' Z! @
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表 l2 O9 `) B9 t! U
SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表. s( Z/ s# J, m
7 u c( z# w+ v* Q1 y妖城在线论坛SELECT * FROM tbl_character WHERE guildID=%d 妖城在线论坛/ J* n# l" u& z! B" }+ d# @- C
7 |" Q% W* \! Gbbs.mocwww.comSELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,
* q7 {+ S F3 s4 }3 v) V/ s* s魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表魔力私服,最新魔力宝贝私服技术交流4 N( j$ ~1 y4 H7 f2 A( O6 a6 S$ ^
OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d
& F) d+ y% L# P! T/ e3 g—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: y. _3 W+ l: B2 {/ p
SELECT * FROM tbl_guild WHERE guildID=%d bbs.mocwww.com7 }6 W6 o4 V* P' K& R: Q8 e# K4 d
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( n3 @* D7 K( t5 V
UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d ( `6 v4 Q' m4 X0 r) L
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表, _! h. F+ L6 h1 k
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
( u# U% R, K7 x8 y妖城在线论坛bbs.mocwww.com4 s$ Q/ s% C3 m& p
DELETE FROM tbl_guildMonster WHERE GuildId=%d 妖城在线论坛* p3 k- i [; C$ U5 x/ z; |
) X% A) j# R3 |# R& T% h; T5 ~7 s0 ?bbs.mocwww.comREPLACE tbl_guildMonster VALUES ( %s:%d [7m err:delete guildMonster(%s) 魔力私服,最新魔力宝贝私服技术交流9 w7 E2 E! @/ p" l: F
/ k% N0 s5 D- W' n& @# K7 ~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编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: T7 D6 p7 _" u
bbs.mocwww.com5 q, _8 l/ ]: J- E) X5 u
save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) bbs.mocwww.com. D5 i" C% H" O$ S
/ _) }. L$ b* K+ X妖城在线论坛INSERT INTO tbl_guildItemBox VALUES %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d)
. f7 C5 G7 y4 E7 W# f) c0 n %s:%d [7m err: insert guildItemBox (%s)
5 N) Z7 b2 m2 f$ j妖城在线论坛 %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
/ z6 l! @* @ H2 k1 h. X0 X; h& \) S魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表 %s:%d [7m err:delete guildItemBox(%s) 9 \+ ^; |+ R$ F9 Q
: S! R2 h; i7 E' m$ s* B8 Z+ L—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートSELECT DISTINCT GuildId FROM tbl_guildItemBox
S. n' t$ R i' @8 Z
/ C" X8 p+ f/ ?% G妖城在线论坛guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID %s:%d [7m GuildID malloc errorbbs.mocwww.com r6 e9 e9 m) _% O( }/ p
%s:%d [7m MySQL result error
6 m h% ~' R; Q7 Z
( o) ~6 |! C. m& y3 vbbs.mocwww.comSELECT * from tbl_guildItemBox WHERE GuildId=%d %s:%d [7m err guildItemBox: invalid field numbbs.mocwww.com: N* |; G( g9 H- O- W, Q$ R& K
%s:%d [7m err: item full? 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# ?1 ^3 c6 r5 Y" }2 m$ n) _- ~
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 妖城在线论坛' s1 G6 r& q( n
%s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
E. a/ m2 r/ F: J- ]" [bbs.mocwww.com %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)妖城在线论坛' ]6 N8 o8 F4 q9 N1 Q
%s:%d [7m err: get guildItemBox query
! T1 v `( R. k5 m; L—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表3 ?! g0 r% l% c1 X
SELECT TrialFlg from tbl_user WHERE CdKey='%s'
% p! V7 p a# B) U K+ m妖城在线论坛- z; F$ J8 j( L- {
SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
4 G) \% X, A- _# `—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート) X8 A8 m1 _! A0 d3 _
UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s' puk2/dataBase/toPuk2.c 1 L' n% R4 {$ f" o
P6 j/ j5 _* i% N妖城在线论坛 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编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート1 [" F1 P6 e/ H( C" K, _, X
妖城在线论坛' X! C e3 W4 p' J& h# i
UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s' 妖城在线论坛4 g3 ]$ Y" |: N6 C0 Q6 W, a
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート% [1 a) @! H+ ^* O F
UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s' puk2/dataBase/toPuk3.c —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート. m7 T% u9 l4 X
; M- x/ e, U7 s下面我发附件,附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据,希望高手们有用。。菜鸟拿去没用的。。—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート5 d! X3 m" i5 a. u
要拿去就凑合着看看吧。
- t9 {, `4 J; Z—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート# ~0 [5 q! P4 R: q; k# q$ e8 j
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]