UBB.Developers Forums UBB.threads 6 V6 Modifications Archived Mods [6.1] Change Username Hack

Mod Name / Version: Change Username for 6.1

Description: This hack lets you rename a user to another username, or merge two usernames. It works for version 6.0
Now you can
a) change a username to something new
b) if the new username already exists, the script will merge the usernames. All the settings from the old username will be kept - except for the total posts number, which will reflect the correct totals. The title doesn't get reset though, so you may need to modify it manually. PMs sent and received, address book entries, moderators, subscriptions, read receipts etc etc are all handled and reflect the new username.

Working under: UBB.threads 6.1

Any pre-requisites: none

Author(s): Max

Credits: built on Dave's great work. Tweaked for 6.1 by JoshPet

Files Altered: /admin/menu.php

New Files: /admin/sk_changename.php and /admin/sk_dochangename.php

Database Altered: Yes

Notes: I didn't write this... I think Max did. I've been using it forever, and it needed a couple of tweaks for version 6.1 to allow for the custom table prefix and the new U_LoginName field.

This hack lets you rename a user to another username, or merge two usernames. It works for version 6.1

Use at your own risk, always backup your database prior to
installing/using hacks.

It's probably just me, but after I fill hit 'change' and it loads sk_dochangename it just goes to a blank white screen. I followed the instructions and uploaded sk_dochangename and sk_changename to my admin directory. Any thoughts on what I might be doing wrong here?

Hmmmm....

Not sure. Those are the same files I'm using.

Are they readable? Might try chmod 777 for the sk_dochangename file.

Changed permissions to 777 for both files and still no luck.

Was this based on Change Username 2.0.2, or an earlier version?

Since the version history isn't present, I'm guessing it was based on the earlier version. It might be better to add the changes to 2.0.2, and then call the new version 2.0.3 (or 2.1.0, to match UBB.threads 6.1).

I wish I knew.... I had downloaded it way back when.... and it was just a text file and didn't have any version numbers in it. <SHRUG>

I'm not even 100% sure who wrote it because there were a couple of different hacks to do this.

All I know is that under 6... I've used it a bunch...and haven't had any trouble. <knock on wood> lol I added the table prefixes and new fields...and this seemed to work find in 6.1. Time will tell. <fingers crossed>

But I don't really know where it came from.

I need to install this on 6.1 as I just went live with it tonight. I think I'll wait to install this hack until I really need it. Maybe by then it'll be tested some more as I know this hack has had a colorful past. It bit me one time! I'm pretty much sick of hacks and updating them from the last 3 days of upgrading a fresh install of 6.1 hehe

I have used it twice so far under 6.1 b1. Knock on wood.

I still think it's confusing that you created a second version branch of this hack.

The hack should be obsolete in 6.2 anyway, since then it will only be necessary to change a single column in one table. (Although merging will still take some more effort.)

It might be the same one... I can't tell there are so many version posted. I just knew it was the one that was working for me.... tried and tested...a couple of times a month. Merges and changes.

I just added the table prefix variable and the new database field.

You're right though... 6.2 usernumber's will be easier.

I think there is a problem with it, when trying to change a username from upper to lowercase or vice versa.

As far as i can remember, that was fixed in another version of this hack.

Oh you are right.....
I had trained myself to change them to something different first..... then back to the name with the proper case.

I just installed this Hack on my 6.1.1 version and I get this error, I am logged in as admin and I can use all the other admin options but this one:....
-----------------------------------------------------------

SQL ERROR: Database error only visible to forum administrators

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource

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

Any help would be apprecaited.

Thanks

I had the same problem and here is what I did to fix it.

1) Open up the file sk_dochangename.php
2) Look for the line up at the top that reads :
require ("../languages/$w3t_language/ubbthreads.php");
3) Change it to :
require ("../languages/${$config['cookieprefix']."w3t_language"}/ubbthreads.php");
4) Save and you should be good to go.

BTW, my chmod is 644 so you shouldn't need to do 777.

It's error/ bug in this hack in file sk_dochchangename.php
Procdeure delete both nicknames. New and old.
When we delete from the file sections about "delete target user" all is ok and work correctly.