[Mazika Yasser]

المشاركة الأصلية كتبت بواسطة BeboSilkroad عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

هو اللي انت معلم عليه دا أول واحد

USE [SRO_VT_SHARDLOG_AMK]
GO
/****** Object:  StoredProcedure [dbo].[_AddLogChar]    Script Date: 3/13/2019 10:27:52 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER   procedure [dbo].[_AddLogChar] 
@CharID		int,
@EventID		tinyint,
@Data1		int,
@Data2		int,
@strPos		varchar(64),
@Desc		varchar(128)
as 

if( @EventID=4 or @EventID=6  or @EventID=9 )
BEGIN
	declare @len_pos 	int
	declare @len_desc	int
	set @len_pos = len(@strPos)
	set @len_desc = len(@Desc)
	if (@len_pos > 0 and @len_desc > 0)
	begin	
		insert _LogEventChar values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)	
	end
	else if (@len_pos > 0 and @len_desc = 0)
	begin 	
		insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos)
	end
	else if (@len_pos = 0 and @len_desc > 0)
	begin 	
		insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @Desc)
	end
	else
	begin
		insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values(@CharID, GetDate(), @EventID, @Data1, @Data2)
	end
--DELETE  TOP (3) FROM _LogEventChar WHERE EventTime < DATEADD(week, -2, GETDATE())
END

--Auto Uniques Titles System
Declare @Mobname Varchar(128)
Declare @Charname varchar (30)
Declare @Amount tinyint -- 255 kills max
IF (@EventID between 9 and 11) -- lol 
Begin
Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel = '4' where (HwanLevel between '106' AND '112') AND (HwanLevel not between '115' and '120')

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_CH_TIGERWOMAN' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='106' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_OA_URUCHI' order by time desc) 

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='109' where (CharName16 = @Charname AND HwanLevel <= '114') OR (NickName16 = @Charname AND HwanLevel <= '114')   --AND MaxLevel between 1 AND 130

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_KK_ISYUTARU' order by time desc) 

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='110' where (CharName16 = @Charname AND HwanLevel <= '115') OR (NickName16 = @Charname AND HwanLevel <= '115')   --AND MaxLevel between 1 AND 130

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_TK_BONELORD' order by time desc) 

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='111' where (CharName16 = @Charname AND HwanLevel <= '116') OR (NickName16 = @Charname AND HwanLevel <= '116')  

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_RM_TAHOMET' order by time desc) 
 
Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='112' where (CharName16 = @Charname AND HwanLevel <= '117') OR (NickName16 = @Charname AND HwanLevel <= '117')  
 
Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_EU_KERBEROS' order by time desc) 
 
Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='107' where (CharName16 = @Charname AND HwanLevel <= '118') OR (NickName16 = @Charname AND HwanLevel <= '118')  --AND MaxLevel between 1 AND 130
 
Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_AM_IVY' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='108' where CharName16 = @Charname AND HwanLevel <= '119' OR (NickName16 = @Charname AND HwanLevel <= '119')

Set @Charname =(Select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_RM_ROC' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='129' where CharName16 = @Charname AND HwanLevel <= '115' OR (NickName16 = @Charname AND HwanLevel <= '115')

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='113' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_BIGSPIDER_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='117' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_DARKEAGLE_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='115' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_WHITETIGER_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='116' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_MUJIGI_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='118' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

Set @Charname = (select top 1 CharName from SRO_VT_ACCOUNT_AMK.dbo.srZor_uniques Where mobname like 'MOB_FW_KYKLOPES_105' order by time desc)

Update SRO_VT_SHARD_AMK.dbo._Char Set HwanLevel='122' where (CharName16 = @Charname AND HwanLevel <= '113') OR (NickName16 = @Charname AND HwanLevel <= '113')   --AND MaxLevel between 1 AND 130

End
IF (@EventID = '20') -- Record GM Death
BEGIN 
			
	IF (@Desc LIKE '%My: no job, Neutral%') 
	BEGIN
		Declare @Killer1 Varchar(64),
				@Killer2 Varchar(64),
				@UserID int
		Set @Killer1 =  SUBSTRING(@Desc, CHARINDEX('His(', @Desc), 
						CHARINDEX('): no job,', @Desc) - CHARINDEX('His(', @Desc) + LEN('): no job,'))

		Set @killer2 = REPLACE(@Killer1,'His(','');
		Set @killer2 = REPLACE(@Killer2,'): no job,','');
		
		SET @UserID = (select UserJID from SRO_VT_SHARD_AMK.dbo._User where CharID = (SELECT CharID FROM SRO_VT_SHARD_AMK.dbo._Char where CharID = @CharID))
		Declare @CharNa Varchar(64) = ( Select CharName16 From SRO_VT_SHARD_AMK.dbo._Char Where CharID = @CharID )
		Declare @ifGMDie int = ( Select sec_content From SRO_VT_ACCOUNT_AMK.dbo.TB_User where JID = @UserID )
		if (@ifGMDie = 156 AND @CharNa ='Big')
		BEGIN

			INSERT into [G_Events].[dbo].[_NoticeQueue] (Service,Message,Date)
			Values (0,@killer2 + ' Win The Gm Killer Event',GETDATE())
			exec G_Events.dbo._GiveSilk @killer2,10,'GMKiller'
		END
		ELSE IF EXISTS (Select CharName From [G_Events].[dbo].[_LMS_Players] Where CharName Like @CharNa  )
		BEGIN
						IF EXISTS (Select CharName From [G_Events].[dbo].[_LMS_Players] Where CharName Like @killer2  )
						BEGIN
						EXEC G_Events..LMSCheck_PDead @killer2,@CharNa
						END
		END
		ELSE
		BEGIN
		EXEC [G_Events].[dbo].[KillFetch] @CharID,@Desc,@strPos
		END
   END
   	IF (@Desc LIKE '%My: no job, Murderer%') 
	BEGIN
			Declare @Killer1Q Varchar(64),
					@Killer2Q Varchar(64),
					@UserIDQ int,
					@MurName Varchar(64)
		Set @MurName = (Select CharName16 From SRO_VT_SHARD_AMK.._Char Where CharID = @CharID )
		Set @Killer1Q =  SUBSTRING(@Desc, CHARINDEX('His(', @Desc), 
						CHARINDEX('): no job,', @Desc) - CHARINDEX('His(', @Desc) + LEN('): no job,'))

		Set @killer2Q = REPLACE(@Killer1Q,'His(','');
		Set @killer2Q = REPLACE(@Killer2Q,'): no job,','');

		if (@Killer2Q = '[My: no j' AND @MurName IN ( Select PlayerName From G_Events.._MW_PlayerName ))
		BEGIN
			INSERT into [G_Events].[dbo].[_NoticeQueue] (Service,Message,Date)
			Values (0,'[Most Wanted Event] ' + @MurName + ' Dead From Murder Status Lol, Event Finished',GETDATE())
			TRUNCATE Table _MW_PlayerName
		END
		ELSE if( @Killer2Q != '[My: no j' AND @MurName IN ( Select PlayerName From G_Events.._MW_PlayerName ))
		BEGIN
			INSERT into [G_Events].[dbo].[_NoticeQueue] (Service,Message,Date)
			Values (0,'[Most Wanted Event] ' + @killer2Q + ' Kill The Most Wanted Player, Congrats',GETDATE())
			exec G_Events.._GiveSilk @Killer2Q,10,'MostWanted'
TRUNCATE Table _MW_PlayerName
		END
		
	END
END
	
	IF (@EventID = 6)
	BEGIN
	Declare @CharLogOut Varchar(max) = ( Select CharName16 From SRO_VT_SHARD_AMK.._Char Where CharID = @CharID )
	if Exists (Select PlayerName From  G_Events.._MW_PlayerName Where PlayerName = @CharLogOut)
	BEGIN
			INSERT into [G_Events].[dbo].[_NoticeQueue] (Service,Message,Date)
			Values (0,'[Most Wanted Event] ' + @CharLogOut + ' Has Logout And Event Finished',GETDATE())
	END
	END