Just opinion about dupe :))

[bulgaria]

Is better when you just use ban

IF @ActionType = '116' OR @ActionType = '164'
BEGIN
WAITFOR DELAY '00:00:05'
SELECT @CharLeave=Leave
FROM PS_userdata.dbo.Users_Master
WHERE UserUID=@UserUID

IF @CharLeave=0
BEGIN
--just ban
END
END

[sondo81]

If @charleave=0
UPDATE [PS_UserData].[dbo].[Users_Master]
SET [Status] = '15'
WHERE UserUID = (SELECT UserUID
FROM [PS_GameData].[dbo].[Chars]
WHERE Del = 0 and CharName = 'Charname')


i think its better then no declare function like --just ban

[bulgaria]

))to much codes

If @charleave=0
--Just ban
UPDATE [PS_UserData].[dbo].[Users_Master] SET [Status] = '15' WHERE UserUID = @UserUID