/****** Object: Stored Procedure dbo.WZ_CS_GetOwnerGuildMaster Script Date: 28.11.2008 19:52:26 ******/
CREATE PROCEDURE 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
GO
Originally Posted by Thorninaron
