USE [master]
GO
/****** Object:  Database [SROPROT_ANTICHEAT]    Script Date: 11/13/2015 17:17:45 ******/
CREATE DATABASE [SROPROT_ANTICHEAT] ON  PRIMARY
( NAME = N'SROPROT_ANTICHEAT', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SROPROT_ANTICHEAT.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON
( NAME = N'SROPROT_ANTICHEAT_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\SROPROT_ANTICHEAT_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
BEGIN
EXEC [SROPROT_ANTICHEAT].[dbo].[sp_fulltext_database] @action = 'enable'
END
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET ANSI_NULLS OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET ANSI_PADDING OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET ARITHABORT OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET  DISABLE_BROKER
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET  READ_WRITE
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET RECOVERY FULL
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET  MULTI_USER
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [SROPROT_ANTICHEAT] SET DB_CHAINING OFF
GO
USE [SROPROT_ANTICHEAT]
GO
/****** Object:  Table [dbo].[_AnticheatGmAccessObjID]    Script Date: 11/13/2015 17:17:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_AnticheatGmAccessObjID](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [username] [VARCHAR](128) NOT NULL,
    [obj_id] [INT] NOT NULL,
    [amount] [INT] NOT NULL,
    [service] [INT] NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[_AnticheatGmAccessControl]    Script Date: 11/13/2015 17:17:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_AnticheatGmAccessControl](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [username] [VARCHAR](MAX) NULL,
    [cmd_id] [INT] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[_AnticheatLoginLog]    Script Date: 11/13/2015 17:17:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_AnticheatLoginLog](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [StrUserID] [VARCHAR](128) NOT NULL,
    [IP] [VARCHAR](128) NOT NULL,
    [HWID] [VARCHAR](128) NULL,
    [DATE] [DATE] NOT NULL,
 CONSTRAINT [PK_sroprot_login_log] PRIMARY KEY CLUSTERED
(
    [ID] 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
/****** Object:  Table [dbo].[_AnticheatIPLockDown]    Script Date: 11/13/2015 17:17:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_AnticheatIPLockDown](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [username] [VARCHAR](128) NOT NULL,
    [IP] [VARCHAR](128) NOT NULL,
 CONSTRAINT [PK__AnticheatIPLockDown] PRIMARY KEY CLUSTERED
(
    [ID] 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
/****** Object:  Table [dbo].[_BanChat]    Script Date: 11/13/2015 17:17:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_BanChat](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [ChatID] [INT] NOT NULL,
    [CharName] [VARCHAR](128) NOT NULL,
    [BanCharName] [VARCHAR](128) NOT NULL,
    [ban_end] [datetime] NOT NULL,
 CONSTRAINT [PK__BanChat] PRIMARY KEY CLUSTERED
(
    [ID] 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
/****** Object:  StoredProcedure [dbo].[_AnticheatArenaStatusNotify]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatArenaStatusNotify]
    @charname     VARCHAR(64),
    @STATUS INT

AS
DECLARE @camp_id INT = 0;
DECLARE @honor_point INT;
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatBicycle]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatBicycle]
AS
SELECT 'OK';
GO
/****** Object:  Table [dbo].[_AntiCheatCharacterLoginLog]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_AntiCheatCharacterLoginLog](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [charname] [nvarchar](60) NULL,
    [hwid] [VARCHAR](50) NULL,
    [ip] [VARCHAR](50) NOT NULL,
    [DATE] [datetime] NOT NULL,
 CONSTRAINT [PK_AntiCheatCharacterLoginLog] PRIMARY KEY CLUSTERED
(
    [ID] 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
/****** Object:  Table [dbo].[_AnticheatUniqueDeath]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_AnticheatUniqueDeath](
    [ID] [INT] IDENTITY(1,1) NOT NULL,
    [name] [VARCHAR](128) NULL,
    [mob_id] [INT] NULL,
    [DATE] [datetime] NOT NULL,
 CONSTRAINT [PK__AnticheatUniqueDath] PRIMARY KEY CLUSTERED
(
    [ID] 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
/****** Object:  StoredProcedure [dbo].[_AnticheatPremiumUser]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_AnticheatPremiumUser]
    @username   VARCHAR(128)
    AS
DECLARE @RESULT INT = 0;
DECLARE @JID INT

IF EXISTS (SELECT  * FROM SRO_VT_ACCOUNT.dbo.TB_User WHERE StrUserID = @username)
BEGIN
SELECT  @JID = JID FROM SRO_VT_ACCOUNT.dbo.TB_User WHERE StrUserID = @username
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._TimedJob WHERE JobID = 47189 AND CharID IN (SELECT CharID FROM SRO_VT_SHARD.dbo._User WHERE UserJID = @JID))
BEGIN
SET @RESULT =1;
END
END
SELECT @RESULT
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatCharacterAuthLog]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_AnticheatCharacterAuthLog]
    @charname   VARCHAR(128),
    @IP VARCHAR(128)
AS
    INSERT INTO _AntiCheatCharacterLoginLog VALUES (@charname, @IP,0, GETDATE())

    SELECT 1;
    RETURN;
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatBanGuildChat]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_AnticheatBanGuildChat]
    @master_user    VARCHAR(128),
    @ban_user   VARCHAR(128),
    @banMinutes INT
AS
DECLARE @mCharID INT =  NULL
DECLARE @bCharID INT =  NULL
DECLARE @mGuildID INT =  0
DECLARE @bGuildID INT =  0
DECLARE @RESULT INT = 0;

SELECT @mCharID = CharID FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @master_user AND Deleted = 0 AND GuildID > 0
SELECT @bCharID = CharID FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @ban_user AND Deleted = 0 AND GuildID > 0

IF(@mCharID IS NOT NULL AND @bCharID IS NOT NULL)
BEGIN
IF(@mGuildID = @bGuildID)
BEGIN
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._GuildMember WHERE MemberClass = 0 AND CharID = @mCharID)
BEGIN
IF EXISTS (SELECT * FROM _BanChat WHERE ChatID = 5 AND CharName = @ban_user)
BEGIN
UPDATE _BanChat SET ban_end = DATEADD(MINUTE,@banMinutes,GETDATE()),BanCharName = @master_user WHERE ChatID = 5 AND CharName = @ban_user
SET @RESULT = 1;
END
ELSE
BEGIN
INSERT INTO _BanChat([ChatID],[CharName],[BanCharName],[ban_end])VALUES(5,@ban_user,@master_user,DATEADD(MINUTE,@banMinutes,GETDATE()))
SET @RESULT = 1;
END

END
END
END
SELECT @RESULT;
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatAuthLog]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_AnticheatAuthLog]
    @username   VARCHAR(128),
    @IP VARCHAR(128)
AS
    INSERT INTO _AnticheatLoginLog VALUES (@username, @IP,0, GETDATE())

    SELECT 1;
    RETURN;
GO
/****** Object:  StoredProcedure [dbo].[__IPLockDown]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[__IPLockDown]
@username VARCHAR (128),
@ip VARCHAR(128)
AS
DECLARE @JID INT
DECLARE @RETURN INT = 1
IF(EXISTS(SELECT * FROM _AnticheatIPLockDown WHERE username = @username))
BEGIN
IF(NOT EXISTS(SELECT * FROM _AnticheatIPLockDown WHERE username = @username AND IP = @ip))
BEGIN
SET @RETURN = 0;
END
END

SELECT @RETURN;
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatUpdateUserStatus]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatUpdateUserStatus]
@username   VARCHAR(36),
@hwid   VARCHAR(36),
@ip VARCHAR(50),
@online SMALLINT
AS
IF EXISTS (SELECT * FROM _AnticheatOnlineUser WHERE username = @username)
BEGIN
UPDATE _AnticheatOnlineUser SET online = @online WHERE username = @username
IF(@hwid IS NOT NULL)
BEGIN
UPDATE _AnticheatOnlineUser SET hwid = @hwid WHERE username = @username
END
IF(@ip IS NOT NULL)
BEGIN
UPDATE _AnticheatOnlineUser SET ip = @ip WHERE username = @username
END
END
ELSE
BEGIN
INSERT INTO _AnticheatOnlineUser ([username],[hwid],[ip],[online]) VALUES (@username,@hwid,@ip,@online)
END
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatUniqueDeathNotify]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_AnticheatUniqueDeathNotify]
    @name   VARCHAR(128),
    @id INT
AS
    INSERT INTO _AnticheatUniqueDeath([name],[mob_id],[DATE]) VALUES(@name,@id,GETDATE());
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatGuild]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_AnticheatGuild]
    @name   VARCHAR(128),
    @TYPE INT,
    @MAX INT

AS
    DECLARE @RESULT INT = 0
    DECLARE @GuildID INT
    DECLARE @UnionID INT
    DECLARE @Uion_1 INT
    DECLARE @Uion_2 INT
    DECLARE @Uion_3 INT
    DECLARE @Uion_4 INT
    DECLARE @Uion_5 INT
    DECLARE @Uion_6 INT
    DECLARE @Uion_7 INT
    DECLARE @Uion_8 INT
    DECLARE @COUNT INT = 0
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @name AND GuildID > 0)
    BEGIN
    SELECT @GuildID = GuildID FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @name
    IF(@TYPE = 1)
    BEGIN
    IF((SELECT COUNT(*) FROM SRO_VT_SHARD.dbo._GuildMember WHERE GuildID = @GuildID) < @MAX)
    BEGIN
    SET @RESULT =1;
    END
    END
    IF(@TYPE = 2)
    BEGIN
    IF EXISTS(SELECT * FROM SRO_VT_SHARD.dbo._Guild WHERE ID = @GuildID AND Alliance > 0)
    BEGIN
    SELECT @UnionID = Alliance FROM SRO_VT_SHARD.dbo._Guild WHERE ID = @GuildID
    SELECT @Uion_1 = Ally1,@Uion_2 = Ally2,@Uion_3 = Ally3,@Uion_4 = Ally4,@Uion_5 = Ally5,@Uion_6 = Ally6,@Uion_7 = Ally7,@Uion_8 = Ally8 FROM SRO_VT_SHARD.dbo._AlliedClans WHERE ID = @UnionID

    IF(@Uion_1 = 0)
    BEGIN
    SET @COUNT = @COUNT + 1
    END

    IF(@Uion_2 = 0)
    BEGIN
    SET @COUNT = @COUNT + 1
    END

    IF(@Uion_3 = 0)
    BEGIN
    SET @COUNT = @COUNT + 1
    END

    IF(@Uion_4 = 0)
    BEGIN
    SET @COUNT = @COUNT + 1
    END

    IF(@Uion_5 = 0)
    BEGIN
    SET @COUNT = @COUNT + 1
    END

    IF(@Uion_6 = 0)
    BEGIN
    SET @COUNT = @COUNT + 1
    END

    IF(@Uion_7 = 0)
    BEGIN
    SET @COUNT = @COUNT + 1
    END

    IF(@Uion_8 = 0)
    BEGIN
    SET @COUNT = @COUNT + 1
    END

    IF((8 - @COUNT) < @MAX)
    BEGIN
    SET @RESULT = 1;
    END
    END
    ELSE
    BEGIN
    SET @RESULT = 1
    END
    END
    END
    SELECT @RESULT;
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatGetJobSuit]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatGetJobSuit]
@name   VARCHAR(128)
AS
DECLARE @RESULT INT = 0
DECLARE @CHARID INT
DECLARE @ITEM_ID INT
DECLARE @TYPE1 INT
DECLARE @TYPE2 INT
DECLARE @TYPE3 INT
DECLARE @TYPE4 INT

IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @name)
BEGIN
SELECT @CHARID = CharID FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @name

IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._Inventory WHERE CharID = @CHARID AND Slot = 8 AND ItemID > 0)
BEGIN
 SELECT @ITEM_ID = RefItemID FROM SRO_VT_SHARD.dbo._Items WHERE ID64 IN (SELECT ItemID FROM SRO_VT_SHARD.dbo._Inventory WHERE CharID = @CHARID AND Slot = 8)
 IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._RefObjCommon WHERE ID = @ITEM_ID AND Service = 1)
 BEGIN
 SELECT @TYPE1 = TypeID1,@TYPE2 = TypeID2,@TYPE3 = TypeID3,@TYPE4 = TypeID4 FROM SRO_VT_SHARD.dbo._RefObjCommon WHERE ID = @ITEM_ID AND Service = 1
 IF(@TYPE1 = 3 AND @TYPE2 = 1 AND @TYPE3 = 7)
 BEGIN
 --хант
 IF(@TYPE4 = 3)
 BEGIN
 SET @RESULT = 1;
 END
 --трейд
  IF(@TYPE4 = 1)
 BEGIN
 SET @RESULT = 2;
 IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharCOS WHERE OwnerCharID = @CHARID)
 BEGIN
 SET @RESULT = 20;
 END
 END
  --тиф
  IF(@TYPE4 = 2)
 BEGIN
 SET @RESULT = 3;
 END

 END
 END
END
END
SELECT @RESULT
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatGetIpCount]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatGetIpCount]
@ip VARCHAR(60)
AS
SELECT COUNT(hwid) FROM _AnticheatOnlineUser WHERE  ip = @ip AND online = 1
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatGetHwIdCount]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatGetHwIdCount]
@hwid VARCHAR(60)
AS
DECLARE @RESULT INT = 0


SELECT COUNT(hwid) FROM _AnticheatOnlineUser WHERE  hwid = @hwid AND online = 1
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatGetCharData]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_AnticheatGetCharData]
    @name   VARCHAR(128)
AS
    DECLARE @level INT = 0;
    DECLARE @GuildChatBan VARCHAR(MAX) = '0';

    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @name)
    BEGIN
       SELECT @level = CurLevel FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @name
    END

    IF EXISTS (SELECT * FROM _BanChat WHERE ChatID = 5 AND CharName = @name)
    BEGIN
    SELECT @GuildChatBan = ban_end FROM _BanChat WHERE ChatID = 5 AND CharName = @name
    END



    SELECT @level,@GuildChatBan
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatChekItemOpt]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[_AnticheatChekItemOpt]
    @name   VARCHAR(128),
    @slot INT,
    @MAX INT

AS
    DECLARE @RESULT INT = 0;
    IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._Items WHERE OptLevel < @MAX AND ID64 IN (SELECT ItemID FROM SRO_VT_SHARD.dbo._Inventory WHERE Slot = @slot AND CharID IN (SELECT CharID FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @name)))
    BEGIN
    SET @RESULT = 1;
    END
    SELECT @RESULT;
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatCheckTeleportAccess]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatCheckTeleportAccess]
    @charname    VARCHAR(16),
    @teleport INT

AS
DECLARE @RETURN INT = 0

IF(@teleport = 166)
BEGIN
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharQuest WHERE QuestID = 544 AND STATUS = 4 AND CharID IN (SELECT CharID FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @charname))
BEGIN
SET @RETURN = 1;
END
END

IF(@teleport = 167)
BEGIN
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharQuest WHERE QuestID = 650 AND STATUS = 4 AND CharID IN (SELECT CharID FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @charname))
BEGIN
SET @RETURN = 1;
END
END
SELECT @RETURN;
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatCheckItemUseAccess]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatCheckItemUseAccess]
@name   VARCHAR(128),
@slot INT
AS
DECLARE @RESULT INT = 1
DECLARE @CHARID INT
DECLARE @ITEM INT
DECLARE @REGION INT

IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @name)
BEGIN
SELECT @CHARID = CharID,@REGION =  LatestRegion FROM SRO_VT_SHARD.dbo._Char WHERE CharName16 = @name

IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._Inventory WHERE CharID = @CHARID AND Slot = @slot AND ItemID > 0)
BEGIN
 SELECT @ITEM = RefItemID FROM SRO_VT_SHARD.dbo._Items WHERE ID64 IN (SELECT ItemID FROM SRO_VT_SHARD.dbo._Inventory WHERE CharID = @CHARID AND Slot = @slot)
 IF(@ITEM IN (2128))
 BEGIN
 IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._RefRegion WHERE wRegionID = @REGION AND IsBattleField = 0)
 BEGIN
 SET @RESULT = 0;
 END
 END
END
END
SELECT @RESULT
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatCheckGmAccessObjID]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatCheckGmAccessObjID]
    @username     VARCHAR(128),
    @objID INT,
    @Amount INT

AS
DECLARE @RETURN INT = 0

IF(EXISTS(SELECT * FROM _AnticheatGmAccessObjID WHERE username = @username AND obj_id = @objID AND amount >= @Amount))
BEGIN
SET @RETURN = 1;
END

IF(EXISTS(SELECT * FROM _AnticheatGmAccessObjID WHERE username = @username AND obj_id = 0 AND amount = 0 AND service = 1))
BEGIN
SET @RETURN = 1;
END

SELECT @RETURN;
GO
/****** Object:  StoredProcedure [dbo].[_AnticheatCheckGmAccessControl]    Script Date: 11/13/2015 17:17:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[_AnticheatCheckGmAccessControl]
    @username     VARCHAR(128),
    @cmd INT

AS
DECLARE @RETURN INT = 0

IF(EXISTS(SELECT * FROM _AnticheatGmAccessControl WHERE username = @username AND cmd_id = @cmd))
BEGIN
SET @RETURN = 1;
END

IF(EXISTS(SELECT * FROM _AnticheatGmAccessControl WHERE username = @username AND cmd_id = 0))
BEGIN
SET @RETURN = 1;
END

SELECT @RETURN;
GO