Tried using Post Associator but need something else

Hi Thoul I was referred to your hack in the phpbb support forums:
http://www.phpbb.com/phpBB/viewtopic.php?p=2154523#2154523

I tried the hack but since my problem is not exactly what its designed to be used for it didnt help.

My board was hacked and they removed all traces of my admin account. They didnt delete the posts however, they just made them into guest posts using the -1 user. I didn't have a recent enough backup and I didn't want to lose a few weeks posts so I manually went through my backup and fixed the database including restoring my admin account. The last problem to fix us making my old posts back into the real username and not Guest.

Here is what one line looks like in my backup:

Code:

What's missing is the username. In fact most of the posts have no username otherwise the hack might've worked. Any idea why this is? My forum was running 2.0.11. I have to update it to the latest before turning it on again.

However I know the poster_id number for my account so I could create some code to use this old sql and replace any row with a poster_id of 2. Or maybe I could insert the username into that field where the poster id is 2. I would have to run something to have it find and replace all the posts from the old backup into the current db.

If I dont use the hack however and try something else, I am concerned that the post_id is associated with the forum_id and therefore there could be duplicate post_id's but in different forums. Is that correct? If so I would have to be careful about replacing the posterid in not just a postid but a forumid as well.

Thanks for any help or suggestions.

Quote:

This is because of the way phpBB stores posts. It won't store the username with posts unless the posts are created by logged out users or a user is deleted through the admin panel.

Quote:

The post_id is unique for each post, so you can't have duplicate post_id's at all. They also aaren't really associated with the forum_id. forum_id is associated with a forum_id in the waa_forums table.