HOWTO: Removing item limits

[Dvinn]

BEGIN EDIT NOTE

(November 23, 2004) - Turns out that the method I was using never affected the ARTIFACT flag anyway, so I've updated this main post to include that data.

(November 22, 2004) - The method outlined here does remove the LORE flag from an item's inspection window, but it still gets treated as LORE anyway! To get the formerly LORE item working right, you need to also remove the "*" from the item's lore text. I'm still looking for a clean MySQL query to do that that won't also break the ARTIFACT tag. I'll be posting about that further down in this thread... Also note that I changed the non NO RENT value to so it would conform with properly collected non NO RENT items.

END EDIT NOTE

I saw a post this morning on these boards about how to remove the LORE flag from the items in someone's database. It occurs to me that there might be others wondering how to do similar-type things so I decided I might as well take a moment to post a few database mods that "unlock" the items in your database. These are all MySQL queries intended to be run an already-sourced database. Obviously, some of these mods are more unbalancing than others.

As written, these will affect every item in your database. See the end of this post for methods of applying these changes to single items.

Note that there is no simple way to undo a mass change like these without re-sourcing your entire item database.

Remove the LORE flag

UPDATE items SET loreflag=0;
UPDATE items SET lore=REPLACE(lore, '*', '');

Remove the NO DROP flag

UPDATE items SET nodrop=1;

Remove the NO RENT flag

UPDATE items SET norent=255;

Remove the Recommended Level flag

UPDATE items SET reclevel=0;

Remove the Required Level flag

UPDATE items SET reqlevel=0;

Remove the Recommend Skill Level flag

UPDATE items SET recskill=0;

Make item effects (procs and click effects) usable at level 0

UPDATE items SET hasteproclvl=0;

Remove the Deity Requirement flag

UPDATE items SET deity=0;

Make items usable by all races

UPDATE items SET races=32767;

Make items usable by all classes

UPDATE items SET classes=65535;

To target any of these changes at a specific item rather than your entire database, there are a couple methods you can use. I'll use the Dragoon Dirk's LORE flag as an example.

Method 1

UPDATE items SET loreflag=0 WHERE Name='Dragoon Dirk';
UPDATE items SET lore=REPLACE(lore, '*', '') WHERE Name='Dragoon Dirk';

This would remove the LORE flag from and item in your database that is named "Dragoon Dirk" but would not include items that have a name that does not exactly match (i.e. "Fabled Dragoon Dirk").

Method 2

UPDATE items set loreflag=0 where id='13942';
UPDATE items SET lore=REPLACE(lore, '*', '') WHERE id='13942';

This would remove the LORE flag from only the item with id 13942 (EQLive's "Dragoon Dirk") but would not include any other items, regardless of their name or id.

Use these changes in good health .