Guild ! Again...

USE [Telecaster]
GO
/****** Object:  StoredProcedure [dbo].[smp_set_guild_leader]    Script Date: 9/23/2012 3:01:02 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- start of smp_set_guild_leader
ALTER PROCEDURE [dbo].[smp_set_guild_leader]
@IN_SID					INT, -- This defines the "Current" leaders ID
@IN_LEADER_SID			INT -- This defines the "New" leaders ID

AS
SET NOCOUNT ON

BEGIN TRANSACTION

-- Normal Member Permission = 1 / Leader Permission = 7
-- SET OLD Leader to "Normal Member"

UPDATE dbo.GuildMember SET permission = 1 WHERE guild_id = @IN_SID AND permission = 7

-- SET NEW Leader

UPDATE dbo.GuildMember SET permission = 7 WHERE player_id = @IN_LEADER_SID

COMMIT TRANSACTION

-- end of smp_set_guild_leader