HE网站编辑器错误解决方案
发布日期：2024-04-29 浏览次数：次
在架设HE网站系统或是打开Muedit装备编辑器有提示错误的时候，那表示你的数据库与软件并不一致或是有表丢失，所以，你需要从新键入数据库，以解决该类型的错误提示，我们给大家准备了解决的SQL代码。
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装备编辑器重新打开，你就会发现，刚才的问题解决了，如果还是提示错误，那你可以检查一下哪里设置错误或是程序代码出现问题，通常该类问题与破解相关，请尊重原版和程序员的劳动成果。