取消新人注册送点
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

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万)
[post
解封

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=0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFB408FFFFFFFEED8000FBB410FFFFFFFEEC80007CFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF 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]

本站声明:本站文章资源均来自网上转载或机器人自动搜索采集,如果本站文章资源有版权问题请联系管理员，我们尽快予以更正。所有文章只限用于个人测试学习使用,不得用于非法商业用途,请勿非法复制传播。特此声明！--[5uwl.net]

五年游戏制作经验; 金牌服务品质保障 游戏开区一条龙 第一品牌无忧网络[5uwl.net]