Fix broken pm table using existing data.

[carcomp]

Hello all. I hope someone from vbulletin reads this.

I recently encountered a problem when doing a forum upgrade / merge. Somehow my pm table in mysql lost some of its data. The pmtext table is still there, but my users can't access their pms because of the broken pm table.

I figured there HAS to be a way to rebuild this pm table using just sql commands. I haven't been able to figure out how to do the following...

For each row in table 'user'
For each row in table 'pmtext'
If user:username is found in pmtext:touserarray {
Insert New Row into table 'pm'
Set pmtextid = Current(pmtextmtextid)
Set userid = Current(user:userid)
}End If
Next RowIn pmtext
Next RowIn user

I know its a bad mix of visualbasic, php and sql, but the concept is there. The guys at vbulletin said that I needed to go to vbulletin.org, and I didn't find any help there. I'm hoping that someone from Team Vbulletin might take this opportunity to either

A. Add this to the next vbulletin release,
B. Possibly whip me up a SQL statement, or multiple statements.

[Lats]

Do you have a recent backup?