[Mini Release] Custom IP/HWID Limit By Query!

USE [YOUR DB]
GO

/****** Object:  Table [dbo].[CustomPcLimit]    Script Date: 30/09/2023 17:14:01 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[CustomPcLimit](
	[RegionID] [int] NOT NULL,
	[IPCount] [int] NOT NULL,
	[HWIDCount] [int] NULL
) ON [PRIMARY]
GO

USE [YOURDB]
GO
/****** Object:  StoredProcedure [dbo].[CustomPcLimitSystem]    Script Date: 30/09/2023 17:15:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[CustomPcLimitSystem]
@CharID int
AS
DECLARE @Region int = (Select LatestRegion From SRO_VT_SHARD.._Char Where CharID=@CharID)
Declare @RegionLimit int = (Select RegionID From YOURDB..CustomPcLimit Where @Region=RegionID)
Declare @RegionCount int = (Select Count(LatestRegion) From SRO_VT_SHARD.._Char Where LatestRegion=@Region)
Declare @LimitIP int = (Select [IPCount] From YOURDB..CustomPcLimit Where @Region=RegionID)
Declare @LimitHWID int = (Select [HWIDCount] From YOURDB..CustomPcLimit Where @Region=RegionID)
Declare @CharName varchar(max) = (Select CharName16 From SRO_VT_SHARD.._Char WHere CharID=@CharID)
DECLARE @IP varchar(max) = (Select [IP] From YOURDB.._Players Where @RegionCount=@LimitIP and CharID=@CharID)
DECLARE @Hwid varchar(max) = (Select [HWID] From YOURDB.._Players Where @RegionCount=@LimitHWID and CharID=@CharID)
Declare @CountIP int = (Select Count(ip)+1 From YOURDB.._Players Where IP=@IP)
Declare @CountHwid int =  (Select Count(HWID)+1 From YOURDB.._Players Where HWID=@Hwid)

--IP LIMIT
If (@Region=@RegionLimit and @CountIP+1=@LimitIP+1 or @CountIP+2=@LimitIP+2 or @CountIP+3=@LimitIP+3)
begin
insert Into _AutoNotice Values ('Sorry You Reached Max IP Limit!',@CharName,0,'00:00:00')
insert into YOURDB.._InstantTeleportDelivery values (@CharID,1,1,25000,982,140,140)
end

--PC LIMIT
If (@Region=@RegionLimit and @CountHwid+1=@LimitHWID+1 or @CountHwid+2=@LimitHWID+2 or @CountHwid+3=@LimitHWID+3)
begin
insert Into _AutoNotice Values ('Sorry You Reached Max Hwid Limit!',@CharName,0,'00:00:00')
insert into YOURDB.._InstantTeleportDelivery values (@CharID,1,1,25000,982,140,140)
end

IF @EventID=11 or @EventID=9
	begin
	WAITFOR DELAY '00:00:05' --CHECK TIME
	Exec YOUR DB..CustomPcLimitSystem @CharID
	END