Area to display # of members and # of ads

[zman78 +]

Hi everyone,
I would love to have a space on my homepage that says you have x number of current ads and x number of site members. I have seen it in many php programs, and im sure it must be possible. I am running the latest designer version. Can anyone help out on this one?

Zack

[John Snyder +]

I'm not sure what files are encrypted. Eric are the smarty plugins encrypted? I wrote something to do this but having the designer version means those pages are encrypted.

I guess we could try a smarty file include or something. Give me a minute to see if that works.

[Eric Barnes]

The smarty files should not be encrypted.

I did have a plugin for the total number of listings. I will see if I can find it but I am finally heading home so it will be in the morning.

[Chaslie +]

I have the below code inserted into my /templates/default/layout.tpl.php file for the 'date' and 'total number of listings':

{$smarty.now|date_format:"%A, %e %B, %Y"}<br>and there are
	{total_listings} <a href="toplistings.php?pg=new">entries</a>

[John Snyder +]

Originally Posted by Chaslie

I have the below code inserted into my /templates/default/layout.tpl.php file for the 'date' and 'total number of listings':

{$smarty.now|date_format:"%A, %e %B, %Y"}<br>and there are
    {total_listings} <a href="toplistings.php?pg=new">entries</a>

That doesn't work on mysite. Where/How did you come by this bit of code. I don't have that function in the plugins directory. Can you post it here?

should be includes/templates/plugins/functions.total_listings.php or something.

[Chaslie +]

With my compliments, John.

includes/templates/plugins/functions.total_listings.php

{
    global $db;
    
    //get total active listings
    $sSQL="SELECT COUNT(*) AS total FROM ".PREFIX."products WHERE expiration > NOW() AND display = 'Y'";
    $result=$db->query($sSQL);
    $rs=$result->fetch();
    $total_listings=$rs['total'];

    return $total_listings;
}

It's been a busy day, eh?

[John Snyder +]

Ya, not too busy though.

What's the function line look like? I am not getting any numbers.

[Chaslie +]

Ooops - sorry John.

function smarty_function_total_listings($params, &$smarty)

[John Snyder +]

I'll have to kick myself in the but on that one, have been looking at the screen too long or its getting too late.

For some reason I couldn't see the difference between:

function smarty_function_total_listings($params, &$smarty)

and

function total_listings($params, &$smarty)

Ok, I'll do the same with users and post both plugins for anyone to upload.

[John Snyder +]

Ok,

All you do is upload the files and then open templates/default/layout.tpl.php and make the proper call to the function where you want the numbers displayed.

Something like this (layout.tpl.php):

Total Users = {total_users}, Total Ads = {total_listings}

Here are the files:

total_users.zip
total_listings.zip