Just opinion about dupe :))

03/15/2012 21:15 bulgaria#1
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
03/17/2012 01:40 sondo81#2
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
03/18/2012 08:49 bulgaria#3
:)))to much codes

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