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

لو سمحت انا اول ما لبست لبس الهانتر في الجيم واخدت نقطة في النطام بتاعه بقي فيه بج في السيلك االلي في الاكونت ... بقي بيجي بدل السيلك عدد البوينت اللي اخدته فقط ويجيلي رسالة عدم وجود سيلك مع اللعلم معايا 100000 سيلك ودي صورة

https://mrkzgulfup.com/uploads/159284217304361.pngمركز الخليج

رد: مشكلة في السيلك
 

رد: مشكلة في السيلك
 

وريني Producer السيستم

رد: مشكلة في السيلك
 

اجيبه ازاي ؟

رد: مشكلة في السيلك
 

شوفو في الAddlogchar

رد: مشكلة في السيلك
 

---------------------------- Pvp & Job Event VORTEX-------------
-----------------------------------------------------------------
IF @EventID = '20'
BEGIN
DECLARE @KilledName VARCHAR(512) = @Desc
---------------------------- Pvp War Section -------------------------------------------
Declare @RunPvp varchar(100) = (Select Run From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'Pvp war')
Declare @ServicePvp int = (Select [Service] From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'Pvp war')
IF(@RunPvp='ON' And @ServicePvp = '1')
BEGIN
Exec [SRO_VT_XEVENT].[dbo].[EVENT_PVP_PROC] @CharID , @EventID , @KilledName , 3 , @Desc
END
---------------------------- Job War Section -------------------------------------------
Declare @RunJob varchar(100) = (Select Run From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'Job war')
Declare @ServiceJob int = (Select [Service] From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'Job war')
IF(@RunJob='ON' And @ServiceJob = '1')
BEGIN
Exec [SRO_VT_XEVENT].[dbo].[EVENT_JOB_PROC] @CharID , @EventID , @KilledName , 3 , @Desc
END
---------------------------- GM Kill Section -------------------------------------------
Declare @RunGM varchar(100) = (Select Run From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'GM Kill')
Declare @ServiceGM int = (Select [Service] From [SRO_VT_XEVENT].[dbo].[Settings_Basic] Where [Event] like 'GM Kill')
IF(@RunGM ='ON' And @ServiceGM = '1')
BEGIN
Exec [SRO_VT_XEVENT].[dbo].[EVENT_GM_KILL_PROC] @CharID , @EventID , @KilledName , 3 , @Desc
END
END
---------------------------------------------------------------
-----------------Jop For Each Star
-----------------------------------------------------------------
IF (@EventID = 6)
BEGIN
EXEC [SRO_VT_SHARDLOG].[dbo].[_Job_Coin] @CharID
END
/* Job Top Count */
IF (@EventID = 9 OR @EventID = 11)
BEGIN
EXEC [SRO_VT_SHARDLOG].[dbo].[Top_Job_Count] @CharID
END

-- Job System
IF @EventID = '19'
BEGIN
-- Renew for the nex day
IF EXISTS (SELECT CharID FROM SRO_VT_XEVENT.dbo._JobDay WHERE isDat < GETDATE())
BEGIN
DELETE FROM SRO_VT_XEVENT.dbo._JobDay WHERE CharID = @CharID
DELETE FROM SRO_VT_XEVENT.DBO._JobNewSys WHERE KillerID = @CharID
END
IF EXISTS (SELECT *
FROM SRO_VT_SHARD.dbo._Char
WITH(NOLOCK) WHERE CharID = @CharID
AND CurLevel >= '90')

BEGIN

EXEC SRO_VT_XEVENT.dbo.[_JobNewJobS] @CharID,@Desc

END
END
---

رد: مشكلة في السيلك
 

مفيش حل ؟

رد: مشكلة في السيلك
 

رد: مشكلة في السيلك
 

اهو يا باشا

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())

رد: مشكلة في السيلك
 

رد: مشكلة في السيلك
 

https://youtu.be/94ido1aefcQ

دا فيديو يا باشا

رد: مشكلة في السيلك
 

ليها حل بعد ما حضرتك شوفت الفيديو ؟

رد: مشكلة في السيلك
 

رد: مشكلة في السيلك
 

علني اهو
https://youtu.be/QHKyJrQnpVM

رد: مشكلة في السيلك