I'm not that worried about it on my forum, its very rare to see a thread with even 50 posts, but I do understand how that could get hard on the database on a busier forum. I'm confused as to which query you call the 'main' query, as there are quite a few queries in showthread.php. There is no reference to LIMIT in $post, the LIMIT in $getlastpost is DESC LIMIT as is the case with most other occurances. In fact, your PHP is almost the exact $postorder variable.
I'm sorry if I am posting the obvious, I havent attempted any unknown hacks before but only predeveloped hacks with documentation.
|