GMSV提取出来的数据库表结构数据
SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
9 m! z8 e" P8 |5 x魔力私服,最新魔力宝贝私服技术交流解释:表结构 CdKey,registnumber 从 主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段
8 G& g# L* t3 `6 z8 c—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート具体怎么写我也不知道魔力私服,最新魔力宝贝私服技术交流1 }! R) j* \' a2 S
SELECT titleID FROM tbl_character WHERE guildID=%d bbs.mocwww.com; e9 A" r6 u1 N" L2 m
2 t2 q& t$ E/ {6 m9 l' Q% E; Z妖城在线论坛SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d 妖城在线论坛. \$ A" S2 D/ t: I* G6 G
bbs.mocwww.com8 T5 M* u2 Q& v
select distinct guildID from tbl_character where guildID >=%d and guildID < %d
6 Y n% Y, ~ X/ p" c% Z2 Q魔力私服,最新魔力宝贝私服技术交流
5 A8 m4 g3 M, dSELECT * FROM tbl_guildMonster %s:%d [7m guildMonsterDataReadError魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# O+ S' s6 l# s; t- ?9 o
; V1 s. J0 ~1 V( V5 H妖城在线论坛REPLACE tbl_guildMonster_bak
- Q6 Y7 I4 U' k) V8 q: \" _- fbbs.mocwww.com—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート: C& x3 H N0 n; G/ A& e7 x; V
SELECT * FROM tbl_guildMonster WHERE guildID=%d
& F8 o) P9 l% W4 F魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表魔力私服,最新魔力宝贝私服技术交流! Y; K+ d, J4 P5 j& W
REPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d
4 @4 z9 s1 N7 r0 b+ N魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
0 u, a: w& M* m) }魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
" V' b! f4 R: B& K2 Ubbs.mocwww.com魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表, u' k' o& n2 |" ^: \. J
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート# \, \: V$ {- H0 Q4 f0 U* s* Q
0 I! E1 Z6 a5 Q4 U6 [5 Y/ e
DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d 妖城在线论坛4 d) l& E. ?0 y9 _1 W
' F+ j: U% i( V$ J! s+ z7 `妖城在线论坛SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d %s:%d [7m backup error guildItemBox妖城在线论坛/ ]% }3 j% k, S$ Y7 D) I, M: D
妖城在线论坛" u. j7 {$ _7 @% m
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d
& ~- E8 i7 w9 X6 ?3 B! r- X妖城在线论坛
7 h6 q2 O5 h9 U—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートSELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d
7 B H! H- S0 Z# `—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート0 \1 g. p; W) a/ I8 o, v
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表. T6 _: h; R7 C- f: P* N! R
0 Q( B6 K3 C# \魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d 1 T4 H& a9 V* L" R. I
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート2 i5 z) D7 g# p
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) 妖城在线论坛 q N4 @" [8 C
%s:%d [7m guildIDOutOfRange1 ?7 E7 M% t! k9 z( [ Q7 X- N. c/ `
/ h1 f6 D4 B. n5 Qbbs.mocwww.comINSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d bbs.mocwww.com+ `- W9 W3 S. x7 Y# \) G( [( g8 Z
. h; M$ ]% M$ p& V6 H& U Zbbs.mocwww.comSELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
' {" ^8 r# y+ q: Z% \魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表5 H9 m$ E5 q0 P! D; k5 H0 }* ^0 W
DELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d %s:%d [7m err : canNotCreateBreedingRoombbs.mocwww.com! A5 b7 X& M* T( d
: M2 B+ D6 v7 K- |) A0 t: xbbs.mocwww.comSELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d 妖城在线论坛2 d) D7 y U* K# v) W# x. A
bbs.mocwww.com( A0 O( A! d) ~4 R; A) y. P
SELECT * FROM tbl_character WHERE guildID=%d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート J$ k3 h0 X; R, f6 O
& w6 v6 g6 {5 Q4 s8 J* {# l h魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name,
, g4 U0 c$ ]. s
4 {( U0 I- `/ A& W) a$ {0 Z, {魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表OwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表& w, I6 F/ p4 @8 i) x Z9 K
( k$ a* Q7 J p3 y! B' ^3 p$ e" H魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT * FROM tbl_guild WHERE guildID=%d 妖城在线论坛& l$ U; a) o( \% ~ z3 i
& c e* _4 y3 i8 y4 Y' k魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d
. ~7 O1 S$ r& c& o# D/ [魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
5 K' U0 P+ m3 m0 R7 G8 f% z5 v魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表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 魔力私服,最新魔力宝贝私服技术交流* [% ]% h, o! j4 v; [9 F8 a
4 w0 S' G5 m' L7 W/ u) [—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートDELETE FROM tbl_guildMonster WHERE GuildId=%d
5 u( Z& n- y8 I; C$ x魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
9 y: {, s9 H/ U# W魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表REPLACE tbl_guildMonster VALUES ( %s:%d [7m err:delete guildMonster(%s)
. B7 d8 h( s! R8 \; Ibbs.mocwww.com
9 b) [( r# m6 m5 V. Q) cUPDATE 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)
% ~3 x+ O7 a& W) S—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
: k2 Z" @' y; P9 q7 Hsave_guildItemBox : GuilMon Escape : guildID(%d), Room(%d)
6 [& s" m3 y% I3 F魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
+ C* X- o' O$ d2 v魔力私服,最新魔力宝贝私服技术交流INSERT INTO tbl_guildItemBox VALUES %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d)
" K, @1 x4 \$ e( m! g6 Z0 {. Bbbs.mocwww.com %s:%d [7m err: insert guildItemBox (%s) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート$ G/ A# f& s" ?6 y& o1 c
%s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
, \, t8 |- D7 N* e/ w妖城在线论坛 %s:%d [7m err:delete guildItemBox(%s)
, m6 z. M& M: F. E- L2 R魔力私服,最新魔力宝贝私服技术交流魔力私服,最新魔力宝贝私服技术交流/ }2 a% F7 ]- [% k1 c6 `# \" v* @
SELECT DISTINCT GuildId FROM tbl_guildItemBox
! v0 c6 l! Z; G6 b' p- G魔力私服,最新魔力宝贝私服技术交流
% z1 c& ]! S2 pbbs.mocwww.comguildItemBoxDBToMemory : tbl_guildItemBox Not GuildID %s:%d [7m GuildID malloc error魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表" g0 F' ?- | a% F$ v
%s:%d [7m MySQL result error—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート% `4 T& Z5 n b2 H* w
0 t5 w# p" b" Z! }" F7 ]! `+ l6 L
SELECT * from tbl_guildItemBox WHERE GuildId=%d %s:%d [7m err guildItemBox: invalid field num魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# D% X t* G y7 L
%s:%d [7m err: item full? bbs.mocwww.com$ ^( Q! V- q# X `- E
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) bbs.mocwww.com H8 Q% S, ^; K) t) d( f, j/ w
%s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d) 魔力私服,最新魔力宝贝私服技术交流& `& [# ]! x3 u3 Q o _
%s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)
( U4 @+ t# Z& i" R9 c# n—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート %s:%d [7m err: get guildItemBox query
7 s* ?' \5 ^3 |% Y( s* Z8 [' Obbs.mocwww.com) B( {7 L) @' c8 m" T) R& E5 T
SELECT TrialFlg from tbl_user WHERE CdKey='%s' bbs.mocwww.com$ M+ x, `, j4 Y( F; @
! V, A- V0 J) Y$ z魔力私服,最新魔力宝贝私服技术交流 SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
2 N) O+ }9 V/ m. E—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートbbs.mocwww.com! D2 r6 f+ S( w5 c0 E8 R
UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s' puk2/dataBase/toPuk2.c 魔力私服,最新魔力宝贝私服技术交流& i( a) X7 k) @3 R: }
bbs.mocwww.com- A- l) ^! q& e: w
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魔力私服,最新魔力宝贝私服技术交流! a0 D* q% B5 r/ q, @0 y
妖城在线论坛' c! J: H: a* W0 G2 i
UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
( C" p- J; b' p' r" c4 c( i6 b2 H9 e—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートbbs.mocwww.com) r5 l: x" C2 ^; j; R
UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s' puk2/dataBase/toPuk3.c
& B6 a$ P$ d% P2 N: Z# H' g9 ^魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表
5 k# d+ P$ N2 w9 ^魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表下面我发附件,附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据,希望高手们有用。。菜鸟拿去没用的。。
( d# F$ n5 P& k3 N! g' s6 ?妖城在线论坛要拿去就凑合着看看吧。
8 s, c4 [4 [% B4 K; B8 J& Dbbs.mocwww.com魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表) G) W: K! j7 k8 X& M d$ f% t: q
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]