| zylstra |
02-03-2006 06:49 PM |
First post above reply box in newreply
What code would I add to the newreply template to show the first post above the reply box? Would it take more than a template mod? Can anyone help me out with this one?
The newreply_reviewbit is below, but it just shows the oldest post in the topic review
PHP Code:
<tr>
<td class="thead" colspan="2">$postdate $posttime</td>
</tr>
<tr title="<phrase 1="$post[postid]">$vbphrase[post_x]</phrase>" valign="top">
<td class="alt1" width="125" align="center">$username</td>
<td class="alt2">$reviewmessage</td>
</tr>
Thanks.
I've tried throwing basically a copy of the php for threadreviewbits directly below it to grab something I called $firstpostbits. I modified the SQL code to order by postid and limit to 1 like this:
PHP Code:
ORDER BY postid DESC
LIMIT " . (1)
in
PHP Code:
// *********************************************************************
// get first post bits
// get first post
$firstpostbits = '';
$posts = $db->query_read("
SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
post.pagetext, post.allowsmilie, post.userid, post.dateline
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = post.userid)
WHERE post.visible = 1
$globalignore
AND post.threadid = $threadinfo[threadid]
ORDER BY postid DESC
LIMIT " . (1)
);
while ($post = $db->fetch_array($posts))
{
if ($postcounter++ < $vbulletin->options['maxposts'])
{
exec_switch_bg();
$posttime = vbdate($vbulletin->options['timeformat'], $post['dateline']);
$postdate = vbdate($vbulletin->options['dateformat'], $post['dateline'], 1);
$username = $post['username'];
// do posts from ignored users
if (in_coventry($post['userid']) AND can_moderate($foruminfo['forumid']))
{
eval('$reviewmessage = "' . fetch_template('newreply_reviewbit_ignore_global') . '";');
}
else if ($ignore["$post[userid]"])
{
$reviewmessage = $ignoreduser;
}
else
{
$reviewmessage = $bbcode_parser->parse($post['pagetext'], $foruminfo['forumid'], $post['allowsmilie']);
}
($hook = vBulletinHook::fetch_hook('newreply_form_reviewbit')) ? eval($hook) : false;
eval('$firstpostbits .= "' . fetch_template('newreply_reviewbit') . '";');
}
else
{
break;
}
}
and I put the $firstpostbits in the newreply template, but it isn't working.
Do you see any problems with the code? |
More Information