Query Delete Premium From user - From All Players

[Gamer]

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

 

[Danger1338]

رد: Query Delete Premium From user - From All Players

was need it thank you :emoji14::emoji37: