289 lines
5.8 KiB
PHP
289 lines
5.8 KiB
PHP
<?php header('Content-type: application/json');
|
|
|
|
ini_set('session.bug_compat_warn', 0);
|
|
|
|
ini_set('session.bug_compat_42', 0);
|
|
|
|
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' AND `community_user_ads`.`trash` = 0";
|
|
|
|
$showmore="no";
|
|
|
|
$nextoffset="";
|
|
|
|
|
|
|
|
$rcount=$database->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.='<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
|
|
|
|
$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.='<tr id="dad_'.$s["adid"].'" style="background:'.$rc.'" onmouseover="this.style.background=\'#000\';" onmouseout="this.style.background=\''.$rc.'\'"><td style="width:90px;padding-left:2px;"><img src="'.$s["image_url"].'" width="'.$s["image_width"].'" height="'.$s["image_height"].'" style="width:100%;height:auto;" /></td><td class="ua-status '.$colorclass.'" style="padding-left:5px;">'.$status.'</td>';
|
|
|
|
|
|
|
|
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.='<td class="ua-adviews">'.$adviews.'</td><td class="ua-adclicks">'.$s["adclicks"].'</td><td>'.$ctr.'</td>';
|
|
|
|
$ctr="";
|
|
|
|
}
|
|
|
|
else
|
|
|
|
{
|
|
|
|
$userads.='<td>N/A</td><td>N/A</td><td>N/A</td>';
|
|
|
|
|
|
|
|
}
|
|
|
|
$userads.='<td class="tdright" nowrap="nowrap"><a onclick="ed_msad(\''.$s["adid"].'\');">edit</a> | <a class="adelad" onclick="del_ad(\''.$s["adid"].'\');">del</a></td>';
|
|
|
|
$userads.='</tr>';
|
|
|
|
|
|
|
|
$userads.='<tr id="uef_'.$s["adid"].'" class="ms_uef">
|
|
|
|
<td colspan="6">
|
|
|
|
<div id="aeem_'.$s["adid"].'" class="aeem"></div>
|
|
|
|
<div id="ed_'.$s["adid"].'" class="edit_ad">
|
|
|
|
<label>URL: </label>
|
|
|
|
<input type="text" name="url_'.$s["adid"].'" id="url_'.$s["adid"].'" value="'.$s["thelink"].'" size="33" maxlength="250" />
|
|
|
|
<button class="redbutton" onclick="subuef(\''.$s["adid"].'\')">Update</button>
|
|
|
|
</div>
|
|
|
|
</td>
|
|
|
|
</tr>';
|
|
|
|
}
|
|
|
|
|
|
|
|
$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();
|
|
|
|
}
|
|
|
|
?>
|