Way to change the user name?

Tell us what you think! This forum is here to serve the Cougar hobby, we need your help to make it better.
Post Reply
ExRseven302
Registered Member
Posts: 19
Joined: 02 Dec 2012, 17:51

Way to change the user name?

#1

Post by ExRseven302 » 02 Dec 2012, 22:03

Is there a way to change your user name? or do I need to delete my account and make a new one, and if so, how do I delete the account?

Thanks
Zana

User avatar
xr7g428
Site Admin
Site Admin
Posts: 4340
Joined: 23 Dec 2010, 21:02
Location: Cave Creek, AZ
Contact:

Re: Way to change the user name?

#2

Post by xr7g428 » 03 Dec 2012, 00:20

Send me a PM with the name you would like to use and I will see if I can figure out how to change it.
Bill Basore, Editor / Publisher
Legendary Cougar Magazine
Currently in the Cat House
'67 XR7 GT 390 4 speed, AC, AM FM, Lime Frost Green
'68 XR7-G 428CJ C6, Tilt-Away, AM, Black Cherry
'68 XR7-G 390 4 speed, Sunroof, Cardinal Red
'68 XR7 GT-E 427 C6 AM Cardinal Red
'68 XR7 resto mod 351W, soon to be AOD, Black Cherry

User avatar
tmh
Registered Member
Posts: 1369
Joined: 15 Oct 2011, 20:09
Location: Chicago

Re: Way to change the user name?

#3

Post by tmh » 03 Dec 2012, 00:57

It would be a simple update query to the table that stores the usernames.

Update [name of the table] set [name of the username field] = '[the new name]' where [name of the username field] = '[the current username]';

Just replace the stuff in brackets with the appropriate names, and don't include the brackets. Need to use apostrophes not quotation marks.
'68 XR-7 J-Code C4, San Jose, Edelbrock 1406, PS, Front PDB, 8" rear 3.0, PS is leaky and sloppy, invisible fan shroud
'79 Bronco XLT 351m, C6, Edelbrock Performer 400 intake, Holley 6140, Howards cam, 4" suspension lift, 33x12.5x15 Duratracs, dana44 front and Ford 9" rear both 4.11 LSD, Warn hub locks, invisible fan shroud
'80 Suzuki GS750E 16V DOHC, looks about 6 months old
'13 Honda CR-V AWD

User avatar
1969eliminator
Registered Member
Posts: 227
Joined: 16 Jan 2011, 00:49
Location: White Rock, BC Canada
Contact:

Re: Way to change the user name?

#4

Post by 1969eliminator » 03 Dec 2012, 10:00

tmh wrote:It would be a simple update query to the table that stores the usernames.

Update [name of the table] set [name of the username field] = '[the new name]' where [name of the username field] = '[the current username]';

Just replace the stuff in brackets with the appropriate names, and don't include the brackets. Need to use apostrophes not quotation marks.
That'll work if there are no Foreign Key Restraints on that field, which is quite likely since it's the primary field in that record and could have numerous other fields attached to it.
1969 Eliminator 351-4V M-code (original owner)

Harry
website: http://harrya.webs.com

User avatar
tmh
Registered Member
Posts: 1369
Joined: 15 Oct 2011, 20:09
Location: Chicago

Re: Way to change the user name?

#5

Post by tmh » 04 Dec 2012, 14:47

I would assume the user name isn't linked to any other tables, that there is something like a USERS table that has the username and other user info but also has a user_ID that's a numeric key with the relationships with other tables, but who knows. I'm sure they can figure it out, regardless.
'68 XR-7 J-Code C4, San Jose, Edelbrock 1406, PS, Front PDB, 8" rear 3.0, PS is leaky and sloppy, invisible fan shroud
'79 Bronco XLT 351m, C6, Edelbrock Performer 400 intake, Holley 6140, Howards cam, 4" suspension lift, 33x12.5x15 Duratracs, dana44 front and Ford 9" rear both 4.11 LSD, Warn hub locks, invisible fan shroud
'80 Suzuki GS750E 16V DOHC, looks about 6 months old
'13 Honda CR-V AWD

User avatar
xr7g428
Site Admin
Site Admin
Posts: 4340
Joined: 23 Dec 2010, 21:02
Location: Cave Creek, AZ
Contact:

Re: Way to change the user name?

#6

Post by xr7g428 » 04 Dec 2012, 15:43

I think it is doable, but no PM yet.
Bill Basore, Editor / Publisher
Legendary Cougar Magazine
Currently in the Cat House
'67 XR7 GT 390 4 speed, AC, AM FM, Lime Frost Green
'68 XR7-G 428CJ C6, Tilt-Away, AM, Black Cherry
'68 XR7-G 390 4 speed, Sunroof, Cardinal Red
'68 XR7 GT-E 427 C6 AM Cardinal Red
'68 XR7 resto mod 351W, soon to be AOD, Black Cherry

ExRseven302
Registered Member
Posts: 19
Joined: 02 Dec 2012, 17:51

Re: Way to change the user name?

#7

Post by ExRseven302 » 04 Dec 2012, 19:04

sorry, got busy, just sent you a pm.

User avatar
xr7g428
Site Admin
Site Admin
Posts: 4340
Joined: 23 Dec 2010, 21:02
Location: Cave Creek, AZ
Contact:

Re: Way to change the user name?

#8

Post by xr7g428 » 04 Dec 2012, 19:08

Done! Feel free to let me know if you need anything or have any suggestions.
Bill Basore, Editor / Publisher
Legendary Cougar Magazine
Currently in the Cat House
'67 XR7 GT 390 4 speed, AC, AM FM, Lime Frost Green
'68 XR7-G 428CJ C6, Tilt-Away, AM, Black Cherry
'68 XR7-G 390 4 speed, Sunroof, Cardinal Red
'68 XR7 GT-E 427 C6 AM Cardinal Red
'68 XR7 resto mod 351W, soon to be AOD, Black Cherry

ttp17
New Member
Posts: 2
Joined: 29 Sep 2017, 11:22

Re: Way to change the user name?

#9

Post by ttp17 » 29 Sep 2017, 11:43

I need to change my user name. How can I do this?

User avatar
jays
Site Admin
Site Admin
Posts: 225
Joined: 23 Dec 2010, 14:16
Location: Oregon, USA

Re: Way to change the user name?

#10

Post by jays » 29 Sep 2017, 12:23

ttp17 wrote:
29 Sep 2017, 11:43
I need to change my user name. How can I do this?
Username changes have to be done by an admin, so you'll need to contact us via the Contact Form with your current username and the one you want to change to. As long as the new username isn't being used by someone else (they have to be unique), we can usually switch you to the new one.
Allergic to Cats

Post Reply