SilkRoad Service Database Editor , Sys

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

    Trixy
    Trixy
    Admin
    Admin

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

    Vsro GM Security Empty Vsro GM Security

    Post by Trixy 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 Thu Mar 28, 2024 12:58 pm