Asfor 4Gold

 20/11/2016

 27/5/2019

 3/4/2019

 20/04/2019

QueenSro

Atrium Sro
14/04/2019

Facebook Page
14/04/2019

 

  [ ] | |  

  FaceBook | Official Group 

  Facebook 




[ ] [ ]

         ::  Silkroad4arab ( :DOKA167)       :: ChaosReborn | D11 | Cap 110 | Pve | New CH Balanced Skills | G.O: 5-4-2018 ( :akory123)       ::  gateway ( :staff5050)       ::  ( :poals)       ::   ( :poals)       :: vSro 1.188 Server Files + client D12 Jupiter orginal ( :TheRock2007)       ::   ( :ERO-SRO)       :: God's Blessing Diverse forms ( :ahmedjak1993)       ::  DC  ( : )       ::   ( :ahmedjak1993)       ::   ( :ahmedabouhaiba)       :: blowfishkey ( :Kingm179)       ::  24 LOADING  ( :ahmedjak1993)       ::  HP MP  ( :mahmoudzone)       ::  pk2 editor blowfish key  ( :Kingm179)       ::   ( :mohamedrcc)       ::  dg 12 - 13 - 14 - 15  ( :ahmedjak1993)       ::  textdata_object ( :GM Toni)       ::   ( : )       :: Crack  ( : )       ::   ( : )       ::  glow Effect  ( :M@hmoud)       :: Back To Old School :- Rev-Sro Information ( :CError)       ::  110  ( :CError)       ::  200 Silk  ( :Rev-Sro)      

 
08-03-2019, 03:41 AM   #1

Mazika Yasser



  Mazika Yasser

[ PK2 Edit ] Pc Games

Mar 2016
129351
395
Designer and editor
Private Server
Male
10
Mazika Yasser

Mazika Yasser

1119  



: 3
:



king pvp king unique !


Mazika Yasser :

,,, [ ]


- BeboSilkroad
:
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())*/
google

09-03-2019, 02:33 AM   #2

BeboSilkroad



  BeboSilkroad


May 2015
121919
101
Alexandria
Karatee
Private Server
Male
10
BeboSilkroad

BeboSilkroad

171  


   Yahoo  BeboSilkroad

: 27
:



ߡ SRO_VT_ACCOUNT table srZor_uniques


BeboSilkroad :
Private Server Creator


09-03-2019, 01:41 PM   #3

.Gamer.


Be Smart

  .Gamer.

||

Jul 2015
123161
2,818
Mansoura Egypt
Developer At Private Silkroad
Private Server
Male
33
.Gamer.

.Gamer.

13367  


   Skype  .Gamer.

: 378

    
: 2

:



!


.Gamer. :
,,, [ ]




09-03-2019, 03:09 PM   #4

Mazika Yasser



  Mazika Yasser

[ PK2 Edit ] Pc Games

Mar 2016
129351
395
Designer and editor
Private Server
Male
10
Mazika Yasser

Mazika Yasser

1119  



: 3
:



:
BeboSilkroad ,,, [ ]
ߡ SRO_VT_ACCOUNT table srZor_uniques
srZor_uniques


Mazika Yasser :

,,, [ ]


09-03-2019, 10:47 PM   #5

BeboSilkroad



  BeboSilkroad


May 2015
121919
101
Alexandria
Karatee
Private Server
Male
10
BeboSilkroad

BeboSilkroad

171  


   Yahoo  BeboSilkroad

: 27
:



:
Mazika Yasser ,,, [ ]
srZor_uniques
á Trigger


BeboSilkroad :
Private Server Creator


13-03-2019, 02:01 AM   #6

Mazika Yasser



  Mazika Yasser

[ PK2 Edit ] Pc Games

Mar 2016
129351
395
Designer and editor
Private Server
Male
10
Mazika Yasser

Mazika Yasser

1119  



: 3
:



:
BeboSilkroad ,,, [ ]
á Trigger


Mazika Yasser :

,,, [ ]


13-03-2019, 06:36 PM   #7

BeboSilkroad



  BeboSilkroad


May 2015
121919
101
Alexandria
Karatee
Private Server
Male
10
BeboSilkroad

BeboSilkroad

171  


   Yahoo  BeboSilkroad

: 27
:



:
Mazika Yasser ,,, [ ]
log event character SRO_VT_LOG


BeboSilkroad :
Private Server Creator


13-03-2019, 09:26 PM   #8

Mazika Yasser



  Mazika Yasser

[ PK2 Edit ] Pc Games

Mar 2016
129351
395
Designer and editor
Private Server
Male
10
Mazika Yasser

Mazika Yasser

1119  



: 3
:



:
BeboSilkroad ,,, [ ]
log event character SRO_VT_LOG


Mazika Yasser :

,,, [ ]


13-03-2019, 11:17 PM   #9

BeboSilkroad



  BeboSilkroad


May 2015
121919
101
Alexandria
Karatee
Private Server
Male
10
BeboSilkroad

BeboSilkroad

171  


   Yahoo  BeboSilkroad

: 27
:



:
Mazika Yasser ,,, [ ]


BeboSilkroad :
Private Server Creator


13-03-2019, 11:28 PM   #10

Mazika Yasser



  Mazika Yasser

[ PK2 Edit ] Pc Games

Mar 2016
129351
395
Designer and editor
Private Server
Male
10
Mazika Yasser

Mazika Yasser

1119  



: 3
:



:
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 :

,,, [ ]


14-03-2019, 12:22 PM   #11

BeboSilkroad



  BeboSilkroad


May 2015
121919
101
Alexandria
Karatee
Private Server
Male
10
BeboSilkroad

BeboSilkroad

171  


   Yahoo  BeboSilkroad

: 27
:



:
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 :
Private Server Creator


14-03-2019, 04:33 PM   #12

Mazika Yasser



  Mazika Yasser

[ PK2 Edit ] Pc Games

Mar 2016
129351
395
Designer and editor
Private Server
Male
10
Mazika Yasser

Mazika Yasser

1119  



: 3
:



:
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 :

,,, [ ]


14-03-2019, 08:33 PM   #13

BeboSilkroad



  BeboSilkroad


May 2015
121919
101
Alexandria
Karatee
Private Server
Male
10
BeboSilkroad

BeboSilkroad

171  


   Yahoo  BeboSilkroad

: 27
:



:
Mazika Yasser ,,, [ ]


BeboSilkroad :
Private Server Creator


14-03-2019, 09:26 PM   #14

Mazika Yasser



  Mazika Yasser

[ PK2 Edit ] Pc Games

Mar 2016
129351
395
Designer and editor
Private Server
Male
10
Mazika Yasser

Mazika Yasser

1119  



: 3
:



:
BeboSilkroad ,,, [ ]


Mazika Yasser :

,,, [ ]


15-03-2019, 02:52 PM   #15

BeboSilkroad



  BeboSilkroad


May 2015
121919
101
Alexandria
Karatee
Private Server
Male
10
BeboSilkroad

BeboSilkroad

171  


   Yahoo  BeboSilkroad

: 27
:



:
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())*/


BeboSilkroad :
Private Server Creator



« | »

: 1 (0 1 )
 




08:05 AM.

@ @ @ @ @ @ SilkroadOnline @ @ @ @ @ @ @ @ (Gold) @ ( Gold) @ (Gold) @ @ ( Korean SilkRoad ) @ AgBot @ ( Accounts ) @ [ ] @ ( Item ) @ ( Gold ) @ ( Item ) @ @ Flora @ Minerva @ Feronia @ Bellona @ [ iSro ] @ @ @ @ PhBot @ -== T-BOT ==- @ Ceres @ @ @ @ @ @ @ StealthLite Bot @ Agbot @ StealthLite @ PHBOT @ T-BOT @ SroKing Bot @ [ iSro ] @ Flora @ Ceres @ Bellona @ Minerva @ Feronia @ 2019 @ @ @ @ ECSRO @ ECSRO(Fembria) @ ECSRO(VIP) @ SJSRO (OLD) @ SJSRO (new) @ sunworld @ IBot @ ( Gold ) @ @ Vsro @ Rusro @ [ Private-SRO ] @ ZSZC & Aurora @ Sbot @ Mbot @ V.I.P Zone @ VIP @ VIP @ [ PK2 Edit ] @ Mysro @ @ @ @ IBOT @ Sbot @ Mbot @ Sroking @ Elite & Eroad @ DreamWorld @ @ [ Silkroad-R ] @ Maycena @ @ [ Silkroad-R ] @ - Private SRO @ Perfection @ Ex.Silkroad R @ SroKings @ @ Other Online Games @ S4 League @ CrossFire @ Conquer Online @ LOL @ Pc Games @ @ Barons Online @ (AriesOnline (Pvp @ QueenSRO Network @ & S4 League @ & CrossFire @ World's Gate @ Sun-World @ Aion @ Continent Of The Ninth @ World Of Warcraft @ PanicSro @ @ @ IceSro-R @ Kings_Silkroad @ Justice Road @ ArabianRoadOnline Network @ Devias Online @ @ CrossFire Fantasy Game @ CrossFire @ & Aion @ & Conquer Online @ League Of Legends @ legenD road @ WantedSro Online @ @ @ Mixsro @ @ SRO-R @ LegenD Road @ Knights War Online @ Evolution Network @ FlagSRO Network @ Perfection (PvP) Network @ S4league @ @ @ @ @ Destructions Network @ FanTasYWorld @ @ Smart-Sro Online @ InFusion Online @ @ Divine Online @ Dota @ PC @ GameXen Network @ inferno online @ @ @ PK2 edit @ Velestia @ Punisher Sro Online @ Atlantis Online @ ALEXNADER SRO @ Hell World Online @ ImmortalRoad @ Centerbot @ Centerbot @ Time.Sro-Online @ Revenge (PVE) Online @ Silkroad4arab || Games Online @ Online Games @ @ @ @ @ @ @ @ @ Creddy Online @ Alliance-sro @ Quick Road (PvP ) @ @ League Of Legends @ League Of Legends @ CrossFire @ League Of Legends @ [ LOL ] @ North America @ EU West @ EU Nordic & East @ League Of Legends @ @ @ @ Wolf team @ Dota 2 @ Dragon nest @ DC Universe Online @ Windows @ Quenth Online @ Wolf team Arabic @ RealDreamSro ( PvP ) @ EmpireSRO @ Amazing Sro @ Speed-sro @ . Destructions Network @ SilkRoad E 80 China @ @ @ Greats-sro Online @ @ @ Srowing @ Dakupra-Online @ @ @ @ @ @ @ @ PantuSRO @ (Silkroad4arab vps , server) @ Tyr Online @ RocSro @ Legend Of Silkroad @ Pioneer Gaming-Network @ Valentus - CAP 80 @ MirrorSro @ Eridanus Online Cap90 @ Fear-Sro @ Silkroad-Z Online PVE @ @ Massive-Network @ Kryptonite-Sro @ DeathRoad @ Mysro Servers @ Devils Team @ DooMSRO Network @ EROAD SRO @ Story-SRO @ Ventrue-Online @ Settlers-SRO @ Electus Online @ MarsRoad Online @ Arrow Online @ Selene @ Hermes @ OldSro Online (cap 80 ) @ Sunroad @ Eloys Online @ Sentiero-Road Online @ Steam-Sro @ Arcane Reborn Online @ Eryxonline @ Vengeance Online @ Mirage Online @ SyndiCateOnline @ Desert Sro @ NeSro Network @ Android @ @ @ MegaWar Sro @ Mirror Sro @ AdvancedSRO @ OblivionSilkroad @ Arrivals_Sro @ Amphibius Online @ Royal online @ Forbidden-Sro @ vanish-sro @ Majesty Online @ Chaos Network @ srAssist Bot @ srAssist Bot @ Damocles Sro @ Demo Sro @ KingsRoad @ Arius 9D ch & eu @ brother sro @ DreamWorld-Online @ Poseidon-Sro @ Ph-Sro @ Jupiet-Online @ Fury Sro @ JungleSro @ Xemia Games @ invctus-sro @ Revolution Gaming Network @ DemonSro @ Aeolus @ Golden Sro @ Chaos Reborn @ Chaos II Online @ Fallen Soul @ StarLife Online @ Xian @ Xian @ Revira online @ @ 2018 @ Silkroad life @ Bcsro Online @ Aliens Online @ Unix Sro @ Immortal SRO @ VehallaSro 11D @ Justice Online @ Venus Online @ [English - Arabic - Videos] @ Egypt-Sro @ (Rap) @ | WWE @ @ The Dragon Sro @ Perfection SRO @ Rev-Sro @ GoldenAge Reborn @ Vodka Road @ Warrior Online @ Atrium Sro @ Destiny-Network @ Martyrs Online @ Egypt Sro @ Data Base @ PUBG Mobile @ Fortnite @ Pro Evolution Soccer @ FIFA Online @ Free Fire @


- - -