Help about Sp_requestGuBattle

[ryantotz]

Who had the database Query for this. ?

 

[yasir43]

USE [RanGame1]
GO

/****** Object:  StoredProcedure [dbo].[sp_RequestGuBattle]    Script Date: 12/18/2023 08:39:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[sp_RequestGuBattle]
    @nClubP int,
    @nClubS int,
    @nEndTime int,
    @nAlliance int,
    @nReturn int    OUTPUT
AS   

        

SET NOCOUNT ON;

SET @nReturn = 0
    
begin tran;   

    INSERT INTO GuildBattle (
    GuSNum,
    GuPNum,
    GuAlliance,
    GuFlag,
    GuKillNum,
    GuDeathNum,
    GuBattleStartDate,
    GuBattleEndDate
    )
    VALUES(
    @nClubS,
    @nClubP,
    @nAlliance,
    0,
    0,
    0,
    GETDATE(),
    DATEADD(minute,10,getdate())
    )
        
    SET @nReturn = -1;
    IF @@ROWCOUNT > 0
    BEGIN
        SET @nReturn = 0;
        commit tran;
    END
    ELSE ROLLBACK TRAN
    -----------------------------------------------------------------
    -- ?? ?? ???? ???? ??? ????. 
    --SELECT @nGuNum=GuNum
    --FROM GuildInfo
    --WHERE ChaNum=@ChaNum
      
    --IF @nGuNum <> 0 -- ??? ??, ???????
    --BEGIN
    --    SET @nReturn = -1
    --    SET NOCOUNT OFF
    --    RETURN @nReturn
    --END
    
    -------------------------------------------------------------------
 --   -- ??? ??? ????.
 --   INSERT INTO GuildInfo (ChaNum, GuName)
 --   VALUES (@ChaNum, @GuName)
    
 --   SELECT @error_var = @@ERROR
 --   IF @error_var <> 0
 --   BEGIN
 --       -- ?? ??? ????
 --       SET @nReturn = -2
 --       SET NOCOUNT OFF
 --       RETURN @nReturn
 --   END
    
 --   -----------------------------------------------------------------
 --   -- ??? ?? ????, ????? ????.
 --   SELECT @nGuNum=@@IDENTITY
    
 --   SET @nReturn = @nGuNum
    
 --   -----------------------------------------------------------------
 --   -- ??? ??? ???(Guild Master)? ?????? ????? ????.
 --   UPDATE ChaInfo
 --   SET GuNum=@nGuNum
 --   WHERE ChaNum=@ChaNum
    
    -- ??? ????? ????.
    SET NOCOUNT OFF
    RETURN @nReturn


GO

 

[ryantotz]

USE [RanGame1]
GO

/****** Object:  StoredProcedure [dbo].[sp_RequestGuBattle]    Script Date: 12/18/2023 08:39:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO




CREATE PROCEDURE [dbo].[sp_RequestGuBattle]
    @nClubP int,
    @nClubS int,
    @nEndTime int,
    @nAlliance int,
    @nReturn int    OUTPUT
AS  

       

SET NOCOUNT ON;

SET @nReturn = 0
   
begin tran;  

    INSERT INTO GuildBattle (
    GuSNum,
    GuPNum,
    GuAlliance,
    GuFlag,
    GuKillNum,
    GuDeathNum,
    GuBattleStartDate,
    GuBattleEndDate
    )
    VALUES(
    @nClubS,
    @nClubP,
    @nAlliance,
    0,
    0,
    0,
    GETDATE(),
    DATEADD(minute,10,getdate())
    )
       
    SET @nReturn = -1;
    IF @@ROWCOUNT > 0
    BEGIN
        SET @nReturn = 0;
        commit tran;
    END
    ELSE ROLLBACK TRAN
    -----------------------------------------------------------------
    -- ?? ?? ???? ???? ??? ????.
    --SELECT @nGuNum=GuNum
    --FROM GuildInfo
    --WHERE ChaNum=@ChaNum
     
    --IF @nGuNum <> 0 -- ??? ??, ???????
    --BEGIN
    --    SET @nReturn = -1
    --    SET NOCOUNT OFF
    --    RETURN @nReturn
    --END
   
    -------------------------------------------------------------------
 --   -- ??? ??? ????.
 --   INSERT INTO GuildInfo (ChaNum, GuName)
 --   VALUES (@ChaNum, @GuName)
   
 --   SELECT @error_var = @@ERROR
 --   IF @error_var <> 0
 --   BEGIN
 --       -- ?? ??? ????
 --       SET @nReturn = -2
 --       SET NOCOUNT OFF
 --       RETURN @nReturn
 --   END
   
 --   -----------------------------------------------------------------
 --   -- ??? ?? ????, ????? ????.
 --   SELECT @nGuNum=@@IDENTITY
   
 --   SET @nReturn = @nGuNum
   
 --   -----------------------------------------------------------------
 --   -- ??? ??? ???(Guild Master)? ?????? ????? ????.
 --   UPDATE ChaInfo
 --   SET GuNum=@nGuNum
 --   WHERE ChaNum=@ChaNum
   
    -- ??? ????? ????.
    SET NOCOUNT OFF
    RETURN @nReturn


GO

Thank You very much Sir for kindness to share,