Zeile 6 | Zeile 6 |
---|
* Website: http://www.mybboard.com * License: http://www.mybboard.com/eula.html *
|
* Website: http://www.mybboard.com * License: http://www.mybboard.com/eula.html *
|
* $Id: showthread.php 2164 2006-08-30 06:17:49Z chris $
| * $Id: showthread.php 2263 2006-09-26 09:24:25Z chris $
|
*/
define("IN_MYBB", 1);
| */
define("IN_MYBB", 1);
|
Zeile 100 | Zeile 100 |
---|
$query = $db->query(" SELECT p.pid FROM ".TABLE_PREFIX."posts p, ".TABLE_PREFIX."threads t
|
$query = $db->query(" SELECT p.pid FROM ".TABLE_PREFIX."posts p, ".TABLE_PREFIX."threads t
|
WHERE t.fid='".$thread[fid]."' AND t.closed NOT LIKE 'moved|%' AND p.tid=t.tid
| WHERE t.fid='".$thread['fid']."' AND t.closed NOT LIKE 'moved|%' AND p.tid=t.tid
|
ORDER BY p.dateline DESC LIMIT 0, 1 ");
| ORDER BY p.dateline DESC LIMIT 0, 1 ");
|
Zeile 555 | Zeile 555 |
---|
// Is there actually a pid to display? if(!$showpost['pid']) {
|
// Is there actually a pid to display? if(!$showpost['pid']) {
|
error($lang->invalidpost);
| error($lang->error_invalidpost);
|
}
// Get the attachments for this post.
| }
// Get the attachments for this post.
|
Zeile 567 | Zeile 567 |
---|
// Build the threaded post display tree. $query = $db->query("
|
// Build the threaded post display tree. $query = $db->query("
|
SELECT u.*, u.username AS userusername, p.* FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid) WHERE p.tid='$tid' $visible ORDER BY p.dateline "); while($post = $db->fetch_array($query)) { if(!$postsdone[$post['pid']]) { $tree[$post['replyto']][$post['pid']] = $post; if($post['pid'] == $mybb->input['pid'] || ($isfirst && !$mybb->input['pid'])) { $isfirst = 0; } $postsdone[$post['pid']] = 1; } }
| SELECT u.username, u.username AS userusername, p.pid, p.replyto, p.subject, p.dateline FROM ".TABLE_PREFIX."posts p LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=p.uid) WHERE p.tid='$tid' $visible ORDER BY p.dateline "); while($post = $db->fetch_array($query)) { if(!$postsdone[$post['pid']]) { if($post['pid'] == $mybb->input['pid'] || ($isfirst && !$mybb->input['pid'])) { $isfirst = 0; } $tree[$post['replyto']][$post['pid']] = $post; $postsdone[$post['pid']] = 1; } }
|
$threadedbits = buildtree(); $posts = build_postbit($showpost); eval("\$threadexbox = \"".$templates->get("showthread_threadedbox")."\";");
| $threadedbits = buildtree(); $posts = build_postbit($showpost); eval("\$threadexbox = \"".$templates->get("showthread_threadedbox")."\";");
|