Bit of a problem...

Ben Nash · May 15, 2014

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.

Edited May 15, 2014 by Ben Nash

Ben Nash · May 15, 2014

Anyone?

--------

Dave · May 15, 2014

Anyone?
--------

Don't imagine many people will have much knowledge of Smarty, myself included!

Let's see if we can crack this over Skype.

bbgengine · May 15, 2014

You all have any luck? I have done some work with smarty.

Edited May 15, 2014 by bbgengine

Dave · May 16, 2014

You all have any luck? I have done some work with smarty.

I helped him out and managed to fix it!

His $data was turning a random string when it was empty which caused the Smarty checks to fail. Simply added in the following check (kinda a quick hack):

$data = (is_array($data) ? $data : array());

Now all is well :)

Sign In

Bit of a problem...

Recommended Posts

Ben Nash

Link to comment

Share on other sites

Ben Nash

Link to comment

Share on other sites

Dave

Link to comment

Share on other sites

bbgengine

Link to comment

Share on other sites

Dave

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Hosting

Marketplace