整理的MuManager Server里操作数据库的sql语句 dedecms.com
从整理的内容来看,只要muonline一个库即可,不需要建新库,但要加些表,也不难加的,里面?????处,是语法有问题处,好像缺select这个关键字,估计是被人改丢了,供大家参考。 本文来自织梦
织梦好,好织梦
CMainFrame MuManager Server Ver 2.10.05 20030716 Taiwan Service Local 织梦好,好织梦
本文来自织梦
AppWizard-Generated Applications 内容来自dedecms
dedecms.com
===========================================================
dedecms.com
织梦内容管理系统
CMuManagerServerDoc 本文来自织梦
内容来自dedecms
CMuManagerServerView 织梦内容管理系统
Game manager server start failed.. 本文来自织梦
dedecms.com
retry...
copyright dedecms
Now game 内容来自dedecms
manager server start!!
织梦内容管理系统
String Table Open Fail
Item name convert error!!
织梦好,好织梦
织梦好,好织梦
item(Tai).txt
织梦内容管理系统
内容来自dedecms
Itemscript Open Fail 织梦内容管理系统
copyright dedecms
item(Kor).txt 织梦好,好织梦
本文来自织梦
Initialize... 本文来自织梦
内容来自dedecms
Connnect 织梦好,好织梦
织梦好,好织梦
socket %d][%s :[%s][%s]:Lev[%d]:Dur[%d] [serial:%d] [%s]:+%d] :%d%%] 织梦好,好织梦
copyright dedecms
skill(Tai).txt dedecms.com
Magic read file Failed copyright dedecms
织梦内容管理系统
skill(kor).txt r 本文来自织梦
copyright dedecms
end 织梦好,好织梦
dedecms.com
SQLSTATE:%s, %s %s
织梦内容管理系统
DRIVER={Microsoft Access Driver (*.mdb)};DBQ=%s; 织梦好,好织梦
dedecms.com
FileDsn=%s CQuery error : excess column Querry stmt : %s 08001 08S01
copyright dedecms
SQLSTATE:%s, Error Note :%s DSN Name(%s) : AccountChar DB Connect Fail GameID5
dedecms.com
内容来自dedecms
GameID4 GameID3 GameID2 GameID1
copyright dedecms
SELECT * FROM AccountCharacter where Id='%s' 织梦好,好织梦
error : %s %d pos: %d E:\霸烙皋聪廉 辑滚\Source_MFC\AccountCharDBSet.cpp copyright dedecms
本文来自织梦
UPDATE AccountCharacter SET GameID5='%s' WHERE Id='%s'
织梦内容管理系统
UPDATE AccountCharacter SET GameID4='%s' WHERE Id='%s'
织梦内容管理系统
copyright dedecms
UPDATE AccountCharacter SET GameID3='%s' WHERE Id='%s'
copyright dedecms
dedecms.com
UPDATE AccountCharacter SET GameID2='%s' WHERE Id='%s'
UPDATE AccountCharacter SET GameID1='%s' WHERE Id='%s'
本文来自织梦
内容来自dedecms
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'
dedecms.com
select CASE WHEN CtlCode IS NULL THEN 0 ELSE CtlCode END FROM Character Where Name = '%s' 本文来自织梦
织梦内容管理系统
UPDATE Character Set CtlCode = '%d' WHERE Name ='%s' dedecms.com
copyright dedecms
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
内容来自dedecms
mail_addr tel__numb phon_numb sno__numb memb_name memb__pwd 织梦好,好织梦
copyright dedecms
memb___id mang_guid
本文来自织梦
dedecms.com
SELECT * from MEMB_INFO where memb___id='%s' %d 织梦内容管理系统
dedecms.com
UPDATE MEMB_DETA SET desc_text='%s' where memb_guid=%d copyright dedecms
织梦内容管理系统
INSERT INTO MEMB_DETA ( memb_guid, desc_text ) valueS (%d,'%s')
copyright dedecms
SELECT memb_guid from MEMB_DETA where memb_guid=%d
内容来自dedecms
UPDATE MEMB_INFO SET memb__pwd = '%s',memb_name = '%s',sno__numb ='%s', 织梦内容管理系统
dedecms.com
tel__numb = '%s',phon_numb = '%s',mail_addr = '%s',fpas_ques ='%s',
本文来自织梦
本文来自织梦
fpas_answ = '%s',bloc_code = '%s' WHERE memb___id = '%s' 本文来自织梦
dedecms.com
DisConnectTM ConnectTM IP ServerName ConnectStat dedecms.com
copyright dedecms
SELECT mail_addr, bloc_code, ctl1_code,(CASE WHEN ConnectStat IS NULL THEN 0 ELSE ConnectStat END) as
dedecms.com
内容来自dedecms
'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' copyright dedecms
SELECT bloc_code FROM MEMB_INFO where memb___id='%s' dedecms.com
copyright dedecms
SELECT bloc_code FROM MEMB_INFO where memb_guid=%d 本文来自织梦
内容来自dedecms
UPDATE MEMB_INFO SET bloc_code= '%s' where memb___id='%s'
内容来自dedecms
织梦内容管理系统
INSERT INTO MEMB_INFO (memb___id, memb__pwd, memb_name, sno__numb, tel__numb, phon_numb, mail_addr, dedecms.com
内容来自dedecms
fpas_ques, fpas_answ, bloc_code, ctl1_code) valueS ('%s', '%s', '%s', '%s','%s', '%s', '%s', '%s', '%s', 0, 0)
appl_days 内容来自dedecms
织梦内容管理系统
SELECT memb_guid, memb___id, memb_name, sno__numb, phon_numb, appl_days, bloc_code from MEMB_INFO
内容来自dedecms
where sno__numb='%s'
织梦好,好织梦
copyright dedecms
', '%s', '%s', %d, '%s', '','' ', ' copyright dedecms
copyright dedecms
exec SP_BLOCKING_APP %d, %d, '%s', '%s', ' copyright dedecms
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
copyright dedecms
织梦好,好织梦
from MEMB_INFO M INNER JOIN BLOCKING B ON M.memb_guid = B.memb_guid where M.memb___id = '%s'
dedecms.com
ORDER BY B.block_guid
织梦好,好织梦
rels_days char_name take_code serv_guid block_guid admin_name dist_code
copyright dedecms
本文来自织梦
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 copyright dedecms
本文来自织梦
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 = '
dedecms.com
内容来自dedecms
update BLOCKING set memb_cont =
copyright dedecms
'',%d,'%s','' 内容来自dedecms
exec USP_Block_CanCel %d,%d,'%s', ' dedecms.com
织梦好,好织梦
DSN Name(%s) : Login DB Connect Fail 织梦内容管理系统
copyright dedecms
SELECT mang_guid FROM MANG_INFO WHERE ctl1_code = 0 AND mang___id='%s'
copyright dedecms
copyright dedecms
auth_code skill_guid 织梦内容管理系统
copyright dedecms
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' 织梦内容管理系统
dedecms.com
mng_auth
copyright dedecms
INSERT INTO MUMNG_MANG_INFO (mang_guid, mng_auth) valueS (%d, %d)
dedecms.com
SELECT mng_auth FROM MUMNG_MANG_INFO WHERE mang_guid='%d'
copyright dedecms
dep_code part_name mang_name mang__pwd mang___id
dedecms.com
SELECT mang_guid, mang___id, mang__pwd, mang_name, mail_addr, part_name, dep_code, ctl1_code
本文来自织梦
FROM MANG_INFO WHERE ctl1_code = 0 AND mang___id='%s' 织梦好,好织梦
UPDATE MUMNG_AUTH_SKILL SET auth_code = %d WHERE skill_guid = %d AND mang_guid = %d
内容来自dedecms
exec MuMng_AddAccount '%s', '%s', '%s', '%s', '%s', %d, '%s', %d 织梦好,好织梦
织梦内容管理系统
INSERT INTO MUMNG_AUTH_SKILL(mang_guid,auth_code,skill_guid) valueS(%d, %d, %d) 本文来自织梦
dedecms.com
DELETE FROM MUMNG_AUTH_SKILL WHERE mang_guid = %d 本文来自织梦
copyright dedecms
DELETE FROM MUMNG_MANG_INFO WHERE mang_guid = %d
dedecms.com
UPDATE MANG_INFO SET mang__pwd = '%s',mang_name = '%s',mail_addr = '%s',part_name = '%s', dep_code = '%s'
dedecms.com
织梦内容管理系统
WHERE mang___id = '%s' AND ctl1_code = '%d' copyright dedecms
UPDATE MANG_INFO SET ctl1_code = 9 WHERE mang_guid = '%d' 织梦好,好织梦
内容来自dedecms
SELECT * FROM MANG_INFO WHERE mang___id ='%s' AND mang__pwd='%s' AND ctl1_code = 0
本文来自织梦
SELECT * FROM MANG_INFO WHERE mang___id='%s' AND ctl1_code = 0 dedecms.com
SELECT dep_code, dep_name FROM DEPART_TBL 本文来自织梦
本文来自织梦
dep_name name 织梦内容管理系统
本文来自织梦
SELECT skill_guid, name FROM MUMNG_SKILL_INFO 织梦好,好织梦
织梦好,好织梦
DSN Name(%s) : WareHouse DB Connect Fail 织梦内容管理系统
本文来自织梦
SELECT AccountID FROM warehouse WHERE AccountID='%s'
UPDATE warehouse SET Money=%d where AccountID='%s' 本文来自织梦
织梦好,好织梦
SELECT Items from warehouse where AccountID='%s' dedecms.com
本文来自织梦
get money error %s 本文来自织梦
SELECT Money from warehouse where AccountID='%s' 织梦好,好织梦
dedecms.com
UPDATE warehouse SET Items=? where AccountID='%s'
copyright dedecms
exec WZ_GetItemSerial DbVersion
dedecms.com
内容来自dedecms
SELECT CASE WHEN DbVersion IS NULL THEN 0 ELSE DbVersion END AS DbVersion FROM 本文来自织梦
copyright dedecms
warehouse where AccountID='%s'
dedecms.com
UPDATE warehouse SET DbVersion=1 where AccountID='%s' 织梦内容管理系统
织梦内容管理系统
pw copyright dedecms
内容来自dedecms
SELECT CASE WHEN pw IS NULL THEN -1 ELSE pw END AS pw FROM warehouse where AccountID='%s'
copyright dedecms
UPDATE warehouse SET pw = %d where AccountID='%s'
本文来自织梦
内容来自dedecms
DSN Name(%s) : Character DB Connect Fail copyright dedecms
dedecms.com
SELECT Name FROM Character WHERE Name='%s' copyright dedecms
本文来自织梦
DELETE FROM Character WHERE AccountID='%s' AND Name='%s'
织梦好,好织梦
UPDATE Character SET MagicList=? where Name='%s' 织梦内容管理系统
内容来自dedecms
UPDATE Character SET Inventory=? where Name='%s' dedecms.com
SELECT MagicList from Character where Name='%s' 织梦好,好织梦
织梦内容管理系统
SELECT Inventory from Character where Name='%s' 本文来自织梦
织梦内容管理系统
????? 本文来自织梦
PkTime PkLevel PkCount MapDir MapPosY MapPosX MapNumber MaxMana Mana MaxLife Life
织梦内容管理系统
copyright dedecms
Money Energy Vitality Dexterity Strength Experience LevelUpPoint 内容来自dedecms
copyright dedecms
AccountID SELECT AccountID, cLevel, Class, LevelUpPoint, Experience, Strength,
Dexterity, Vitality, Energy, Money, Life, MaxLife, Mana, MaxMana, MapNumber,
织梦好,好织梦
MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime FROM Character where Name='%s'
copyright dedecms
本文来自织梦
! 本文来自织梦
1.76精品传奇_1.76天下毁灭_1.76复古传奇_英雄合击_中变靓装传奇_无忧传奇
传奇花屏补丁,花屏补丁,土城花屏补丁,盟重土城花屏补丁下载,土城花屏补丁下载,沙巴克花屏补丁,传奇土城花屏补丁下载
网站每天发布最新、最好的传奇版本下载和与传奇服务端配套开区传奇模版,网游技术教程全部免费下载!
无忧网络是目前唯一家所有的传奇服务端,传奇私服花屏补丁,盟重花屏补丁和传奇客户端下载都经过站长亲自测试并配有真实测试图!
所有的工具软件和传奇版本在发布之前,都会经过站长亲自测试,保证chuanqisf可以进入游戏,所有软件都无毒无插件!
本站声明:本站所有技术资料与下载资源均为网络搜集整理,并不代表本站的观点与立场,如有侵犯您的权益,请来信指出,本站将立即改正Copyright © 2002-2014 无忧网络 版权所有蜀ICP备09041899号