[vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes.

[mokujin]

Not tested, but try these ;-D

PHP Code:

UPDATE post SET pagetext = REPLACE(pagetext, 'Sammy\'s', 'Elliot') 

PHP Code:

UPDATE post SET pagetext = REPLACE(pagetext, "Sammy's", "Elliot") 

[Max Taxable]

Originally Posted by mokujin

Not tested, but try these ;-D

PHP Code:

UPDATE post SET pagetext = REPLACE(pagetext, 'Sammy\'\'s', 'Elliot') 

PHP Code:

UPDATE post SET pagetext = REPLACE(pagetext, "Sammy's", "Elliot") 

Those might work too. The one I posted did definitely work.

[mokujin]

Oh wait, I thought you need help, but this is a how-to ;-))

[Max Taxable]

Originally Posted by mokujin

Oh wait, I thought you need help, but this is a how-to ;-))

Yep I had used this query before and never had problems. When it kicked the syntax error this morning, it took me a bit to figure out why.

So, just thought I would share in case anyone else wants to globally change quoted usernames, and needs a query to do it.

I smell a Hack coming here, one that does this automatically any time you change a username?

[blind-eddie]

Would you happen to know what query to run to change username in other areas that do not change when a new name is applied?

--------------- Added [DATE]1405906738[/DATE] at [TIME]1405906738[/TIME] ---------------

Never mind, I went into the database and changed the names that needed changed in the areas that did not change the users name.

[Max Taxable]

Originally Posted by blind-eddie

Would you happen to know what query to run to change username in other areas that do not change when a new name is applied?

What areas are those, just out of curiosity. PMs quoted? Can add what you've figured out, to the article.

[blind-eddie]

ibProArcade v2.7.2+

[Max Taxable]

I wonder if that is true also for v3 Arcade.