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