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 FireFish

Seriously, King Kovifor;

Can we expect a 1.0.7 that works? I know you replied to my post that many people have it working fine; i just wish they posted here in this thread so that we can get advice as to how they got it working.

I, like everyone else here, is stuck at the Usergroup Permissions Error, whether the group does or doesn't have the permissions to change username. I tried running the SQL too, nothing.

Can you please do us all a great service by making a 1.0.7 that works?

Maybe strip out features since 1.0.4; as the 1.0.4 worked fine.

:up: ---->Can you at least PM me & maybe e-mail me a copy of 1.0.4 so that I can get it working for now until these issues are resolved?

I would be very greatful if you could at least send me the 1.0.4 or post a download link for it so I can uninstall & reinstall it knowing it'll work for now.

Thanks again! I appreciate your efforts in developing this mod.

My Permissions errors were in the way I was checking it. The way I wrote the code (and misinterpreted how the bit fields work), it was always going to come out as a "1", returning true. This gave the results your gave.

Paul M pointed out all my mistakes and how to fix it, meaning that it should work, and I 99.99% sure that this will work. I think if it doesn't, I will ask someone to come on board for permissions who knows how to do them.

[FireFish]

Originally Posted by King Kovifor

My Permissions errors were in the way I was checking it. The way I wrote the code (and misinterpreted how the bit fields work), it was always going to come out as a "1", returning true. This gave the results your gave.

Paul M pointed out all my mistakes and how to fix it, meaning that it should work, and I 99.99% sure that this will work. I think if it doesn't, I will ask someone to come on board for permissions who knows how to do them.

Hallelujah! Uninstalled the mod, Downloaded today's 1.0.7, uploaded new files & installed.

**** It works!!!! ****

Thanks King!

[King Kovifor]

Your welcome. And I feel like an idiot for actually making the mistakes. Glad these worked. I hope to expand on the actual feature set, permissions, and ease of use on everyone in v1.1.x! Any feature suggestions would be welcomed!

[Kaleem]

Invalid SQL:
ALTER TABLE `usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'unreq_perms'
Error Number : 1060

I get thsi error when i try to upgrade

[GekkoPixie]

Originally Posted by LightInClouds

Invalid SQL:
ALTER TABLE `usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'unreq_perms'
Error Number : 1060

I get thsi error when i try to upgrade

Same here.

[SuperTaz]

Edit: Found the issue

[FireFish]

Originally Posted by LightInClouds

Invalid SQL:
ALTER TABLE `usergroup` ADD `unreq_perms` INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

MySQL Error  : Duplicate column name 'unreq_perms'
Error Number : 1060

I get thsi error when i try to upgrade

Try uninstalling the previous version altogether first. Then, install fresh.

[FreshFroot]

just a nice feature would be if anytime a username is changed, it saves the old username in their user notes, each time they have their names changed.

[jellybaby]

Sorry but it still doesnt work for me, I have the permissions problem

Just to say I have uninstalled and re-installed new version and checked permissions several times.

[BigDog56]

Installed the mod, no problems. Now I'll have to wait for someone to request a change before I know it's working without a hitch. Nice mod. Thank you very much for the time you spent creating it! :up: