USE [PS_GameData]
GO
/****** Object:  StoredProcedure [dbo].[usp_UpdateMapID]    Script Date: 19.11.2017 14:17:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


create Proc [dbo].[usp_UpdateMapID]

@CharID int,
@Map smallint

AS

SET NOCOUNT ON

DECLARE @ServerID int
SET @ServerID = 1

UPDATE Chars
SET Map = @Map
WHERE CharID = @CharID

IF(@@ERROR = 0 AND @@ROWCOUNT = 1)
BEGIN
	RETURN 1
END
ELSE
BEGIN
	RETURN -1
END

SET NOCOUNT OFF