Codezwiz >> Forums >> General PHP Nuke Help >> A Custom Content Module

Hey Guys,

I have thus put together the following code to pump out in one set the last 5 pages and links for the Content module and the last 5 categories for the content module as well.

here is the code:

<?php

/************************************************************************/
/* PHP-NUKE: Web Portal System */
/* =========================== */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* 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. */
/************************************************************************/

if (eregi("block-Top10_Downloads.php",$_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}

global $prefix, $db;

$a = 1;
$sql = "SELECT pid, title FROM ".$prefix."_pages ORDER BY pid DESC LIMIT 0,10";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$page = ereg_replace("_", " ", $row[title]);

$content .= "<strong><big>�;</big></strong> ;;<a href=\"modules.php?name=Content&pa=showpage&pid=$row[pid]\">$row[title]</a><BR>";
$a++;
}

$a = 1;
$sql = "SELECT cid, title FROM ".$prefix."_pages_categories ORDER BY cid DESC LIMIT 0,10";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$categories = ereg_replace("_", " ", $row[title]);

$content .= "<big>�;</big> ;;<a href=\"modules.php?name=Content&pa=list_pages_categories&cid=$row[cid]\">$row[title]</a><br></td>";
$a++;
}

?>