Untitled

USE [MuOnline]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO


ALTER PROCEDURE [dbo].[IGC_Monster_KillCount_Save]
	@szCharName VARCHAR(10), --Name of character who kill the monster
	@iMonsterID INT --Monster ID that was killed
AS
	BEGIN
		SET NOCOUNT ON
		DECLARE @ServerName varchar(20)
		SELECT @ServerName = S.ServerName FROM Character AS C INNER JOIN MEMB_STAT S ON C.AccountID = S.memb___id WHERE C.Name = @szCharName
		BEGIN
			INSERT INTO dbo.C_Monster_KillCount_Extended (Name, MonsterID, gs, killDate) VALUES (@szCharName, @iMonsterID, @ServerName, GETDATE())
		END
		IF EXISTS (SELECT 0 FROM dbo.C_Monster_KillCount WHERE Name = @szCharName AND MonsterID = @iMonsterID)
			BEGIN
				UPDATE dbo.C_Monster_KillCount SET Count = Count +1 WHERE Name = @szCharName AND MonsterID = @iMonsterID
			END
		ELSE
			BEGIN
				INSERT INTO dbo.C_Monster_KillCount (Name, MonsterID, Count) VALUES (@szCharName, @iMonsterID, 1)
			END


		IF (@@ERROR <> 0)
			SELECT 0 as ResultCode --No error, return success.
		ELSE
			SELECT 1 as ResultCode --We got an error error, return fail.
	END
GO