Will take some time, but shud work if the Stored Procedure works like it shud
PHP Code:
USE SRO_VT_SHARD
Declare @MaxID int SET @MaxID = (SELECT MAX(CharID) FROM _Char)
Declare @DynID int SET @DynID = 0
while (@DynID <= @MaxID)
BEGIN
Declare @SelectCharName varchar(50) SET @SelectCharName = (SELECT _Char.CharName16 FROM _Char WHERE CharID = @DynID)
Declare @DynSlot int SET @DynSlot = 0
Declare @InventorySizeMAX int SET @InventorySizeMAX = (SELECT InventorySize FROM _Char WHERE CharName16 = @SelectCharName)
while (@DynSlot <= @InventorySizeMAX)
BEGIN
exec _DeleteInventoryItem @SelectCharName,@DynSlot
SET @DynSlot = @DynSlot + 1
END
SET @DynID = @DynID + 1
END
EDIT: Took me 4:11 Minutes to execute the query with a total amount of 6691 chars from the VSRO basic Database.
