Miscellaneous Hacks - [DBTech] Username Change v1 (vB4)

What is Username Change?
Username Change is Brought to you by the Designer of products such as RPG Inferno and Inferno vBShout and the programmer of RPG Integration v3.

Username Change from DragonByte Tech is a modification designed to allow users to change their usernames at will (within your configured limits, of course).

About Username Change
Your members will no longer bug you for username changes, you can let them change it whenever they want!

It also has a history feature in the member profile, showing a list of previous usernames. This history feature uses vBulletin's own Profile Change history - no additional tables needed!

-------------------------------------------------------------------------------------------

If you like this mod please hit the button to the right ---->

Please remember to click the, button to the right if you installed the mod ---->

What does 'Marking As Installed' do ?

* It helps you to stay on top of updates - members who have installed modifications will be notified by us whenever new updates are available.

* For security issues - vbulletin.org will contact all members who have installed a modification whenever a security issue is brought to their attention.

* Marking a modification as installed also helps us know how many people are using our work, giving us extra incentive to provide more features and new modifications.

We appreciate the support!

-------------------------------------------------------------------------------------------

Priority support is handled at the Developers Website.

-------------------------------------------------------------------------------------------

Feature List

• Uses vBulletin's "Profile Change History" feature for maximum compatibility with other mods
• Change username via UserCP -> Edit Profile
• One-click revert username via UserCP -> Edit Profile
• Username change history in a member's profile
• Moderators can change usernames at any time easily
• "Can Change Own Username" permission for users
• "Can Change Others Usernames" permission for mods
• "Can View Own History" permission for profile block
• "Can View Others History" permission for profile block
• Per-usergroup username change delay (in days)
• Per-usergroup profile history limit
• Per-usergroup maximum total username changes

ModCP Change Log

• Paginated results of all username changes
• Displays date of change, old value and new value
• Displays who changed the username
• Choose date range to display, or view all changes

-------------------------------------------------------------------------------------------

This mod displays a copyright notification in the footer of all pages which includes:

• 1 Link to DragonByte Technologies homepage
• 1 Link to Product Description page of this modification

[Diana Notacat]

LIFE SAVERS. Thank you. I will now be safe from my username change happy members who like to annoy me with requests!

[DragonByte Tech]

Originally Posted by tinkleondabeach

Would this work for 3.8?

No, but Marco's old mod for 3.5 still works on 3.8


Fillip

[RedHacker]

User Profile

* Username History

For show this must change username...?

[DragonByte Tech]

Yeah, username must have been changed at least once in order for the History to appear in the profile


Fillip

[sung]

Originally Posted by DragonByte Tech

No, but Marco's old mod for 3.5 still works on 3.8

Is there any possibility to import the name change history/information from Marco's plugin to this one?

[DragonByte Tech]

No, sorry that's not possible.
Marco's plugin uses its own method of storing information, whereas I use vBulletin's method (which, in fairness, didn't exist in vB 3.5 which is what Marco's plugin was written for).

[sung]

Originally Posted by DragonByte Tech

No, sorry that's not possible.
Marco's plugin uses its own method of storing information, whereas I use vBulletin's method (which, in fairness, didn't exist in vB 3.5 which is what Marco's plugin was written for).

I realize they use different methods for storing the information, but as long as the information was about the same it should be possible to either manually or with a script move the information over.

It would be nice not to lose the username history, as well as resetting all the name change timers/counters, when moving from Marco's to your mod.

[DragonByte Tech]

Well yeah it's not like it's entirely impossible, we just have no plans of writing such a script at this time because not everybody who installs this is upgrading from 3.8

It's been a while since I dealt with Marco's mod, but doing it manually would work too, I guess.


Fillip

[sung]

Here's the script I made/used to go from Marco's name change mod to this one.

PHP Code:

<?php

// Change this stuff

$dbhost = 'host';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'table';

// END OF STUFF TO CHANGE

$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

if($mysqli->connect_error) {
   die("Connect Error: " . $mysqli->connect_error);
}

// Get current usernames for users that have changes
$result = $mysqli->query("SELECT distinct mh_unm_history.userid, user.username FROM mh_unm_history, user WHERE user.userid = mh_unm_history.userid");
while ($row = $result->fetch_row()) {
   $usernames[$row[0]] = mysql_real_escape_string($row[1]);
}
$result->free_result();

// Get the username changes
$result = $mysqli->query("SELECT * from mh_unm_history ORDER BY userid ASC, dateline DESC");
while ($row = $result->fetch_row()) {
   $userid = $row[0];
   $dateline = $row[1];
   $oldname = mysql_real_escape_string($row[2]);
   $adminid = $row[3];
   $uniq = md5($dateline . $userid . $userid . rand(1111,9999));

   // Build the array of queries we'll execute later
   $q[] = "INSERT INTO userchangelog VALUES('', $userid, 'username', '$usernames[$userid]', '$oldname', $adminid, $dateline, '$uniq')";

   // Set the username as the old one in the
   // event there are multiple name changes
   $usernames[$userid] = $oldname;
}

foreach ($q as $query) {
   if (!$mysqli->real_query($query))
      echo "FAILED: " . $query . "<br>\n"; 
}

$result->close();
$mysqli->close();
?>

Things I know will cause issues: if you don't have the mysqli (notice the i) extension or use a prefix on your forum tables.

You're on your own to backup/test/verify/etc the above code will work for you!

[Das UndergrounD]

I need this mod for vb3.8 please!!!