الموقع العربي الاول للعبة Silkroad Online

كود:
USE [SRO_VT_SHARD]           

GO

--------------------------------                           

DECLARE @ChrID INT;            

DECLARE @CharName VARCHAR(64); 

DECLARE @AccJID INT;           

---------------------------------

SET @CharName =    'CharNameHere'---

---------------------------------

SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)

SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)

--------------------------------

USE [SRO_VT_ACCOUNT]

--------------------------------

DELETE FROM [dbo].[_BlockedUser]

WHERE UserJID = @AccJID

DELETE FROM [dbo].[_Punishment]

WHERE UserJID = @AccJID



--By ( H I T L E R) --  



-----------------------------------------------------------------

SELECT StrUserID FROM TB_User WHERE JID = @AccJID

-----------------------------------------------------------------