Query to Delete item but with OptLevel

Hello Brothers
how i can Delete Item but with Optlevel
as Example:
delete Sword D13 +10 from all Server ??

Quote:

---

Originally Posted by arabcart

Hello Brothers
how i can Delete Item but with Optlevel
as Example:
delete Sword D13 +10 from all Server ??

---

To select all the "weapons" :

PHP Code:

---

SELECT     _Inventory.*, _Items.ID64, _Items.OptLevel, _Items.RefItemID, _RefObjCommon.ID, _RefObjCommon.CodeName128
FROM         _Inventory INNER JOIN
                      _Items ON _Inventory.ItemID = _Items.ID64 INNER JOIN
                      _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID 
where CodeName128 like 'ITEM_CH_SWORD_%' 


---

To select all the swords with +13

PHP Code:

---

SELECT     _Inventory.*, _Items.ID64, _Items.OptLevel, _Items.RefItemID, _RefObjCommon.ID, _RefObjCommon.CodeName128
FROM         _Inventory INNER JOIN
                      _Items ON _Inventory.ItemID = _Items.ID64 INNER JOIN
                      _RefObjCommon ON _Items.RefItemID = _RefObjCommon.ID 
where CodeName128 like 'ITEM_CH_SWORD_%' AND OptLevel >= 13 


---

To delete all the weapons who are +13 and a sword you just have to change the query to a update one to set ItemID = 0 (the weapons are still in db then but not in inventory of chars)

Dont forget if you use advanced elixers in your server there are +13 weapons wich are in DB +11 (and have a magic + on it)

Where this Query ??

Quote:

---

To delete all the swords in the server who are +13 or higher:

---