AOPSERVER take the script that repairs some problems: delete items, characters and much more:
USE [AT_GameDB01]
GO
/****** Object: StoredProcedure [dbo].[rasp_SolItemRemove] Script Date: 12/09/2016 07:39:13 p.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[rasp_SolItemRemove]
@
[Only registered and activated users can see links. Click Here To Register...] Bigint
, @
[Only registered and activated users can see links. Click Here To Register...]pe tinyint
, @
[Only registered and activated users can see links. Click Here To Register...]s smallint
, @
[Only registered and activated users can see links. Click Here To Register...]Unique smallint
, @
[Only registered and activated users can see links. Click Here To Register...]Num smallint
, @
[Only registered and activated users can see links. Click Here To Register...]ItemNum smallint = NULL OUTPUT
AS
SET NOCOUNT ON
SET XACT_ABORT ON
UPDATE [dbo].[tbl_SolItem]
SET [ItemUnique] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [ItemUnique]
END
, @
[Only registered and activated users can see links. Click Here To Register...]ItemNum = [ItemNum] = [ItemNum] - @
[Only registered and activated users can see links. Click Here To Register...]Num
, [SerialNum] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [SerialNum]
END
, [Para1] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [Para1]
END
, [Para2] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [Para2]
END
, [StartHourVary] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [StartHourVary]
END
, [DurationHourVary] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [DurationHourVary]
END
, [RareInfo] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [RareInfo]
END
, [Rank] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [Rank]
END
, [CurDurability] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [CurDurability]
END
, [MaxDurability] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [MaxDurability]
END
, [SealInfo] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [SealInfo]
END
, [Particle] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [Particle]
END
, [Effect] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [Effect]
END
, [Reserved] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [Reserved]
END
, [Reserved1] = CASE WHEN [ItemNum] = @
[Only registered and activated users can see links. Click Here To Register...]Num THEN 0 ELSE [Reserved1]
END
WHERE [SolID] = @
[Only registered and activated users can see links. Click Here To Register...] and [ItemPos] = @
[Only registered and activated users can see links. Click Here To Register...]s and [PosType] = @
[Only registered and activated users can see links. Click Here To Register...]pe and [ItemUnique] = @
[Only registered and activated users can see links. Click Here To Register...]Unique and [ItemNum] >= @
[Only registered and activated users can see links. Click Here To Register...]Num and @
[Only registered and activated users can see links. Click Here To Register...]Num > 0
IF dbo.rf_CheckError( @@ROWCOUNT, @@ERROR ) <> 1
RETURN 0
ELSE
RETURN 1