![]() |
|
Article Options |
[vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes.
by
![]() You gave someone a username change. Great, but his old username is still in all places where he was quoted in the past. Run this query in AdminCP, replacing with actual usernames
BUT: if there exists a apostrophe in the old username, the DB will think that's the end of the string and will kick a syntax error. Therefore where apostrophe exists in either username, double it, as such: '' Example:
Where old name was: Sammy's and new name is: Elliot. You're welcome. ![]() The following members like this post: blind-eddie, Alan_SP
|
||||||||
Views: 8075
|
Comments |
#2
|
||||||||
|
||||||||
Not tested, but try these ;-D
__________________
I am on holiday (18 Jan to 14 Feb), so I can't complete your requests in time, sorry guys, hope next time you still hire me. Thanks PM me for custom paid modifications for your vB3/vB4 forums ... ![]() No members have liked this post.
|
#3
|
||||||||
|
||||||||
Originally Posted by mokujin
Those might work too. The one I posted did definitely work.![]()
![]() No members have liked this post.
|
#4
|
||||
|
||||
Oh wait, I thought you need help, but this is a how-to ;-))
__________________
I am on holiday (18 Jan to 14 Feb), so I can't complete your requests in time, sorry guys, hope next time you still hire me. Thanks PM me for custom paid modifications for your vB3/vB4 forums ... ![]() The following members like this post: Max Taxable
|
#5
|
||||
|
||||
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? No members have liked this post.
|
#6
|
||||
|
||||
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 21 Jul 2014 at 01:38 --------------- Never mind, I went into the database and changed the names that needed changed in the areas that did not change the users name.
__________________
![]() National Arcade Competition Club- NACC All arcade edits will work on vb4. Check out my heavily modified ibproarcade with over 50,000 games for you, free of charge! Exclusive arcade addons, edits and skins were made by stangger5 owner of Next Level Arcade No members have liked this post.
|
#7
|
||||
|
||||
What areas are those, just out of curiosity. PMs quoted? Can add what you've figured out, to the article.
No members have liked this post.
|
#8
|
||||
|
||||
ibProArcade v2.7.2+
__________________
![]() National Arcade Competition Club- NACC All arcade edits will work on vb4. Check out my heavily modified ibproarcade with over 50,000 games for you, free of charge! Exclusive arcade addons, edits and skins were made by stangger5 owner of Next Level Arcade The following members like this post: Max Taxable
|
#9
|
||||
|
||||
I wonder if that is true also for v3 Arcade.
No members have liked this post.
|
![]() |
«
Previous Article
|
Next Article
»
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Article Options | |
|
|
New To Site? | Need Help? |
All times are GMT. The time now is 06:11.