新人送点
CREATE TRIGGER 新人送点 ON Character
AFTER INSERT
AS
SET NOCOUNT ON
UPDATE Character SET Character.LevelUpPoint=1234
FROM Inserted
WHERE Character.name=Inserted.name
SET NOCOUNT OFF
新人送转
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
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)))
罗兰攻城
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
删除申请帐号后从未上过线
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=0xFFB408FFFFFFFEED8000FBB410FFFFFFFEEC80007CFF From Inserted
Where [Character].accountid=inserted.accountid
and [Character].name=inserted.name
减少数据库占用率：
backup log MuOnline with NO_LOG
backup log MuOnline with TRUNCATE_ONLY
DBCC SHRINKDATABASE(MuOnline)
backup log Ranking with NO_LOG
backup log Ranking with TRUNCATE_ONLY
DBCC SHRINKDATABASE(Ranking)
--自动更新所有圣导师的统率为9999
Update [Character] set [Character].Leadership=9999 Where [Character].Class=64
圣导送９９９９统率：
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
最后更新于 2022-05-25 21:32:37 并被添加「mu」标签，已有 751 位童鞋阅读过。
本站使用「署名 4.0 国际」创作共享协议，可自由转载、引用，但需署名作者且注明文章出处