Page 1 of 1
Change back?
Posted: Tue Aug 16, 2011 4:48 am
by Iron_Maiden
I have been conversing with GSH as of late and I have a new password now for my old account. I just want to know if anyone here wants me to switch back or likes me better with my cool, stylish underscore. May change back simply because old account has more posts. Thank you
--Iron_Maiden
Re: Change back?
Posted: Tue Aug 16, 2011 5:28 am
by HitchcockGreen
Option 3:
Merge the two accounts?
Re: Change back?
Posted: Tue Aug 16, 2011 4:34 pm
by PCG-Oldfart
Yep I would merge the new into the old then have admin change your name to Spanky or a better band called Black Sabbath.

Re: Change back?
Posted: Tue Aug 16, 2011 6:16 pm
by HitchcockGreen
lmao
I do believe that you can merge accounts and use one of the merged accounts names.
I had three or four accounts merged for me on sectorzero.

Re: Change back?
Posted: Tue Aug 16, 2011 6:24 pm
by GSH
Doing some googling, I didn't see an easy way in phpBB's ACP to merge users. Just scripts to upload and execute, etc. If there is such a way, I'd like to hear that.
-- GSH
Re: Change back?
Posted: Tue Aug 16, 2011 11:42 pm
by HitchcockGreen
I think there's a simpler way to do it through phpmyadmin.
Re: Change back?
Posted: Wed Aug 17, 2011 12:20 am
by HitchcockGreen
IIRC...
Code: Select all
CODE: SELECT ALL
UPDATE `phpbb_posts`
SET `post_username` = 'primary', `poster_id` = 2
WHERE `poster_id` = 3
After that is completed... you'll have to update primary's post count. so do a
CODE: SELECT ALL
SELECT *
FROM `phpbb_posts`
WHERE `poster_id` =2
to find out how many total post have been made by primary. Then edit the user_posts value within the phpbb_users table to be how ever many post were returned.
Re: Change back?
Posted: Wed Aug 17, 2011 3:23 am
by Nielk1
There is a post recount option in the admin panel. If GSH has the ability to run SQL, it is indeed an easy thing to do by swapping the IDs on the posts. He could even upload the query in an install.php set up like a phpbb3 update that runs the SQL and then demands it be deleted (like step 1 of all phpbb3 updates). However, GSH is using a fruity variation of phpBB3.
As from the screw-ups we have seen that this odd install does support certain mods, GSH should see if there is access to a mod that might help, like letting an admin change a post's poster.
Re: Change back?
Posted: Sun Aug 21, 2011 11:11 pm
by Baconboy
I would say just use old account and delete new one.