Username Alias Hack

VERSION 2 IS OUT

http://www.vbulletin.org/hacks/index...ack&hackid=993

ONLY use this thread to get the instructions to revert them if you had installed this version.





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!

Anyways, here's what it does:

In the User Profile, it will display right beside "Search for user's posts." a list of "Aliases" which is what their previous usernames were, if they were changed at all.

Go here for an example of that (this is my profile at my forum): http://forums.crystaldimensions.com/...tinfo&userid=2

-also-

In the Admin CP, there will be an extra field for updating a User Profile, called "Aliases." You can change the Aliases field, but you don't have to, cos the script I wrote automatically appends the old username to that list of aliases. Also, it detects and deletes duplicate entries. Such as if your username is being changed back to "Person" and it was that before, and is now in the Aliases field, it will automatically be taken out of the aliases list. It does one other thing, it only allows a character limit of 70 characters in the list of aliases, but does not end the list with a chopped up username or a comma, instead it cuts off the end of the list to the last comma. If you update the aliases field manually, and the username at the same time, it will override the auto-update and it will update the aliases field to what you entered yourself.

Attached is a text file of the installation instructions! Hope you like it!

[Chris M]

Wow...

This looks cool

Satan

[Goldknight]

I like this hack, good job

/me install because this hack is including support...

[darkmaninc]

what's the proper sql query to add a new field into a existing table ??

[Velocd]

Originally posted by darkmaninc
what's the proper sql query to add a new field into a existing table ??

Run this query:
ALTER TABLE user ADD alias varchar(100) not null;

[darkmaninc]

ah yeah doh.... knew there was something i kept missing ....lol
hard to think with a headache...
Thanks Velocd :banana:

[Velocd]

I forgot to mention that this is a pretty cool hack. I might even consider allowing username-changes on my forum now because of it.

Another good addition of a hack to create would be one that logs all the users custom-titles they might have made. I may code this later on tonight if nobody beats me to it

[Brianna]

Thank you everyone, this is my first hack i've ever made ^_^;

Any suggestions of improvement to make it even better, please let me know

[UltimaKing]

Very nice!

[Brianna]

oh, and I forgot to mention, a good purpose for manual entering of the alias field is when say a user changes their username to something really similar, but still different, it will auto add to the alias field anyways

like, a user at my forums has "seven" in his username, and he had it changed to "se7en" no real need for "seven" to be in the aliases field, lol