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);