[borbole]

Originally Posted by spillage

Since the old usernames are unknown, and I want to move all guest posts to a single usermane, it would appear you're now saying this mod will not do the job.

Am I correct?

The old usernames of the deleted users can be seen under their posts they made or you can see them at the database as well. Anyway, to do what you want, to assign posts of all guests to someone, run this query at your phpmyadmin or from Maintenance->Execute SQL Query in your Acp.

UPDATE post 
        SET username = 'posterusername'
        WHERE  userid = 0;

But first make a backup of your posts table. Also, change posterusername with the actual username to whom you want to attribute the posts of all guests and if your db tables have a prefix, include it in the query as well.

Let me know if you want to do the same with threads as well.

P.s. At vb.com you asked how to get back posts of deleted users that appear as guests btw and that is exactly what this mod does. Also, before you download and use a mod, it would be best if first you had a good look at the description