phpwcms Support Forum

Code: Select all

<?php
// ================================================================
// Show the count of articles in active category
// 02.03.08 K.H. flip-flop
// 
// Thanks to Jensensen for the inspiration
// http://forum.phpwcms.org/viewtopic.php?p=100208#p100208
// Input    :     {ARTICLECOUNT} 
// Output .e.g.:  17
// File:          /template/inc_script/frontend_render/rt_article_count.php
// Config:        $phpwcms['allow_ext_render']  = 1; 
// 
// ================================================================= 
// ----------------------------------------------------------------
// obligate check for phpwcms constants
if (!defined('PHPWCMS_ROOT')) {
   die("You Cannot Access This Script Directly, Have a Nice Day.");
}
// ----------------------------------------------------------------


function my_article_count () {

	$my_cat_id = $GLOBALS['content']['cat_id'];

	$sql = "SELECT * FROM ".DB_PREPEND."phpwcms_article WHERE article_cid=$my_cat_id ";
	$sql .= "AND article_public=1 AND article_aktiv=1";
	$result = mysql_query($sql);
	$num_rows = mysql_num_rows($result);

return $num_rows;
}

// ARTICLECOUNT replacement

if( ! (strpos($content["all"],'{ARTICLECOUNT}')===false)) {
	$content["all"] = str_replace('{ARTICLECOUNT}', my_article_count(), $content["all"]);
}

?>

Code: Select all

<?php
// ================================================================
// Show the count of articles in the active category (V1.1)
// 02.03.08 K.H. flip-flop 
// 25.04.08 K.H. Edit V1.1
// 
// Thanks to Jensensen for the inspiration
// http://forum.phpwcms.org/viewtopic.php?p=100208#p100208
// Input    :     {ARTICLECOUNT} 
// Output .e.g.:  17
// File:          /template/inc_script/frontend_render/rt_article_count.php
// Config:        $phpwcms['allow_ext_render']  = 1; 
// ================================================================= 
// ----------------------------------------------------------------
// obligate check for phpwcms constants
if (!defined('PHPWCMS_ROOT')) {
   die("You Cannot Access This Script Directly, Have a Nice Day.");
}
// ----------------------------------------------------------------

if( ! (strpos($content["all"],'{ARTICLECOUNT}')===false)) {
	$content["all"] = str_replace('{ARTICLECOUNT}', count($GLOBALS['content']["articles"]), $content["all"]);
}
?>

Code: Select all

foreach($GLOBALS['content']['struct'] as $key => $value) {

// NEW CODE line 2881 approx.
	$temp_sql = "SELECT * FROM ".DB_PREPEND."phpwcms_article WHERE article_cid=$key ";
	$temp_sql .= "AND article_public=1 AND article_aktiv=1";
	$temp_result = mysql_query($temp_sql);
	$temp_num_rows = mysql_num_rows($temp_result);

Code: Select all

		// ORIGINAL CODE line 2925 approx.
		// $li .= '>' . $li_a . '</a>';
		$li .= '>' . $li_a . ' ('.$temp_num_rows.')</a>'; // NEW CODE 
		$li .= $li_ul.'</li>'.LF; // remove $li_ul from this line of code if $ie_patch is used
		$x++;
	} 
	mysql_free_result($temp_result); // NEW CODE
}