function GetCategortyViewedTimesReport()
{
$q = db_query("select categoryID, name, viewed_times from " . CATEGORIES_TABLE . " where categoryID!=1 order by viewed_times DESC");
$data = array();
while ($r = db_fetch_row($q)) {
$wayadd = '';
$way = catCalculatePathToCategoryA($r["categoryID"]);
foreach ($way as $rail) {
if ($rail['categoryID'] != 1) {
$wayadd .= $rail['name'] . ' / ';
}
}
$row = array();
$row["name"] = $wayadd . "<b>" . $r["name"] . "</b>";
$row["viewed_times"] = $r["viewed_times"];
$data[] = $row;
}
return $data;
}
function catGetAppendedCategoriesToProduct($productID)
{
$q = db_query("select " . CATEGORIES_TABLE . ".categoryID as categoryID, name as category_name " . " from " . CATEGORIY_PRODUCT_TABLE . ", " . CATEGORIES_TABLE . " " . " where " . CATEGORIY_PRODUCT_TABLE . ".categoryID = " . CATEGORIES_TABLE . ".categoryID " . " AND productID = " . (int) $productID);
$data = array();
while ($row = db_fetch_row($q)) {
$wayadd = '';
$way = catCalculatePathToCategoryA($row["categoryID"]);
$cway = count($way);
for ($i = $cway - 1; $i >= 0; $i--) {
if ($way[$i]['categoryID'] != 1) {
$wayadd .= $way[$i]['name'] . ' / ';
}
}
$row["category_way"] = $wayadd . "<b>" . $row["category_name"] . "</b>";
$data[] = $row;
}
return $data;
}
