/**
* Constructor
*
* @param string $language Language
*
* @return void
*/
public function __construct($language = null)
{
parent::__construct();
$this->setLanguage($language);
$query = sprintf("\n SELECT\n fc.id AS id,\n fc.lang AS lang,\n fc.parent_id AS parent_id,\n fc.name AS name,\n fc.description AS description,\n fc.user_id AS user_id\n FROM\n %sfaqcategories fc\n WHERE\n 1=1", SQLPREFIX);
if (!is_null($this->language)) {
$query .= sprintf(" \n AND \n fc.lang = '%s'", $this->language);
}
$query .= "\n ORDER BY fc.id";
$result = $this->db->query($query);
if (!$result) {
throw new PMF_Exception($this->db->error());
}
while ($row = $this->db->fetch_assoc($result)) {
$cat = new PMF_Category($row);
$this->data[$row['id']] = $cat;
if (!isset($this->children[$row['parent_id']])) {
$this->children[$row['parent_id']] = array($cat);
} else {
$this->children[$row['parent_id']][] = $cat;
}
}
if (!count($this->children)) {
$emptyCategory = array('id' => -1, 'lang' => $this->language, 'name' => null, 'children' => 0, 'parent_id' => 0);
$this->children[0] = new PMF_Category($emptyCategory);
}
foreach ($this->children as $parentid => $children) {
if (!$parentid) {
continue;
}
$parent = $this->data[$parentid];
$parent->setChildcount(sizeof($children));
foreach ($children as $child) {
$child->setParent($parent);
}
}
}
/**
* Constructor
*
* @return void
*/
public function __construct()
{
parent::__construct();
}
/**
* Constructor
*
* @param string $language Language
*
* @return void
*/
public function __construct($language = null)
{
parent::__construct();
$this->setLanguage($language);
}
