EXECUTE :
USE [MaxiGuard_User]
GO
/****** Object: Table [dbo].[_JobSuitLog] Script Date: 3/21/2025 10:52:46 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_JobSuitLog](
[Idx] [int] IDENTITY(1,1) NOT NULL,
[CharID] [int] NOT NULL,
[CharName16] [varchar](25) NOT NULL,
[JobType] [tinyint] NOT NULL,
[Action] [bit] NOT NULL,
[IP] [varchar](35) NOT NULL,
[IPInt] [bigint] NOT NULL,
[Serial] [varbinary](8) NOT NULL,
[Date] [datetime] NOT NULL
) ON [PRIMARY]
GO
USE [MaxiGuard_User]
GO
/****** Object: Table [dbo].[_CharTriJob] Script Date: 3/21/2025 10:53:17 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[_CharTriJob](
[CharID] [int] NOT NULL,
[JobLvl_Trader] [tinyint] NOT NULL,
[Trader_Exp] [int] NOT NULL,
[JobLvl_Hunter] [tinyint] NOT NULL,
[Hunter_Exp] [int] NOT NULL,
[JobLvl_Robber] [tinyint] NOT NULL,
[Robber_Exp] [int] NOT NULL,
[LastUpdated] [datetime] NOT NULL,
CONSTRAINT [PK__CharTriJob] PRIMARY KEY CLUSTERED
(
[CharID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT INTO MaxiGuard_User.dbo._CharTriJob SELECT CharID, 1,0,1,0,1,0,GETDATE() FROM SRO_VT_SHARD.dbo._Char
UPDATE SRO_VT_SHARD.dbo._Char SET NickName16 = CharName16
update SRO_VT_SHARD.dbo._RefShardContentConfig SET Value = 1 WHERE CodeName128 = 'TRADE_SAFETY_OPTION'
UPDATE SRO_VT_SHARD.dbo._CharTrijob SET JobType = 0
----------------------------------------------------------
ADD TO _AddNewChar:
INSERT INTO MaxiGuard_User.dbo._CharTriJob VALUES(@NewCharID, 1,0,1,0,1,0,GETDATE())
-------------------------------------------------------------
EDIT _AddNewChar:
MAKE SURE THE INSERTING LINE TO _Char INSERTS NickName16 SAME AS CharName16
--------------------------------------------------------------------
ADD TO _JobSuitEquip_EDIT:
DECLARE @WearingSuitTypeID4 tinyint = (SELECT TypeID4 FROM SRO_VT_SHARD.dbo._RefObjCommon WITH(NOLOCK) WHERE ID = @SuitItemID)
IF(@WearingSuitTypeID4 = 2) --Trying to wear Thief Suit, check for trader/hunter entries.
BEGIN
IF EXISTS(SELECT 1 FROM _JobSuitLog WITH(NOLOCK) WHERE JobType IN (1,3) AND (CharID = @CharID) AND Date > DATEADD(MINUTE, -30, GETDATE()))
BEGIN
exec _AddBridgeCommand 500, '_JobSuitEquip_EDIT', '14', 'Cannot equip the Job Suit because you have worn opposite Job''s Suit in the last 30 minutes.', @Charname
return 0;
END
END
ELSE IF(@WearingSuitTypeID4 IN (1,3)) --trying to wear trader/hunter suit, check for thief entries
BEGIN
IF EXISTS(SELECT 1 FROM _JobSuitLog WITH(NOLOCK) WHERE JobType IN (2) AND (CharID = @CharID) AND Date > DATEADD(MINUTE, -30, GETDATE()))
BEGIN
exec _AddBridgeCommand 500, '_JobSuitEquip_EDIT', '14', 'Cannot equip the Job Suit because you have worn opposite Job''s Suit in the last 30 minutes.', @Charname
return 0;
END
END
---------------------------------------------------------------
ADD TO _JobJoin_EDIT:
exec MaxiGuard_User.dbo._AddBridgeCommand 500, '_JobJoin_EDIT', '14', 'Oldschool 3 Job System is active. You can wear any job suit without joining to any jobs.', @Charname
return 0;
----------------------------------------------------------------
ENABLE JOB JOIN & JOB SUIT EQUIP TRIGGERS IN MAXIGUARD PANEL
ENABLE REMOVE * FROM JOB NAME IN MAXIGUARD PANEL
----------------------------------------------------------------------
REMOVE "Trader Grade" "Hunter Grade" "Thief Grade" Grade from textuisystem.txt