143 lines
2.8 KiB
PHP
143 lines
2.8 KiB
PHP
<?php header('Content-type: application/json');
|
|
|
|
if ( !defined('PATHTOINCLUDES') ) define('PATHTOINCLUDES', $_SERVER["DOCUMENT_ROOT"] . '/include/analytics/');
|
|
|
|
include(PATHTOINCLUDES."base.php");
|
|
|
|
date_default_timezone_set('UTC');
|
|
|
|
$em="";
|
|
|
|
|
|
|
|
$limit=10;
|
|
|
|
if(!isset($_GET["offset"])){$offset=0;} else{$offset=$_GET["offset"];}
|
|
|
|
$sql2="SELECT count(`community_user_ads`.`adid`) AS cuid FROM `community_user_ads` WHERE `community_user_ads`.`approved` = 'yes'";
|
|
|
|
$showmore="no";
|
|
|
|
$nextoffset="";
|
|
|
|
|
|
|
|
$rcount=$database->database_query($sql2);
|
|
|
|
$thecount = $database->database_result($rcount,0);
|
|
|
|
if($offset > $thecount){$offset=$offset - $thecount;}
|
|
|
|
if($offset < 0) {$offset=0;}
|
|
|
|
|
|
|
|
if($thecount-$offset > $limit) {$showmore="yes";$nextoffset=($offset+$limit);} else {$showmore="no";$nextoffset="";}
|
|
|
|
|
|
|
|
$sql="SELECT
|
|
|
|
`community_user_ads`.`adid`,
|
|
|
|
`community_user_ads`.`userid`,
|
|
|
|
`community_user_ads`.`image_url`,
|
|
|
|
`community_user_ads`.`image_width`,
|
|
|
|
`community_user_ads`.`image_height`,
|
|
|
|
`community_user_ads`.`approved`,
|
|
|
|
`community_user_ads`.`thelink`,
|
|
|
|
`community_user_ads`.`image_name`,
|
|
|
|
`community_user_ads`.`thetags`,
|
|
|
|
`community_user_ads`.`adclicks`,
|
|
|
|
`community_user_ads`.`adviews`
|
|
|
|
FROM
|
|
|
|
`community_user_ads`
|
|
|
|
WHERE `community_user_ads`.`approved` = 'yes' AND `community_user_ads`.`trash` = 0
|
|
|
|
ORDER BY `community_user_ads`.`ctr` DESC, `community_user_ads`.`thesort` ASC
|
|
|
|
LIMIT ".$limit." OFFSET ".$offset;
|
|
|
|
|
|
|
|
$query=$database->database_query($sql) or $em.=$database->database_error();
|
|
|
|
|
|
|
|
$theads="";
|
|
|
|
$rownum=0;
|
|
|
|
$adviewlist="";
|
|
|
|
while ($row = $database->database_fetch_assoc($query)) {
|
|
|
|
$rownum=$rownum+1;
|
|
|
|
if($row["userid"] != $_SESSION["cp_userid"])
|
|
|
|
{
|
|
|
|
if($adviewlist==""){$adviewlist.=$row["adid"];} else {$adviewlist.=",".$row["adid"];} // list for ad impressions
|
|
|
|
}
|
|
|
|
$ma_class="memberad";
|
|
|
|
$theads.='<div class="'.$ma_class.'"><a href="'.$row["thelink"].'" target="_blank" onclick="update_ct('.$row["adid"].');"><img src="'.$row["image_url"].'" width="'.$row["image_width"].'" height="'.$row["image_height"].'" alt="i_'.$row["adid"].'" /></a></div>';
|
|
|
|
}
|
|
|
|
$morelink="";
|
|
|
|
if($showmore=="yes")
|
|
|
|
{
|
|
|
|
$morelink.='<p id="ms_showmore"><a href="javascript:getmemberservices_more('.$nextoffset.');">more...</a></p>';
|
|
|
|
}
|
|
|
|
// user's ad list
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
$arr = array ('error' => $em, 'theads'=> $theads, 'showmore' => $showmore, 'nextoffset'=> $nextoffset, 'morelink' => $morelink);
|
|
|
|
echo json_encode($arr);
|
|
|
|
|
|
|
|
if($adviewlist !="")
|
|
|
|
{
|
|
|
|
$sql3="UPDATE `community_user_ads` SET `adviews` = (`adviews` + 1) WHERE `adid` IN(".$adviewlist.")";
|
|
|
|
$query3=$database->database_query($sql3) or $em=$database->database_error();
|
|
|
|
$sql4="UPDATE `community_user_ads` SET `ctr`= ((`adclicks` / `adviews`) * 100) WHERE `adclicks` > 0 AND `adid` IN(".$adviewlist.")";
|
|
|
|
$query4=$database->database_query($sql4) or $em=$database->database_error();
|
|
|
|
}
|
|
|
|
?>
|