奇迹MU

奇迹MU常见架设问题解决方法

       在架设HE网站系统或是打开Muedit装备编辑器有提示错误的时候,那表示你的数据库与软件并不一致或是有表丢失,所以,你需要从新键入数据库,以解决该类型的错误提示,我们给大家准备了解决的SQL代码。

奇迹MU架设常见问题解决方法
 
use MuOnline
go
if not exists (select 1 from syscolumns where name = 'ServerCode' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add ServerCode int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'myCash' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add myCash int DEFAULT (0)
GO
Update MEMB_INFO set myCash=0 where myCash is null
GO
if not exists (select 1 from syscolumns where name = 'zs' and id = object_id('Character'))
alter table Character
add zs int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'Contribution' and id = object_id('Character'))
alter table Character
add Contribution int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'jf' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add jf int DEFAULT (0)
go
 
if not exists (select 1 from syscolumns where name = 'member' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add member int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'LGONGZHISJ' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add LGONGZHISJ datetime DEFAULT ('')
go
if not exists (select 1 from syscolumns where name = 'StopTime' and id = object_id('MEMB_INFO'))
alter table MEMB_INFO
add StopTime datetime DEFAULT ('')
go
if not exists (select 1 from syscolumns where name = 'OnlineHours' and id = object_id('MEMB_STAT'))
alter table MEMB_STAT
add OnlineHours int DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'LeaderShip' and id = object_id('Character'))
alter table Character
add LeaderShip smallint DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'ChatLimitTime' and id = object_id('Character'))
alter table Character
add ChatLimitTime smallint DEFAULT (0)
go
if not exists (select 1 from syscolumns where name = 'FruitPoint' and id = object_id('Character'))
alter table Character
add FruitPoint int DEFAULT (0)
go
Update Character set Life=0 where Life is null
Update Character set MapDir=0 where MapDir is null
Update Character set MaxLife=0 where MaxLife is null
Update Character set Mana=0 where Mana is null
Update Character set MaxMana=0 where MaxMana is null
Update Character set MapNumber=0 where MapNumber is null
Update Character set MapPosX=0 where MapPosX is null
Update Character set MapPosY=0 where MapPosY is null
Update Character set MDate=getdate() where MDate is null
Update Character set LDate=getdate() where LDate is null
Update Character set Contribution=0 where Contribution is null
Update Character set Zs=0 where Zs is null
Update MEMB_INFO set jf=0 where jf is null
Update MEMB_INFO set member=0 where member is null
Update MEMB_INFO set myCash=0 where myCash is null
GO
 
       在SQL的查询分析器内,选择MuOnline这个表,并将以上SQL语句复制进入,点击执行查询,退出即可。执行完语句,请重新刷新一下网页,如果网页没有变化,还是提示错误,可以尝试清除浏览器Cookie即可,MuEdit装备编辑器重新打开,你就会发现,刚才的问题解决了,如果还是提示错误,那你可以检查一下哪里设置错误或是程序代码出现问题,通常该类问题与破解相关,请尊重原版和程序员的劳动成果。

http://www.mugms.com/xiazaipindao/cankaoziliao/105.html


赞 ( )

觉得文章有用就打赏一下文章作者

支付宝扫一扫打赏

微信扫一扫打赏