Needing Some Help With An SP

USE [PS_GameData]
GO
/****** Object: StoredProcedure [dbo].[Verify_StaffStatus] Script Date: 12/10/2013 12:32:40 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER Proc [dbo].[Verify_StaffStatus]

AS

SET NOCOUNT ON

DECLARE @UserUID int
DECLARE @UID varchar (18)
DECLARE @CharID int
DECLARE @Event1 tinyint
DECLARE @Event2 tinyint
DECLARE @LoginStatus tinyint
DECLARE @StaffStatus tinyint
--
SELECT @UserUID=UserUID, @LoginStatus=LoginStatus FROM Chars WHERE CharID = @CharID
--
IF @CharID = 2050
BEGIN
UPDATE Chars SET StaffStatus = 1 WHERE CharID=@CharID
END
ELSE
IF @CharID = 4
BEGIN
UPDATE Chars SET StaffStatus = 1 WHERE CharID=@CharID
END