الموقع العربي الاول للعبة Silkroad Online

ده ال 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