need a block updated

mavrick1971 · New Member Joined: Jul 10, 2005 Posts: 2

I need a block updated to new sql layer, just want my site completely upto new sql layer. Possible to add 5 newest web links.

Check author website and there no longer around.

Code:

<?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\">$titleheadlines: ";
$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&file=article&sid=$sid\">$title</a> ($counter "._READS.") ";
$a++;
}
$content .= "<big>·</big> <a href=\"modules.php?name=News\">More News...</td>";

// Top Downloads
$content .= "<td valign=\"top\">$titletopdownloads: ";
$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&d_op=viewdownloaddetails&lid=$lid&title=$title\">$title2</a> ($hits hits) ";
$a++;
}

// New Downloads
$content .= " $titlenewdownloads: ";
$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&d_op=viewdownloaddetails&lid=$lid&title=$title\">$title2</a> ($hits hits) ";
 $a++;
}
$content .= "</table></td>";
?>

Raven · Posted: Sun Jul 10, 2005 9:36 pm

Old

Code:

// Top Downloads
$content .= "<td valign=\"top\">$titletopdownloads: ";
$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&d_op=viewdownloaddetails&lid=$lid&title=$title\">$title2</a> ($hits hits) ";
$a++;
}

// New Downloads
$content .= " $titlenewdownloads: ";
$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&d_op=viewdownloaddetails&lid=$lid&title=$title\">$title2</a> ($hits hits) ";
$a++;
}

New

Code:

// Top Downloads
$content .= "<td valign=\"top\">$titletopdownloads: ";
$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&d_op=viewdownloaddetails&lid=$lid&title=$title\">$title2</a> ($hits hits) ";
$a++;
}

// New Downloads
$content .= " $titlenewdownloads: ";
$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&d_op=viewdownloaddetails&lid=$lid&title=$title\">$title2</a> ($hits hits) ";
$a++;
}

mavrick1971 · New Member Joined: Jul 10, 2005 Posts: 2

thank you very much Groovy