Possible SQL to create new "PM" table from "PMTEXT" table

[carcomp]

My 'pm' table no longer accurately reflects what my 'pmtext' table has in it. I don't know if its from the restore I performed on my forum, but i'm betting it is. Some of my users can't see their PMs, but in phpmyadmin, I can see them in the pmtext table.

I think its possibly just a SQL statement command, but I'm not that good at sql yet (I'm more of a visual basic programmer). But the following is what I need to do.

Empty Table 'pm'
For Each ROW in table 'user'
Take 'pmtextid' from table 'pmtext' where its the same as 'userid' from table 'user' then insert this into table 'pm' and allow 'pmid' to auto increment for each instance of 'userid'
Repeat for next user

I've actually manually done this one time in phpmyadmin and it works, i just need a way to batch the whole thing.

I could easily create this in visual basic! I just need to get the 'pm' table rebuilt based on what is in the pmtext table. I think this should be a part of vbulletin itself, but when I placed a ticket, they just told me that "its not a feature, we can't help you".


Any ideas?

Regards,
Mitch Thompson
Admin
www.quad4forums.com
.