Username Alias Hack (version 2; completely different)

Note:The structure for this hack is COMPLETELY different from the last one. If you have installed the original Username Alias Hack, please revert the changes you made with those installation instructions first. Go Here to see the old hack's info.

Info:Does your forum have a number of admins? Ever look at your forum and see a member with 200+ posts and be like "who is this person? i've seen him/her before, but I don't remember this username" cos they had a name change, and changed their avatar and signature as well? I had this problem a few times. Another administrator changed the member's username and I was stumped. So I had this idea for a hack!

The hack now involves a dropdown list of every previous name, and can be placed anywhere inside of your getinfo template.

Here is an example of this new version:
http://forums.tsa-gaming.com/member....tinfo&userid=1
(Note: this is with some modifications of what I am releasing, but in essence, you see the drop down list there )

Also, the Admin CP is completely different. Attached in the next post is a screenshot of what my Admin CP looks like. (This is exactly the same as what I am releasing has) As you will see, the list of previous aliases is displayed, as well as the ability to delete any alias, even the ability to change the current username to an old alias with ease!

Attached is a text file with the updated instructions. If you installed the previous version, REVERT those changes FIRST.

Thanks, and hope you like this one much more





Possible addition in the near future: Admins can see a button next to the alias dropdown list that will allow them to change the username right there to an older alias?

[Brianna]

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...

[Dean C]

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

[Brianna]

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

[Dean C]

OK thats fine. Good work

- miSt

[Ghostsuit]

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?

[Brianna]

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..

[Hobbes]

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 !

[Hobbes]

03-04-03 at 10:28 AM Ghostsuit said this in Post #15
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?

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:

[Brianna]

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.

[Hobbes]

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.....!!!!!