If I had to do that, I'd write a php script: For each thread, read the 7 columns from the thread table and the pagetext field for the first post (from the post table), and then update the post pagetext field with a string that includes the thread table data. It may be possible to do it totally with sql so you wouldn't need a script, but it seems easier to deal with in a php script (maybe just because I'm not an sql expert).
Your request is kind of in a "grey area" - we'll help you, but I think it's unlikely that anyone's going to take the time to write it for you (but maybe someone will prove me wrong).
|