Username Alias Hack (version 2; completely different)

[Brianna]

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 (https://vborg.vbsupport.ru/showthread.php?s=&threadid=44001) 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.php?action=getinfo&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]

*Attaching Admin CP Screenshot*

[Boofo]

Instead of a drop down box, how about a pop-up javascript window? It would be a little cleaner and easier to manage. Just a thought.

[N9ne]

Wow, this is a nice hack, however I have PPN's change username hack installed, so I won't be needing this, but those are some nice features you have there, good work, vb.org is getting better and better daily!.

[Dean C]

Yes i agree with Boofo :). A javascript pop-up with a little window might be better :p

Nice hack nevertheless :p

- miSt

[Brianna]

How would a popup window be better? All it means is an extra click when instead it could be right there on the profile, as it is. Sure, you have to click to see all aliases besides the first one, but who's really going to have more than one alias? I put those four aliases in my forums' profile there just for example.

[Mephisteus]

is this easy to adept so it will also add an alias if an user changes it using lesane's store?

Nice hack by the way :)

[Brianna]

Anything regarding integration with the store can found here. (Basically says that I will work on it eventually.)

https://vborg.vbsupport.ru/showthread.php?s=&threadid=48468

[Dean C]

It would be better because a drop-down menu is meant to result in some action in the browser. Having it in this case would be pointless. You can't have it pop-up the old usernames because its been changed so i think a pop-up would be nice :)

- miSt

[Brianna]

Okay, I am thus making the dropdown more efficient. How would it sound if the dropdown was also available to allow the user to change their username back to an older one on their own? Will that fulfill the purpose of a dropdown list enough?

[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 :D

- 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

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

and I got

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

help?



FIXED!

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

[Hobbes]

03-04-03 at 10:28 AM Ghostsuit said this in Post #15 (https://vborg.vbsupport.ru/showthread.php?postid=361060#post361060)
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.....:(!!!!!

[Logo]

hmm same to me...

i can only see the screen above :(