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?
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>
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 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 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
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.
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.