Query Delete Premium From user - From All Players

Gamer

طاقم الإدارة
مشرف
SQL Developer
2 فبراير 2017
844
46
94
94
المنصورة
Facebook
xGamer1337

المستوي:

257454929.gif

505913405.gif

591526393.gif


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

139875365.gif