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.

[puroeuro]

if i did decide to run the SQL what conditionals would i need to be looking for?

[King Kovifor]

You would need to know your ID and the status.

[m002.p]

Originally Posted by puroeuro

if i did decide to run the SQL what conditionals would i need to be looking for?

If you have phpmyadmin access to the forum database, take a peak there. It might be easier to visually see what needs doing or changing with an interface than running SQL queries that you might not be too familar with or even worse, could cost you dearly.

[King Kovifor]

v1.1.0 is coming along nicely. I need to do a few major things like:

Limitations
Allowing One Request Per Time

I am working on phrasing now and Allowing one request per time will be next. Should have a release soon enough.

[djbaxter]

I think I may have already asked this but is there anyway to move the menu item out of "Moderated Items" to "Details" in UserCP?

[King Kovifor]

Originally Posted by djbaxter

I think I may have already asked this but is there anyway to move the menu item out of "Moderated Items" to "Details" in UserCP?

Hm?

[djbaxter]

See menu1 attached with "Request Username" way down at the bottom under Moderated Items".

I'm asking if it can be placed near "Edit Details" or "Edit Options" where it's easier for members to find it - see menu2, attached.

[King Kovifor]

Originally Posted by djbaxter

See menu1 attached with "Request Username" way down at the bottom under Moderated Items".

I'm asking if it can be placed near "Edit Details" or "Edit Options" where it's easier for members to find it - see menu2, attached.

Unless they added template hooks, it's stuck down there.

[inciarco]

Gread Mod. :up:

I've Noticed that Once a Username is Used even if it has been Changed and is Free to Use (No User has it), the Mod don't Allow to Use that Name Again (even if is Available). Is important to Perfect the Hack so that if the Username is Available and No User has Requested It (Is in the List of Requests), the Mod Allows the User to Ask for that Username; right now the User Gets a "Violation of Rules" Message.

I've also noticed that is Important to Perfect the Process of Acceptance of Usernames, because I've made the Simulation of a Username to be Requested and before the Admin being Able to Approve it another User Creates an Account with that Name (I changed an Existing Account Username to Simulate that), when doing the Approval Process the Mod generates an Error Message, Don't Send any PM, and don't Apply the Change (that's the Good News), but the Process gets Stopped Suddenly and the Mod don't Allow a Good Exit (like a Window Informing about the Current Existance of the Username, and of course Denying the Change and Sending the PM to the User noticing the Reject of the Request).

I Hope those 2 Little Bugs can be Solved on the Next Release, this is a GREAT MOD, I've Nominated it for MOTM because in all Boards the Changing of Usernames is Asked and this Mod simplifies that Process a lot.

One More Thing (3): Is it possible to Update it to vB3.7.3?? The Process gets done but the Profile Information about Usernames Changes can't be shown because of the Changes vBulletin made on the Member Profile Page.

My Best Regards, and Again Thank You for Sharing this Great Mod.

[King Kovifor]

Originally Posted by inciarco

Gread Mod. :up:

I've Noticed that Once a Username is Used even if it has been Changed and is Free to Use (No User has it), the Mod don't Allow to Use that Name Again (even if is Available). Is important to Perfect the Hack so that if the Username is Available and No User has Requested It (Is in the List of Requests), the Mod Allows the User to Ask for that Username; right now the User Gets a "Violation of Rules" Message.

I've also noticed that is Important to Perfect the Process of Acceptance of Usernames, because I've made the Simulation of a Username to be Requested and before the Admin being Able to Approve it another User Creates an Account with that Name (I changed an Existing Account Username to Simulate that), when doing the Approval Process the Mod generates an Error Message, Don't Send any PM, and don't Apply the Change (that's the Good News), but the Process gets Stopped Suddenly and the Mod don't Allow a Good Exit (like a Window Informing about the Current Existance of the Username, and of course Denying the Change and Sending the PM to the User noticing the Reject of the Request).

I Hope those 2 Little Bugs can be Solved on the Next Release, this is a GREAT MOD, I've Nominated it for MOTM because in all Boards the Changing of Usernames is Asked and this Mod simplifies that Process a lot.

One More Thing (3): Is it possible to Update it to vB3.7.3?? The Process gets done but the Profile Information about Usernames Changes can't be shown because of the Changes vBulletin made on the Member Profile Page.

My Best Regards, and Again Thank You for Sharing this Great Mod.

What error message do you receive? And I see no reason why the modification would not allow you to request a username if it isn't there. Has there been a name that was originally that?