as the title goes :)
If Your encountered an error Like This while inviting a Club Duel in Gunner Server Files :D
Here's the error:
DB:42000, NativeError:2812, [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'sp_RequestGuBattle'.
The Solution Is now Here Execute This Script in your SQL Server..
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[sp_EndGuBattle]
@GuSNum int,
@GuPNum int,
@GuFlag int,
@GuKillNum int,
@GuDeathNum int,
@nReturn int OUTPUT
AS
DECLARE @error_var int,
@rowcount_var int
SET NOCOUNT ON
SET @nReturn = 0
SET @error_var = 0
SET @rowcount_var = 0
BEGIN
IF @GuFlag = 6 --Win
begin
UPDATE GuildInfo
SET GuBattleWin = GuBattleWin + 1
WHERE GuNum=@GuSNum
End
else IF @GuFlag = 5 --Lose
Begin
UPDATE GuildInfo
SET GuBattleLose = GuBattleLose + 1
WHERE GuNum=@GuSNum
End
else IF @GuFlag = 1 --Draw
Begin
UPDATE GuildInfo
SET GuBattleDraw = GuBattleDraw + 1
WHERE GuNum=@GuPNum
End
--INSERT INTO GuildBattle (GuSNum, GuPNum, GuFlag, GuKillNum,GuDeathNum)
--VALUES (@GuSNum, @GuPNum, @GuFlag, @GuKillNum,@GuDeathNum)
SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @error_var <> 0 OR @rowcount_var = 0
BEGIN
SET @nReturn = 0
SET NOCOUNT OFF
RETURN @nReturn
END
END
SET @nReturn = 1
SET NOCOUNT OFF
RETURN @nReturn
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER Procedure [dbo].[sp_RequestGuBattle]
@GuSNum int,
@GuPNum int,
@GuFlag int,
@GuAlliance int,
@nReturn int OUTPUT
AS
DECLARE @error_var int,
@rowcount_var int
SET NOCOUNT ON
SET @nReturn = 0
SET @error_var = 0
SET @rowcount_var = 0
BEGIN
--INSERT INTO GuildBattle (GuSNum, GuPNum, GuFlag, GuAlliance)
--VALUES (@GuSNum, @GuPNum, @GuFlag, @GuAlliance)
SELECT @error_var = @@ERROR, @rowcount_var = @@ROWCOUNT
IF @error_var <> 0 OR @rowcount_var = 0
BEGIN
SET @nReturn = 0
SET NOCOUNT OFF
RETURN @nReturn
END
END
SET @nReturn = 1
SET NOCOUNT OFF
RETURN @nReturn
NaMiSwAn
Ragezone