Administrative and Maintenance Tools - Username Request

Introduction
I was looking through the Modification Requests forum here and found a pretty good idea. The basic idea was to add a list of users who would like a name change for the administrators. I added the basics and released it. In consecutive versions I have added the abilities and features you have requested and this is the product. It is morphing into a more powerful, more useful system each and every version.

The Tools

User Tools
Inside the User Control Panel, there is an area that is added where a user is given the ability to submit a username that they would like their name changed to. They receive PM updates depending upon the "status" of their request, whether it is Accepted or Rejected.

Administrative Tools
As soon as a request is added to the database, the specified administrator is sent an e-mail saying that a user would like a username request. Inside the Administrators Control Panel, a new section is added under the "Users" navigation tab, that lists all the "Pending" requests with the ability to "Reject" or "Approve" the request. A user will be notified via PM when an action is taken. When a username is approved, the system will automatically change the username.

Username History
This tool will list all username changes that a user has requested. It will also display the status of the request, meaning that if you reject it, this will be displayed. This tool will be built upon in a later version.

Username History Changes:
In the next version, the status of a username change request has been revamped and no longer includes hard-coded "Accepted", "Rejected", and "Requested" status values. More information will be given at the release of v1.1.0!

Requirements
This hack has several requirements. They include:

• vBulletin v3.6.6 or higher (This is the minimum version required for the next requirement)
• The usercp_nav_bottom template hook.

To get around the second requirement, you can copy the cell manually or add $template_hook[usercp_navbar_bottom] at the end of the User Control Panel navigation.

Installation
Installing the product is easy. Just follow these steps:

1. Upload Files into your Administrators Control Panel directory.
2. Import the product through the Product Manager.
3. Click Install Here

Known Bugs:

1. No e-mail is sent out to users upon username change. Fix: The next version will include a fix that will respect all the users settings on receiving e-mail from administrators.
2. The setting for PM sender was ignored within the code and uses the userid of the administrator who changed the username through the administration back-end. Fix: In the next version, revamped settings and improved back-end will now properly use a setting similar to this.

Big Thanks!
I would like to give a big thanks to Paul M for helping me with my stupid mistakes in v1.0.4 - v1.0.6! Now all of my mistakes should be taken care of (unless I made a mistake in the disallowed if statement). Thanks Paul!

I would also like to say thanks to Marco for pointing out a possible SQL Injection that was in v1.0.4 - v1.0.6 (It was inside the ACP, and used a wrong variable name / clean type).

And to Dannyloski for fixing my modification on his forum and providing the fix here. Much faster than I did it.

Final Remarks
I hope that you will enjoy this product as much as I enjoyed making it.

[JulianD]

I would definitely use this if you add the Change Amount Limitation feature to this hack!

Thanks though.

[King Kovifor]

Working on that...

[inciarco]

Great Hack, King Kovifor!! :up:

Mod Works Great!! User Name Changes Are Done Succesfully!! :up:

Three little Bug (I Think)!!

When Trying to See the "Username History", Appears "No history to be found", even When I've Made 4 Changes On That User. (That's The First Bug)!!

EDIT 2: Perhaps The Hack Could be Trying to Look for the Previous (Changed) Username Instead of the New Changed Username?? (Could Be Better To Reference Them By the User Unique Number Code, and also Present that Code in an Additional Column)!!

I Copy/Paste the Table of Username Requests:

Requests 
Username Nuevo Nombre de Usuario Solicitado Date Actions 
foros foros1 06:34 PM, 25-10-2007 Approve - Reject - Username History 
foros1 foros 06:40 PM, 25-10-2007 Approve - Reject - Username History 
foros foros2 06:42 PM, 25-10-2007 Username History 
foros2 foros3 06:43 PM, 25-10-2007 Username History

I've made 4 Changes to the Username of a User called foros; first to foros1, then to foros (again), then to foros 2, and then to foros3.

When I made the second change back to foros (from foros1), the Approve/Reject Links Activated to Both Previous Requests (Even When I've Approved Them Both)!! (That's The Second Bug)!!

EDIT 1: Another Bug I Found after writing this Message, is that When seeing the "Username History Tip", when I've got the "Username History - No history to be found." Result, and when I tried Introducing the "Months" value in the option "Username History Tip", and pressed the Button "Refine Your Search!", I've got the Error Result "Error - No username was specified.", even when I've been trying to see the Results for Username "foros". (The one of the Previous described Bugs). (That's The Third Bug)!!

I Hope You Can Test This Great Hack and Correct Those Little Bugs!!

Great Hack!! Process of Changing Usernames is Great and Very Fast!! Communication of Final Results is Automatic and Very Easy!! Thank You Very Much!! :up:

My Best Regards!!

[inciarco]

One Little Question: How do Users Check The History Changes They've Made??

I've set the Option "Can View Username History" to "Yes", but I Haven't Been Able To Locate The Link for the User To Check Those Changes!!

I Appreciate Your Help!!

My Best Regards!! :up:

[Ryloth]

has anyone tested on 3.6.4 ? i see the min req, but just wondering b/c i dont have plans on updating anytime soon.

[King Kovifor]

Originally Posted by inciarco

Great Hack, King Kovifor!! :up:

Mod Works Great!! User Name Changes Are Done Succesfully!! :up:

Three little Bug (I Think)!!

When Trying to See the "Username History", Appears "No history to be found", even When I've Made 4 Changes On That User. (That's The First Bug)!!

EDIT 2: Perhaps The Hack Could be Trying to Look for the Previous (Changed) Username Instead of the New Changed Username?? (Could Be Better To Reference Them By the User Unique Number Code, and also Present that Code in an Additional Column)!!

I Copy/Paste the Table of Username Requests:

Requests 
Username Nuevo Nombre de Usuario Solicitado Date Actions 
foros foros1 06:34 PM, 25-10-2007 Approve - Reject - Username History 
foros1 foros 06:40 PM, 25-10-2007 Approve - Reject - Username History 
foros foros2 06:42 PM, 25-10-2007 Username History 
foros2 foros3 06:43 PM, 25-10-2007 Username History

I've made 4 Changes to the Username of a User called foros; first to foros1, then to foros (again), then to foros 2, and then to foros3.

When I made the second change back to foros (from foros1), the Approve/Reject Links Activated to Both Previous Requests (Even When I've Approved Them Both)!! (That's The Second Bug)!!

EDIT 1: Another Bug I Found after writing this Message, is that When seeing the "Username History Tip", when I've got the "Username History - No history to be found." Result, and when I tried Introducing the "Months" value in the option "Username History Tip", and pressed the Button "Refine Your Search!", I've got the Error Result "Error - No username was specified.", even when I've been trying to see the Results for Username "foros". (The one of the Previous described Bugs). (That's The Third Bug)!!

I Hope You Can Test This Great Hack and Correct Those Little Bugs!!

Great Hack!! Process of Changing Usernames is Great and Very Fast!! Communication of Final Results is Automatic and Very Easy!! Thank You Very Much!! :up:

My Best Regards!!

The username history should be greatly improved (hopefully fixing these bugs) and a new feature will fix approval of both...

Originally Posted by inciarco

One Little Question: How do Users Check The History Changes They've Made??

I've set the Option "Can View Username History" to "Yes", but I Haven't Been Able To Locate The Link for the User To Check Those Changes!!

I Appreciate Your Help!!

My Best Regards!! :up:

Username History is attached inside the profile pages.

Originally Posted by Ryloth

has anyone tested on 3.6.4 ? i see the min req, but just wondering b/c i dont have plans on updating anytime soon.

Yeah. It works. You just need to manually add the template cell instead of having template hooks. I could write up instructions later for you.

[anwar.abdullakh]

when I request username and press submit...
i get the following error...

Fatal error: Cannot use object of type vB_DataManager_User as array in /home/forum/www/profile.php(2886) : eval()'d code on line 33

[King Kovifor]

Originally Posted by anwar.abdullakh

when I request username and press submit...
i get the following error...

Fatal error: Cannot use object of type vB_DataManager_User as array in /home/forum/www/profile.php(2886) : eval()'d code on line 33

I don't know what is causing this, but I will look into it.

[benFF]

A little request, but it would be cool if a user could type in a reason for the username change which is also listed in the table

[King Kovifor]

Originally Posted by benFF

A little request, but it would be cool if a user could type in a reason for the username change which is also listed in the table

This may be added in v1.1.0!