Mohamed ElKersh
10-03-2016, 09:10 PM
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[_OldTitles1] Script Date: 10/03/2016 07:53:30 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_OldTitles1](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CharName] [varchar](20) NOT NULL,
[OldHwan] [int] NULL,
[UName] [varchar](50) NULL,
CONSTRAINT [PK__OldTitles1] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
iF (@EventID = 9 OR @EventID = 11)
BEGIN
DECLARE @Hwanlevelchange1 int = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles1] Where UName = '5')
DECLARE @MaxK1 int = (SELECT Count(CodeName128) FROM [SRO_VT_SHARDLOG].[dbo].[_UniquesLog] Where Killer = @CharName1 And CodeName128 = 'MOB_OA_URUCHI')
If @MaxK1 >= '2'
BEGIN
-- Take the title from the player and change to hwanlvl = 1
Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles1] ([CharName],[OldHwan],[UName]) Values (@CharName1,@CheckHwanlevel,'5')
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange1 where HwanLevel like '5'
DELETE from [SRO_VT_SHARDLOG].[dbo].[_OldTitles1] where UName Like '5' And OldHwan = @Hwanlevelchange1
-- Adding the title to the new player ( 8 is the hwan lvl change to yours (reward hwanlvl) )
UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = '5' where CharName16 = @CharName1
-- Item Reward
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,'ITEM_ETC_SD_TOKEN_01',10,0
-- Notice Lines To show All server this char is Hero
insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice','** Unique Hero System** : '+@Charname1+' has now recived (Unique Hero ) title for killing Tiger Girl 2 times And recived Arena Coins as reward ',GETDATE())
-- Delete Log Unique From Table
DELETE from [SRO_VT_SHARDLOG].[dbo].[_UniquesLog] where Killer = @Charname1 and CodeName128 = 'MOB_OA_URUCHI'
END
END
دول لو شغالين ماشي انا لو عاوز احط يونيك تالت اعمل ايه ؟ قولي بظبط اعمل ايه او اديني كويري او اديني ال logchar اللي عندك اظبط انا الدنيا
GO
/****** Object: Table [dbo].[_OldTitles1] Script Date: 10/03/2016 07:53:30 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_OldTitles1](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CharName] [varchar](20) NOT NULL,
[OldHwan] [int] NULL,
[UName] [varchar](50) NULL,
CONSTRAINT [PK__OldTitles1] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
iF (@EventID = 9 OR @EventID = 11)
BEGIN
DECLARE @Hwanlevelchange1 int = (SELECT OldHwan FROM [SRO_VT_SHARDLOG].[dbo].[_OldTitles1] Where UName = '5')
DECLARE @MaxK1 int = (SELECT Count(CodeName128) FROM [SRO_VT_SHARDLOG].[dbo].[_UniquesLog] Where Killer = @CharName1 And CodeName128 = 'MOB_OA_URUCHI')
If @MaxK1 >= '2'
BEGIN
-- Take the title from the player and change to hwanlvl = 1
Insert Into [SRO_VT_SHARDLOG].[dbo].[_OldTitles1] ([CharName],[OldHwan],[UName]) Values (@CharName1,@CheckHwanlevel,'5')
UPDATE [SRO_VT_SHARD].[dbo].[_Char] SET HwanLevel = @Hwanlevelchange1 where HwanLevel like '5'
DELETE from [SRO_VT_SHARDLOG].[dbo].[_OldTitles1] where UName Like '5' And OldHwan = @Hwanlevelchange1
-- Adding the title to the new player ( 8 is the hwan lvl change to yours (reward hwanlvl) )
UPDATE [SRO_VT_SHARD].[dbo].[_Char] set HwanLevel = '5' where CharName16 = @CharName1
-- Item Reward
EXEC [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @CharName1,'ITEM_ETC_SD_TOKEN_01',10,0
-- Notice Lines To show All server this char is Hero
insert into [SRO_VT_SHARDLOG].[dbo].[iLegend_Tool] ([Service],[Type],[Message],[Date]) Values ('1','Notice','** Unique Hero System** : '+@Charname1+' has now recived (Unique Hero ) title for killing Tiger Girl 2 times And recived Arena Coins as reward ',GETDATE())
-- Delete Log Unique From Table
DELETE from [SRO_VT_SHARDLOG].[dbo].[_UniquesLog] where Killer = @Charname1 and CodeName128 = 'MOB_OA_URUCHI'
END
END
دول لو شغالين ماشي انا لو عاوز احط يونيك تالت اعمل ايه ؟ قولي بظبط اعمل ايه او اديني كويري او اديني ال logchar اللي عندك اظبط انا الدنيا