عندي مشكلة في التايتل ان الداتا الي بستخدمها في نظام لما حد من البلاير يموت التايجر او الديمون او اليورش او كابتن ايف بياخد تايتل علي اسم اليونك بالتالي لما احب ادي لحد تيتل مثلا king pvp او king unique اول ميروح يموت اليونك بيتشيال التايتل تلقائي ويتحط اسم اليونك ممكن طرية ان الغي النظام ده ؟؟!
دا تريجر معمول ان اي حد يموت يونيك ياخد تايتل اوتوماتيك، هتدخل علي SRO_VT_ACCOUNT و تشوف في تريجر متسجل في table اسمه srZor_uniques و لو لاقيت تريجر امسحه
المشاركة الأصلية كتبت بواسطة BeboSilkroad
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
دا تريجر معمول ان اي حد يموت يونيك ياخد تايتل اوتوماتيك، هتدخل علي SRO_VT_ACCOUNT و تشوف في تريجر متسجل في table اسمه srZor_uniques و لو لاقيت تريجر امسحه
srZor_uniques ياعني لو لقيت ده امسحو من الداتا خالص
المشاركة الأصلية كتبت بواسطة 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
المشاركة الأصلية كتبت بواسطة Mazika Yasser
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
كود:
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
اعمل لـ ده Execute بدل اللي عندك انا لاغيتلك سطور اليونيكات اللي بتدي تايتل
كود:
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())
المشاركة الأصلية كتبت بواسطة BeboSilkroad
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
اعمل لـ ده Execute بدل اللي عندك انا لاغيتلك سطور اليونيكات اللي بتدي تايتل
كود:
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())
المشاركة الأصلية كتبت بواسطة Mazika Yasser
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
لا
ضيف دا بدل اللي عندك
كود:
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())*/