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.='
'; } $morelink=""; if($showmore=="yes") { $morelink.=''; } // 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(); } ?>