Done. Attached is the update to allow the user to change their name to a previous alias.

NOTE: This is ONLY to change to a previous alias, not change the username entirely. And I am posting the version here instead of updating the database version cos some may not want a user to have that ability...

Ok i may have misinterpreted this but if they change they're dropdown in their profile it changes back. Surely this leaves the door open for other users to change this users username back?

- miSt

Nope, it does a check to see that the logged in user is the user who "owns" the profile first.

Try it on my example profile, it will tell you that you do not have permission to access it. However, if I do so while logged in, it will allow me to do so :)

OK thats fine. Good work :D

- miSt

Know if this works in 2.3.0 RC3? I've tried installing and nothing happens when I change a username. Any ideas what I've done wrong or does it jsut not work?

I've never even used 2.3.0, sorry. I used 2.2.8 for this... I am not sure how much a difference in code there is there, but if you found all the stuff it asks you to replace and add above/below, then more than likely it should.. in that case chances are you didn't install it properly..

i was told to run

[sql]CREATE TABLE `useralias` ( `userid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, `alias` VARCHAR(50) NOT NULL ); [/sql]

and I got

[sql]Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: CREATE TABLE `useralias` ( `userid` INT(10) UNSIGNED DEFAULT '0' NOT NULL, `alias` VARCHAR(50) NOT NULL );
mysql error: You have an error in your SQL syntax near '; ' at line 1

mysql error number: 1064[/sql]

help?



FIXED!

thanks to Xenon...I R illiterate :(!

Dittoness....i installed this on a 2.2.6...and when i change it in the admin cp, nothing shows.....and nothing shows in the getinfo template either.....

*requests help*

pwwease? :bunny:

I will install a fresh 2.2.6 (if I have it) sometime soon and install my hack and see if it works, if it does then you more than likely made a mistake on installation. If it doesn't, then I will see what the problem is with this version :) And I will both PM you and post here.

Well....you said reinstall it....i did...and I still (1) have nothing show in getinfo....

and (2) nothing happens in admin cp see screenie.....:(!!!!!