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]

Originally Posted by MThornback

It created the history table without the table prefix as well...thought you'd care to know....

Thanks for this, I somehow missed the table_prefix on that create statement. Fixed in my copy now, will update zip later today.

Originally Posted by MThornback

For some reason, (and I had posted something else before (sorry...but I am still fairly sure that the $ was missing from the db variable )

Could you please be more specific, i couldn't find a missing $ in the install code (or was it somewhere else?)

Originally Posted by MThornback

But I installed it anyway and it seems to work fine now

Then please click Install.

[MThornback]

Originally Posted by MarcoH64

Thanks for this, I somehow missed the table_prefix on that create statement. Fixed in my copy now, will update zip later today.


Could you please be more specific, i couldn't find a missing $ in the install code (or was it somewhere else?)

Then please click Install.

I did forget to clickinstall didn't I...whoops

all your db variables that you need to write changes to the database were missing their "$" in front of it

ie I changed:

$vbulletin->db->query_write
		(	"ALTER TABLE " . TABLE_PREFIX . "usergroup ADD column (mh_unm_permissions INT( 10 ) UNSIGNED DEFAULT 0 NOT NULL
		,	mh_unm_changelimit TINYINT UNSIGNED DEFAULT 30 NOT NULL
		,	mh_unm_viewhistorylimit TINYINT UNSIGNED DEFAULT 1 NOT NULL
	)"
	);

to

$vbulletin->$db->query_write
		(	"ALTER TABLE " . TABLE_PREFIX . "usergroup ADD column (mh_unm_permissions INT( 10 ) UNSIGNED DEFAULT 0 NOT NULL
		,	mh_unm_changelimit TINYINT UNSIGNED DEFAULT 30 NOT NULL
		,	mh_unm_viewhistorylimit TINYINT UNSIGNED DEFAULT 1 NOT NULL
	)"
	);

and thats the only way it wrote to my tables...

[jugo]

Thank you sir.

[Marco van Herwaarden]

Originally Posted by MThornback

all your db variables that you need to write changes to the database were missing their "$" in front of it

There should be no $ in front of 'db', there is already 1 in front of vbulletin ($vbulletin->db->....)

[Marco van Herwaarden]

Originally Posted by mini2

OK, I only use legacy, and I've installed this and it seems to work OK, BUT, private messages are screwed. So I'm guessing it's postbit(legacy) related.

Please disable the product, i will find what is causing this and uplaod an update.

[Marco van Herwaarden]

Fix for the Private Message problem posted in Post #2. Thansk to mini2 for finding the problem and also providing a quick fix.

[MThornback]

Originally Posted by mini2

Just to let you know, removing the postbit (legacy) template change didn't fix it, but disabling the product did.

*/ edit /*

In fact, I can (of course) leave the product enabled and just disable the plugin for showing it in postbit(legacy) and everything else works swimmingly.

*/ edit again /*

Fixed it, PM sent.....

Turning off the legacy plugin fixed my problem too...

Found something else...

Fatal error: Call to a member function on a non-object in /public_html/forum/includes/class_dm_user.php(1719) : eval()'d code on line 5

when I tried editing via the profile link (changes it...no record to the database though) & when I made an edit to change it back from the AdminCP...same error

a) the .com part isn't included...i'm no expert...so exuse my ignorance when I say "why?"
b) class_dm_user.php wasn't in my install package

[Marco van Herwaarden]

Originally Posted by MThornback

Fatal error: Call to a member function on a non-object in /public_html/forum/includes/class_dm_user.php(1719) : eval()'d code on line 5

when I tried editing via the profile link (changes it...no record to the database though) & when I made an edit to change it back from the AdminCP...same error

a) the .com part isn't included...i'm no expert...so exuse my ignorance when I say "why?"
b) class_dm_user.php wasn't in my install package

What vB version are you using?
Are you using table prefix?

[Marco van Herwaarden]

New version 1.01 released:

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.

[dcpaq2xx]

Originally Posted by Aftermath

Awesome. I am definitely going to install this hack for all my premium users too! Thanks.

One thing, do you think you can make a mini addon for Previous usernames too? That would be useful so users may notice the user's previous names anytime, just like this forum. http://forums.adventchildren.net/member.php?u=1

Yes, I have to agree as well that that is somewhat similar to what Ebay.com does and had suggested in my original request for this User Name Historty Plugin. It would be great to have it setup something like or exactly like what Aftermath showed us in that link to that users profile. I wouldnt want this feature in the forums, ONLY IN THEIR PROFILE. please keep the "hover effect" like MarcoH64 already has it.

Doug