How to Remove Item optlvl > 30

[itatknic]

Hello all !
I have more item optlvl greater than 30 . I want remove all it (item optlvl > 30).

any help will be greatly appreciated and will gain my utmost respect..lol
Thanks for any help in advance

[sarkoplata]

USE SRO_VT_SHARD
DELETE FROM _Items WHERE OptLevel > 30

[Kape7]

Originally Posted by sarkoplata

USE SRO_VT_SHARD
DELETE FROM _Items WHERE OptLevel > 30

Or instead of delete them, reduce the plus.

This is what happens when you mess up with the alchemy XD

[IceAmStiel]

Originally Posted by sarkoplata

USE SRO_VT_SHARD
DELETE FROM _Items WHERE OptLevel > 30

Will either cause an error right away at the execution since there are constraints referenced or as soon as someone tries to login to his/her char again.
If you're going to delete an item completely you'd have to set the reference on the inventory tables to 0/NULL (belongs to its location) AND delete the ItemID from _ItemPool as well.


I would also recommend against the use of a simple update statement since e.g. Alchemy Stones use the OptLevel for their assimilation values (!> 30 though, just sayin) - could end up turning every stone to a 0% one.

You may use..

UPDATE _Items
SET OptLevel = 0
WHERE
	RefItemID in
		(
		SELECT ID FROM _RefObjCommon
		WHERE (CodeName128 like 'ITEM_CH%' OR CodeName128 like 'ITEM_EU%')
		AND TypeID1 = 3 AND TypeID2 = 1 AND TypeID3 != 7 AND [Service] = 1
		)
AND
	OptLevel > 30

sry, in case I was acting like a smartypants

[ahmed4ever2u]

@Caipi i think this one is better

just execute this query .

--##################By Ahmed4ever2u--#####################################
use SRO_VT_SHARD
		DECLARE
			@OptLevel VarCHAR (129) = (SELECT MAX (OPTLEVEL) FROM _Items)
			
	Update _items
		SET OptLevel = '10'
		where OptLevel = @OptLevel
--##################By Ahmed4ever2u--#####################################

then use this query to see the highest item plus

SELECT MAX (OPTLEVEL) FROM _Items

have Fun :-p

[sarkoplata]

Originally Posted by Synx7

Or instead of delete them, reduce the plus.

This is what happens when you mess up with the alchemy XD

Yes, was just a basic example, you may f*ck up the _Items table if you mess with it.

[IceAmStiel]

Oh well I'll simply quote myself:

Originally Posted by IceAmStiel

I would also recommend against the use of a simple update statement since e.g. Alchemy Stones use the OptLevel for their assimilation values (!> 30 though, just sayin) - could end up turning every stone to a 0% one.