اقتباس:
المشاركة الأصلية كتبت بواسطة Mohamed Hitler
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
شوفو في ال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
---