Hi,
I ran into a problem where the old warchives-plugin didn't work anymore. Don't know why but though I was not happy with the coding at all I rewrote it similar to the TAG_* code:
------------------------------------------------------------------------------------------------------------------
<?php
$addon_name = "weighted archive generator";
$addon_version = "0.2";
$addon_description = "takes the categories and makes the font larger the more posts are in that category.<p>the tag is: <PIXELPOST_WARCHIVES>.";
$default_language_abr = strtolower($PP_supp_lang[$cfgrow['langfile']][0]);
$cats_output = '<div id="cat_cloud">';
$queryr = "SELECT COUNT(*) AS max
FROM {$pixelpost_db_prefix}pixelpost AS p, {$pixelpost_db_prefix}catassoc AS c
WHERE p.id = c.image_id AND p.datetime<='$cdate'
GROUP BY cat_id
ORDER BY max DESC
LIMIT 1";
$cat_max = mysql_query($queryr);
$cat_max = mysql_fetch_row($cat_max);
$cat_max = $cat_max[0];
if ($language_abr == $default_language_abr)
$queryr = "SELECT ROUND(COUNT(*)/${cat_max},1) AS rank, c.id AS cat_id, c.name AS cat_name, COUNT(*) as cnt
FROM {$pixelpost_db_prefix}pixelpost AS p, {$pixelpost_db_prefix}catassoc AS ca, {$pixelpost_db_prefix}categories c
WHERE p.id = ca.image_id AND ca.cat_id = c.id AND p.datetime<='$cdate'
GROUP BY ca.cat_id
ORDER BY ca.cat_id";
else
$queryr = "SELECT ROUND(COUNT(*)/${cat_max},1) AS rank, c.id AS cat_id, c.alt_name AS cat_name, COUNT(*) as cnt
FROM {$pixelpost_db_prefix}pixelpost AS p, {$pixelpost_db_prefix}catassoc AS ca, {$pixelpost_db_prefix}categories c
WHERE p.id = ca.image_id AND ca.cat_id = c.id AND p.datetime<='$cdate'
GROUP BY ca.cat_id
ORDER BY ca.cat_id";
$cats = mysql_query($queryr);
while(list($rank, $cat_id, $cat_name, $cnt) = mysql_fetch_array($cats))
{
$cats_output .= '<a href="index.php?x=browse&category='.$cat_id.'" class="tags'.$rank[0].$rank[2].'">'.$cat_name.'</a> ';
}
$cats_output .= '</div>';
$tpl = str_replace("<PIXELPOST_WARCHIVES>",$cats_output,$tpl); //thumbnails in this page
?>
------------------------------------------------------------------------------------------------------------------
Cheers,
Yann