02-24-2007, 05:38 PM
This code is from the "Downloads" Modul in Php-Nuke (same as the Weblinks). I want that instead of showing the categories in 2 columns, it'll show only one column - Which means, Category under a category and not 2 in a row.
What should i edit (I'm not good with php):
php Code:
function index() {
global $prefix, $db, $show_links_num, $module_name;
include("header.php");
$maindownload = 0;
menu($maindownload);
echo "
";
OpenTable();
echo "<center><font class="title">"._DOWNLOADSMAINCAT."</font></center>
";
echo "<table border="0" cellspacing="10" cellpadding="0" align="center"><tr>";
$sql = "SELECT cid, title, cdescription FROM ".$prefix."_downloads_categories WHERE parentid='0' ORDER BY title";
$result = $db->sql_query($sql);
$count = 0;
while ($row = $db->sql_fetchrow($result)) {
$cid = $row[cid];
$cid = intval(trim($cid));
$title = $row[title];
$cdescription = $row[cdescription];
if ($show_links_num == 1) {
$cnumrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_downloads WHERE cid='$cid'"));
$cnumm = "($cnumrows)";
} else {
$cnumm = "";
}
echo "<td><font class="option"><strong><big>·</big></strong> <a href="modules.php?name=$module_name&d_op=viewdown load&cid=$cid">$title</a>$cnumm</font>";
categorynewdownloadgraphic($cid);
if ($cdescription) {
echo "
<font class="content">$cdescription</font>
";
} else {
echo "
";
}
$sql2 = "SELECT cid, title FROM ".$prefix."_downloads_categories WHERE parentid='$cid' ORDER BY title LIMIT 0,3";
$result2 = $db->sql_query($sql2);
$space = 0;
while ($row2 = $db->sql_fetchrow($result2)) {
$cid = $row2[cid];
$stitle = $row2[title];
if ($space>0) {
echo ", ";
}
if ($show_links_num == 1) {
$cnumrows2 = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_downloads WHERE cid='$cid'"));
$cnum = " ($cnumrows2)";
} else {
$cnumrows2 = "";
}
echo "<font class="content"><a href="modules.php?name=$module_name&d_op=viewdown load&cid=$cid">$stitle</a>$cnum</font>";
$space++;
}
if ($count<1) {
echo "</td><td> </td>";
$dum = 1;
}
$count++;
if ($count==2) {
echo "</td></tr><tr>";
$count = 0;
$dum = 0;
}
}
if ($dum == 1) {
echo "</tr></table>";
} elseif ($dum == 0) {
echo "<td></td></tr></table>";
}
$numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_downloads"));
$catnum = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_categories"));
echo "<center><font class="content">"._THEREARE." $numrows "._DOWNLOADS." "._AND." $catnum "._CATEGORIES." "._INDB."</font></center>";
CloseTable();
include("footer.php");
}
Thanks,
What should i edit (I'm not good with php):
php Code:
function index() {
global $prefix, $db, $show_links_num, $module_name;
include("header.php");
$maindownload = 0;
menu($maindownload);
echo "
";
OpenTable();
echo "<center><font class="title">"._DOWNLOADSMAINCAT."</font></center>
";
echo "<table border="0" cellspacing="10" cellpadding="0" align="center"><tr>";
$sql = "SELECT cid, title, cdescription FROM ".$prefix."_downloads_categories WHERE parentid='0' ORDER BY title";
$result = $db->sql_query($sql);
$count = 0;
while ($row = $db->sql_fetchrow($result)) {
$cid = $row[cid];
$cid = intval(trim($cid));
$title = $row[title];
$cdescription = $row[cdescription];
if ($show_links_num == 1) {
$cnumrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_downloads WHERE cid='$cid'"));
$cnumm = "($cnumrows)";
} else {
$cnumm = "";
}
echo "<td><font class="option"><strong><big>·</big></strong> <a href="modules.php?name=$module_name&d_op=viewdown load&cid=$cid">$title</a>$cnumm</font>";
categorynewdownloadgraphic($cid);
if ($cdescription) {
echo "
<font class="content">$cdescription</font>
";
} else {
echo "
";
}
$sql2 = "SELECT cid, title FROM ".$prefix."_downloads_categories WHERE parentid='$cid' ORDER BY title LIMIT 0,3";
$result2 = $db->sql_query($sql2);
$space = 0;
while ($row2 = $db->sql_fetchrow($result2)) {
$cid = $row2[cid];
$stitle = $row2[title];
if ($space>0) {
echo ", ";
}
if ($show_links_num == 1) {
$cnumrows2 = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_downloads WHERE cid='$cid'"));
$cnum = " ($cnumrows2)";
} else {
$cnumrows2 = "";
}
echo "<font class="content"><a href="modules.php?name=$module_name&d_op=viewdown load&cid=$cid">$stitle</a>$cnum</font>";
$space++;
}
if ($count<1) {
echo "</td><td> </td>";
$dum = 1;
}
$count++;
if ($count==2) {
echo "</td></tr><tr>";
$count = 0;
$dum = 0;
}
}
if ($dum == 1) {
echo "</tr></table>";
} elseif ($dum == 0) {
echo "<td></td></tr></table>";
}
$numrows = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_downloads"));
$catnum = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_downloads_categories"));
echo "<center><font class="content">"._THEREARE." $numrows "._DOWNLOADS." "._AND." $catnum "._CATEGORIES." "._INDB."</font></center>";
CloseTable();
include("footer.php");
}
Thanks,