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

[GoldenChaos]

I took the plunge and installed it - it works 100% perfectly with vB 3.7.1 Patch Level 1. My users are thoroughly enjoying this hack! It was a breeze to install and set up ... and with a six month time limit between name changes, I don't think anybody will be changing it to anything silly anytime soon.

[Shazz]

Originally Posted by GoldenChaos

I took the plunge and installed it - it works 100% perfectly with vB 3.7.1 Patch Level 1. My users are thoroughly enjoying this hack! It was a breeze to install and set up ... and with a six month time limit between name changes, I don't think anybody will be changing it to anything silly anytime soon.

Still has many bugs but for a 3.5 hack going to 3.7+ is still amazing that it runs without any updates

[pokesph]

would love to see an update of this.. it's breaking every time we update vB currently some functions aren't working on 3.7.1PL1

If anyone has 'fixed' this for their board, how about a detailed post of what all you did

[SAWASCI]

please update for 371pl1

[bada_bing]

I have just installed this and when I try and change the usergroup permission on this I get this database error please help

Database error in vBulletin 3.5.3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Administrators',
	`description` = '',
	`usertitle` = 'Administrator',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`anymediapermissions` = '3',
	`ecdownloadpermissions` = '16383',
	`ecexcludecatlist` = '',
	`ecdownloadsmaxuploadtotal` = '-1',
	`ecdownloadsmaxdailydl` = '-1',
	`ecdownloadsmaxdailyfiles` = '-1',
	`ecdownloaddelaygrp` = '-1',
	`glossarypermissions` = '127',
	`itraderpermissions` = '7',
	`mh_unm_permissions` = '1',
	`mh_unm_changelimit` = '30',
	`mh_unm_viewhistorylimit` = '1',
	`forumpermissions` = '1074790399',
	`attachlimit` = '0',
	`profileviewpermissions` = '0',
	`vbarticles` = '4095',
	`pmquota` = '375',
	`pmpermissions` = '3',
	`pmsendmax` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '31',
	`adminpermissions` = '3',
	`genericpermissions` = '205389759',
	`genericoptions` = '31',
	`profilepicmaxwidth` = '200',
	`profilepicmaxheight` = '250',
	`profilepicmaxsize` = '25600',
	`avatarmaxwidth` = '90',
	`avatarmaxheight` = '90',
	`avatarmaxsize` = '20000'
WHERE usergroupid=6;

MySQL Error  : Unknown column 'profileviewpermissions' in 'field list'
Error Number : 1054
Date         : Monday, June 16th 2008 @ 09:44:28 AM
Script       : http://www.mysite.com/forums/admincp/usergroup.php
Referrer     : http://www.xxxxxx.com/forums/admincp/usergroup.php?do=edit&usergroupid=6
IP Address   : 67.59.x.x
Username     : XXXXXXXXXXX
Classname    : vb_database

[bada_bing]

hack uninstalled until I can get a fix ..

[ibuddy]

someone needs to make this for 3.7 badly

[sava700]

yeah..I just noticed that this makes a big problem when you view someones profile...it added a huge Change username box on the top right side of the page when you view a profile.

[Shazz]

Originally Posted by sava700

yeah..I just noticed that this makes a big problem when you view someones profile...it added a huge Change username box on the top right side of the page when you view a profile.

What vB version are you using

[PinkDaisy]

I have this installed on 3.7.2 and it seems to work fine so far!