Username Management - Control who can change Usernames plus history

<font size="4">Username Management - Version 1.04</font>

Hack: Username Management
Version: v1.04
Author: MarcoH64

Description
With this modification installed you can let your members change their own username, or let Staff members change the usernames of other members.

Also a history of previously used names for a member is kept.

Features
- Users can change their own username controlled by Usergroup Permissions. If needed a time limit between changes can be set.
- Staff can change the Username of other members. This is again controlled by Usergroup Permissions.
- Previously used Usernames of a member can be viewed in posts, by hoovering over their Username. This is also controlled by Usergroup settings
- Full searchable history of Username changes in AdminCP
- Fully Phrased
- Optimized for server performance
- Documented API for addon developers

Changelog
23-12-2005 v1.04
- Changed master="true" to false in cpnav file.
- Fixed bug where history was generated when running Update User Names from Update Counters

v1.03
- Changed the size of the 'mh_unm_changelimit' & 'mh_unm_changelimit' columns in the usergroup table
from TINYINT to SMALLINT to support values > 255

23-11-2005 v1.02 (maintenance release)
- Improved internal caching routines
- Added internal routine for retrieving the latest changed usernames
- Coders: Parameter value change for parameter '$overridelimit' in 'mh_unm_fetch_username_history'
This release is needed if you want to use some fo the new Addon's!!
Known issues: Coder documentation not complete, no examples are given, although the 2 released addon's can be used as examples.

22-11-2005 v1.01
- Fixed bug messing up Private Messages (thanks mini2)
- Fixed bug in install routine that would create a wrong tablename if using table prefixes
- Changed the internal caching routines
- Added more parameters to mh_unm_fetch_username_history for more flexibility for Addon coders
- Added extended information mode
- Created first version of the Coders documentation
Known issues: No example code for an Addon Plugin yet.

22-11-2005 v1.00
Initial release

Upgrades
Upload all files from 'upload' folder.
Install the new product file, choosing an overwrite install.

Notes
Copyright ©2005 MarcoH64
This Modification may not be redistributed in whole or significant part or changed without prior agreement of author.
Please don't forget to click Install.
If you like this work and would like to support the author, donations are always welcome at Paypal: Marcoh64 AT gmail.com

[Marco van Herwaarden]

Hmmm that looks like a design error. To allow higher values, change the 'mh_unm_changelimit' column of the usergroup table in your database from TINYINT to SMALLINT. Will update this in the next release.

This may be useful for my forum..hm...I will test it out none-the-less.

[WNxWakko]

Originally Posted by MarcoH64

Hmmm that looks like a design error. To allow higher values, change the 'mh_unm_changelimit' column of the usergroup table in your database from TINYINT to SMALLINT. Will update this in the next release.

I have no clue how to do that. Is there a query I can just run from the Admincp?

[Oblivion Knight]

[sql]ALTER TABLE usergroup CHANGE mh_unm_changelimit mh_unm_changelimit SMALLINT(3) UNSIGNED NOT NULL DEFAULT '30'[/sql]Yes, [high]mh_unm_changelimit[/high] should be there twice..

[Marco van Herwaarden]

You can run the following 2 queries:
[sql]ALTER TABLE usergroup CHANGE COLUMN mh_unm_changelimit mh_unm_changelimit SMALLINT UNSIGNED DEFAULT 30 NOT NULL;
ALTER TABLE usergroup CHANGE COLUMN mh_unm_viewhistorylimit mh_unm_viewhistorylimit SMALLINT UNSIGNED DEFAULT 1 NOT NULL;[/sql]
If you are using a table prefix, then add it in front of the tablename (ie. prefix_usergroup).

If you run the queries from the AdminCP, you must run 1 line at a time. If you are using something like phpMyAdmin, you can just copy&paste both lines in 1 go.

[Marco van Herwaarden]

Originally Posted by Oblivion Knight

[sql]ALTER TABLE usergroup CHANGE mh_unm_changelimit mh_unm_changelimit SMALLINT(3) UNSIGNED NOT NULL DEFAULT '30'[/sql]Yes, [high]mh_unm_changelimit[/high] should be there twice..

If you use SMALLINT(3), it will not increase the column size.
SMALLINT defaults to 5 positions.

PS I never understand why people keep quoting numeric default values.

[dieselpowered]

So if someone changes their member name, does it change the member name all all previous posts? Plus I can only assume that the old username will be in quoted posts...correct?

[Marco van Herwaarden]

It will be changed everywhere, except quoted posts.
It uses the standard routines in vB to change the name, the same that is used when changing from AdminCP. Everything that would be changed when doing it from the AdminCP, is also changed with this hack.

It merely builds on top of the standard functions by giving Users and moderators also a place to change the name, and to add logging/reporting to it.

[Snake]

Nice update there...

feature request:

having this History of Usernames to be searchable as "registered users" so if someone wants to register with a username that is in this list, he will not be able to, and will be required to contact the admin if this is an error...

the situation come often when someone register, and not remember his password or complete username, and instead of asking for a new access he register twice... that came at least 3 times here this year only...

something like "this username was once used by a user on this site. if you really need this username, please contact the admins. "... and this can be joined with the Ajax Alert...

[Marco van Herwaarden]

Well that would be something completly different......and for 3 times a year?

But i have been thinking about not allowing a change if a name have been used before.

For example a popular guy on the board, decide to change his name, and a newbee immediate change his name the the popular guys old name.

A lot of people would get confused. Or maybe just no reuse of names for 3 month.

that's the same situation i guess, just not the same start.. lol

[zappsan]

Just installed this on my testboard and I really like it.
Thanks

Just one question:

Sorry, the username entered contains one or more semi-colon characters ( ; ).

Please go back and remove any semi-colons

What's wrong with semi-colons?

[Marco van Herwaarden]

They are not allowed i guess. But that has nothing to do with my hack, it is vB itself blocking it.

[zappsan]

Originally Posted by MarcoH64

They are not allowed i guess. But that has nothing to do with my hack, it is vB itself blocking it.

Oh, ok, thanks for clearing me up.

I've got another problem:
When I allow a usergroup to change names, they can't login into the ModCP anymore.
They click on the "Change name" link, enter username and password in the login window, but instead of logging them in, the login window is displayed again.

Am I doing anything wrong?

edit: I just noticed that the user needs to mod at least one forum to make it work.
Is there a way to change this?