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.

[King Kovifor]

Originally Posted by toddos

hi,

if i insert a new username and send it, it shows me this sql error:

Whats wrong ? Why doesnt it insert the userid ?

Database error in vBulletin 3.7.0 Beta 4:

Invalid SQL:
INSERT INTO vb7pm (pmtextid, userid) VALUES (29322, );

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
Error Number  : 1064

toddos,

I have never tested this with vBulletin v3.7.0 Beta X, so there are bound to be problems. As of right now, I don't have a test forum that is running v3.7.0. I cannot check out the problem for a while.

Originally Posted by solidlink

How do you click "Install Here" ? I dont really understand this part... i have already imported it using the product mgr.

Clicking "Install" on vBulletin.org shows me that you "have" the product installed and it allows me to provide better support (by only doing it with people who press it if wanted).

[Deadly Assassin]

Brilliant, thankyou

[scoobasteve]

Great hack!!

I'd like to request a feature. I don't know if it has been asked yet, but here it is:

I could see many users abusing this great feature by requesting a new username everyday.

What I'd like to see is this: If a user requests a new username, the following happens:

1. If his request got rejected, he has to wait another XX days before he can request for a new one (time is adjustable in the ACP).

2. If it got accepted, he has to wait YY days before he can change it again. (again, adjustable in ACP).

Also, when the user goes to the page, display a warning that echoes the above ("Warning: if you request a new name, you will have to wait 6 months before you can request for a new one")

Yay?

[King Kovifor]

I have the code for that in a version that i have been working on. I just can't Finish it because I can't access my data.

[BBF]

are you convert this mod to 3.7?

it's works ok..(change the username but sometimes doesn't send pm)
it's the only problem that i was found.

[King Kovifor]

Yes, I plan on conversion. My local setup still isn't back to normal and I don't have access to vB3.7 right now.

[aeturner89]

I have suggestion. It would be nice if you can be able to set time limits between name changes. Like say I want to allow only 1 name change per 6 months. If they try to change it sooner they get an error message saying they must wait until [insert date here].

[xcesiv]

i got a heap of errors when extracting this file.

so havnt installed it

[King Kovifor]

Originally Posted by xcesiv

i got a heap of errors when extracting this file.

so havnt installed it

What kind of errors?

[Chris Sotier]

It says that the users dont have permission how I fix it?