USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_CS_GetOwnerGuildMaster] Script Date: 11/28/2015 18:07:43 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
ALTER Procedure [dbo].[WZ_CS_GetOwnerGuildMaster]
@iMapSvrGroup SMALLINT
AS
BEGIN
BEGIN TRANSACTION
SET NOCOUNT ON
IF EXISTS ( SELECT MAP_SVR_GROUP FROM MuCastle_DATA WITH (READUNCOMMITTED)
WHERE MAP_SVR_GROUP = @iMapSvrGroup)
BEGIN
DECLARE @iIsCastleOccupied TINYINT
DECLARE @szGuildName VARCHAR(8)
SELECT @iIsCastleOccupied = CASTLE_OCCUPY, @szGuildName = OWNER_GUILD FROM MuCastle_DATA WHERE MAP_SVR_GROUP = @iMapSvrGroup
IF (@iIsCastleOccupied = 1)
BEGIN
IF (@szGuildName <> '')
BEGIN
IF EXISTS ( SELECT G_Master FROM Guild WITH (READUNCOMMITTED)
WHERE G_Name = @szGuildName)
BEGIN
SELECT 1 As QueryResult, @szGuildName As OwnerGuild, G_Master As OwnerGuildMaster FROM Guild WITH (READUNCOMMITTED) WHERE G_Name = @szGuildName
END
ELSE
BEGIN
SELECT 4 As QueryResult, '' As OwnerGuild, '' As OwnerGuildMaster
END
END
ELSE
BEGIN
SELECT 3 As QueryResult, '' As OwnerGuild, '' As OwnerGuildMaster
END
END
ELSE
BEGIN
SELECT 2 As QueryResult, '' As OwnerGuild, '' As OwnerGuildMaster
END
END
ELSE
BEGIN
SELECT 0 As QueryResult, '' As OwnerGuild, '' As OwnerGuildMaster
END
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
END
