Query Guild

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_Guild_Create]    Script Date: 9/21/2018 10:29:45 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


--
ALTER PROCEDURE [dbo].[_Guild_Create]
    @GuildName    VARCHAR(64),
    @CreaterID    INT
AS
    IF (EXISTS (SELECT id FROM _Guild WHERE Name = @GuildName))
    BEGIN
        RETURN -1000
    END
    IF (EXISTS (SELECT CharID FROM _GuildMember WHERE CharID = @CreaterID))
    BEGIN
        RETURN -1001
    END
BEGIN TRANSACTION

    DECLARE @GuildID    INT
    DECLARE @FoundationDate  smalldatetime

    SET @FoundationDate = GetDate()
    INSERT _Guild(Name, Lvl, GatheredSP, FoundationDate,Alliance,Booty) VALUES(@GuildName, 5, 0, @FoundationDate,0,0)
    SET @GuildID = @@IDENTITY

    IF (@@error <> 0 OR @@rowcount = 0 OR @GuildID = 0)
    BEGIN
        ROLLBACK TRANSACTION
        RETURN -5
    END

    --&#44600;드장은 퍼미션이 0xffffffff !!
    DECLARE @rvalue INT
    EXEC @rvalue = _Guild_FnAddMember @GuildID, @CreaterID, 0, @FoundationDate,0xffffffff
    IF (@@error <> 0 OR @rvalue <= 0)
    BEGIN
        ROLLBACK TRANSACTION
        RETURN @rvalue
    END

    -- &#44600;드 창고를 생성하자
    EXEC @rvalue = _Guild_CreateChest_NoTX @GuildID
    IF (@@error <> 0 OR @rvalue <= 0)
    BEGIN
        ROLLBACK TRANSACTION
        RETURN @rvalue
    END

commit TRANSACTION
    RETURN @GuildID