SilkRoad Service Database Editor , Sys

SilkRoad Service Database Editor , Sys

SilkRoad Service Database Editor, Systems, cap, degree, Filter, autoevent, Gameserver, VPS Dedicated, setup, 2 server one machine



Vsro GM Security

Share
avatar
Trixy
Admin
Admin

Posts : 22
Join date : 2018-06-19
Age : 31
Location : USA

Vsro GM Security

Post by Trixy on Fri Jun 29, 2018 6:53 am

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


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









_________________

    Current date/time is Mon Nov 19, 2018 7:01 pm