I have been importing data from PHPBB to Vbulletin and found out that usernames are there twice so I Prune them using standard admin functions and later I found that posts are containing references to old username IDs. So all I need to do is simple SQL query to match usernames and update userID in post table. I checked tables and it looks like I will need only to modify table "post" get there username search it in table "user" get there correct "userid" and replace userid in table "post". Can someone help with this SQL? I can run it in phpmyadmin but there is 50k posts so it will take some time so I think the code needs to be optimized... Same think is going on with PMs I think but this can not be fixed and I think PMs can be ignored... EXAMPLE: first post here webmaster-money.org/forum/urlcash-url-www-t2975.html darksorrow does not exist but he is under different ID with 0 posts webmaster-money.org/forum/member.php?u=2566