GMSV提取出来的数据库表结构数据
SELECT CdKey, RegistNumber FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
/ k* ^& c2 v7 U* M解释:表结构 CdKey,registnumber 从 主目录中的tbl_guild中读取 guildID=%d和serverNumber=%d 段妖城在线论坛) H; ^- _! o; Y7 g
具体怎么写我也不知道妖城在线论坛& {9 c5 ^. r" j
SELECT titleID FROM tbl_character WHERE guildID=%d
" a, `# O! {4 E R6 g5 w魔力私服,最新魔力宝贝私服技术交流妖城在线论坛/ s' s" G- q! v- S5 U# H3 |
SELECT Name from tbl_character WHERE CdKey='%s' and RegistNumber=%d bbs.mocwww.com; V. \5 z' V9 H5 ]* }
0 r4 Y; h6 h3 v* u$ _/ r2 }魔力私服,最新魔力宝贝私服技术交流select distinct guildID from tbl_character where guildID >=%d and guildID < %d
- k/ p0 {" u& S$ t' @0 X妖城在线论坛; M) O: c( j0 \
SELECT * FROM tbl_guildMonster %s:%d [7m guildMonsterDataReadError妖城在线论坛8 j: i& v% J& d% ^$ ]+ J- R7 [3 ?
n; @ M( l; Q$ u; YREPLACE tbl_guildMonster_bak —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( r( H6 e* k2 k" d, V4 c
0 ~1 v- k4 {# L8 x6 |1 P7 x$ i
SELECT * FROM tbl_guildMonster WHERE guildID=%d 妖城在线论坛7 l5 p; r9 k2 D7 M! d6 R
8 R( T7 ^6 `7 r2 e+ tbbs.mocwww.comREPLACE tbl_guildItemBox_bak SELECT * FROM tbl_guildItemBox WHERE GuildId=%d
# R/ d0 J1 u" l' r妖城在线论坛魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表+ J) h6 c3 V& w4 A, J/ v
DELETE FROM tbl_guild WHERE guildID=%d AND serverNumber=%d
- r. O& [& Q6 X4 }2 n3 Wbbs.mocwww.com魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表2 I) A$ J& H( h8 T7 F
DELETE FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
# M. M- a6 Z' J C) U9 m) hbbs.mocwww.com
+ o; ^6 u4 \4 Y; Y* P妖城在线论坛DELETE FROM tbl_guildItemBox WHERE GuildId=%d AND CdKey='%s' AND RegistNumber=%d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート& f, S7 ^. l; C' x/ m
[. o4 t% K7 w- i6 e妖城在线论坛SELECT CdKey, RegistNumber FROM tbl_character WHERE guildID=%d %s:%d [7m backup error guildItemBox魔力私服,最新魔力宝贝私服技术交流, ?: f7 J+ c/ w+ H! F0 g
魔力私服,最新魔力宝贝私服技术交流5 z! [7 ?* R5 O5 T# z: v( Q
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, titleID, OwnTitle FROM tbl_character WHERE guildID=%d
, {# q! i# I, g# m' A妖城在线论坛0 M( m2 G8 a8 b& p- Q
SELECT COUNT(guildID) from tbl_guild WHERE serverNumber = %d 妖城在线论坛 o: f" {7 v3 I7 ^6 c( C9 _. ?! [- V- X
bbs.mocwww.com4 e$ k" d- m; [ r" U4 e
SELECT * from tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
* t& `; Y& p; V' }" @
9 j# n' F8 X( m# Q; ]( n/ p# t魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT guildID from tbl_character WHERE CdKey='%s' AND RegistNumber=%d
. Z$ K$ n B& t5 z* d9 ?* Y魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート( b* X9 `6 X6 P" y& T7 D6 I
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)
' B6 U1 R9 H5 b* M, A' j妖城在线论坛 %s:%d [7m guildIDOutOfRange* i5 j: d; m, P
/ _$ @) b5 J$ V魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表INSERT INTO tbl_guildMonster SET guildID=%d,roomNumber=%d, CdKey='%s', RegistNumber=%d, isUse=%d 魔力私服,最新魔力宝贝私服技术交流# ^6 F$ b' H6 S6 [
妖城在线论坛" x* p2 H6 a! s* F; ~
SELECT roomNumber FROM tbl_guildMonster WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d
+ Y2 k6 K2 _! V" ]( sbbs.mocwww.com
& u0 R9 k7 p3 r) \' L: g—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートDELETE FROM tbl_guild WHERE guildID=%d AND CdKey='%s' AND RegistNumber=%d %s:%d [7m err : canNotCreateBreedingRoom
. G& g9 c9 x8 z" v: ?, Tbbs.mocwww.com
5 D9 G! _, ]1 q) @* `% [! Z Z魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT guildID FROM tbl_guild WHERE CdKey='%s' AND RegistNumber=%d
! ?( }7 l. K" ]5 B魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表; w+ D5 G1 r+ \; M
SELECT * FROM tbl_character WHERE guildID=%d 魔力私服,最新魔力宝贝私服技术交流* R. o8 r& ^! x8 Z. A @$ Q% D. ~
—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート& [, v+ |) V& X( s( {# Y6 k
SELECT Lv, FaceImageNumber, sequence, RegistNumber, CdKey, Name, 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表# |* E, L3 u4 z' @5 x2 H: F
' @# x) c% E: j2 I% n2 s—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲートOwnTitle FROM tbl_character WHERE CdKey='%s' AND RegistNumber=%d
* Y2 M8 j) A/ I$ K% K/ u妖城在线论坛
0 r: ]5 I B8 z v" _* o( z g魔力私服,最新魔力宝贝私服技术交流SELECT * FROM tbl_guild WHERE guildID=%d
' [: Y' Z* R8 Z: U+ n2 D1 y+ ?妖城在线论坛魔力私服,最新魔力宝贝私服技术交流5 L" o- E5 ^: v. s8 j
UPDATE tbl_character SET titleID=%d WHERE CdKey='%s' AND RegistNumber=%d
' g+ D& o" s. p/ n4 h% `8 K魔力私服,最新魔力宝贝私服技术交流& \: y4 { h, {8 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 妖城在线论坛; F- [. D) ]( A& o
8 w+ @, c% k+ H9 F/ h' K! J2 FDELETE FROM tbl_guildMonster WHERE GuildId=%d —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート, S( {. v# ?# O$ d5 F e( M: W
妖城在线论坛, b% u% m0 n: Z
REPLACE tbl_guildMonster VALUES ( %s:%d [7m err:delete guildMonster(%s) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート1 f# k3 |9 J, K9 r; ^+ d+ _. h
bbs.mocwww.com" I1 A0 w4 a/ b6 ~& w9 b; |, N
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)
$ o+ S! [- q9 v; d; v" ~) i4 ~bbs.mocwww.com
3 U' W. f- W0 c1 R- }. r( I* `魔力私服,最新魔力宝贝私服技术交流save_guildItemBox : GuilMon Escape : guildID(%d), Room(%d) bbs.mocwww.com+ l$ Y' p- `& A5 y( L( u; |9 J, n
妖城在线论坛+ R- v" A3 L5 |5 ~$ E, |
INSERT INTO tbl_guildItemBox VALUES %s:%d [7m save_guildItemBox : itemindex failed : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d), itemindex(%d) 妖城在线论坛: G% t* d2 O( c; v* M
%s:%d [7m err: insert guildItemBox (%s)
8 v! k% y- J! t. Gbbs.mocwww.com %s:%d [7m save_guildItemBox : SQL buffer Limit : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
: c% E6 i) o& f, w魔力私服,最新魔力宝贝私服技术交流 %s:%d [7m err:delete guildItemBox(%s) —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート3 i! V! f- y1 w
3 l! H) j& i2 b魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表SELECT DISTINCT GuildId FROM tbl_guildItemBox 妖城在线论坛5 G7 r t$ m! Z$ ?' y
魔力私服,最新魔力宝贝私服技术交流0 U7 E; Z; z" J7 i
guildItemBoxDBToMemory : tbl_guildItemBox Not GuildID %s:%d [7m GuildID malloc error
" P( Q& h% v. @( e魔力私服,最新魔力宝贝私服技术交流 %s:%d [7m MySQL result error—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート, ]9 _/ {. v& p' {2 S s, \
! |9 ~4 B, p" k' E5 v$ E妖城在线论坛SELECT * from tbl_guildItemBox WHERE GuildId=%d %s:%d [7m err guildItemBox: invalid field num
$ l7 u$ \% A6 Q }/ Y- P; }! ?1 H魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表 %s:%d [7m err: item full? bbs.mocwww.com' A3 I7 J$ ^0 _" `8 I( t m% k
%s:%d [7m Load_guildItemBox : SelectItem Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
& w6 a$ a0 p2 q( Q& G. Cbbs.mocwww.com %s:%d [7m Load_guildItemBox : Func Entry Error : guildID(%d), Room(%d), SelectItem(%d), Itempos(%d)
4 U+ u7 U# D9 b+ y# R魔力私服,最新魔力宝贝私服技术交流 %s:%d [7m Load_guildItemBox : roomNo(%d) Error : guildID(%d)[m %s:%d [7m guildItemBoxDataReadGuildIDError : guildID(%d)
0 r: ?; i2 k3 q3 o% vbbs.mocwww.com %s:%d [7m err: get guildItemBox query
! W* C( z- z U, z9 O4 r$ f2 @/ U妖城在线论坛
% P, _. G7 z; q% e3 P0 ~1 t妖城在线论坛SELECT TrialFlg from tbl_user WHERE CdKey='%s'
+ S3 \$ \2 _) H! d. N3 }8 m—魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート
, c6 a& {3 O' r* _ b! O8 `+ c: ?: x6 obbs.mocwww.com SELECT Puk2Key, Kind, UseFlg, LinkCdKey, EnableFlg from tbl_puk2 WHERE Kind = %d and Puk2Key='%s'
' Q+ ~ D) U2 B- u& y3 R+ S魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表bbs.mocwww.com( [/ S3 ~; A4 S/ G- C+ V+ b4 k/ S
UPDATE tbl_puk2 SET UseFlg=%d, VerUpDate=%u,LinkCdKey='%s' Where puk2Key='%s' puk2/dataBase/toPuk2.c 魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表7 e$ U7 u" w8 p8 }4 i$ }
" f7 ]# N2 o! T! j- g$ P0 O+ E* h* M( u魔力私服,最新魔力宝贝私服技术交流 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
c4 c3 n4 J& X" s( [$ d* ]. K, S妖城在线论坛妖城在线论坛0 ?# X! _2 k, l, q% U/ Q; G- r
UPDATE tbl_user SET TrialFlg=%d WHERE CdKey='%s'
3 u6 \$ S% X0 ?妖城在线论坛 ~6 t' Q u7 ?) J4 M
UPDATE tbl_puk3 SET UseFlg=%d, VerUpdate=%u, LinkCdKey='%s' WHERE Puk3Key='%s' puk2/dataBase/toPuk3.c —魔力私服,魔力宝贝私服技术,DELPHI编程,魔力寶貝, 魔力宝贝, 크로스게이트,クロスゲート! J0 Q+ j, m! w
$ V3 N8 P: g; m( {" P4 P魔力私服,最新魔力宝贝私服技术交流下面我发附件,附件内包含tech参数.txt NPC参数.TXT 还有一些GMSV提取出来的数据,希望高手们有用。。菜鸟拿去没用的。。
6 M8 D" {# c) q5 j0 Z魔力私服,最新魔力宝贝私服技术交流要拿去就凑合着看看吧。魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表0 E* B( h* M, y) H. ]/ S
魔力私服,最新魔力私服,魔力宝贝私服,魔力宝贝私服技术,魔力宝贝私服,私服架设技术,妖城,FLASH,电影,黑客,网络,网吧,破解,入侵,注册表( c( W# S: X' `4 a
[ 本帖最后由 hotpursuit 于 2008-4-29 15:22 编辑 ]