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]

Originally Posted by 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

So, for example, replace X with my user ID of 18 again?

[DragonByte Tech]

No. If the DB has an entry "Username" instead of "username", replace X with "Username".

Fillip

[Amaury]

Originally Posted by DragonByte Tech

No. If the DB has an entry "Username" instead of "username", replace X with "Username".


Fillip

Oh, so if an entry or entries has / have "Username" instead of "username," replace the X with "Username" and run another query to fix all "Username" entries to "username"?

[johkalhaups]

A conflict was detected in the bitfields. You cannot continue with the installation of this product until this has been fixed. The conflicts found were:
Bitfield Collision: credits_cantearn = allowvideos

Im getting that trying to update to the latest version of this mod.

Im on vB 4.1.11 PL 1

What is this bitfield?

[Amaury]

I'm not seeing any uppercase results.

Here are my results:







Here's my change log again:









Also, we don't want anyone other than admins to be able to change usernames. How do we disable the username change option in User CP -> General Settings?

[Amaury]

Bump.

I've been promoted to an administrator again for the time being, so you could create an account and then I could promote you to a temporary admin if you want to have a look for yourself.

I've found two more users to be affected besides the owner and I, making it a total of four users affected. The two more that I discovered are just missing one change, while the owner and I are missing a lot.

[Amaury]

Never mind. I figured out the problem. It was the usergroup options for each usergroup.

This was originally five:



EDIT: I do have one more question, though. Under the Date Changed column on the history tab, it's the time, a comma, and the date (e.g., 7:24 PM, 11/20/2012). However, I would like the date to be first (e.g., 11/20/2012, 7:24 PM). How would I accomplish this?

[Amaury]

Originally Posted by Amaury25

Never mind. I figured out the problem. It was the usergroup options for each usergroup.

This was originally five:



EDIT: I do have one more question, though. Under the Date Changed column on the history tab, it's the time, a comma, and the date (e.g., 7:24 PM, 11/20/2012). However, I would like the date to be first (e.g., 11/20/2012, 7:24 PM). How would I accomplish this?

Bump.

[DragonByte Tech]

You'll need to edit this line in /dbtech/username_change/includes/class_profileblock.php

PHP Code:

$entry['change_time'] = vbdate($this->registry->options['timeformat'], $entry['change_time']) . ', ' . vbdate($this->registry->options['dateformat'], $entry['change_time']); 


Fillip

[Amaury]

Originally Posted by DragonByte Tech

You'll need to edit this line in /dbtech/username_change/includes/class_profileblock.php

PHP Code:

$entry['change_time'] = vbdate($this->registry->options['timeformat'], $entry['change_time']) . ', ' . vbdate($this->registry->options['dateformat'], $entry['change_time']); 


Fillip

Aw, I was hoping it'd be a simple template edit.

Unfortunately, I'm no expert at server work. I have the server information, but all I know how to do is take backups.

I can send you the information, if you'd be willing to do it, though.