I have 2 php files and 2 smarty template files. The problem is in the stats.php file I believe. What happens is when I add a new link and then get "clicks" on it the stats do show but when I delete the link the stats mess up. Look at the screenshot below...
[ATTACH=CONFIG]1455[/ATTACH]
As you can see it displays a "[" but it should say "No statistics" instead.
Here are the files:
stats.tpl.php
{include file="header.tpl.php"}
<!--Contents-->
<div id="contents">
<!--Left Contents-->
<div id="memberRightPanel">
<br />
<div class="heading1">Statistics</div>
<br />
<div style=" background:#f6f6f6; padding:20px; overflow:hidden; -moz-border-radius: 4px; -webkit-border-radius: 4px; -khtml-border-radius: 4px; border-radius: 4px; border:1px solid #cccccc; color:#252525">
<!--Date Pickers-->
<form action="stats.php" method="post">
<table cellspacing="0" style="font-size:13px; width:700px;" class="datearea">
<tr>
<td class="label" style="width:80px;">From</td> <td><input type="text" name="date1" id="date1" class="input_small" /></td> <td class="label" style="text-align:center; width:85px">To</td> <td><input type="text" id="date2" name="date2" class="input_small" /></td><td > <input type="submit" name="submit" style="vertical-align:middle" value="View" /></td>
</tr>
</table>
</div>
</form></div>
<!--End Date Picker-->
<script type="text/javascript">
var today = '{$serverDate}';
{literal}
$(document).ready(function(){
$('#date1').datepicker({ dateFormat: "yy-mm-dd"});
$('#date1').datepicker( "option", "defaultDate", today );
$('#date2').datepicker({ dateFormat: "yy-mm-dd"});
$('#date2').datepicker( "option", "defaultDate", today );
});
{/literal}
</script>
<div class="clear">
<p style="color:#56565f; font-size:16px; font-family:MyriadPro; margin:10px auto;">{if $date_start ne ""}Showing Statistics From | {$date_start} {/if}{if $date_end ne ""}- {$date_end}{/if} </p>
</div>
<div class="clear">
<br />
<div class="heading2">Link Locker Statistics</div>
<br />
<table cellspacing="0" class="earnings_table">
<tr>
<th> Link Locker Name</th>
<th>Earnings</th>
<th>Unlocks</th>
<th>Clicks</th>
<th>CR</th>
<th>EPC</th>
</tr>
{if $history ne "" && $history|@count gt 0}
{foreach item=data from=$history}
<tr>
<td>{$data.file}</td>
<td>${$data.profit}</td>
<td >{$data.downloads}</td>
<td>{$data.clicks}</td>
<td>{$data.conv}%</td>
<td>${$data.epc}</td>
</tr>
{/foreach}
<tr>
<td> Total/Average</td>
<td>${$total_profit}</td>
<td >{$total_downloads}</td>
<td>{$total_clicks}</td>
<td>{$total_conv}%</td>
<td>${$total_epc}</td>
</tr>
{else}
<tr><td colspan="7">No Statistics.</td></tr>
{/if}
</table>
<div class="clear">
<br />
<div class="heading2">Content Locker Statistics</div>
<br />
<table cellspacing="0" class="earnings_table">
<tr>
<th> Content Locker Name</th>
<th>Earnings</th>
<th>Unlocks</th>
<th>Clicks</th>
<th>CR</th>
<th>EPC</th>
</tr>
{if $gw_data ne "" && $gw_data|@count gt 0}
{foreach item=data from=$gw_data}
<tr>
<td><span title="{$data.gw_name}" class="ec-tip-twitter"> {$data.gw_name}</span></td>
<td>${$data.profit}</td>
<td >{$data.downloads}</td>
<td>{$data.clicks}</td>
<td>{$data.conv}%</td>
<td>${$data.epc}</td>
</tr>
{/foreach}
<tr>
<td> Total/Average</td>
<td>${$gtotal_profit}</td>
<td >{$gtotal_downloads}</td>
<td>{$gtotal_clicks}</td>
<td>{$gtotal_conv}%</td>
<td>${$gtotal_epc}</td>
</tr>
{else}
<tr><td colspan="7">No Statistics.</td></tr>
{/if}
</table>
</div>
</div>
</div>
<!--End Right Contents-->
</div>
<!--End Contents-->
{include file="footer.tpl.php"}
stats.php
<?php
require_once('header.php');
if(!$Auth->checkAuth()) // if user isn't logged in
{
header("location: index.php");
exit;
}
$uid = $Auth->getLoggedId();
$template->assign('script', 'stats');
//Dates
$date_start = makesafe($_POST['date1']);
$date_end = makesafe($_POST['date2']);
$serverDate = date("Y-m-d");
$template->assign('serverDate', $serverDate);
if(!empty($date_start))
$template->assign('date_start', date('d-m-Y', strtotime($date_start)));
if(!empty($date_end))
$template->assign('date_end', date('d-m-Y', strtotime($date_end)));
if(!empty($date_start))
{
$q = "AND DATE(`date`) >= '$date_start'";
if(!empty($date_end))
{
$q .= " AND DATE(`date`) <= '$date_end'";
}
$q2 = "AND DATE(d.date) >= '$date_start'";
if(!empty($date_end))
{
$q2 .= " AND DATE(d.date) <= '$date_end'";
}
$hourly = false;
}
if(empty($q))
{
$q = "AND DATE(`date`) > DATE_SUB(CURDATE(), INTERVAL 7 DAY)";
$q2 = "AND DATE(d.date) > DATE_SUB(CURDATE(), INTERVAL 7 DAY)";
$hourly = false;
$template->assign('date_start', date('d-m-Y', strtotime("-6 days")));
}
//Country BreakDown
$csql1 = "SELECT COUNT(id) as total, campaign_id, country FROM offer_process WHERE uid = '$uid' AND status = 1 $q GROUP BY country ";
$result = mysql_query($csql1);
if(mysql_num_rows($result))
{
while($cr = mysql_fetch_object($result))
{
$country = $cr->country;
$countries[$country] = $cr->total;
}
}
if(!empty($countries))
{
$country_analytics = "['Country', 'Downloads'],";
foreach($countries as $c => $v)
{
$c = getCountryName($c);
$country_analytics .= "['$c', $v],";
}
$country_analytics = substr($country_analytics, 0, -1);
$template->assign('country_analytics', $country_analytics);
}
//Get Clicks/Downloads in given days
require_once("leads_chart.php");
//End Clicks/Downloads
//Get data associated with countries
$crsql = mysql_query("SELECT id, filename FROM files WHERE uid = '$uid' AND hits > 0");
if(mysql_num_rows($crsql))
{
$data = array();
$total_clicks = 0 ;
$total_downloads = 0;
$total_profit = 0;
$total_conv = 0;
$total_avg = 0;
$tota_epc = 0;
while($crrow = mysql_fetch_object($crsql))
{
$fid = $crrow->id;
$filename = stripslashes($crrow->filename);
if(strlen($filename) > 23)
$filename = substr($filename,0,20)."...";
//report data
$profit = 0;
$clicks = 0;
$downloads = 0;
$conv = 0;
$epc = 0;
$avgCPA = 0;
//First get data from offer process
$rsql = mysql_query("SELECT * FROM offer_process WHERE file_id = '$fid' AND uid = '$uid' $q");
if(mysql_num_rows($rsql))
{
while($rrs = mysql_fetch_object($rsql))
{
//update clicks
$clicks++;
//update downloads
$status = $rrs->status;
if($status == 1){
$downloads++;
//update profit
$credits = $rrs->credits;
$profit += $credits;
}
}
}
//conv
$conv = sprintf("%.2f", ($downloads / $clicks) * 100);
//avg cpa
$avgCPA = sprintf("%.2f", $profit / $downloads);
//ToDo Epc Calculation
$epc = sprintf("%.2f", $profit / $clicks);
//total CLICKS
$total_clicks += $clicks ;
$total_downloads += $downloads;
$total_profit += $profit;
if(!empty($clicks)){
$data[] = array('id' => $fid, 'file' => $filename, 'downloads' => $downloads, 'clicks' => $clicks, 'profit' => $profit, 'conv' => $conv, 'avgcpa' => $avgCPA, 'epc' => $epc);
}
}
}
$total_conv = sprintf("%.2f", ($total_downloads / $total_clicks) * 100);
$total_avg = sprintf("%.2f", $total_profit / $total_downloads);
$total_epc = sprintf("%.2f", $total_profit / $total_clicks);
$template->assign('total_clicks', $total_clicks);
$template->assign('total_downloads', $total_downloads);
$template->assign('total_profit', $total_profit);
$template->assign('total_conv', $total_conv);
$template->assign('total_avg', $total_avg);
$template->assign('total_epc', $total_epc);
$template->assign('history', $data);
//Premium Chart
$mm2 = mysql_query("SELECT SUM(credits) as income, date FROM earnings_log WHERE uid = '$uid' AND notes LIKE '%Premium Signup%' $q GROUP BY DATE(date) ");
if(mysql_num_rows($mm2))
{
while($mr2 = mysql_fetch_object($mm2))
{
$pdate = date("Y-m-d", strtotime($mr2->date));
$pincome = $mr2->income;
$pdata .= "['$pdate', $pincome],";
}
$pdata = "['Date', 'Premium Earnings'],".$pdata;
$pdata = substr($pdata, 0, -1);
$template->assign('pdata', $pdata);
}
$dsql = mysql_query("SELECT COUNT(d.id) as `count`, d.referrer as referrer, f.id FROM downloads_log as d INNER JOIN files as f ON d.file_uniqid = f.code WHERE f.uid = '$uid' AND d.referrer != 'NULL' AND d.referrer != '' $q2 GROUP BY d.referrer ORDER BY `count` DESC LIMIT 20");
if(mysql_num_rows($dsql))
{
while($dr = mysql_fetch_object($dsql))
{
$ref_name = stripslashes($dr->referrer);
$ref_name = str_replace("http://", "", $ref_name);
if(strpos($ref_name, "/") > 0){
//$ref_name = substr($ref_name, 0, strpos($ref_name, "/"));
}
$refs[] = array('referrer' => $ref_name, 'count' => $dr->count);
}
$template->assign('referrers', $refs);
}
function getGatewayNameByGid($gid)
{
$gid = makesafe($gid);
$sql = mysql_query("SELECT name FROM gateways WHERE gid = $gid");
if(mysql_num_rows($sql))
{
$m = mysql_fetch_object($sql);
return $m->name;
}else
{
return 0;
}
}
//Content Gateways Stats----------------------------------//
$rsql = mysql_query("SELECT SUM(IF(status = 'complete', 1, 0)) as downloads, SUM(IF(status = 'complete', credits, 0)) as credits, COUNT(DISTINCT session_id) as `hits`, gid, COUNT(id) as clicks FROM gw_session_offers WHERE uid = '$uid' $q GROUP BY gid");
if(mysql_num_rows($rsql))
{
while($rrs = mysql_fetch_assoc($rsql))
{
$gid = $rrs['gid'];
$gwname = getGatewayNameByGid($gid);
//null variables
$profit = 0;
$clicks = 0;
$downloads = 0;
$conv = 0;
$epc = 0;
$avgCPA = 0;
$hits = 0;
$hits = $rrs['hits'];
$clicks = 0;
$downloads = 0;
$clicks = $rrs['clicks'];
$profit = 0;
$credits = 0;
$downloads = $rrs['downloads'];
//update profit
$credits = $rrs['credits'];
$profit = $credits;
if(empty($hits))
$hits = 0;
if(empty($downloads))
$downloads = 0;
if(empty($downloads))
{
$credits = 0;
$profit = $credits;
}
if(!empty($clicks)){
//conv
$conv = sprintf("%.2f", ($downloads / $clicks) * 100);
//$conv = abs(($downloads / $clicks) * 100);
//avg cpa
$avgCPA = sprintf("%.2f", $profit / $downloads);
//ToDo Epc Calculation
$epc = sprintf("%.2f", $profit / $clicks);
if($conv == '100.00')
$conv = 100;
if($conv == '0.00')
$conv = 0;
if($epc == '0.00')
$epc = 0;
if($avgCPA == '0.00')
$avgCPA = 0;
//total CLICKS
$gtotal_clicks += $clicks ;
$gtotal_downloads += $downloads;
$gtotal_profit += $profit;
$gw_data[] = array('id' => $gid, 'downloads' => $downloads, 'clicks' => $clicks, 'profit' => $profit, 'conv' => $conv, 'avgcpa' => $avgCPA, 'epc' => $epc, 'gw_name' => $gwname);
}else
{
$conv = '0';
$avgCPA = '0';
$epc = '0';
}
}
}else
{
}
$gtotal_conv = sprintf("%.2f", ($gtotal_downloads / $gtotal_clicks) * 100);
$gtotal_avg = sprintf("%.2f", $gtotal_profit / $gtotal_downloads);
$gtotal_epc = sprintf("%.2f", $gtotal_profit / $gtotal_clicks);
@mysql_free_result($rsql);
$template->assign('gtotal_clicks', $gtotal_clicks);
$template->assign('gtotal_downloads', $gtotal_downloads);
$template->assign('gtotal_profit', $gtotal_profit);
$template->assign('gtotal_conv', $gtotal_conv);
$template->assign('gtotal_avg', $gtotal_avg);
$template->assign('gtotal_epc', $gtotal_epc);
//End Content gateways stats -----------------------------//
$template->assign('gw_data', $gw_data);
$template->display('stats.tpl.php');
?>
Thank you.
