I ran into an issue today regarding the method for removal of the LORE flag. While setting loreflag=0 does kill the flag that gets displayed in an item inspect window, it doesn't actually make the item non-LORE. Turns out you also need to remove the asterisk ("*") from the item's lore text. I used this query to do that:
UPDATE items SET lore = replace(lore, '*', '');
Unfortunately, that breaks the ARTIFACT tag as it kills the asterisk out of ALL items that have one in their descriptions (artifacts need to have that text prefixed by "*#").
What query could I run that would remove the asterisk unless it's followed by a pound sign?
|