<?php





/************************************************************************/


/* PHP-NUKE: Web Portal System                                          */


/* ===========================                                          */


/*                                                                      */


/* PHP All Info Block v2.0 by: SlimBrady (tbrady85@netcommander.com)    */


/* http://unitedgamerz.net - http://fraggedout.com                      */


/*                                                                      */


/* This program is free software. You can redistribute it and/or modify */


/* it under the terms of the GNU General Public License as published by */


/* the Free Software Foundation; either version 2 of the License.       */


/************************************************************************/





/************************/


/*      Variables       */


/************************/





// Number of Headlines to show


$headlines = 15;


// Number of downloads to show for Top Downloads


$downloadnumbertop = 5;


// Number of downloads to show for New Downloads


$downloadnumbernew = 10;


// Title of headlines section


$titleheadlines = "Headlines";


// Title of Top Downloads section


$titletopdownloads = "Top Downloads";


// Title of New Downloads section


$titlenewdownloads = "New Downloads";





/************************/


/*     End Variables    */


/************************/





// Stops people from accessing it directly


if (eregi("block-All_Info.php", $_SERVER['PHP_SELF'])) {


    Header("Location: index.php");


    die();


}





global $prefix, $multilingual, $currentlang, $db, $dbi;





// Headlines


if ($multilingual == 1) {


    $querylang = "WHERE (alanguage='$currentlang' OR alanguage='')";


} else {


    $querylang = "";


}


$content = "<table width=\"100%\" border=\"0\">";


$content .= "<tr><td align=\"left\"><b>$titleheadlines:</b><br>";


$a = 1;


$sql = "SELECT sid, title, comments, time, counter FROM ".$prefix."_stories $querylang ORDER BY sid DESC LIMIT 0,$headlines";


$result = $db->sql_query($sql);


while ($row = $db->sql_fetchrow($result)) {


    $sid = $row[sid];


    $title = $row[title];


    $comtotal = $row[comments];


    $counter = $row[counter];


    $content .= "$a: <a href=\"modules.php?name=News&amp;file=article&amp;sid=$sid\">$title</a>&nbsp;<em>($counter "._READS.")</em><br>";


   $a++;


}


$content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"news.html\">More News...</td>";





// Top Downloads


$content .= "<td valign=\"top\"><b>$titletopdownloads:</b><br>";


$a = 1;


$result = sql_query("select lid, title, hits from ".$prefix."_downloads_downloads order by hits DESC limit 0,$downloadnumbertop", $dbi);





while(list($lid, $title, $hits) = sql_fetch_row($result, $dbi)) {


    $title2 = ereg_replace("_", " ", $title);


    $content .= "$a: <a href=\"modules.php?name=Downloads&amp;d_op=viewdownloaddetails&amp;lid=$lid&amp;title=$title\">$title2</a>&nbsp;<em>($hits hits)</em><br>";


    $a++;


}





// New Downloads


$content .= "<br><b>$titlenewdownloads:</b><br>";


$a = 1;


$result = sql_query("select lid, title, hits from ".$prefix."_downloads_downloads order by date DESC limit 0,$downloadnumbernew", $dbi);


while(list($lid, $title, $hits) = sql_fetch_row($result, $dbi)) {


      $title2 = ereg_replace("_", " ", $title);


     $content .= "$a: <a href=\"modules.php?name=Downloads&amp;d_op=viewdownloaddetails&amp;lid=$lid&amp;title=$title\">$title2</a>&nbsp;<em>($hits hits)</em><br>";


      $a++;


}


$content .= "</table></td>";


   ?>

// Top Downloads


$content .= "<td valign=\"top\"><b>$titletopdownloads:</b><br>";


$a = 1;


$result = sql_query("select lid, title, hits from ".$prefix."_downloads_downloads order by hits DESC limit 0,$downloadnumbertop", $dbi);





while(list($lid, $title, $hits) = sql_fetch_row($result, $dbi)) {


    $title2 = ereg_replace("_", " ", $title);


    $content .= "$a: <a href=\"modules.php?name=Downloads&amp;d_op=viewdownloaddetails&amp;lid=$lid&amp;title=$title\">$title2</a>&nbsp;<em>($hits hits)</em><br>";


    $a++;


}





// New Downloads


$content .= "<br><b>$titlenewdownloads:</b><br>";


$a = 1;


$result = sql_query("select lid, title, hits from ".$prefix."_downloads_downloads order by date DESC limit 0,$downloadnumbernew", $dbi);


while(list($lid, $title, $hits) = sql_fetch_row($result, $dbi)) {


      $title2 = ereg_replace("_", " ", $title);


     $content .= "$a: <a href=\"modules.php?name=Downloads&amp;d_op=viewdownloaddetails&amp;lid=$lid&amp;title=$title\">$title2</a>&nbsp;<em>($hits hits)</em><br>";


      $a++;


} 

// Top Downloads


$content .= "<td valign=\"top\"><b>$titletopdownloads:</b><br>";


$a = 1;


$result = $db->sql_query("select lid, title, hits from ".$prefix."_downloads_downloads order by hits DESC limit 0,$downloadnumbertop");





while(list($lid, $title, $hits) = $db->sql_fetchrow($result)) {


    $title2 = ereg_replace("_", " ", $title);


    $content .= "$a: <a href=\"modules.php?name=Downloads&amp;d_op=viewdownloaddetails&amp;lid=$lid&amp;title=$title\">$title2</a>&nbsp;<em>($hits hits)</em><br>";


    $a++;


}





// New Downloads


$content .= "<br><b>$titlenewdownloads:</b><br>";


$a = 1;


$result = $db->sql_query("select lid, title, hits from ".$prefix."_downloads_downloads order by date DESC limit 0,$downloadnumbernew");


while(list($lid, $title, $hits) = $db->sql_fetchrow($result)) {


      $title2 = ereg_replace("_", " ", $title);


     $content .= "$a: <a href=\"modules.php?name=Downloads&amp;d_op=viewdownloaddetails&amp;lid=$lid&amp;title=$title\">$title2</a>&nbsp;<em>($hits hits)</em><br>";


      $a++;


}