- Joined
- Oct 6, 2010
- Messages
- 539
- Reaction score
- 241
run this in sql
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[IGC_ArcaBattleProcInsert] Script Date: 19/02/2018 08:17:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[IGC_ArcaBattleProcInsert]
@nProcState tinyint
as
BEGIN
DECLARE return int
SET return = 0
Set nocount on
IF NOT EXISTS ( SELECT Proc_State FROM IGC_ARCA_BATTLE_PROC_STATE WITH ( READUNCOMMITTED ) )
BEGIN
begin transaction
INSERT INTO IGC_ARCA_BATTLE_PROC_STATE (Proc_State) VALUES ( @nProcState )
END
ELSE
begin transaction
UPDATE IGC_ARCA_BATTLE_PROC_STATE SET Proc_State = @nProcState
IF ( @@Error <> 0 )
BEGIN
rollback transaction
SET return = -1
SELECT return
END
ELSE
BEGIN
commit transaction
SELECT return
END
END
Thanks!! Fix BC Event the problem of no reward items yet?
Last edited: