[Release] Query To Un-ban Account [Database]

[ღ ∂ Ropp]

PHP Code:

--By Leandro ( nukertube ) --
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 Leandro ( nukertube ) --  

-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
----------------------------------------------------------------- 


Regards, ღ ∂ Ropp

Credits ; nukertube

[@$$]

thanks

[ღ ∂ Ropp]

Your welcome c;

[Keyeight]

you are very active member nice work thx for sharing

[ღ ∂ Ropp]

You guys are extremely welcome c;

[xxnukertube]

:::::::::::::::::

Thx for Credits

Plz Thx for me plzz ^^

[SunSoon]

Tyyy