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.

[Dannyloski]

Getting an error when extracting the .ZIP File, I want to install this so bad on my Forums, can you reupload the .ZIP? Oh and quick question, where does the "Username Change History" display for the particular user, in their Profile?

[Charlie98902]

Originally Posted by Dannyloski

Getting an error when extracting the .ZIP File, I want to install this so bad on my Forums, can you reupload the .ZIP? Oh and quick question, where does the "Username Change History" display for the particular user, in their Profile?

Try again I just downloaded it and extracted it just fine.

[Dannyloski]

Installed now ... There was an error I got when extracting, but the files were all intact, so I did the installation fine ... Awesome Hack!

[Dannyloski]

I have a couple of questions regarding this Hack, any help would be appreciated. Thanks.

1. How can I delete a certain username change from the "Username History" box for a particular user.
   
   
2. Is it possible to make the "Username History" box display ONLY "Approved" Username Changes?
   
   
3. Is there any news on when the "Reason" feature for a Username Change Request will be added? It would be a nice addition if it would display in the PM sent to the Admin or in the AdminCP under the corresponding username change request.

[Andyrew]

I have this installed and working fine, but the only problem i can see is that some users will get confused when their name is changed if not online while the whole process takes place.
What if they log off after a change name request, when they come back to log in they will be typing their old user name.
Once they realize the name must have changed they log in with the new name and get a PM telling them the new name has been accepted. (it's a bit late by then)
Does this mod send out an email to the user to let them know about the name change, otherwise i can see many users coming back to forums after a few days and wondering why they cannot log in.

[m002.p]

I have a couple of questions regarding this Hack, any help would be appreciated. Thanks.

1. How can I delete a certain username change from the "Username History" box for a particular user.

2. Is it possible to make the "Username History" box display ONLY "Approved" Username Changes?

3. Is there any news on when the "Reason" feature for a Username Change Request will be added? It would be a nice addition if it would display in the PM sent to the Admin or in the AdminCP under the corresponding username change request.

I copy that ^^^ & as previously mentioned by myself; would love to see that option to "allow more than one admin to be able to recieve the username request PM" set in the admin cp options.

Any expected date for the new version?

[King Kovifor]

Originally Posted by BellyBelly

Can someone please explain this to me - which template do I need to check and what code needs to be there? My standard vanilla VB has the username request, just not my custom one which 99% of members use...

I may have been answering for a different hack. This hack should be within the User CP Shell template (with $template_hook[usercp_nav_bottom] as the hook).

[King Kovifor]

Originally Posted by Dannyloski

I have a couple of questions regarding this Hack, any help would be appreciated. Thanks.

1. How can I delete a certain username change from the "Username History" box for a particular user.
2. Is it possible to make the "Username History" box display ONLY "Approved" Username Changes?
3. Is there any news on when the "Reason" feature for a Username Change Request will be added? It would be a nice addition if it would display in the PM sent to the Admin or in the AdminCP under the corresponding username change request.

1. You could manually remove it through SQL queries, as their is no built in function. I will add this to the next version.
2. I could make this an option in the next version.
3. The reason feature should be a next version update.

Originally Posted by Andyrew

I have this installed and working fine, but the only problem i can see is that some users will get confused when their name is changed if not online while the whole process takes place.
What if they log off after a change name request, when they come back to log in they will be typing their old user name.
Once they realize the name must have changed they log in with the new name and get a PM telling them the new name has been accepted. (it's a bit late by then)
Does this mod send out an email to the user to let them know about the name change, otherwise i can see many users coming back to forums after a few days and wondering why they cannot log in.

I have been told about that and forgot to put it in the last version, and with school / soccer / band / life it's been hard to code lately.

Originally Posted by m002.p

I copy that ^^^ & as previously mentioned by myself; would love to see that option to "allow more than one admin to be able to recieve the username request PM" set in the admin cp options.

Any expected date for the new version?

Nope. I try not to give out dates and I'm working on allowing more than one administrator to get e-mails.

[Dannyloski]

King Kovifor, thanks for answering my questions. Could you please tell me which SQL Query to run to delete a certain username change from the "Username History" box for a particular user? I would highly appreciate it, thanks. Also, I really look forward to the Next Version release which will contain those things I was asking about by default. I'll keep a look out on this Thread to see when it comes out. I saw in the above post that you dont have an expected date set in mind for the next release, but could you say maybe like a couple of days, weeks, or months? Just curious. Thanks!

[King Kovifor]

Originally Posted by Dannyloski

King Kovifor, thanks for answering my questions. Could you please tell me which SQL Query to run to delete a certain username change from the "Username History" box for a particular user? I would highly appreciate it, thanks. Also, I really look forward to the Next Version release which will contain those things I was asking about by default. I'll keep a look out on this Thread to see when it comes out. I saw in the above post that you dont have an expected date set in mind for the next release, but could you say maybe like a couple of days, weeks, or months? Just curious. Thanks!

Your welcome. I need to revisit the table (i believe you could remove the ID of the request, but not sure...). And not really. If I get a good day to code stuff, it could be tomorrow, but with the current time crunch I have, that could be three weeks from now. So not definite date.