Grabbing data from the Statistics form

[Nurofreeze]

My site is at www.ebasin.com.

If you'll notice, I have included statistics on the home page and would like to grab the code that displays the number of active ads to the home page statistics. Can someone please tell me where this particular section of code is and if I can just copy and paste it into the existing code on the home page, changing the paths and what not? I paid to have the index page created but am trying to learn all of this on my own.

thanks.

[Chuck S]

You can find the statistics query in index.php and the statistics template has the html so you can find out how to do it via looking at this.

[Nurofreeze]

thanks omega.

[Nurofreeze]

Just got back on this. Is the statistics template statspal.tmpl?

[Chuck S]

yes thats the template

[Nurofreeze]

Ok. I'm doing the best I can but I'm having trouble finding which code to put in. I keep getting SQL errors. Which block of code do I use from each file?

I'm assuming this is the correct block in statspal

<tr>
<td class="{$Style['tddetails']}" align="left"><span class="{$Style['small']}">{$Globals['pp_lang']['activeads']}</span></td>
<td class="{$Style['tddetails']}" align="right"><span class="{$Style['small']}">$totalproducts</span></td>
</tr>

And this the correct querry in index.php?

$query = "SELECT SUM(views), count(*) FROM {$Globals['pp_db_prefix']}products WHERE approved=1";
$totalv = ppmysql_query($query,$link);
list( $totalviews, $totalproducts ) = mysql_fetch_row($totalv);
ppmysql_free_result($totalv);

With

$totalproducts = number_format( $totalproducts );

But how do I query it on an index page independant of the classifieds?
What files do I need to include?

Thanks again.