HOWTO: Removing item limits

[Dvinn]

Originally Posted by animepimp

UPDATE items SET lore = replace(lore, '*', '') WHERE NOT lore LIKE '*#'; should work.

I tried that and it doesn't change anything in my database. I did end up figuring something out that works, though:

First I change all occurances of '#*' to "##":

update items set lore=replace(lore, '#*', '##');

Then I kill all the asterisks in lore:

update items set lore=replace(lore, '*', '');

Then I switch '##' back over to '#*':

update items set lore=replace(lore, '##', '#*');

It's all moot, though, because even items with '#*' aren't showing the artifact flag (presumably the client only shows that flag now if artifactflag=1?).

So the PEQ database has no items that show the artifact flag to begin with.