[Dev.Ri3o]

ده ال System
هتعمل ال Table ده عشان يسجل ال Title القيدم بتاع ال PLayer

USE [SRO_VT_SHARDLOG]
GO

/****** Object:  Table [dbo].[JobHwanLevel]    Script Date: 21/12/2016 2:15:00 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[JobHwanLevel](
	[CharID] [int] NOT NULL,
	[Charname] [varchar](Max) NULL,
	[OldHwanLevel] [int] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

وهتعمل ال Procedure ده

USE [SRO_VT_SHARDLOG]
GO
/****** Object:  StoredProcedure [dbo].[_JobTitleX]    Script Date: 21/12/2016 2:15:54 PM ******/
---------------------**** This Procedure Is Created By Dev.Ri3o @Silkroad4arab ****--------
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE  PROCEDURE [dbo].[_JobTitleX]        
@Operation  AS TINYINT,               
@CharID   AS INT,        
@Slot_From  AS TINYINT,        
@Slot_To  AS TINYINT           
AS
DECLARE @ItemID int
DECLARE @CharName Varchar(Max)
Set @CharName = ( Select CharName16 From [SRO_VT_SHARD].[dbo].[_Char] Where CharID=@CharID )
DECLARE @OLDHWAN int = ( Select HwanLevel From [SRO_VT_SHARD].[dbo].[_Char] Where CharID=@CharID )
DECLARE @NEWHWAN int
Set @NEWHWAN = '150'

 SELECT TOP 1 @ItemID = RefItemID 
 FROM SRO_VT_SHARD.[dbo].[_Items] 
 INNER JOIN SRO_VT_SHARD.[dbo].[_Inventory] INV 
 ON ID64 = INV.ItemID 
 WHERE INV.CharID = @CharID and INV.Slot = @Slot_From
               

-----------  Player wears job suit-----------
 IF @Operation = '0' and @Slot_To = '8' 
 BEGIN
 IF NOT EXISTS (Select CharID From [SRO_VT_SHARD].[dbo].[_Char] Where CharName16=@CharName)
               (SELECT HwanLevel FROM SRO_VT_SHARD.[dbo].[_Char] WHERE CharID = @CharID)
 Insert Into [SRO_VT_SHARDLOG].[dbo].[JobHwanLevel] ([CharID],[CharName],[OldHwanLevel]) Values (@CharID,@CharName,@OLDHWAN)
	
           BEGIN 
           Update [SRO_VT_SHARD].[dbo].[_Char] Set HwanLevel = @NEWHWAN Where CharName16=@CharName
           END
 END
----------- By Developer Ri3o -----------

----------- ## Player Close Off Job Suit ## -----------                 
 IF  @Operation = '0' AND  @Slot_From = '8'
           BEGIN 
           IF EXISTS (Select CharID From [SRO_VT_SHARD].[dbo].[_Char] Where CharName16=@CharName)
		             (SELECT OldHwanLevel From [SRO_VT_SHARDLOG].[dbo].[JobHwanLevel] Where CharID=@CharID)

		  BEGIN
           Update [SRO_VT_SHARD].[dbo].[_Char] Set HwanLevel = @OLDHWAN
           END
END
---------
Print 'Ri3o'

هتغير انت بقى ال 150 دى للرقم بتاعك اللى انت عاملو
وهتحط ده فى ال AddLogChar

 IF @Operation = 0  AND @Slot_To = 8 OR @Slot_From = 8
  BEGIN
  EXEC [SRO_VT_SHARDLOG].[dbo].[_JobTitleX] 
  END