Hi all,
I want the script only shows the subcategories in the left panel WHICH are subcategory of the current u are browsing at that moment. (same level)
Can anybody help me?
Example
-----------------------------------------------------------------------------
Interspire Homepage
Home - Cars - Fast cars (trail)
Categories:
- Cars TEXT
- Houses
- Boats
Subcategories:
- Fast cars
- Beautiful cars
-----------------------------------------------------------------------------
This is my current code:
<?php
/*******************************************\
* *
* Generic ArticleLive Panel Parsing Class *
* *
\*******************************************/
$panelClass = "AL_ROOTARTICLECATEGORIES_PANEL";
if(!class_exists($panelClass)){
CLASS AL_ROOTARTICLECATEGORIES_PANEL
{
var $_htmlFile;
function AL_ROOTARTICLECATEGORIES_PANEL($HTMLFile)
{
$this->_htmlFile = $HTMLFile;
}
function ParsePanel()
{
$htmlPanelData = "";
$parsedPanelData = "";
if(file_exists($this->_htmlFile))
{
if($fp = @fopen($this->_htmlFile, "rb"))
{
while(!feof($fp))
$htmlPanelData .= fgets($fp, 4096);
@fclose($fp);
}
}
// Parse the panel of tokens, etc
$GLOBALS["CategoryList"] = $this->_GetCategoryList();
$GLOBALS["SubCategoriesTable"] = $this->_GetSubCats(); /* i want the script fills in the current category ID */
$parsedPanelData = $GLOBALS["AL_CLASS_TEMPLATE"]->ParseGL($htmlPanelData);
return $parsedPanelData;
}
function _GetCategoryList()
{
// Get a list of article categories and return them
$output = "";
$query = sprintf("select * from %scategories where ParentID=0 order by SortOrder asc, Name asc", $GLOBALS["AL_CFG"]["tablePrefix"]);
$catResult = mysql_query($query);
while($catRow = mysql_fetch_array($catResult))
{
$output .= sprintf("
<div class=\"ListItem\">
<a href='%s'>
%s
</a>
</div>
", AL_HELPER::CategoryLink($catRow["CategoryID"], $catRow["Name"]), $catRow["Name"]);
}
if(mysql_num_rows($catResult) == 0)
$output .= sprintf("<div>%s</div>", $GLOBALS["AL_LANG"]["hpNoCategories"]);
return $output;
}
/* i want the script fills in the current category ID */
function _GetSubCats($parentid=3) {
$output = "";
$query = sprintf("select * from %scategories where ParentID='%d' order by Name asc", $GLOBALS["AL_CFG"]["tablePrefix"], (int)$parentid);
$subcatResult = mysql_query($query);
if (mysql_num_rows($subcatResult) == 0) return $output;
while($subcatRow = mysql_fetch_array($subcatResult)) {
$subcatlist = $this->_GetSubCats($subcatRow["CategoryID"]);
$subcatlink = AL_HELPER::CategoryLink($subcatRow["CategoryID"], $subcatRow["Name"]);
$output .= sprintf("
<div>
<A href='%s'>%s</A><br/>%s
</div>
", $subcatlink, $subcatRow["Name"], $subcatlist);
}
return $output;
}
}
}
?>