Expand|Select|Wrap|Line Numbers
- // Display Event List
- echo "<center>"._EVENTLIST."</center><br>";
- $now = Date(Y-m-d);
- // sort table colum
- if(!isset($_GET['page'])){
- $page = 1;
- } else {
- $page = $_GET['page'];
- }
- $sort_order = "date desc";
- if( isset( $_GET['order']) ){
- $order = $_GET['order'];
- switch ($order) {
- case "A_date":
- $sort_order = 'date asc';
- break;
- case "D_date":
- $sort_order = 'date desc';
- break;
- case "A_code":
- $sort_order = 'code asc';
- break;
- case "D_code":
- $sort_order = 'code desc';
- break;
- case "A_host":
- $sort_order = 'host asc';
- break;
- case "D_host":
- $sort_order = 'host desc';
- case "A_place":
- $sort_order = 'place asc';
- break;
- case "D_place":
- $sort_order = 'place desc';
- break;
- default:
- $sort_order = 'date desc'; // the default sort order
- $short = 'Illegal GET Value in ' . __FILE__;
- $long = $short . ". Cause is <b>$order</b> is invalid.";
- LogMessage("Error", $short, $long);
- break;
- }
- }
- $max_results = 5;
- $from = (($page * $max_results) - $max_results);
- $result = $db->sql_query("SELECT * FROM ".$prefix."_event_cat ORDER by $sort_order LIMIT $from, $max_results") or die("Error: " . mysql_error());
- if($db->sql_numrows($result) == 0){
- echo(""._NODATA."");
- }
- $bgcolor = "$bgcolor3";
- echo "<table width=\"100%\" border=\"1\">";
- echo "<tr bgcolor=\"$bgcolor2\">"
- ."<td align=\"center\"><a href=\"/modules.php?name=event&order=A_date\"><img src=\"images/asc.gif\" alt=\""._SORTASC."\" title=\""._SORTASC."\" border=\"0\" width=\"6\" height=\"6\"></a> "._EVENTDATE." <a href=\"/modules.php?name=event&order=D_date\"><img src=\"images/desc.gif\" alt=\""._SORTDESC."\" title=\""._SORTDESC."\" border=\"0\" width=\"6\" height=\"6\"></a></td>"
- ."<td align=\"center\"><a href=\"/modules.php?name=event&order=A_code\"><img src=\"images/asc.gif\" alt=\""._SORTASC."\" title=\""._SORTASC."\" border=\"0\" width=\"6\" height=\"6\"></a> "._CODE." <a href=\"/modules.php?name=event&order=D_code\"><img src=\"images/desc.gif\" alt=\""._SORTDESC."\" title=\""._SORTDESC."\" border=\"0\" width=\"6\" height=\"6\"></a></td>"
- ."<td align=\"center\">"._EVENTNAME."</td>"
- ."<td align=\"center\"><a href=\"/modules.php?name=event&order=A_host\"><img src=\"images/asc.gif\" alt=\""._SORTASC."\" title=\""._SORTASC."\" border=\"0\" width=\"6\" height=\"6\"></a> "._HOST." <a href=\"/modules.php?name=event&order=D_host\"><img src=\"images/desc.gif\" alt=\""._SORTDESC."\" title=\""._SORTDESC."\" border=\"0\" width=\"6\" height=\"6\"></a></td>"
- ."<td align=\"center\">"._EVENTTIME."</td>"
- ."<td align=\"center\"><a href=\"/modules.php?name=event&order=A_place\"><img src=\"images/asc.gif\" alt=\""._SORTASC."\" title=\""._SORTASC."\" border=\"0\" width=\"6\" height=\"6\"></a> "._PLACE." <a href=\"/modules.php?name=event&order=D_place\"><img src=\"images/desc.gif\" alt=\""._SORTDESC."\" title=\""._SORTDESC."\" border=\"0\" width=\"6\" height=\"6\"></a></td>"
- ."<td align=\"center\">"._COST."</td>"
- ."<td align=\"center\">"._AVAIL."</td>"
- ."<td align=\"center\">"._STATUS."</td>"
- ."</tr>";
- // show data in table with while loop
- while ($row = $db->sql_fetchrow($result)) {
- if ($bgcolor == "$bgcolor3"){
- $bgcolor = "$bgcolor1";
- }else{
- $bgcolor = "$bgcolor3";
- }
- $eid = intval($row['eid']);
- $code = filter($row['code'], "nohtml");
- $name = filter($row['name'], "nohtml");
- $date = filter($row['date'], "nohtml");
- $time = filter($row['time'], "nohtml");
- $place = filter($row['place'], "nohtml");
- $cost = filter($row['cost'], "nohtml");
- $host = filter($row['host'], "nohtml");
- $vacancy = intval($row['vacancy']);
- $active = intval($row['active']);
- // Caculate actual available vacancy
- $confirm = mysql_result($db->sql_query("SELECT COUNT(*) as eid FROM ".$prefix."_event_user where eid=$eid"),0);
- $temp = mysql_result($db->sql_query("SELECT COUNT(*) as eid FROM ".$prefix."_event_user_temp where eid=$eid"),0);
- $available = $vacancy-($confirm+$temp);
- echo "<tr bgcolor=\"".$bgcolor."\">"
- ."<td align=\"center\">$date</td>"
- ."<td align=\"center\">$code</td>"
- ."<td align=\"center\">$name</td>"
- ."<td align=\"center\">$host</td>"
- ."<td align=\"center\">$time</td>"
- ."<td align=\"center\">$place</td>"
- ."<td align=\"center\">$cost</td>"
- ."<td align=\"center\">$available</td>";
- // display event status
- $event_act = $active;
- if ($active == 1) {
- $active = "<img src=\"images/active.gif\" alt=\""._EVENTACTIVE."\" title=\""._EVENTACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
- $change = "<img src=\"images/inactive.gif\" alt=\""._EVENTNOTACTIVE."\" title=\""._EVENTNOTACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
- } elseif ($active == 0) {
- $active = "<img src=\"images/inactive.gif\" alt=\""._EVENTNOTACTIVE."\" title=\""._EVENTNOTACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
- $change = "<img src=\"images/active.gif\" alt=\""._EVENTACTIVE."\" title=\""._EVENTACTIVE."\" border=\"0\" width=\"16\" height=\"16\">";
- }
- echo "<td align=\"center\"><font class=\"content\"> $active</a> </td></tr>";
- }
- echo "</table>"
- ."<br><br>";
- // Page Numbering
- $total_results = mysql_result($db->sql_query("SELECT COUNT(*) as eid FROM ".$prefix."_event_cat"),0);
- $total_pages = ceil($total_results / $max_results);
- // Build Previous Link
- if($page > 1){
- $prev = ($page - 1);
- echo "<a href=\"/modules.php?name=event&page=$prev\">«"._PREV." </a> ";
- }
- for($i = 1; $i <= $total_pages; $i++){
- if(($page) == $i){
- echo " [$i] ";
- } else {
- echo "<a href=\"/modules.php?name=event&page=$i\"> $i </a> ";
- }
- }
- // Build Next Link
- if($page < $total_pages){
- $next = ($page + 1);
- echo "<a href=\"/modules.php?name=event&page=$next\"> "._NEXT."»</a>";
- }
- echo "</center>";
- echo "<br>";
- CloseTable();
- include("footer.php");
- }
One additional question is, I want to display the first row of the table to be today's date events no matter they are in ascending or descending order and that means the initial open page will not be the 1st page, Can I do that and how?
Thanks in advance