$order = $mbcon['replyorder'] == '0' ? "DESC" : "ASC";
$start_id = ($page - 1) * $mbcon['replyperpage'];
$querycondition = $use_blogalias ? "`blogalias`='{$blogaliasp}'" : "`blogid`='{$itemid}'";
if ($permission['SeeHiddenEntry'] != 1) {
$partialquery = "SELECT * FROM `{$db_prefix}blogs` WHERE {$querycondition} AND `property`<'2' LIMIT 0, 1";
$partialquery2 = "WHERE `property`<'2'";
} else {
$partialquery = "SELECT * FROM `{$db_prefix}blogs` WHERE {$querycondition} AND `property`<'3' LIMIT 0, 1";
$partialquery2 = " WHERE property<'3'";
}
$records = $m_b->single_record($partialquery, $partialquery2);
}
if (is_array($records)) {
$itemid = $records[0]['blogid'];
if ($is_save && $mbcon['txtdown'] == '1') {
$m_b->save_a_text($records[0]);
} else {
$section_body_main = $m_b->make_viewentry($records[0]);
}
} else {
getHttp404($lnc[186]);
}
//Load plugins
$section_body_main[0] = plugin_get('entrybegin') . $section_body_main[0];
$section_body_main[] = plugin_get('commentbegin');
if ($records[0]['replies'] != 0 || $records[0]['tbs'] != 0) {
if ($mbcon['avatar'] == 1 || $mbcon['usergravatar'] == 1 || $mbcon['visitorgravatar'] == 1) {
$replyarray = $m_b->getgroupbyquery("SELECT t1.*, t2.userid, t2.avatar FROM `{$db_prefix}replies` t1 LEFT JOIN `{$db_prefix}user` t2 ON t1.replierid=t2.userid WHERE t1.blogid='{$itemid}' AND (t1.reproperty<2 OR t1.reproperty=4) ORDER BY t1.reptime {$order} LIMIT {$start_id}, {$mbcon['replyperpage']}");
} else {
$replyarray = $m_b->getgroupbyquery("SELECT * FROM `{$db_prefix}replies` WHERE blogid='{$itemid}' AND (reproperty<2 OR reproperty=4) ORDER BY reptime {$order} LIMIT {$start_id}, {$mbcon['replyperpage']}");
}
