Jordie (Interspire Staff)
02-15-2007, 02:20 AM
Hey guys,
Just an update on this one for a few people who have been having trouble because it relates to older code.
Same file: templates/[Your_Template]/Panels/RootArticleCategoriesPanel.php
Find:
while($catRow = mysql_fetch_array($catResult))
{
$output .= sprintf("
<div class=\"ListItem\">
<a href='%s'>
%s
</a>
</div>
", AL_HELPER::CategoryLink($catRow["CategoryID"], $catRow["Name"],false,true), $catRow["Name"]);
}
Now just before the closing } adding in this code:
// Start sub category mod
$query1 = sprintf("select * from %scategories where ParentID=%d order by Name asc", $GLOBALS["AL_CFG"]["tablePrefix"], $catRow["CategoryID"]);
$subResult = mysql_query($query1);
while($subRow = mysql_fetch_array($subResult))
{
$output .= sprintf'
<div class="ListItem" style="padding-left:20">
<A href="%s">
%s
</A>
</div>
', AL_HELPER::CategoryLink($subRow["CategoryID"], $subRow["Name"]), $subRow["Name"]);
}
// End sub category mod
So the whole thing now becomes:
while($catRow = mysql_fetch_array($catResult))
{
$output .= sprintf("
<div class=\"ListItem\">
<a href='%s'>
%s
</a>
</div>
", AL_HELPER::CategoryLink($catRow["CategoryID"], $catRow["Name"],false,true), $catRow["Name"]);
// Start sub category mod
$query1 = sprintf("select * from %scategories where ParentID=%d order by Name asc", $GLOBALS["AL_CFG"]["tablePrefix"], $catRow["CategoryID"]);
$subResult = mysql_query($query1);
while($subRow = mysql_fetch_array($subResult))
{
$output .= sprintf('
<div class="ListItem" style="padding-left:20">
<A href="%s">
%s
</A>
</div>
', AL_HELPER::CategoryLink($subRow["CategoryID"], $subRow["Name"]), $subRow["Name"]);
}
// End sub category mod
}
I hope that helps everyone!