$section = "external-news"; } elseif ($_GET['q'] == "ext_bottom_7days") { $query = "SELECT * FROM ext WHERE `Deleted`='0' AND `Visible`='1' AND `Posted` >= DATE_SUB(CURRENT_DATE(), INTERVAL {$recent_days} DAY) ORDER BY `Rank` ASC LIMIT 4"; $section = "external-news"; } elseif ($_GET['q'] == "ext_bottom_all") { $query = "SELECT * FROM ext WHERE `Deleted`='0' AND `Visible`='1' ORDER BY `Rank` ASC LIMIT 4"; $section = "external-news"; } if ($result = mysql_query_cached($query)) { foreach ($result->data as $item) { $name = utf8entities(stripslashes($item['Name'])); $id = $item['Id']; $comments = $item['CommentCount']; $rank = $section == "external-news" ? $item['Rank'] : 0; $upvotes = $section == "press" ? $item['Upvotes'] : 0; echo template_item($name, $section, $id, $comments, false, $upvotes, $rank); } } } } else { die("Error: No valid query was passed on."); } /* if(!isset($_GET['s']) || !isset($_GET['f']) || !isset($_GET['o']) || !isset($_GET['p'])) { die("An internal error occurred. Not all variables were set."); } if($_GET['s'] == "ext") { $section = "ext";
if ($var_page < $last_page) { $p = $var_page + 2; $page_list .= "<a href=\"/press/list/{$var_sort}/{$var_sortdir}/{$p}/\">next >></a>"; } $query_sort = $var_sort == "date" ? "Posted" : "Upvotes"; $query_dir = $var_sortdir == "asc" ? "ASC" : "DESC"; $query = "SELECT Id, Name, CommentCount, Upvotes FROM press WHERE `Approved` = '1' AND `Deleted` = '0' ORDER BY `{$query_sort}` {$query_dir} LIMIT {$start},{$per_page}"; if ($result = mysql_query_cached($query)) { $style[0] = $var_sort == "date" && $var_sortdir == "desc" ? " class=\"active\"" : ""; $style[1] = $var_sort == "date" && $var_sortdir == "asc" ? " class=\"active\"" : ""; $style[2] = $var_sort == "upvotes" && $var_sortdir == "desc" ? " class=\"active\"" : ""; $style[3] = $var_sort == "upvotes" && $var_sortdir == "asc" ? " class=\"active\"" : ""; echo "<div class=\"sort-options\">\n\t\t\t\tSort order:\n\t\t\t\t<a href=\"/press/list/date/desc/\"{$style[0]}>Newest first</a>\n\t\t\t\t<a href=\"/press/list/date/asc/\"{$style[1]}>Oldest first</a>\n\t\t\t\t<a href=\"/press/list/upvotes/desc/\"{$style[2]}>Highest ranked first</a>\n\t\t\t\t<a href=\"/press/list/upvotes/asc/\"{$style[3]}>Lowest ranked first</a>\n\t\t\t</div>\n\t\t\t<div class=\"clear\"></div>"; echo "<div class=\"page-list page-list-top\">\n\t\t\t\t{$page_list}\n\t\t\t</div>"; foreach ($result->data as $item) { $name = utf8entities(stripslashes($item['Name'])); $id = $item['Id']; $comments = $item['CommentCount']; $upvotes = $item['Upvotes']; echo template_item($name, "press", $id, $comments, false, $upvotes, 0); } echo "<div class=\"page-list page-list-bottom\">\n\t\t\t\t{$page_list}\n\t\t\t</div>"; } } else { $var_code = ANONNEWS_ERROR_MALFORMED_DATA; require "module.error.php"; } } else { $var_code = ANONNEWS_ERROR_DATABASE_ERROR; require "module.error.php"; }
} $query_sort = $var_sort == "date" ? "Posted" : "Rank"; $query_dir = $var_sortdir == "asc" ? "ASC" : "DESC"; $query = "SELECT Id, Name, CommentCount, Rank FROM ext WHERE `Visible` = '1' AND `Deleted` = '0' ORDER BY `{$query_sort}` {$query_dir} LIMIT {$start},{$per_page}"; if ($result = mysql_query_cached($query)) { $style[0] = $var_sort == "date" && $var_sortdir == "desc" ? " class=\"active\"" : ""; $style[1] = $var_sort == "date" && $var_sortdir == "asc" ? " class=\"active\"" : ""; $style[2] = $var_sort == "rank" && $var_sortdir == "desc" ? " class=\"active\"" : ""; $style[3] = $var_sort == "rank" && $var_sortdir == "asc" ? " class=\"active\"" : ""; echo "<div class=\"sort-options\">\n\t\t\t\tSort order:\n\t\t\t\t<a href=\"/external-news/list/date/desc/\"{$style[0]}>Newest first</a>\n\t\t\t\t<a href=\"/external-news/list/date/asc/\"{$style[1]}>Oldest first</a>\n\t\t\t\t<a href=\"/external-news/list/rank/desc/\"{$style[2]}>Highest ranked first</a>\n\t\t\t\t<a href=\"/external-news/list/rank/asc/\"{$style[3]}>Lowest ranked first</a>\n\t\t\t</div>\n\t\t\t<div class=\"clear\"></div>"; echo "<div class=\"page-list page-list-top\">\n\t\t\t\t{$page_list}\n\t\t\t</div>"; foreach ($result->data as $item) { $name = utf8entities(stripslashes($item['Name'])); $id = $item['Id']; $comments = $item['CommentCount']; $rank = $item['Rank']; echo template_item($name, "external-news", $id, $comments, false, 0, $rank); } echo "<div class=\"page-list page-list-bottom\">\n\t\t\t\t{$page_list}\n\t\t\t</div>"; } else { $var_code = ANONNEWS_ERROR_DATABASE_ERROR; require "module.error.php"; } } else { $var_code = ANONNEWS_ERROR_MALFORMED_DATA; require "module.error.php"; } } else { $var_code = ANONNEWS_ERROR_DATABASE_ERROR; require "module.error.php"; }
<div class="clear"></div> </div> </div> <div class="section-wrapper"> <div class="section-header"> <?php echo $lang[7]; ?> </div> <div class="section"> <?php $query = "SELECT * FROM sites WHERE `Deleted`='0' AND `Approved`='1' ORDER BY `Posted` DESC LIMIT 4"; if ($result = mysql_query_cached($query)) { foreach ($result->data as $item) { $name = utf8entities(stripslashes($item['Name'])); $id = $item['Id']; $comments = $item['CommentCount']; echo template_item($name, "related-sites", $id, $comments, false, 0, 0); } } ?> <a href="/related-sites/list/desc/" class="section-button">More (<?php echo $total_sites; ?> ) <span class="bold">>></span></a> <a href="/related-sites/add/" class="section-button"><span class="bold">+</span> Add</a> <div class="clear"></div> </div> </div>