include("control/config_local.php");
include("control/global_funcs.php");
include("control/ADOdb/adodb.inc.php");
connectdb();
if($next == "") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 0,10");
} elseif($next == "1") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 10,10");
} elseif($next == "2") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 20,10");
} elseif($next == "3") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 30,10");
} elseif(next == "4") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 40,10");
} elseif($next == "5") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 50,10");
} elseif($next == "6") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 60,10");
} elseif($next == "7") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 70,10");
} elseif($next == "8") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 80,10");
} elseif($next == "9") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 90,10");
} elseif($next == "10") {
$pullnews = $db->Execute("SELECT * FROM gaming_news ORDER BY id DESC LIMIT 100,10");
}
$prev = $next - 1;
if($prev == "0") { $prev = ""; }
$next = $next + 1;
?>
News Archives - Gaming Portal - Outpost10F
$bntscore = "1";
$res = $db->Execute("SELECT character_name FROM bnt_ships WHERE ship_destroyed='N' ORDER BY score DESC LIMIT 5");
while(!$res->EOF)
{
$bnt=$res->fields;
echo "
";
echo "
$bnt[character_name]
";
$bntscore++;
$res->MoveNext();
}
?>
$promscore = "1";
$res = $db->Execute("SELECT empire FROM prom_players WHERE rank>0 ORDER BY rank ASC LIMIT 5");
while(!$res->EOF)
{
$prom=$res->fields;
echo "