View file mobilink_wap/advertisers.php

<?php
define('path', dirname(__FILE__));
require path.'/moduls/config.php';
require path.'/moduls/functions.php';
$cid = htmlspecialchars($_GET['cid']);
$cid = $mcr->decode($cid);

$c = explode("::",$cid);
$id = $c[0];
$ps = $c[1];

$error = false;
$select = @Mysql_Query("select * from `users` where `id`='". mysql_escape_string($id) ."'");
if(!mysql_affected_rows()){
    header("location: http://".$site_url."/");
} else {
    $row = @mysql_fetch_array($select);
    if($row['pass']!=$ps){
        header("location: http://".$site_url."/");
    } elseif($row['banned'] == 1){
        header("location: http://".$site_url."/");
    } else {
        $cid = $mcr->encode($row['id']."::".$row['pass']);
        $takep = "&amp;cid=".$cid;
    }
}

require path.'/moduls/header.php';

$rekid = preg_replace(array('/[^0-9]/'), '', $_GET['rekid']);

$case = trim($_GET['case']);

switch($case){
default:
echo '<div class="title">Reklamlar</div>';
echo '<br />';

if($_GET['action']=="start"){
    if(@mysql_result(@mysql_query("select count(1) from `advertisers` where `usid`='".$row['id']."' and `id`='".$rekid."' and `status`='3'"),0)>0){
        echo 'Deaktiv olunan reklama start vermek olmaz..<br />';
    } else if($row['rek_balance']<=2){
        echo 'Reklamlara start vermek ucun balansinizi artirmalisiz..<br />';
    } else {
       if(@mysql_query("update `advertisers` set `status`='2' where `usid`='".$row['id']."' and `id`='".$rekid."'")){
            echo '<span style="color: green;">Se&#231;ilmi&#351; reklam aktivle&#351;dirildi!</span><br />';
        }
    }
}

if($_GET['action']=="stop"){
    if(@mysql_result(@mysql_query("select count(1) from `advertisers` where `usid`='".$row['id']."' and `id`='".$rekid."' and `status`='3'"),0)>0){
        echo 'Deaktiv olunan reklama pauza vermek olmaz..<br />';
    } else {
       if(@mysql_query("update `advertisers` set `status`='1' where `usid`='".$row['id']."' and `id`='".$rekid."'")){
            echo '<span style="color: green;">Se&#231;ilmi&#351; reklam&#305;n n&#252;mayi&#351;i dayand&#305;r&#305;ld&#305;!</span><br/><br />';
        }
    }
}

echo '+ <a href="advertisers.php?case=create_ad'.$takep.'">Yeni reklam elave et</a><br />';

$st = @mysql_query("select `id` as `sid`,`title`,`url`,`status`,`banner`, `looks`,
                  (select count(1) from `clicks` where `rek_id`=`sid` and `time`>='".$today."') as `clicks` from `advertisers` where `usid`='".$row['id']."'");

if(!mysql_affected_rows()){
    echo '<br />Reklam yoxdur..<br />';
} else {
    if ($row['rek_balance'] < 50) {
        echo '<br />Reklam start etmek &#252;&#231;&#252;n balans&#305;n&#305;zda kifayer qeder pul yoxdur. <a href="balance.php?case=my_fond&amp;'.$takep.'">Hesaba pul qoy</a><br /><br />';
    }
    while($r = mysql_fetch_assoc($st)){
        echo '<br />';

        echo ' <a href="advertisers.php?case=edit&amp;rekid='.$r['sid'].$takep.'">'.$r['title'].'</a> ';
        echo '<a href="advertisers.php?case=edit&amp;rekid='.$r['sid'].$takep.'"><img src="/img/icon/edit.gif" alt="Deyis" /></a></a> <a href="advertisers.php?case=del_ad&amp;rekid='.$r['sid'].$takep.'"><img src="/img/icon/delete.gif" alt="Sil" /></a><br/>';
        echo 'N&#252;mayi&#351;/klik: '.$r['looks'].'/'.$r['clicks'].'<br/>';
        $r_arr = array("0"=>"Yoxlan&#305;lmay&#305;b", "1"=>"Pauza", "2"=>"Aktiv", "3"=>"Deaktiv");

        if($r['status']==1){
            echo 'Pauza - <a href="advertisers.php?action=start&amp;rekid='.$r['sid'].$takep.'">Start</a>';
        } elseif($r['status']==2){
            echo 'Aktiv - <a href="advertisers.php?action=stop&amp;rekid='.$r['sid'].$takep.'">Pauza</a>';
        } else {
            echo "Status: <span style=\"color: #704638;\">".$r_arr[$r['status']]."</span>";
        }
        echo "<br/>";
    }
}
break;

case "del_ad":
echo '<div class="title">Reklamlar</div>';
echo '<br />';
if ($_GET['yes']!="ok") {
    echo 'Reklam&#305; silmek istediyinize eminsiniz?<br />';
    echo '<br />';
    echo '- <a href="advertisers.php?case=del_ad&amp;yes=ok&amp;rekid='.intval($_GET['rekid']).$takep.'">Beli</a><br />';
    echo '- <a href="advertisers.php?'.$takep.'">Xeyir</a><br />';
} else {
    if(@mysql_result(@mysql_query("select count(1) from `advertisers` where `usid`='".$row['id']."' and `id`='".intval($_GET['rekid'])."' and `status`='3'"),0)>0){
        echo 'Deaktiv olunan reklami silmek olmaz..<br />';
    } else {
        $aselect = @mysql_query ("select `banner` from `advertisers` where `usid`='".$row['id']."' and `id`='".intval($_GET['rekid'])."';");
        $inf = mysql_fetch_array ($aselect);
        unlink("img/ad/".$inf['banner']);
        mysql_query("delete from `advertisers` where `usid`='".$row['id']."' and `id`='".intval($_GET['rekid'])."'");
        echo 'Qeyd etdiyiniz reklam silindi..<br />';
    }
}
break;

case "stat":
echo '<div class="title">Statistika</div>';
echo '<br />';
$rek = @mysql_fetch_array(@mysql_query("select * from `advertisers` where `id`='".$rekid."' and `usid`='".$row['id']."'"));
if($rek['url']==""){
    echo 'Reklam tap&#305;lmad&#305;..<br/>';
    break;
}
$tm = @mysql_fetch_array(@mysql_query("SELECT MIN(`time`), MAX(`time`) from `clicks` where `rek_id`='".$rekid."'"));
$t = ($tm[1] - $tm[0]) / 86400;
if($t > 15){
    $t = 15;
}
$i = 0;
while($i <= $t){

    $b = mysql_fetch_array(mysql_query("SELECT count(1), sum(`money`) from `clicks` where `rek_id`='".$rekid."' and `time`>='".($tm[1]-(86400*$i))."' and `time` < '".($tm[1]-(86400*intval($i-1)))."'"));
    $div = ($i == $t) ? '<div class="main">' : '<div class="menu">';
    echo $div;
    
    echo date("Y-m-d",$tm[1]-(86400*$i)).'</div>';
    //echo 'Serfiyyat: '.(sprintf("%01.2f", $b[1]/100)).'$<br />';
    echo 'Serfiyyat: '.(sprintf("%01.2f", $b[1]/100)).'$ | Klikler: '.$b[0].'<br />';
    $i++;
    echo '<br />';
}

break;

case "edit":
echo '<div class="title">Edit</div>';
echo '<br />';
$rek = @mysql_fetch_array(@mysql_query("select * from `advertisers` where `id`='".$rekid."' and `usid`='".$row['id']."'"));
if($rek['url']==""){
    echo 'Reklam tapilmadi..<br/>';
    break;
}
if(isset($_POST['add_advertiser'])){
    function int($str){
        $intval = preg_replace(array('/[^0-9]/'), '', $str);
        if(strlen($intval == 0))$intval = "0";
        return $intval;
    }

    $limit = trim($_POST['limit']);
    $limit = substr($limit,0,4);
    $l = explode(".",$limit);
    $l1 = int($l[1]) == 0 ? "00" : int($l[1]);
    $limit = int($l[0]) .".". $l1;;
    $lm = $limit * 100;

    $money = trim($_POST['money']);
    $money = substr($money,0,4);

    $m = explode(".",$money);
    $m1 = int($m[1]) == 0 ? "00" : int($m[1]);
    $money = int($m[0]) .".". $m1;;
    $mn = $money * 100;

    $mn = $money * 100;

    $operator = $_POST['operator'];
    $operator = is_array($operator) ? $operator : array("all");

    $o1 = trim($operator[0]);
    $o2 = trim($operator[1]);
    $o3 = trim($operator[2]);
    $o4 = trim($operator[3]);

    foreach($operator as $opp){
        $op .= ",".$opp;
    }
    $op = substr($op,1,strlen($op));
    if(count($operator) == 0 || $o1=="all" || count($operator)>4){
        $op = "all";
    }

    $platform = $_POST['platform'];
    $platform = is_array($platform) ? $platform : array("all");
    $c = count($platform);

    if(($c == 1 and $platform[0]=="all") || ($c == 2 and $platform[1]=="opera" and $platform[2]=="mobile")){
        $pl = 0;
    } else if($c == 1 and $platform[0]=="opera"){
        $pl = 1;
    } else if($c == 1 and $platform[0]=="mobile"){
        $pl = 2;
    }

    if($mn > 10){
        $err = "Reklamin deyeri 0.10$ dan cox olmamal&#305;d&#305;r..";
    } elseif($mn < 2){
        $err = "Reklamin deyeri 0.02$ dan az olmamal&#305;d&#305;r..";
    } elseif($lm > 1500){
        $err = "G&#252;nl&#252;k limit 15.00$ dan cox olmamal&#305;d&#305;r..";
    }

    if($err){
        echo $err.'<br/>';
    } else {

        @mysql_query("update `advertisers` set
            `mlimit`='". mysql_escape_string($lm) ."',
            `money`='". mysql_escape_string($mn) ."',
            `operators`='". mysql_escape_string($op) ."',
            `platforms`='". intval($pl) ."'
             WHERE `usid`='". $row['id'] ."' and `id`='". $rekid ."'
        ");
        echo 'Reklam u&#287;urla deyi&#351;dirildi..<br/>';
    }
} else {
    $titl = $rek['title'];
    $url = $rek['url'];
    $limit = $rek['mlimit'] / 100;
    $money = $rek['money'] / 100;
    foreach(explode(",",$rek['operators']) as $opss){
        $operator[] = $opss;
    }
    //$operator = array($rek['operators']);
    
    if($rek['platforms'] == 1){
    $platform = array("opera");
    }elseif($rek['platforms'] == 2){
    $platform = array("mobile");
    } else {
    $platform = array("all");
    }
}

if(!isset($_POST['add_advertiser']) || $err){
echo '<form enctype="multipart/form-data" action="advertisers.php?case='.$case.'&amp;rekid='.$rek['id'].$takep.'" method="post">';
if(strlen($rek['banner'])>5){
    echo '<img src="/img/ad/'.$rek['banner'].'"/><br />';
}
echo '<b>Reklam linkin ad&#305;:</b> '.$titl.'<br/>';
echo '<b>Reklam url:</b> <a href="'.$url.'">'.$url.'</a><br/>';
echo '<br/>';
echo '<b>Operatorlar:</b><br />';
echo '<input type="checkbox" name="operator[]" value="all" '.(in_array('all',$operator) ? "checked" : "").'> B&#252;t&#252;n operatorlar<br />';
echo '<input type="checkbox" name="operator[]" value="azercell" '.(in_array('azercell',$operator) ? "checked" : "").'> Azercell<br />';
echo '<input type="checkbox" name="operator[]" value="bakcell" '.(in_array('bakcell',$operator) ? "checked" : "").'> Bakcell<br />';
echo '<input type="checkbox" name="operator[]" value="azerfon" '.(in_array('azerfon',$operator) ? "checked" : "").'> Azerfon<br />';
echo '<br/>';
echo '<b>Platformalar:</b><br />';
echo '<input type="radio" name="platform[]" value="all" '.(in_array('all',$platform) ? "checked" : "").'> B&#252;t&#252;n platformalar<br />';
echo '<input type="radio" name="platform[]" value="opera" '.(in_array('opera',$platform) ? "checked" : "").'> PC, Windows mobile<br />';
echo '<input type="radio" name="platform[]" value="mobile" '.(in_array('mobile',$platform) ? "checked" : "").'> Mobile<br />';
echo '<br/>';
echo 'Hal-haz&#305;rda &#350;ekede:<br />';
$mx = mysql_query("select max(`money`),min(`money`) from `advertisers` where `status`='2';");
$m = mysql_fetch_array($mx);
echo '<b>'. sprintf("%01.2f", $m[0]/100).'</b>$ maksimum<br />';
echo '<b>'. sprintf("%01.2f", $m[1]/100).'</b>$ minimum<br />';
echo '<b>Reklam&#305;n deyeri ($):</b><br />';
echo '<input format="N*" name="money" size="5" value="'.$money.'"> (min: '. sprintf("%01.2f", $m[1]/100).'; max: '. sprintf("%01.2f", $m[0]/100).')<br />';
echo '<br/>';
echo '<b>G&#252;nl&#252;k limit ($):</b><br />';
echo '<input format="N*" name="limit" size="5" value="'.$limit.'"><br />';
echo '<br/>';
echo '<input type="submit" name="add_advertiser" value="Tesdiqle">';
echo '</form>';
echo '</div>';
echo '</div>';
}

break;

case "create_ad":
echo '<div class="title">Reklam yarat</div>';
echo '<br />';
FUNCTION ISIMAGE($FILE) {
    $ARRAY = @FILE($FILE);
    $COUNT=0;
    WHILE($COUNT < COUNT($ARRAY)) {
        IF(!EMPTY($ARRAY[$COUNT])) {
            $RESULT .= ICONV("cp1251", "UTF-8", $ARRAY[$COUNT]);
        }
        ++$COUNT;
    }
    IF(PREG_MATCH('/(php|echo|print|input|header|mysql|array|while|foreach|break|intval)/i', STRTOLOWER($RESULT))) {
        RETURN ('shell');
    } ELSE {
        RETURN $RESULT;
    }
}
FUNCTION FILE_TYPE($FILE){
    $TYPE = PATHINFO($FILE, PATHINFO_EXTENSION);
    RETURN STRTOLOWER($TYPE);
}

if(isset($_POST['add_advertiser'])){

function int($str){
    $intval = preg_replace(array('/[^0-9]/'), '', $str);
    if(strlen($intval == 0))$intval = "0";
    return $intval;
}

    $file = htmlspecialchars($_FILES["banner"]["tmp_name"]);
    $filename = $_FILES["banner"]["name"];

    $filetype = strtolower(FILE_TYPE($filename));

    $filesize = @filesize($file);
    $filesize = @floor($filesize / 1024);

    list($w,$h,$par) = @getimagesize($file);

    $url = htmlspecialchars($_POST['url']);
    $titl = htmlspecialchars($_POST['titl']);

    $limit = trim($_POST['limit']);
    $limit = substr($limit,0,4);
    $l = explode(".",$limit);
    $l1 = int($l[1]) == 0 ? "00" : int($l[1]);
    $limit = int($l[0]) .".". $l1;;
    $lm = $limit * 100;

    $money = trim($_POST['money']);
    $money = substr($money,0,4);

    $m = explode(".",$money);
    $m1 = int($m[1]) == 0 ? "00" : int($m[1]);
    $money = int($m[0]) .".". $m1;;
    $mn = $money * 100;

    $mn = $money * 100;

    $operator = $_POST['operator'];
    $operator = is_array($operator) ? $operator : array("all");

    $o1 = trim($operator[0]);
    $o2 = trim($operator[1]);
    $o3 = trim($operator[2]);
    $o4 = trim($operator[3]);
    
    foreach($operator as $opp){
        $op .= ",".$opp;
    }
    $op = substr($op,1,strlen($op));
    if(count($operator) == 0 || $o1=="all" || count($operator)>4){
        $op = "all";
    }

    $platform = $_POST['platform'];
    $platform = is_array($platform) ? $platform : array("all");
    $c = count($platform);

    if(($c == 1 and $platform[0]=="all") || ($c == 2 and $platform[1]=="opera" and $platform[2]=="mobile")){
        $pl = 0;
    } else if($c == 1 and $platform[0]=="opera"){
        $pl = 1;
    } else if($c == 1 and $platform[0]=="mobile"){
        $pl = 2;
    }

    if(empty($url) || strlen($url)<=7){
        $err = "Zehmet olmasa reklam linkini d&#252;zg&#252;n yazin";
    } elseif(strlen($titl)<=3){
        $err = "Basliq cox qisadir";
    } elseif($mn > 50){
        $err = "Reklamin deyeri 0.50$ dan cox olmamalidir..";
    } elseif($mn < 2){
        $err = "Reklamin deyeri 0.02$ dan az olmamalidir..";
    } elseif($lm > 15000){
        $err = "G&#252;nl&#252;k limit 150.00$ dan cox olmamalidir..";
    } elseif(strlen($filename)>3){
        if($size>25){
            $err = "&#350;eklin &#231;ekisi 25kb dan &#231;ox olmamal&#305;d&#305;r..";
        } elseif($w>230 || $h>45){
            $err = "&#350;eklin eni uzunu 230x45 dan &#231;ox olmamal&#305;d&#305;r..";
        } elseif(ISIMAGE($file) == 'shell'){
            $err = "&#350;ekil yaln&#305;z gif, jpg, png, jpeg format&#305;nda olmal&#305;d&#305;r..";
        } elseif($par!="" && $par!==1 && $par!==3){
            $err = "&#350;ekil yaln&#305;z gif, jpg, png, jpeg format&#305;nda olmal&#305;d&#305;r..";
        }
    }

    if($err){
        echo $err.'<br/>';
    } else {
        if(strlen($filename)>3){
            $mt = preg_replace(array('/[^0-9]/'), '', microtime());
            $bnr = md5($filename).$mt.".".$filetype;
            @copy($file, "img/ad/".$bnr);
        } else {
            $bnr = "";
        }
        
        @mysql_query("insert into `advertisers` set
            `usid`='". $row['id'] ."',
            `title`='". mysql_escape_string($utf->encode($utf->decode($titl))) ."',
            `url`='". mysql_escape_string($url) ."',
            `banner`='". mysql_escape_string($bnr) ."',
            `mlimit`='". mysql_escape_string($lm) ."',
            `money`='". mysql_escape_string($mn) ."',
            `operators`='". mysql_escape_string($op) ."',
            `platforms`='". intval($pl) ."',
            `status`='0'
        ");
$manat = "50";
       @mysql_query ("UPDATE `users` SET `rek_balance`=`rek_balance`+".(($manat * $set['usd_kurs'])*100)." where id='".$row["id"]."';");
        echo 'Reklam u&#287;urla elave edildi..<br/>';
    }
} else {
    $url = "http://";
    $limit = "0.00";
    $money = "0.02";
    $operator = array("all");
    $platform = array("all");
}

if(!isset($_POST['add_advertiser']) || $err){
echo '<form enctype="multipart/form-data" action="advertisers.php?case='.$case.$takep.'" method="post">';
echo '<b>Reklam linkin ad&#305;:</b><br />';
echo '<input type="text" name="titl" maxlength="35" size="35" value="'.$titl.'"><br />';
echo '<br/>';
echo '<b>Reklam URL:</b><br />';
echo '<input type="text" name="url" size="35" value="'.$url.'"><br />';
echo '<br/>';
echo 'Image file<br />';
echo '<input type="file" name="banner" size="20"><br />';
echo 'Desteklenen formatlar: gif, jpg, jpeg, png<br />';
echo 'Maksimum &#246;l&#231;&#252;ler: 230x45px, 25kb<br />';
echo '<br/>';
echo '<b>Operatorlar:</b><br />';
echo '<input type="checkbox" name="operator[]" value="all" '.(in_array('all',$operator) ? "checked" : "").'> B&#252;t&#252;n operatorlar<br />';
echo '<input type="checkbox" name="operator[]" value="azercell" '.(in_array('azercell',$operator) ? "checked" : "").'> Azercell<br />';
echo '<input type="checkbox" name="operator[]" value="bakcell" '.(in_array('bakcell',$operator) ? "checked" : "").'> Bakcell<br />';
echo '<input type="checkbox" name="operator[]" value="azerfon" '.(in_array('azerfon',$operator) ? "checked" : "").'> Azerfon<br />';
echo '<br/>';
echo '<b>Platformalar:</b><br />';
echo '<input type="radio" name="platform[]" value="all" '.(in_array('all',$platform) ? "checked" : "").'> B&#252;t&#252;n platformalar<br />';
echo '<input type="radio" name="platform[]" value="opera" '.(in_array('opera',$platform) ? "checked" : "").'> PC, Windows mobile<br />';
echo '<input type="radio" name="platform[]" value="mobile" '.(in_array('mobile',$platform) ? "checked" : "").'> Mobile<br />';
echo '<br/>';
echo 'Hal-haz&#305;rda &#350;ekede:<br />';
$mx = mysql_query("select max(`money`),min(`money`) from `advertisers` where `status`='2';");
$m = mysql_fetch_array($mx);
echo '<b>'. sprintf("%01.2f", $m[0]/100).'</b>$ maksimum<br />';
echo '<b>'. sprintf("%01.2f", $m[1]/100).'</b>$ minimum<br />';
echo '<b>Reklam&#305;n deyeri ($):</b><br />';
echo '<input format="N*" name="money" size="10" value="'.$money.'"> (min: '. sprintf("%01.2f", $m[1]/100).'; max: '. sprintf("%01.2f", $m[0]/100).')<br />';
echo '<br/>';
echo '<b>G&#252;nl&#252;k limit ($):</b><br />';
echo '<input format="N*" name="limit" size="5" value="'.$limit.'"> (0.00 - limitsiz)<br />';
echo '<br/>';
echo '<input type="submit" name="add_advertiser" value="Tesdiqle">';
echo '</form>';
}

break;
}

echo '<br /><a href="home.php?'.$takep.'">&#304;lk sehife</a><br />';
require path.'/moduls/footer.php';
?>