Register Members List Search Today's Posts Mark Forums Read

Reply
 
Article Options
[vB3/vB4] VERY general SQL query via AdminCP to change usernames in quotes.
Max Taxable
Join Date: Feb 2011
Posts: 3,118

by Max Taxable Max Taxable is offline 25 Jun 2014

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
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.



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:
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Where old name was: Sammy's and new name is: Elliot.


You're welcome.
Views: 6922
Reply With Quote
Comments
  #2  
Old 25 Jun 2014, 15:11
mokujin's Avatar
mokujin mokujin is offline
 
Join Date: Nov 2005
Real name: Đạt
Not tested, but try these ;-D

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
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 ...
Reply With Quote
  #3  
Old 25 Jun 2014, 15:12
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Originally Posted by mokujin View Post
Not tested, but try these ;-D

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.
Those might work too. The one I posted did definitely work.
Reply With Quote
  #4  
Old 25 Jun 2014, 15:14
mokujin's Avatar
mokujin mokujin is offline
 
Join Date: Nov 2005
Real name: Đạt
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 ...
Reply With Quote
  #5  
Old 25 Jun 2014, 15:21
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Originally Posted by mokujin View Post
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?
Reply With Quote
  #6  
Old 21 Jul 2014, 00:30
blind-eddie's Avatar
blind-eddie blind-eddie is offline
 
Join Date: Apr 2006
Real name: Tim
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.
__________________
LONG LIVE 3.8 SERIES
National Arcade Competition Club- NACC All arcade edits will work on vb4.
Check out my heavily modified ibproarcade with over 45,000 games for you, free of charge!
Exclusive arcade addons, edits and skins were made by stangger5 owner of Next Level Arcade
Reply With Quote
  #7  
Old 21 Jul 2014, 02:12
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
Originally Posted by blind-eddie View Post
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.
Reply With Quote
  #8  
Old 21 Jul 2014, 02:17
blind-eddie's Avatar
blind-eddie blind-eddie is offline
 
Join Date: Apr 2006
Real name: Tim
ibProArcade v2.7.2+
__________________
LONG LIVE 3.8 SERIES
National Arcade Competition Club- NACC All arcade edits will work on vb4.
Check out my heavily modified ibproarcade with over 45,000 games for you, free of charge!
Exclusive arcade addons, edits and skins were made by stangger5 owner of Next Level Arcade
Reply With Quote
  #9  
Old 21 Jul 2014, 02:29
Max Taxable's Avatar
Max Taxable Max Taxable is offline
 
Join Date: Feb 2011
I wonder if that is true also for v3 Arcade.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Article Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 21:30.

Layout Options | Width: Wide Color: