UBB.threads PHP Forum Software Community Forums UBB.threads Version 7/8 Support Complicated SQL query

What would be the SQL query for replacing < and > in ubbt_USER_PROFILE > USER_SIGNATURE and ubbt_USER_PROFILE > USER_DEFAULT_SIGNATURE with respectively < and >

?

You'd want to do a database backup on this before hand just in case it causes any problems, but something like this *should* work:

UPDATE ubbt_USER_PROFILE SET USER_SIGNATURE = REPLACE(USER_SIGNATURE, '<','<')

UPDATE ubbt_USER_PROFILE SET USER_DEFAULT_SIGNATURE = REPLACE(USER_DEFAULT_SIGNATURE, 'glt;','>')

Thank you Rick!

That worked.

I need these to regularly fix the signatures on our forums (their URLs contain a "?php" phrase, as they are dynamic). The sigs are turned into plain text as soon as users try to update their profiles.

I guess I have to store these as two separate SQL Queries right? I can't just paste both lines in the Control Panel's SQL Query window at once, right? As for now I have just entered and executed them one by one.

Unfortunately the </> are stored as </> as soon as you try to store the queries. I have stored them anyway, so that I can copy/paste and then edit them for future use

Since they are both working on the same table you can try doing them as one query like:

UPDATE ubbt_USER_PROFILE
SET USER_SIGNATURE = REPLACE(USER_SIGNATURE, '<','<'),
USER_DEFAULT_SIGNATURE = REPLACE(USER_DEFAULT_SIGNATURE, 'glt;','>')

Thank you Rick!

There were a few errors in that, but I got the idea:

UPDATE ubbt_USER_PROFILE SET USER_SIGNATURE = REPLACE(USER_SIGNATURE, '<','<'), USER_DEFAULT_SIGNATURE = REPLACE(USER_DEFAULT_SIGNATURE, '>','>')

Thanks a lot!