?> ?<?php echo $page_current > 1 ? "pv=" . $page_current . "&" : ""; ?> action=moderate&id='+id; return true; } } ); } </script> <div id="module-header"> <?php if ($total_pages > 1) { echo "<div id=\"pagination-links\">\n"; echo "Pages: " . $pagination->GetPageLinks(); echo "</div>\n"; } ?> </div> <?php $query = "\tSELECT a.*, CONCAT_WS(' ', b.`firstname`, b.`lastname`) AS `fullname`, b.`username`\n\t\t\t\t\t\tFROM `community_events` AS a\n\t\t\t\t\t\tLEFT JOIN `" . AUTH_DATABASE . "`.`user_data` AS b\n\t\t\t\t\t\tON a.`proxy_id` = b.`id`\n\t\t\t\t\t\tWHERE a.`community_id` = " . $db->qstr($COMMUNITY_ID) . "\n\t\t\t\t\t\tAND a.`event_active` = '1'\n\t\t\t\t\t\tAND a.`pending_moderation` = '1'\n\t\t\t\t\t\tAND a.`cpage_id` = " . $db->qstr($PAGE_ID) . "\n\t\t\t\t\t\tORDER BY %s\n\t\t\t\t\t\tLIMIT %s, %s"; $query = sprintf($query, $sort_by, $limit_parameter, $_SESSION[APPLICATION_IDENTIFIER]["cid_" . $COMMUNITY_ID][$PAGE_URL]["pp"]); $results = $db->GetAll($query); if ($results) { $last_date = 0; $total_events = @count($results); echo "<table class=\"calendar\" style=\"width: 99%\">\n"; echo "<colgroup>\n"; echo "\t<col style=\"width: 30%\" />\n"; echo "\t<col style=\"width: 70%\" />\n";