مشكلة في السيلك

[Mostafa Shaaban]

المشاركة الأصلية كتبت بواسطة [GM]RAMBO

راجع ع التاب دة [_JobNewJobS] ممكن يكون المشكلة فية لأن انا شايف ان السيستم مافيهوش اي مشاكل بس مكتوب ان اي حاجة تحصل ف السيستم تقري الملف دة ف حاول تشوف الي جواه ممكن يطلع العيب فية

اهو يا باشا

USE [SRO_VT_XEVENT]
GO
/****** Object: StoredProcedure [dbo].[_JobNewJobS] Script Date: 6/24/2020 6:40:43 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_JobNewJobS]
@CharID int,
@Desc varchar(128)
as

DECLARE @UserID int = (SELECT userjid FROM SRO_VT_SHARD.dbo._User where CharID = @CharID)
DECLARE @KilledCharName VARCHAR(512) = @Desc
SELECT @KilledCharName = REPLACE(@KilledCharName, LEFT(@KilledCharName, CHARINDEX('(', @KilledCharName)), '')
SELECT @KilledCharName = REPLACE(@KilledCharName, RIGHT(@KilledCharName, CHARINDEX(')', REVERSE(@KilledCharName))), '')
----- Killer CharID
DECLARE @KilledCharID INT
,@KillerWorldID INT
,@KillerCharname varchar(50)
,@Killed1Charname varchar(50)
SELECT @KilledCharID = CharID , @KillerWorldID = WorldID FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharName16 = @KilledCharName
SELECT @KillerCharname = CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @CharID
SELECT @Killed1Charname = NickName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @KilledCharID

SELECT @KilledCharName = NickName16 FROM [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @CharID
DECLARE @WorldIDKiller int = (SELECT WorldID FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @CharID)
-- Check if he kills the char more than 3 times
DECLARE @PKill int = (select COUNT(*) from _JobNewSys where KillerID = @CharID and KilledID = @KilledCharID AND Kills = '1')
DECLARE @KillsCount int = (SELECT count(Kills) FROM _JobNewSys WHERE KillerID = @CharID )


DECLARE @JobString VARCHAR(10) = LTRIM(RTRIM(SUBSTRING(@Desc, 5, 7)))
DECLARE @JobType INT = CASE
WHEN @JobString LIKE 'Trader' THEN 1
WHEN @JobString LIKE 'Robber' THEN 2
WHEN @JobString LIKE 'Hunter' THEN 3
ELSE 0 END
DECLARE @IpKiller varchar(max) = 1--(SELECT IP FROM SRO_VT_MYTHIC.dbo._IPLogs WHERE CharID = @CharID )
DECLARE @IpKilled varchar(max) = 2--(SELECT IP FROM SRO_VT_MYTHIC.dbo._IPLogs WHERE CharID = @KilledCharID )



select @KilledCharName
IF ( @PKill <= 3 AND @JobType <> 0 AND @WorldIDKiller != '60' AND @KillsCount < '500') --AND @IpKilled != @ipkiller)
BEGIN
INSERT INTO _JobNewSys (KillerID , KilledID , Kills) VALUES (@CharID , @KilledCharID,'1')
IF @JobType = 2
BEGIN
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Job] @UserID,1/*Silks Count*/
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' you earn [1] job point.',Getdate())
END
ELSE IF @JobType != 2
BEGIN
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Job] @UserID,1/*Silks Count*/
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' you earn [1] job point.',Getdate())
END
END
ELSE IF ( @PKill <= 3 AND @JobType <> 0 AND @WorldIDKiller = '60' AND @KillsCount < '500') --AND @IpKilled != @ipkiller)
BEGIN
INSERT INTO _JobNewSys (KillerID , KilledID , Kills) VALUES (@CharID , @KilledCharID,'1')
IF @JobType = 2
BEGIN
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Job] @UserID,1/*Silks Count*/
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' you earn [1] job point.',Getdate())
END
ELSE IF @JobType != 2
BEGIN
EXEC SRO_VT_ACCOUNT.[CGI].[CGI_WebPurchaseSilk_Job] @UserID,2/*Silks Count*/
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' you earn [1] job point.',Getdate())
END
END
ELSE IF @PKill > '3'
BEGIN

--INSERT INTO SRO_VT_XEVENT.dbo._Chat ([send],[sendto],[Message],[date]) VALUES ('0',@KillerCharname,'You have killed '+@Killed1Charname +' 3times you wont earn more job points from him.',GETDATE())
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'You have killed '+@Killed1Charname +' 4 times you wont earn more job points from him.',Getdate())
INSERT INTO _JobNewSys (KillerID , KilledID , Kills) VALUES (@CharID , @KilledCharID,'0')
END
if (@KillsCount >= 50)
begin
--INSERT INTO SRO_VT_XEVENT.dbo._Chat ([send],[sendto],[Message],[date]) VALUES ('0',@KillerCharname,'Your total job kills today is ['+CAST(@KillsCount AS VARCHAR(256))+']/500',GETDATE())
Insert Into iLegend_Tool (Service,Type,Target,Message,Date) Values (1,'Private',@KillerCharname,'Your total job kills today is ['+CAST(@KillsCount AS VARCHAR(256))+']/50',Getdate())

INSERT INTO _JobDay (CharID,Charname,IsDat) VALUES (@charid,@KillerCharname,GETDATE())