Files
Testing/include/analytics/member_services_more.php

143 lines
2.8 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?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();
}
?>