MuManager Server里操作数据库的sql语句　

从整理的内容来看，只要muonline一个库即可，不需要建新库，但要加些表，也不难加的，里面？？？？？处，是语法有问题处，好像缺select这个关键字，估计是被人改丢了，供大家参考。

CMainFrame MuManager Server Ver 2.10.05 20030716 Taiwan Service Local

AppWizard-Generated Applications

===========================================================

CMuManagerServerDoc

CMuManagerServerView

Game manager server start failed..

retry...

Now game

manager server start!!

String Table Open Fail

Item name convert error!!

item(Tai).txt

Itemscript Open Fail

item(Kor).txt

Initialize...

Connnect

socket %d][%s :[%s][%s]:Lev[%d]:Dur[%d] [serial:%d] [%s]:+%d] :%d%%]

skill(Tai).txt

Magic read file Failed

skill(kor).txt r

end

SQLSTATE:%s, %s %s

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=%s;

FileDsn=%s CQuery error : excess column Querry stmt : %s 08001 08S01

SQLSTATE:%s, Error Note :%s DSN Name(%s) : AccountChar DB Connect Fail GameID5

GameID4 GameID3 GameID2 GameID1

SELECT * FROM AccountCharacter where Id='%s'

error : %s %d pos: %d E:\霸烙皋聪廉 辑滚\Source_MFC\AccountCharDBSet.cpp

UPDATE AccountCharacter SET GameID5='%s' WHERE Id='%s'

UPDATE AccountCharacter SET GameID4='%s' WHERE Id='%s'

UPDATE AccountCharacter SET GameID3='%s' WHERE Id='%s'

UPDATE AccountCharacter SET GameID2='%s' WHERE Id='%s'

UPDATE AccountCharacter SET GameID1='%s' WHERE Id='%s'

cLevel Class

SELECT Class,cLevel FROM Character WHERE Name = '%s'

Id

SELECT * FROM AccountCharacter WHERE Id='%s'

UPDATE AccountCharacter set GameID%d = '%s' WHERE Id = '%s'

select CASE WHEN CtlCode IS NULL THEN 0 ELSE CtlCode END FROM Character Where Name = '%s'

UPDATE Character Set CtlCode = '%d' WHERE Name ='%s'

DSN Name(%s) : Account DB Connect Fail desc_text

SELECT * from MEMB_DETA where memb_guid=%d

ctl1_code memb_guid bloc_code fpas_answ fpas_ques

mail_addr tel__numb phon_numb sno__numb memb_name memb__pwd

memb___id mang_guid

SELECT * from MEMB_INFO where memb___id='%s' %d

UPDATE MEMB_DETA SET desc_text='%s' where memb_guid=%d

INSERT INTO MEMB_DETA ( memb_guid, desc_text ) valueS (%d,'%s')

SELECT memb_guid from MEMB_DETA where memb_guid=%d

UPDATE MEMB_INFO SET memb__pwd = '%s',memb_name = '%s',sno__numb ='%s',

tel__numb = '%s',phon_numb = '%s',mail_addr = '%s',fpas_ques ='%s',

fpas_answ = '%s',bloc_code = '%s' WHERE memb___id = '%s'

DisConnectTM ConnectTM IP ServerName ConnectStat

SELECT mail_addr, bloc_code, ctl1_code,(CASE WHEN ConnectStat IS NULL THEN 0 ELSE ConnectStat END) as

'ConnectStat',(CASE WHEN ServerName IS NULL THEN 'None' ELSE ServerName END) as

'ServerName',(CASE WHEN IP IS NULL THEN 'None' ELSE IP END) as 'IP',ConnectTM,

DisConnectTM FROM MEMB_INFO m LEFT OUTER JOIN MEMB_STAT s ON m.memb___id = s.memb___id

WHERE m.memb___id = '%s'

SELECT ConnectStat, ServerName FROM MEMB_STAT WHERE memb___id = '%s'

SELECT bloc_code FROM MEMB_INFO where memb___id='%s'

SELECT bloc_code FROM MEMB_INFO where memb_guid=%d

UPDATE MEMB_INFO SET bloc_code= '%s' where memb___id='%s'

INSERT INTO MEMB_INFO (memb___id, memb__pwd, memb_name, sno__numb, tel__numb, phon_numb, mail_addr,

fpas_ques, fpas_answ, bloc_code, ctl1_code) valueS ('%s', '%s', '%s', '%s','%s', '%s', '%s', '%s', '%s', 0, 0)

appl_days

SELECT memb_guid, memb___id, memb_name, sno__numb, phon_numb, appl_days, bloc_code from MEMB_INFO

where sno__numb='%s'

', '%s', '%s', %d, '%s', '','' ', '

exec SP_BLOCKING_APP %d, %d, '%s', '%s', '

select B.memb_guid, B.block_guid, M.memb___id, B.char_name,B.serv_guid, B.take_code, B.appl_days, rels_days, B.ctl1_code

from MEMB_INFO M INNER JOIN BLOCKING B ON M.memb_guid = B.memb_guid where M.memb___id = '%s'

ORDER BY B.block_guid

rels_days char_name take_code serv_guid block_guid admin_name dist_code

select * from BLOCKING_LOG where block_guid = %d memb_cont take_cont select * from BLOCKING where block_guid = %d

select B.block_guid, B.take_cont, B.memb_cont, B.appl_days, B.rels_days

from MEMB_INFO M INNER JOIN BLOCKING B ON M.memb_guid = B.memb_guid where M.memb___id = '%s'

AND M.bloc_code <> '0' AND B.ctl1_code = '5' %s ' where block_guid = %d

update BLOCKING set take_cont = '

update BLOCKING set memb_cont =

'',%d,'%s',''

exec USP_Block_CanCel %d,%d,'%s', '

DSN Name(%s) : Login DB Connect Fail

SELECT mang_guid FROM MANG_INFO WHERE ctl1_code = 0 AND mang___id='%s'

auth_code skill_guid

SELECT S.skill_guid, S.auth_code FROM MANG_INFO A INNER JOIN MUMNG_AUTH_SKILL S ON A.mang_guid = S.mang_guid

WHERE mang___id='%s'

mng_auth

INSERT INTO MUMNG_MANG_INFO (mang_guid, mng_auth) valueS (%d, %d)

SELECT mng_auth FROM MUMNG_MANG_INFO WHERE mang_guid='%d'

dep_code part_name mang_name mang__pwd mang___id

SELECT mang_guid, mang___id, mang__pwd, mang_name, mail_addr, part_name, dep_code, ctl1_code

FRO