database_query($sql2); $thecount = $database->database_result($rcount,0); if($offset > $rcount){$offset=$offset - $rcount;} if($offset < 0) {$offset=0;} //if($thecount-$offset > $limit) {$showmore="yes";$nextoffset=($offset+$limit);} else {$showmore="no";$nextoffest="";} $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 } if($rownum==1){$ma_class="memberad first";} else {$ma_class="memberad";} $theads.='
i_'.$row[
'; } $morelink=""; if($showmore=="yes") { $morelink.='

more...

'; } // user's ad list $sql2="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`.`thedate`, `community_user_ads`.`image_name`, `community_user_ads`.`thesort`, `community_user_ads`.`thetags`, `community_user_ads`.`approved_date`, `community_user_ads`.`adclicks`, `community_user_ads`.`adviews` FROM `community_user_ads` WHERE `community_user_ads`.`trash` = 0 AND `community_user_ads`.`userid` = ".$_SESSION["cp_userid"]." LIMIT 10 OFFSET 0"; $query2=$database->database_query($sql2) or $em=$em.$database->database_error(); $userads=""; $rn=0; while ($s = $database->database_fetch_assoc($query2)) { $rn=$rn+1; if($rn % 2 != 0){$rc="#333";} else{$rc="#333";} $colorclass=""; if($s["approved"]=="pending"){$status="Approval Pending";$colorclass="yellow";} elseif($s["approved"]=="no"){$status="Declined";$colorclass="red";} elseif($s["approved"]=="yes"){$status="Approved";$colorclass="green";} else{$status="";} if($status =="Approved") { if (date('Y-m-d H:i:s', strtotime($s["approved_date"])) == $s["approved_date"]) { $status=date('Y-m-d',strtotime($s["approved_date"]));} } $userads.=''.$status.''; if($s["approved"]=="yes"){ $ctr=""; if($s["userid"] != "") { $adviews=($s["adviews"]+1); if($s["adclicks"] > 0) { $ctr=($s["adclicks"] / $adviews) * 100; $ctr=round($ctr,2); $ctr=$ctr."%"; } } else { $adviews=$s["adviews"]; $ctr=($s["adclicks"] / $adviews) * 100; } $userads.=''.$adviews.''.$s["adclicks"].''.$ctr.''; $ctr=""; } else { $userads.='N/AN/AN/A'; } $userads.='edit | del'; $userads.=''; $userads.='
'; } $arr = array ('error' => $em, 'theads' => $theads, 'userads' => $userads, '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(); } ?>