More cleaning up of the old “Discussion Board”
The sorting of the migrated old "Discussion Board" was - well, somewhat awkward. I found out it is sorted by the last-changed timestamp field of the thread-record - which - of course I didn’t fill…
The update with a single SELECT-Statement didn’t work since the MySQL-Version on my Webserver doesn’t support UPDATE with sub-SELECT 
Also the number of replies - field wasn’t set - don’t know if it makes any difference, just to make sure…
2 more little php-scripts which step through the threads-table, get the information (no of messages in that thread, timestamp of the newest message) and put into the corresponding field in the threads-table.
Viewing at all threads, deleting some more empty messages and some more spam took me almost the whole day… pew
![[del.icio.us]](http://images.del.icio.us/static/img/delicious.small.gif){kind=small}
More about this here in this blog: