more will be added later!
Global Manager:
Code:
MaxUserForNonePCBangIP 1
Max number of connections per IP.
Download Server
Max concurrent connections, to prevent overload.
Shard Server
Code:
EnablePremiumFreeAccess 1
Users with Premium can log in on the first try.**
Code:
BanUselessUserWhenFreeAccess 1
Kick non-premium players, when the server is full and a Premium user try to log in.**
Game Server
"Speed hack" (serverside).
**Required stored procedures and tables for VSRO DB (it's already in BlackRogue DB):
USE [BR_AccountTest]
GO
/****** Object: Table [dbo].[_FreeAccess] Script Date: 03/31/2012 11:22:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_FreeAccess](
[JID] [int] NOT NULL,
[EndTime] [datetime] NOT NULL,
[ShardID] [int] NOT NULL
) ON [PRIMARY]
GO
USE [BR_AccountTest]
GO
/****** Object: StoredProcedure [dbo].[_CheckFreeAccess] Script Date: 03/31/2012 11:24:32 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
----------------------------------------------------------------------
-- ภฺภฏมขฑูภฬ ฐกดษวัม๖ธฆ ศฎภฮวฯฑโ ภงวั วมทฮฝรมฎ
----------------------------------------------------------------------
CREATE PROCEDURE [dbo].[_CheckFreeAccess]
@JID INT,
@ShardID INT
AS
-- วุด็ JID ภว วุด็ ปตๅภว BanLvl ภฬ ฑโบปภฬ พฦดั พึต้ฟก EndTime ภป ฐกมฎฟยดู.
DECLARE @EndTIme DATETIME
SET @EndTIme = 0
-- ว๖ภ็ ผณฐ่ ป๓ BANLevel ภฬ 4 ( BanLevel รึฐํฤก ) ภฮ ฐๆฟ์ฟกธธ FA ฐก ฐกดษวฯดู.
SELECT TOP 1 @EndTIme = Endtime
FROM _FreeAccess
WHERE JID = @JID
AND ShardID = @ShardID
ORDER BY EndTime DESC
if exists (select 1 from TB_User where JID=@JID and block=1)
begin
Select 1
return
end
IF ( @EndTIme <> 0 ) AND ( DATEDIFF( SECOND, GETDATE(), @EndTIme ) > 0 )
BEGIN
-- ฝรฐฃย๗ฐก พ็ผ๖, ฝรฐฃ ฟฉภฏฐก ภึดยณ๐
SELECT 1
END
ELSE
BEGIN
-- ฝรฐฃย๗ฐก ภฝผ๖, ฝรฐฃ ฟฉภฏฐก พ๘ดยณ๐
SELECT 0
END
GO
USE [BR_AccountTest]
GO
/****** Object: StoredProcedure [dbo].[_ResetFreeAccess] Script Date: 03/31/2012 11:24:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
----------------------------------------------------------------------
-- ณฏยฅฐก ม๖ณญ พึต้ภบ ป่มฆวุ น๖ธฐดู.
----------------------------------------------------------------------
CREATE PROCEDURE [dbo].[_ResetFreeAccess]
AS
DELETE FROM _FreeAccess WHERE GETDATE() > EndTime
GO
----------------------------------------------------------------------
-- ณฏยฅฐก ม๖ณญ พึต้ภบ ป่มฆวุ น๖ธฐดู.
----------------------------------------------------------------------
ALTER PROCEDURE [dbo].[_ResetFreeAccess]
AS
DELETE FROM _FreeAccess WHERE GETDATE() > EndTime
USE [BR_GameTest]
GO
/****** Object: Table [dbo].[_FreeAccessBanLvl] Script Date: 03/31/2012 11:25:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_FreeAccessBanLvl](
[JID] [int] NOT NULL,
[BanLvl] [int] NOT NULL,
[EndTime] [datetime] NOT NULL
) ON [PRIMARY]
GO
