How to clean inventory of all chars?

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.