[Arcturus] - Dev Store Proc's for Admins

[Twilight]

These two procedures (seven_ORA)for detection hidden GMs in a database and their blockings.

GM256,GM512,GM768 - These are correct GMs accounts. Can rename on the or add in inquiry still AND (NOT (Account = 'myGM'))

CREATE PROCEDURE [dbo].[SP_GMGUARD] @Check int AS
If   (@Check = 1)
begin
declare cur_event cursor for
SELECT     Account
FROM         UserInfo
WHERE ([Right] > 1) AND (NOT (Account = 'GM256')) AND (NOT (Account = 'GM256')) AND (NOT (Account = 'GM512')) AND (NOT (Account = 'GM768'))
declare @Account nvarchar(50)
declare @i int
open cur_event
Fetch next from cur_event into @Account
set @i = 0 
while(@@fetch_status = 0  )
BEGIN
-- RUN TERMINATOR PROC
exec SP_GMHACKERTERMINATOR @Account
--print @Account
fetch next from cur_event into @Account	
Set @i = @i + 1
END
close cur_Event
deallocate cur_Event

end

else
begin 
print 'skip Check GM'
End
GO

and

CREATE PROCEDURE [dbo].[SP_GMHACKERTERMINATOR] @Hacker nvarchar(50) AS
DECLARE @TodayTime datetime
--print @TodayTime
update UserInfo set [Right] = '0', BlockReason='Hacker Stop!',BlockGM = 'Terminator' where Account = @Hacker
print CONVERT(VARCHAR, @TodayTime, 109) + ' Account - '+@Hacker+' - BLOCKED!'
GO

Command for execute : exec SP_GMGUARD 1

It is possible to use it as the task in Job tools SQL a server or any other language using timers.
Procedure - as an example. But it is possible to create other, analyzing logs on the basis of this procedure
Success.
Twilight for RZ.

[MentaL]

[Necro]

Thank you Twilight = ) will try this one maybe later on tonight.

[Regain]

nice guide.. ;]
twilight can i ask what server do you work for or own?

[Necro]

nice guide.. ;]
twilight can i ask what server do you work for or own?

haha had me thinking the same thing.

[Regain]

its because i haven't seen him around on any server as a dev and he seems to know quite a bit about arcutus.

[Necro]

its because i haven't seen him around on any server as a dev and he seems to know quite a bit about arcutus.

Yeah true that is what i was wondering or could just be he is a dev but under other name on a server hehe

[CioNide]

Looks interesting.

Can someone tell me what Arcturus is?

[Twilight]

its because i haven't seen him around on any server as a dev and he seems to know quite a bit about arcutus.

Yeah true that is what i was wondering or could just be he is a dev but under other name on a server hehe

My Name is constant on Dev forums.
In current of 5 years there was a necessity to understand and complete many games (La2C1 (Meifu) and (...), RFO.. And it is a lot of much others)...
The information should be free, therefore with you I share experience or that that has found out.

[Necro]

Thanks for the reply Twilight and for sharing information with us here :)

[Regain]

From Russia With Love!

anyways thanks for your contribution.
i personally wouldn't share these info. ;]

[m0onstar88]

good to know it :)

thanks for sharing it...