| BeboSilkroad |
14-03-2019 12:22 PM |
رد: عندي مشكلة في التايتل ؟؟
اقتباس:
المشاركة الأصلية كتبت بواسطة Mazika Yasser
(المشاركة 5366178)
كود:
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())
|
