MyBB Community Forums

Thanks for the testing koziolek.

This is a question for the developers. Is pagination for threaded view in place in 1.2? I don't think it is because I didn't see it on the current board.

By the way, I was wondering does the page even load in threaded view, considering there are 1932 replies. It should be a huge page that would take forever to load. This takes forever to load on my connection:

http://community.mybboard.net/showthread...=10781&pid=

I really think they need to put in pagination at threaded view.

Can you please confirm if this works alright:

$query = $db->query("SELECT u.username AS userusername, u.username, p.pid, p.replyto, p.subject, p.dateline, IF(p.pid <> ".intval($mybb->input['pid']).", '', p.message) as message, i.path as iconpath, i.name as iconname FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid) LEFT JOIN ".TABLE_PREFIX."icons i ON (i.iid=p.icon) WHERE p.tid='$tid' AND p.visible='1' ORDER BY p.dateline");

I have removed unneded IF with message, so this code:

$query = $db->query("SELECT u.username AS userusername, u.username, p.pid, p.replyto, p.subject, p.dateline, '' as message, i.path as iconpath, i.name as iconname FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid) LEFT JOIN ".TABLE_PREFIX."icons i ON (i.iid=p.icon) WHERE p.tid='$tid' AND p.visible='1' ORDER BY p.dateline") ;

works fine.

Good to know that.... BTW, does it displays the first message just fine? I thought the message in the first post came from that query.

No, I splitted the query.

Maybe you can post the whole modification so that it's helpful to users ...

I have post it. DIFF file is self-explanatory.
http://community.mybboard.net/showthread...5#pid74425