Update Smilie Code

[Dade]

We all know it gets annoying whenever you delete, rename, or edit a smilie and the code ( Ex. :wink: ) turns out to just be text, thus loosing it's attachment to the smilie. I'd love a hack where you could search the entire board for that code ( like :wink: ), and then update all of the codes to the new one you want it to say ( like :wink2: )

[Joshua Clinard]

I would use that!

[Admin]

Try running this query:
UPDATE post SET pagetext=REPLACE(pagetext,":wink:",":wink2:");
(and don't cry if your server crashes or something like that. :))

[Dade]

Originally posted by FireFly
and don't cry if your server crashes or something like that)

LOL :D

Yeah.. but this would be awesome where you could do it straigtht from the Admin CP, oh well, thanks for the help Chen :)