卡号踢人的方法：
1.点开任务栏启动项目的第4个标题为[Authe..]
2.点击菜单栏[Control]->[User]
3.在[All List Refresh]下面的空格处填上玩家的帐号，点下面的[Search];
4.如果真正卡号了 在[Account] [Description]下面会出现那个帐号；
5.单击那个帐号 点右边[Compulsory User Disconnect(*Caution*)]就踢了；
6.可以再次点[Search] 查不到就说明踢了！
霹雳后台密码找回SQL语句
霹雳后台密码遗忘找回方式
霹雳将真诚的为大家服务为大家提供更好的游戏服务端管理平台。
霹雳软件产品：
1.霹雳奇迹WEB管理平台。
2.如果密码忘了请在查询分析器里运行以下语句帐号即为admin 密码:admin：
use muonline
go
delete from web_admin
insert into web_admin(acc,pass,qx) values('admin','21232f297a57a5a743894a0e4a801fc3','▼ABCE◥
D」∫⊥⊥『∈』F≯G▲◆△←∝〃※ˇ∵∑◢IJK→∠↑①◤P∏○□●Q「‖￠R②S≡≈≌◣YZ¨「⒈⒉1')
MUONLINE数据库日志收缩语句 短而精悍
BACKUP LOG MuOnline WITH NO_LOG
DBCC SHRINKDATABASE(MuOnline,10)
1.新人注册送500点
CREATE TRIGGER 新人送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=500
FROM Inserted
WHERE Character.name=Inserted.name
SET NOCOUNT OFF
修改上面那个500就是送的点数
运行查询分析器把这段代码对准muonline数据库查询
看到查询成功就可以关闭
如果需要更改送的点数:到muonline-用户表-dbo.Character-触发器-dbo.新人送点(按右键编辑)
修改500的数字为你要的点数 再查询一次就行了
2.圣导送９９９９统率：
CREATE TRIGGER [Leadership] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Leadership=9999
From Inserted
Where Inserted.Class=64 and [Character].accountid=inserted.accountid
and [Character].name=inserted.name
修改下面那个9999就是送的点数
运行查询分析器复制这段代码对准muonline数据库查询
看到查询成功就可以关闭
如果需要更改送的点数:到muonline-用户表-dbo.Character-触发器-dbo.Leadership(按右键编辑)
修改9999的数字为你要的点数 再查询一次就行了
新人上线400级
CREATE TRIGGER [Restrict_IntLUP] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].cLevel=400 From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name
多区数据库解决帐号重复SQL语句
update memb_info set servercode = 1 where servercode =2
玩家角色达到条件以后自动专职SQL语句
CREATE TRIGGER 战士自动一转 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=17
FROM Inserted
Where Inserted.cLevel=150 and Inserted.Class=16
SET NOCOUNT OFF
CREATE TRIGGER 法师自动一转 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=1
FROM Inserted
Where Inserted.cLevel=150 and Inserted.Class=0
SET NOCOUNT OFF
CREATE TRIGGER 妹妹自动一转 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=33
FROM Inserted
Where Inserted.cLevel=150 and Inserted.Class=32
SET NOCOUNT OFF
CREATE TRIGGER 战士自动三转 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=18
FROM Inserted
Where Inserted.cLevel=380 and Inserted.Class=17
SET NOCOUNT OFF
CREATE TRIGGER 法师自动三转 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=2
FROM Inserted
Where Inserted.cLevel=380 and Inserted.Class=1
SET NOCOUNT OFF
CREATE TRIGGER 妹妹自动三转 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=34
FROM Inserted
Where Inserted.cLevel=380 and Inserted.Class=33
SET NOCOUNT OFF
CREATE TRIGGER 魔剑自动三转 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=50
FROM Inserted
Where Inserted.cLevel=380 and Inserted.Class=48
SET NOCOUNT OFF
CREATE TRIGGER 圣导自动三转 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.Class=64
FROM Inserted
Where Inserted.cLevel=150 and Inserted.Class=66
SET NOCOUNT OFF
--进入MuOnline数据库，选择存储过程，找到WZ_CONNECT_MEMB右键属性，然后拖到最后面找到end上面加上下面语句即可
--自动更新所有圣导师的统率为9999
Update [Character] set [Character].Leadership=9999 Where [Character].Class=64
end
GO
取消新人注册送点
CREATE TRIGGER [Restrict_IntLUP] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].LevelUpPoint=0 From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name
新手送3333点(具体送多少修改LevelUpPoint=3333 From Inserted )
CREATE TRIGGER [Restrict_IntLUP] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].LevelUpPoint=3333 From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name
圣导送统率
CREATE TRIGGER [Leadership] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Leadership=99
From Inserted
Where Inserted.Class=64 and [Character].accountid=inserted.accountid
and [Character].name=inserted.name
33人战盟带旗(具体送多少修改having count(*)>32))),比如35就修改having count(*)>34)
use muonline
update extchrdata set stat=3 where name in (select G_master from guild where G_name in (select G_name from guildmember where G_name in
(select g_name from guildmember group by g_name having count(*)>32)))
更改角色名
use muonline
declare @oldname nvarchar(10),@newname nvarchar(10)
--在单引号里面输入要查询的角色名，前是老名字，后是新名字。
set @oldname = '老名字'
set @newname = '新名字'
if @newname in (select name from character where name=@newname)
print '数据库里已有相同角色名，不进行更名操作！'
else
begin
update accountcharacter set gameid1 = @newname where gameid1 = @oldname
update accountcharacter set gameid2 = @newname where gameid2 = @oldname
update accountcharacter set gameid3 = @newname where gameid3 = @oldname
update accountcharacter set gameid4 = @newname where gameid4 = @oldname
update accountcharacter set gameid5 = @newname where gameid5 = @oldname
update accountcharacter set gameidc = @newname where gameidc = @oldname
update character set name = @newname where name = @oldname
update guild set g_master = @newname where g_master = @oldname
update guildmember set name = @newname where name = @oldname
update optiondata set name = @newname where name = @oldname
end
清空有全属装备的仓库
update warehouse set Items=null where (charindex(0xbf,items)%10=8) or (charindex(0xff,items)%10=8)
or (charindex(0x7f,items)%10=8) or (charindex(0x3f,items)%10=8)
罗兰攻城
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GCGuild]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GCGuild]
GO
CREATE TABLE [dbo].[GCGuild] (
[IDX] [int] NOT NULL ,
[GuildName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GuildIdx] [int] NOT NULL ,
[GuildMZName] [varchar] (10) NOT NULL
) ON [PRIMARY]
GO
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (100,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (101,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (102,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (103,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (104,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (200,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (201,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (202,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (203,' ',0,' ')
insert into gcguild (IDX,GuildName,GuildIdx,GuildMZName) VALUES (204,' ',0,' ')
GO
删除空仓库
delete from warehouse
where (items is null) and (money = '500000')
--删除空仓库('500000'是注册送的钱,我送了50万)
解封
use muonline
UPDATE [MuOnline].[dbo].[Character]
SET [CtlCode]='0'
WHERE Name='名字'
新人送２转
CREATE TRIGGER [zscount] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].zs_count=2
From Inserted
Where Inserted.zs_count=0 and [Character].accountid=inserted.accountid
and [Character].name=inserted.name
减少奇迹私服SQL日志的方法
backup log MuOnline with NO_LOG
backup log MuOnline with TRUNCATE_ONLY
DBCC SHRINKDATABASE(MuOnline)
--将上面的语句多次执行，直到日志文件缩小。
删除申请帐号后从未上过线
delete from memb_info where memb___id in (select memb___id from memb_stat)
删除没有100级人物的帐号
delete from memb_info where memb___id not in (select DISTINCT accountid from character where clevel>=100)
delete from warehouse where accountid not in (select DISTINCT accountid from character where clevel>=100)
delete from character where accountid not in (select memb___id from memb_info)
注册帐号送戒指
CREATE TRIGGER [1] ON [dbo].[Character]
after Insert
as
Update [Character] set [Character].Inventory=0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB408FFFFFFFEED8000FBB410FFFFFFFEEC80007C
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF
FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name
淡淡网络内部防复制SQL代码(支持最新996X)
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE TRIGGER [dbo].[clear_copyitems] ON [dbo].[warehouse]
FOR UPDATE
AS
BEGIN
IF UPDATE(items)
BEGIN
DECLARE @al_acid varchar(10)
DECLARE @al_name varchar(10)
DECLARE @whItems AS binary(1200)
DECLARE @bdItems AS binary(760)
DECLARE @bItem AS binary(1)
DECLARE @wItem AS binary(1)
DECLARE @bItemId AS binary(4)
DECLARE @WItemId AS binary(4)
DECLARE @i AS int
DECLARE @ii AS int
DECLARE @find AS int
SET @find=0
SELECT @al_acid=inserted.accountid,@whItems=inserted.items FROM inserted
SELECT @al_name=GameIDC FROM AccountCharacter WHERE id=@al_acid
SELECT @bdItems=inventory FROM character WHERE accountid=@al_acid AND name=@al_name
SET @i=0
WHILE @i<120
BEGIN
SET @wItem=SUBSTRING(@whItems,@i*10+1,1)
SET @wItemId=SUBSTRING(@whItems,@i*10+4,4)
IF @wItem<>0xFF AND @wItemId<>0x00000000 AND @wItem IS NOT NULL AND @wItemId IS NOT NULL
BEGIN
SET @ii=0
WHILE @ii<76
BEGIN
SET @bItem=SUBSTRING(@bdItems,@ii*10+1,1)
SET @bItemId=SUBSTRING(@bdItems,@ii*10+4,4)
IF @bItem<>0xFF AND @bItemId<>0x00000000
BEGIN
IF @bItem=@wItem AND @bItemId=@wItemId
BEGIN
SET @whitems=SUBSTRING(@whitems,1,@i*10)+0xFFFFFFFFFFFFFFFFFFFF+SUBSTRING(@whitems,(1+@i)*10+1,(76-1-@i)*10)
SET @find=1
SET @ii=76
END
SET @ii=@ii+1
END
END
SET @i=@i+1
END
END
IF @find=1
BEGIN
UPDATE warehouse SET items=@whitems WHERE accountid=@al_acid
END
END
END
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
sql 清除库
如果你运行建议备份后否自后果自负
use MuOnline
DELETE FROM [dbo].[Character]
DELETE FROM [dbo].[vCharacterPreview]
DELETE FROM [dbo].[AccountCharacter]
DELETE FROM [dbo].[Admit_Info]
DELETE FROM [dbo].[Guild]
DELETE FROM [dbo].[GuildMember]
DELETE FROM [dbo].[MANG_INFO]
DELETE FROM [dbo].[MEMB_DETA]
DELETE FROM [dbo].[MEMB_INFO]
DELETE FROM [dbo].[MUMNG_AUTH_SKILL]
DELETE FROM [dbo].[MUMNG_MANG_INFO]
DELETE FROM [dbo].[MUMNG_SKILL_INFO]
DELETE FROM [dbo].[OptionData]
DELETE FROM [dbo].[UseLog]
DELETE FROM [dbo].[VI_CURR_INFO]
DELETE FROM [dbo].[warehouse]
最好的奇迹私服发布站 www.haomusf.Com