المستوي:
For All Users
كود:
DELETE FROM [SRO_VT_SHARD].[dbo].[_TimedJob]
WHERE Category = '5' OR
Category = '3' OR
Category = '0'
For User
كود:
DELETE FROM [SRO_VT_SHARD].[dbo].[_TimedJob]
WHERE CharID = '[COLOR="red"]CHAR ID[/COLOR]'
From Char ..
USE SRO_VT_SHARD
GO
DECLARE @CharName Varchar (MAX)
DECLARE @CharID INT
SET @CharName = 'Gamer'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
DELETE FROM _TimedJob WHERE CharID = @CharID