مشاهدة النسخة كاملة : عندي مشكلة في التايتل ؟؟
Mazika Yasser
08-03-2019, 03:41 AM
عندي مشكلة في التايتل ان الداتا الي بستخدمها في نظام لما حد من البلاير يموت التايجر او الديمون او اليورش او كابتن ايف بياخد تايتل علي اسم اليونك بالتالي لما احب ادي لحد تيتل مثلا king pvp او king unique اول ميروح يموت اليونك بيتشيال التايتل تلقائي ويتحط اسم اليونك ممكن طرية ان الغي النظام ده ؟؟!
BeboSilkroad
09-03-2019, 02:33 AM
دا تريجر معمول ان اي حد يموت يونيك ياخد تايتل اوتوماتيك، هتدخل علي SRO_VT_ACCOUNT و تشوف في تريجر متسجل في table اسمه srZor_uniques و لو لاقيت تريجر امسحه
.Gamer.
09-03-2019, 01:41 PM
تابع موضوعع !
Mazika Yasser
09-03-2019, 03:09 PM
دا تريجر معمول ان اي حد يموت يونيك ياخد تايتل اوتوماتيك، هتدخل علي SRO_VT_ACCOUNT و تشوف في تريجر متسجل في table اسمه srZor_uniques و لو لاقيت تريجر امسحه
srZor_uniques ياعني لو لقيت ده امسحو من الداتا خالص
BeboSilkroad
09-03-2019, 10:47 PM
srZor_uniques ياعني لو لقيت ده امسحو من الداتا خالص
لأ، انت هتدور عليه في الداتا و لما تلاقيه اضغط مرتين عليه، هيظهرلك حاجة اسمها Trigger دوس مرتين عليها و شوف في اي تريجر متسجل فيها ولا لأ
Mazika Yasser
13-03-2019, 02:01 AM
لأ، انت هتدور عليه في الداتا و لما تلاقيه اضغط مرتين عليه، هيظهرلك حاجة اسمها Trigger دوس مرتين عليها و شوف في اي تريجر متسجل فيها ولا لأ
مفيش حاجة متسجلة فيها
https://f.top4top.net/p_1166auxo21.png
ارجو الحل يا اخي
BeboSilkroad
13-03-2019, 06:36 PM
مفيش حاجة متسجلة فيها
https://f.top4top.net/p_1166auxo21.png
ارجو الحل يا اخي
تعرف تبعتلي البروسيدجر بتاع الlog event character من ال SRO_VT_LOG خده كوبي و هاته هنا
Mazika Yasser
13-03-2019, 09:26 PM
تعرف تبعتلي البروسيدجر بتاع الlog event character من ال SRO_VT_LOG خده كوبي و هاته هنا
https://f.top4top.net/p_1167ra2vz1.png
انهي وحده
BeboSilkroad
13-03-2019, 11:17 PM
https://f.top4top.net/p_1167ra2vz1.png
انهي وحده
هو اللي انت معلم عليه دا أول واحد
Mazika Yasser
13-03-2019, 11:28 PM
هو اللي انت معلم عليه دا أول واحد
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
BeboSilkroad
14-03-2019, 12:22 PM
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())
Mazika Yasser
14-03-2019, 04:33 PM
اعمل لـ ده 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())
مش عايز يضاف :Emoji28:
https://a.top4top.net/p_1168bmu2h1.png
حل يا اخي
BeboSilkroad
14-03-2019, 08:33 PM
مش عايز يضاف :Emoji28:
https://a.top4top.net/p_1168bmu2h1.png
حل يا اخي
عندك اوتوماتيك ايفينت ؟
Mazika Yasser
14-03-2019, 09:26 PM
عندك اوتوماتيك ايفينت ؟
لا
BeboSilkroad
15-03-2019, 02:52 PM
لا
ضيف دا بدل اللي عندك
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
15-03-2019, 11:08 PM
ضيف دا بدل اللي عندك
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())*/
تم الحل بفضلك شكرا جزيلا #يغلق
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc