HE网站编辑器错误解决方案_MU-GM游戏官网-奇迹商业服务端丨奇迹商业服务端架设教程丨奇迹MU定制
1656351178
当前位置:主页 > 新闻资讯 > 技术动态 >

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装备编辑器重新打开,你就会发现,刚才的问题解决了,如果还是提示错误,那你可以检查一下哪里设置错误或是程序代码出现问题,通常该类问题与破解相关,请尊重原版和程序员的劳动成果。

在线咨询

点击这里给我发消息 1656351178

点击这里给我发消息 1656351178

在线咨询

手机通话

咨询时间:09:00-21:00

请输入您的联系电话,座机请加区号

手机通话

微信扫一扫

微信二维码

微信联系
返回顶部