style="border-left: none"><?php
echo communities_order_link("title", "File Title");
?>
</td>
<td<?php
echo $_SESSION[APPLICATION_IDENTIFIER]["cid_" . $COMMUNITY_ID][$PAGE_URL]["sb"] == "owner" ? " class=\"sorted" . strtoupper($_SESSION[APPLICATION_IDENTIFIER]["cid_" . $COMMUNITY_ID][$PAGE_URL]["so"]) . "\"" : "";
?>
style="border-left: none"><?php
echo communities_order_link("owner", "Owner");
?>
</td>
<td<?php
echo $_SESSION[APPLICATION_IDENTIFIER]["cid_" . $COMMUNITY_ID][$PAGE_URL]["sb"] == "date" ? " class=\"sorted" . strtoupper($_SESSION[APPLICATION_IDENTIFIER]["cid_" . $COMMUNITY_ID][$PAGE_URL]["so"]) . "\"" : "";
?>
style="border-left: none"><?php
echo communities_order_link("date", "Last Updated");
?>
</td>
<?php
if ($COMMUNITY_ADMIN) {
?>
<td style="border-left: none">Views</td>
<?php
}
?>
</tr>
</thead>
<tbody>
<?php
foreach ($results as $key => $result) {
$accessible = true;
style="border-left: none; text-align: left"><?php
echo communities_order_link("replies", "Replies");
?>
</td>
<td<?php
echo $_SESSION[APPLICATION_IDENTIFIER]["cid_" . $COMMUNITY_ID][$PAGE_URL]["sb"] == "poster" ? " class=\"sorted" . strtoupper($_SESSION[APPLICATION_IDENTIFIER]["cid_" . $COMMUNITY_ID][$PAGE_URL]["so"]) . "\"" : "";
?>
style="border-left: none"><?php
echo communities_order_link("poster", "Topic Starter");
?>
</td>
<td<?php
echo $_SESSION[APPLICATION_IDENTIFIER]["cid_" . $COMMUNITY_ID][$PAGE_URL]["sb"] == "date" ? " class=\"sorted" . strtoupper($_SESSION[APPLICATION_IDENTIFIER]["cid_" . $COMMUNITY_ID][$PAGE_URL]["so"]) . "\"" : "";
?>
style="border-left: none"><?php
echo communities_order_link("date", "Latest Action");
?>
</td>
</tr>
</thead>
<tbody>
<?php
foreach ($results as $key => $result) {
$accessible = true;
if ($result["release_date"] && $result["release_date"] > time() || $result["release_until"] && $result["release_until"] < time()) {
$accessible = false;
}
//get the last poster user info
if ($result['total_replies'] > 0) {
$query = " SELECT cdt.`updated_date`, cdt.`updated_by`, cdt.`anonymous`, cdt.`proxy_id`, user_data.`firstname`, user_data.`lastname`, user_data.`username`\n FROM `community_discussion_topics` as cdt\n LEFT JOIN `" . AUTH_DATABASE . "`.`user_data` AS user_data\n ON cdt.`proxy_id` = user_data.`id`\n WHERE cdt.`cdtopic_parent` = " . $db->qstr($result['cdtopic_id']) . "\n ORDER BY cdt.`updated_date` DESC\n LIMIT 1";
$last_poster = $db->GetRow($query);
