Yardım Vsro Old 3 job sistemi

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