Msg 156, Level 15, State 1, Procedure TT_IGScore, Line 14
Incorrect syntax near the keyword 'ELSE'.

USE [Ranking]
GO
/****** Object:  StoredProcedure [dbo].[TT_IGScore]    Script Date: 12/08/2012 16:24:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE	[dbo].[TT_IGScore]
	@ServerCode		INT,
	@AccountID		VARCHAR(10),
	@Name			VARCHAR(10),
	@PlayDay		TINYINT
As
Begin
	BEGIN TRANSACTION
	SET NOCOUNT ON	

	IF EXISTS (SELECT NULL FROM IMPERIALGUARDIAN_INFO WHERE Account = @AccountID AND Name = @Name AND ServerCode = @ServerCode AND PlayDay = @PlayDay) 
		UPDATE IMPERIALGUARDIAN_INFO SET WinCount = WinCount+1 WHERE Account = @AccountID AND Name = @Name AND ServerCode = @ServerCode AND PlayDay = @PlayDay
		UPDATE MuOnline.dbo.Character SET reputation = reputation+1 WHERE AccountID = @AccountID AND Name = @Name
	ELSE
		INSERT INTO IMPERIALGUARDIAN_INFO (ServerCode, Account, Name, WinCount, PlayDay) VALUES (@ServerCode,@AccountID,@Name,1,@PlayDay)

	IF(@@Error <> 0 )
		ROLLBACK TRANSACTION
	ELSE	
		COMMIT TRANSACTION

	SET NOCOUNT OFF	
End

USE [Ranking]
GO
/****** Object:  StoredProcedure [dbo].[TT_IGScore]    Script Date: 12/08/2012 16:24:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[TT_IGScore]
	@ServerCode INT,
	@AccountID VARCHAR(10),
	@Name VARCHAR(10),
	@PlayDay TINYINT
AS
BEGIN
	BEGIN TRANSACTION
	SET NOCOUNT ON	
	
	IF EXISTS (
	       SELECT NULL
	       FROM   IMPERIALGUARDIAN_INFO
	       WHERE  Account = @AccountID
	              AND NAME = @Name
	              AND ServerCode = @ServerCode
	              AND PlayDay = @PlayDay
	)
	BEGIN
	    UPDATE IMPERIALGUARDIAN_INFO
	    SET    WinCount = WinCount + 1
	    WHERE  Account = @AccountID
	           AND NAME = @Name
	           AND ServerCode = @ServerCode
	           AND PlayDay = @PlayDay
	
	UPDATE MuOnline.dbo.Character
	SET    reputation = reputation + 1
	WHERE  AccountID = @AccountID
	       AND NAME = @Name
	END
   ELSE
   	BEGIN
	
	INSERT INTO IMPERIALGUARDIAN_INFO
	  (
	    ServerCode,
	    Account,
	    NAME,
	    WinCount,
	    PlayDay
	  )
	VALUES
	  (
	    @ServerCode,
	    @AccountID,
	    @Name,
	    1,
	    @PlayDay
	  )
	END
	IF (@@Error <> 0)
	    ROLLBACK TRANSACTION
	ELSE
	    COMMIT TRANSACTION
	
	SET NOCOUNT OFF
END