Hello, I found problem with AStat where was category filter.
If CategoryRank example 1.1.1
found also 1.1.10, 1.1.11, ...
Repair script Astat_aip.class.inc.php
original:
private function make_where_clause($catfilter)
{
$returned=array();
$sql="SELECT id, ".CATEGORIES_TABLE.".global_rank
FROM ".CATEGORIES_TABLE.",
(SELECT global_rank FROM ".CATEGORIES_TABLE." WHERE id = '".$catfilter."') as tmp1
WHERE ".CATEGORIES_TABLE.".global_rank LIKE CONCAT(tmp1.global_rank, '%')
ORDER BY ".CATEGORIES_TABLE.".global_rank";
$result = pwg_query($sql);
if($result)
{
while ($row = pwg_db_fetch_row($result))
{
$returned[]=$row[0];
}
}
return(implode(',', $returned));
}
new:
private function make_where_clause($catfilter)
{
$returned=array();
$sql="SELECT id, ".CATEGORIES_TABLE.".global_rank
FROM ".CATEGORIES_TABLE.",
(SELECT global_rank FROM ".CATEGORIES_TABLE." WHERE id = '".$catfilter."') as tmp1
WHERE ".CATEGORIES_TABLE.".global_rank LIKE CONCAT(tmp1.global_rank, '.%')
OR ".CATEGORIES_TABLE.".global_rank = tmp1.global_rank
ORDER BY ".CATEGORIES_TABLE.".global_rank";
$result = pwg_query($sql);
if($result)
{
while ($row = pwg_db_fetch_row($result))
{
$returned[]=$row[0];
}
}
return(implode(',', $returned));
}
Offline
Hi
Thanks for the information.
I'll fix it as soon as I've some time for.
Offline
Hi,
the same problem in new version AStat.
Thanks T.
Offline