Change back?

[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

[HitchcockGreen]

Option 3:
Merge the two accounts?

[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.

[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.

[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

[HitchcockGreen]

I think there's a simpler way to do it through phpmyadmin.

[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.

[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.

[Baconboy]

I would say just use old account and delete new one.