[abcdefgary]

edited text

[Geoserv]

Perfect.

Thanks a lot.

Geoserv.

[noyp]

We've been 'serv by Geoserv....

thanks will try this.


noyP

[P1mpPanther]

very easy to install - works out the box.

nice job, thanks!

[jc007]

Great Mod, thanks

[pligger2]

Great, however for some reason it's not working in sidebar
(counter is drawed in paint), i want to put this count here, by editing sidebar_stories.php.

	elseif ($the_template == "yget") {
	
	echo "<div class=tlb><span><a onclick=\"new Effect.toggle('ssstories','blind', {queue: 'end'}); \"> <img src=\"".my_base_url.my_pligg_base."/templates/".The_Template."/images/expand.png\" /></a></span><a href=\"".$ss->link."\">".$ss->header." {$queued}</a></div><div id=ssstories style=padding-bottom:2px>";
	$ss->template = $the_template . '/sidebar_stories.tpl';
	$ss->show();
	echo "</div>";

but it's not working.
What i'm doeing wrong ?

[not2serious]

Looks like I got it installed corectly.

Thanks, for the great instructions.

[tbones]

I´ve tried to get all the published and upcoming stories of certain categories. It works but I guess it could be optimized. Help is appreciated.

$queued = $db->get_var('SELECT count(*) from ' . table_links . ' where link_status != "discard" and (link_category = 1 or link_category = 8 or link_category = 9 or link_category = 10 or link_category = 3);');

[not2serious]

Hi tbones,

I would like to have a story count after every category. Not just specific ones, I have 14 categories. Would you be able to provide specific instructions (code, file names and location in the code) on how to accomplish this mod. I am not a coder, but have been able to accomplish some of the mods I need.

I would greatly appreciate your help.

[tbones]

I´m not a coder at all but you can see from the above code that the db table is table_links aka pligg_links (if you took the default prefix). So the query should be

SELECT count(*) from ' . table_links . ' where (link_status = "queued" or link_status = "published") and link_category = x

I guess you have to define a smarty variable for every category but I can´t tell you were to put this information in sidebar_categories.tpl or somewhere else.