Need help addin stats to layout.php (SOLVED)

[jaimck]

My site is www.fast-ptc.info and i want to add some stats on my layout.php.

stats - total click, total site hits, etc...

So here is a image of where i want the stats



This is where the stats will be in the layout.php

Code:

<center>
<div class="bottom_bg">
<div class="bot_bg_in">

I want stats here!

</div>
</center>

Thanks in advance.

[Aligroup]

just copy your stats code and paste that in footer it will work 

[jaimck]

For stats code do you mean?

if($settings[homepage_stats] == 1) {
   $sql=$Db1->query("SELECT COUNT(userid) AS total FROM user");
   $totalmembers=$Db1->fetch_array($sql);
   $sql=$Db1->query("SELECT new_members, hits, clicked FROM stats WHERE date='$today_date'");
   $todaystats=$Db1->fetch_array($sql);
   $sql=$Db1->query("SELECT SUM(amount) AS total, COUNT(amount) AS amount FROM payment_history WHERE status=1");
   $totalpaid=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(stats.clicked) AS clicks FROM stats");
$total_clicks=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(stats.hits) AS total FROM stats");
$total_hits=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(cost) AS total FROM ledger WHERE status='1'","total");
$total_income=$Db1->fetch_array($sql);

   $homepagestats="
   ".number_format($totalmembers[total])."&ensp;Members&ensp;&ensp;
   ".number_format($todaystats[new_members])."&ensp;New Today&ensp;&ensp;
   ".number_format($todaystats[hits])."&ensp;Hits Today&ensp;&ensp;
   ".number_format($total_online)."&ensp;Online&ensp;&ensp;
   ".number_format($totalpaid[amount])."&ensp;Payouts Made&ensp;&ensp;
   $".number_format($totalpaid[total],2)."&ensp;Total Paid&ensp;&ensp;
        ".number_format($total_clicks[clicks])."&ensp;Total PTC Served&ensp;
        ".number_format($total_hits[total])."&ensp;Total Site Hits&ensp;";

I have tried this and failed.

Or

<?=$h_top;?>

I have tried this and it only shows the stats that are located up top. (Located in layout_header.php

[jaimck]

Any help will be appreciated.

[wiicker95]

Add this code : <?php if($settings['homepage_stats']==1) echo $homepagestats; ?>

[Aligroup]

Add this code : <?php if($settings['homepage_stats']==1) echo $homepagestats; ?>

add this code

[jaimck]

Instead of this:

Code:

if($settings[homepage_stats] == 1) {
$sql=$Db1->query("SELECT COUNT(userid) AS total FROM user");
$totalmembers=$Db1->fetch_array($sql);
$sql=$Db1->query("SELECT new_members, hits, clicked FROM stats WHERE date='$today_date'");
$todaystats=$Db1->fetch_array($sql);
$sql=$Db1->query("SELECT SUM(amount) AS total, COUNT(amount) AS amount FROM payment_history WHERE status=1");
$totalpaid=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(stats.clicked) AS clicks FROM stats");
$total_clicks=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(stats.hits) AS total FROM stats");
$total_hits=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(cost) AS total FROM ledger WHERE status='1'","total");
$total_income=$Db1->fetch_array($sql);

$homepagestats="
".number_format($totalmembers[total])."&ensp;Members&ensp;&ensp;
".number_format($todaystats[new_members])."&ensp;New Today&ensp;&ensp;
".number_format($todaystats[hits])."&ensp;Hits Today&ensp;&ensp;
".number_format($total_online)."&ensp;Online&ensp;&ensp;
".number_format($totalpaid[amount])."&ensp;Payouts Made&ensp;&ensp;
$".number_format($totalpaid[total],2)."&ensp;Total Paid&ensp;&ensp;
        ".number_format($total_clicks[clicks])."&ensp;Total PTC Served&ensp;
        ".number_format($total_hits[total])."&ensp;Total Site Hits&ensp;";
}

and calling it by:

Code:

<?php if($settings['homepage_stats']==1) echo $homepagestats; ?>

Can i make another and add it to the header like example:

Code:

if($settings[custom_stats] == 1) {
        $sql=$Db1->query("SELECT SUM(stats.clicked) AS clicks FROM stats");
$total_clicks=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(stats.hits) AS total FROM stats");
$total_hits=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(cost) AS total FROM ledger WHERE status='1'","total");
$total_income=$Db1->fetch_array($sql);

$customstats="
        ".number_format($total_clicks[clicks])."&ensp;Total PTC Served&ensp;
        ".number_format($total_hits[total])."&ensp;Total Site Hits&ensp;";
}

and call it by:

Code:

<?php if($settings['custom_stats']==1) echo $customstats; ?>

Or can you show me another way i can call stats other then homepage stats please?

[jaimck]

Worked it out so thanks to everyone trying to help 

I added this:

include/settings.php

"custom_stats"=>"2",

And This:

templates/ --- / layout_header.php

if($settings[custom_stats] == 2) {
        $sql=$Db1->query("SELECT SUM(stats.clicked) AS clicks FROM stats");
$total_clicks=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(stats.xclicked) AS total FROM stats");
$total_ce=$Db1->fetch_array($sql);
        $sql=$Db1->query("SELECT SUM(stats.ptrads) AS total FROM stats");
$total_ptra=$Db1->fetch_array($sql);
       

   $customstats="
        ".number_format($total_clicks[clicks])."&ensp;Total PTC Served&ensp;
        &ensp;-&ensp;
        ".number_format($total_ce[total])."&ensp;Total CE Ads Served&ensp;
        &ensp;-&ensp;
        ".number_format($total_ptra[total])."&ensp;Total PTRA Served&ensp;";
}

And then This:

Templates / --- / layout.php

<?php if($settings['custom_stats']==2) echo $customstats; ?>