طلب

[mohamed9000]

ازاي اخلي ال char عليه title name لو لابس ال job ?

[Dev.Klito]

ممنوع الاسئلة الخرافية

[Dev.Ri3o]

ممنوع الاسئلة الخرافية

مش خرافية بالعكس فكرة حلوة جدا

[افندينا ™Hamboka™]

لسه مشفتش الفكره ديه ف اي جيم

[MikrotikBody]

ممكن تستخدم أي سيستم وتحوله لو الأكونت لبس الجوب يتعملو أبديت للتيتيل نيم اللي انت عايزه

[MikrotikBody]

ممنوع الاسئلة الخرافية

ازاي خرافيه مش فاهم ؟

[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

[Dev.Ri3o]

##