Welcome to Game Network Online
That system not release by Game Network Online
But release AntiCheat with auto ban system one day
if you try cheated
First Create that table
[size=22]Then Put that in AddLogChar ,, SRO_VT_LOG[/size]
That system not release by Game Network Online
But release AntiCheat with auto ban system one day
if you try cheated
First Create that table
- Code:
USE [SRO_VT_LOG]
GO
/****** Object: Table [dbo].[_GM_Account] Script Date: 3/1/2018 7:15:27 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_GM_Account](
[Service] [int] NOT NULL,
[JID] [int] NOT NULL,
[StrUserID] [varchar](25) NOT NULL,
[CharID] [int] NOT NULL,
[CharName16] [varchar](25) NOT NULL,
[sec_primary] [tinyint] NOT NULL CONSTRAINT [DF__GM_Account_sec_primary] DEFAULT ((3)),
[sec_content] [tinyint] NOT NULL CONSTRAINT [DF__GM_Account_sec_content] DEFAULT ((3)),
CONSTRAINT [PK__GM_Account] PRIMARY KEY CLUSTERED
(
[JID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
- Code:
USE [SRO_VT_LOG]
GO
/****** Object: Table [dbo].[_GM_Account_Ban] Script Date: 3/1/2018 7:18:18 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_GM_Account_Ban](
[JID] [int] NOT NULL,
[CharID] [int] NOT NULL,
[StrUserID] [varchar](25) NOT NULL,
[sec_primary] [tinyint] NOT NULL CONSTRAINT [DF__GM_Account_Ban_sec_primary] DEFAULT ((3)),
[sec_content] [tinyint] NOT NULL CONSTRAINT [DF__GM_Account_Ban_sec_content] DEFAULT ((3)),
[timeBegin] [datetime] NOT NULL,
[timeEnd] [datetime] NOT NULL,
[Type] [tinyint] NOT NULL,
[SN] [int] IDENTITY(1,1) NOT NULL,
CONSTRAINT [PK__GM_Account_Ban_1] PRIMARY KEY CLUSTERED
(
[JID] ASC,
[Type] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
- Code:
USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[___GM_HACK_LOGIN] Script Date: 3/1/2018 7:18:50 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--################################################################## Created SafyStar ##################################################################
CREATE Procedure [dbo].[___GM_HACK_LOGIN]
@CharID INT
as
Declare @JID INT
Declare @StrUserID varchar(25)
Declare @SerialNO INT =(select MAX (SerialNO)SerialNo from SRO_VT_ACCOUNT.._BlockedUser)+1
Declare @SerialNO2 bigint =(select MAX (Serial64)Serial64 from SRO_VT_SHARD.._TimedJob)+1
Declare @timeBegin datetime
Declare @timeEnd datetime
Declare @Charname16 VarChar(50)
--################################################
DECLARE @AccountID varchar (25) = (SELECT AccountID FROM SRO_VT_SHARD.dbo._AccountJID As ID INNER JOIN SRO_VT_SHARD.dbo._User as JID ON Id.JID = JID.UserJID where CharID = @CharID)
Declare @sec_primary tinyint = (select sec_primary from [SRO_VT_ACCOUNT]..TB_User where JID in (select USERJID from [SRO_VT_SHARD].._User where CharID=@CharID )and sec_primary>3 )
Declare @sec_content tinyint = (select sec_content from [SRO_VT_ACCOUNT]..TB_User where JID in (select USERJID from [SRO_VT_SHARD].._User where CharID=@CharID )and sec_primary>3 )
Declare @sec_primary2 tinyint = (select sec_primary from [SRO_VT_LOG].._GM_Account where JID = @JID)
Declare @sec_content2 tinyint = (select sec_content from [SRO_VT_LOG].._GM_Account where JID = @JID)
Declare @StrUserID2 VarChar(25) = (select StrUserID from [SRO_VT_LOG].._GM_Account_Ban where CharID=@CharID)
SET @JID = (SELECT JID FROM [SRO_VT_ACCOUNT].dbo.TB_User As JID INNER JOIN [SRO_VT_SHARD].dbo._User as USERJID ON JID.JID = USERJID.UserJID where CharID = @CharID)
SET @strUserID = (SELECT StrUserID FROM [SRO_VT_ACCOUNT].dbo.TB_User As JID INNER JOIN [SRO_VT_SHARD].dbo._User as USERJID ON JID.JID = USERJID.UserJID where CharID = @CharID)
Set @CharID = (select CharID from SRO_VT_SHARD.._User where CharID = @CharID)
SET @timeBegin = (Select timeBegin from SRO_VT_ACCOUNT.._BlockedUser where UserJID in (select USERJID from [SRO_VT_SHARD].._User where CharID=@CharID ) )
SET @timeEnd = (Select timeEnd from SRO_VT_ACCOUNT.._BlockedUser where UserJID in (select USERJID from [SRO_VT_SHARD].._User where CharID=@CharID ) )
--################################################
If not Exists (Select * from SRO_VT_LOG.._GM_Account where JID =@JID and sec_primary IN (135,251) AND sec_content IN (135,251)and Service like 1 )
Begin
Insert Into SRO_VT_LOG.._GM_Account_Ban (JID,CharID,StrUserID,sec_primary,sec_content,timeBegin,timeEnd,Type)
Values (@JID,@CharID,@StrUserID,@sec_primary,@sec_content,GETDATE (),GetDate()+200000,1)
Insert INTO [SRO_VT_ACCOUNT].._BlockedUser (UserJID,UserID,Type,SerialNo,timeBegin,timeEnd)
Select JID,StrUserID,Type,@SerialNO,GetDate(),GetDate()+200000 from SRO_VT_LOG.._GM_Account_Ban WHERE JID =@JID
/*INSERT INTO [SRO_VT_SHARD].[dbo].[_TimedJob]
([CharID],[Category],[JobID],[TimeToKeep],[Data1],[Data2],[Data3],[Data4],[Data5],[Data6],[Data7],[Data8],[Serial64],[JID])
VALUES (@CharID,0,99999,2201232,0,0,0,0,0,0,0,0,@SerialNO2,0)
*/
end
If Exists (select * from SRO_VT_LOG.._GM_Account_Ban where sec_primary>4 and sec_content >4)
Begin
Update SRO_VT_LOG.._GM_Account_Ban set sec_primary=@sec_primary , sec_content=sec_content , timeBegin= GetDate() , timeEnd = GETDATE()+200000,Type=1 where CharID=@CharID
END
return -3
GO
[size=22]Then Put that in AddLogChar ,, SRO_VT_LOG[/size]
- Code:
if (@EventID IN (4,9,6) )
Begin
Exec [SRO_VT_LOG].[dbo].[___GM_HACK_LOGIN] @CharID
END