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

[Amaury]

An admin just checked. They're showing up there.

EDIT: Here's a screenshot he provided.

[DragonByte Tech]

Hmm... Can you check the userchangelog database table and see if the fieldname column is anything other than "username" (all lowercase) for the entries that are missing?

Fillip

[Amaury]

Originally Posted by DragonByte Tech

Hmm... Can you check the userchangelog database table and see if the fieldname column is anything other than "username" (all lowercase) for the entries that are missing?


Fillip

Is that also done via the Admin CP?

[DragonByte Tech]

Via phpMyAdmin is the best bet, though it can be done via the AdminCP if the user has Execute SQL permissions from config.php


Fillip

[Amaury]

Originally Posted by DragonByte Tech

Via phpMyAdmin is the best bet, though it can be done via the AdminCP if the user has Execute SQL permissions from config.php


Fillip

SQL executions are possible.

What would the execution be?

[DragonByte Tech]

If you're using a table prefix, you need to add it in front of the table name:

select fieldname from userchangelog where userid = x

Replacing X with the userid of a user that's got missing entries.


Fillip

[Amaury]

Originally Posted by DragonByte Tech

If you're using a table prefix, you need to add it in front of the table name:

select fieldname from userchangelog where userid = x

Replacing X with the userid of a user that's got missing entries.


Fillip

Just so I pass along the correct information, am I understanding this right?

Admin CP -> Maintenance -> Execute SQL Query

In the Manual Query box, enter that code and replace the X with the user's ID -- for example, mine is 18.

[DragonByte Tech]

That's correct

Ideally it should return "username" in all lowercase over and over again for all the entries.


Fillip

[Amaury]

Originally Posted by DragonByte Tech

That's correct

Ideally it should return "username" in all lowercase over and over again for all the entries.


Fillip

In that case, just exit the Admin CP, go back to the forum index, and carry on with your day, right? =P

If not, though, what should be done?

[DragonByte Tech]

If not then

update userchangelog set fieldname = 'username' where fieldname = 'x'

replacing X with whatever the result of the previous query was that is not "username" in all lowercase


Fillip