View file mobilink_wap/admin.php

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

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

$error = false;
$select = @Mysql_Query("select * from `users` where lower(`pass`)='". mysql_escape_string($ps) ."' and `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;
    }
}

if($_SERVER['PHP_AUTH_USER']!="admin" and $_SERVER['PHP_AUTH_PW']!="admin"){
header('WWW-Authenticate: Basic realm="ENTER"');
header('HTTP/1.0 401 Unauthorized');
exit();
}

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

$cnt = "SELECT COUNT(1) as `user_count`,
    (SELECT COUNT(1) FROM `sites` WHERE `status`='0') as `sites_active_0`,
    (SELECT COUNT(1) FROM `sites` WHERE `status`='1') as `sites_active_1`,
    (SELECT COUNT(1) FROM `sites` WHERE `status`='2') as `sites_active_2`,
    (SELECT COUNT(1) FROM `advertisers` WHERE `status`='0') as `advertisers_active_0`,
    (SELECT COUNT(1) FROM `advertisers` WHERE `status`!='0' and `status`!='3') as `advertisers_active_1`,
    (SELECT COUNT(1) FROM `advertisers` WHERE `status`='3') as `advertisers_active_3`,
    (SELECT COUNT(1) FROM `clicks` WHERE `time`>='".$today."') as `count_clicks`
    FROM `users`";
$cnt = @mysql_query($cnt);
$cnt = @mysql_fetch_assoc($cnt);

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

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

switch($case){
default:
echo '<div class="title">Admin panel</div>';
echo '<br/>';
echo 'Reklamlar<br/>';
echo '<a href="admin.php?case=adver_no_active'.$takep.'">Tesdiq g&#246;zleyenler</a>-('.$cnt['advertisers_active_0'].')<br />';
echo '<a href="admin.php?case=adver_active'.$takep.'">Aktivler</a>-('.$cnt['advertisers_active_1'].')<br />';
echo '<div class="a_end"><a href="admin.php?case=adver_deactive'.$takep.'">Deaktivler</a>-('.$cnt['advertisers_active_3'].')<br />';
echo '<br/>';
echo 'Saytlar<br/>';
echo '<a href="admin.php?case=sites_no_active'.$takep.'">Tesdiq g&#246;zleyenler</a>-('.$cnt['sites_active_0'].')<br />';
echo '<a href="admin.php?case=sites_active'.$takep.'">Aktivler</a>-('.$cnt['sites_active_1'].')<br />';
echo '<div class="a_end"><a href="admin.php?case=sites_deactive'.$takep.'">Deaktivler</a>-('.$cnt['sites_active_2'].')<br />';
echo '<br/>';
echo '&#220;mumi<br />';
echo '<a href="admin.php?case=users'.$takep.'">&#304;stifade&#231;iler</a>-('.$cnt['user_count'].')<br />';
echo '<a href="admin.php?case=balans'.$takep.'">Balans art&#305;r</a><br />';
////echo '<a href="admin.php?case=clicks'.$takep.'">Klikler</a>-('.$cnt['count_clicks'].')<br />';
///echo '<a href="admin.php?case=banlist'.$takep.'">Banlist</a><br />';
///echo '<a href="admin.php?case=usd_kurs'.$takep.'">Valyuta</a><br />';
break;

case("balans"):
echo '<div class="title">Balans art&#305;r</div>';
echo '<br />';
if(!isset($_POST['us_login'])){
    echo '<form action="admin.php?case=balans'.$takep.'" method="post">';
    echo '<b>Login:</b><br />';
    echo '<input type="text" name="us_login"><br />';
    echo '<br />';
    echo '<b>Balans:</b><br />';
    echo '<input type="text" maxlength="4" size="4" name="manat"> <b>AZN</b><br />';
    echo '<br />';
    echo '<input type="submit" value="Elave et"> ';
    echo '</form>';
    if ($set['bonus']!=0) echo '<br /> Na&#287;d &#246;eni&#351;lere <b>'.$set['bonus'].'%</b> bonus elave olunur.<br/>';
} else {
    $us_login = trim($_POST['us_login']);
    $manat = int($_POST['manat']);
    
    if ($set['bonus']!=0) {
        $manat_h = ($manat / 100) * 20;
        $manat = $manat_h + $manat;
    }

    $sq = "Select `id`,`login`,`pass`,`email` FROM `users` WHERE lower(`login`)='". strtolower($us_login) ."'";
    $sq = @Mysql_Query($sq);
    $sq = @Mysql_Fetch_Array($sq);
    
    mysql_query ("UPDATE `users` SET `rek_balance`=`rek_balance`+".(($manat * $set['usd_kurs'])*100)." where id='".$sq["id"]."';");
    print '<b>'.$sq["login"].'</b> loginli istifade&#231;inin reklam balans&#305;na '.sprintf("%01.2f", $manat * $set['usd_kurs']).'$ elave edildi.<br />';

    $subject = "Balansiniz artirildi.";
    $to = $sq["email"];
    $text .= "Hormetli ".$sq["login"]." sizin hesabiniza ".sprintf("%01.2f", $manat * $set['usd_kurs'])."$ reklam balansi elave edildi..\n";
    $text .= "----\n";
    $text .= "Istifadeci paneli: http://".$site_url."/home.php?cid=".$mcr->encode($sq["id"]."::".$sq["pass"])."\n";
    $fnc->message_send($to, $subject, $text);
}
break;

case ("users"):
echo '<div class="title">&#304;stifade&#231;iler</div>';
echo '<br />';

if(isset($_GET['x'])){
    $x = int($_GET['x']);
    @mysql_query("delete from `users` where `id`='".$x."'");
    @mysql_query("delete from `sites` where `usid`='".$x."'");
    @mysql_query("delete from `advertisers` where `usid`='".$x."'");
}

$query = mysql_query("SELECT * FROM `users` ORDER BY `balance` DESC, `id` ASC;");
echo '<table>';

echo '<tr align="center">';
echo '<td class="tab_t">#</td>';
echo '<td class="tab_t">User</td>';
echo '<td class="tab_t">Balans/Rek ($)</td>';
echo '<td class="tab_t">E-mail</td>';
echo '<td class="tab_t" colspan="2">!</td>';
echo '</tr>';

if(!mysql_affected_rows()){
    echo '<tr>';
    echo '<td class="tab_r">0</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '</tr>';
}

$i=1;
while($r = @mysql_fetch_array($query)){
    $rid = $r['id'];
    $login = $r['login'];
    $balance = $r['balance'];
    $rek_balance = $r['rek_balance'];
    $email = $r['email'];
    echo '<tr>';
    echo '<td class="tab_r">'.($i).'</td>';
    echo '<td class="tab_r">'.($login).'</td>';
    echo '<td class="tab_r">'. sprintf("%01.2f", $balance/100).'/'. sprintf("%01.2f", $rek_balance/100).'</td>';
    echo '<td class="tab_r">'.($email).'</td>';

    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;x='.($rid).'">X</a></td>';
    echo '</tr>';
    $i++;
}

echo '</table>';
break;

case ("sites_active"):
echo '<div class="title">Aktiv saytlar</div>';
echo '<br />';

if(isset($_GET['x'])){
    $x = int($_GET['x']);
    @mysql_query("delete from `sites` where `id`='".$x."'");
}

if(isset($_GET['d'])){
    if(!isset($_POST['text'])){
        echo '<form action="admin.php?case='.$case.$takep.'&amp;d='.int($_GET['d']).'" method="post">';
        echo 'Sebeb:<br />';
        echo '<input type="text" name="text"><br />';
        echo '<input type="submit" value="Deaktiv et">';
        echo '</form>';
        echo '<br />';
    } else {
        $d = int($_GET['d']);
        @mysql_query("update `sites` set `status`='2', `ban_text`='".trim($_POST['text'])."' where `id`='".$d."'");
        $rk = "SELECT `usid` FROM `sites` WHERE `id`='".$d."'";
        $rk = @Mysql_Query($rk);
        $rk = @Mysql_Fetch_Array($rk);
        $sq = "Select `id`,`login`,`pass`,`email` FROM `users` WHERE `id`='".$rk['usid']."'";
        $sq = @Mysql_Query($sq);
        $sq = @Mysql_Fetch_Array($sq);

        $subject = "Saytiniz deaktiv edildi.";
        $to = $sq["email"];
        $text .= "Hormetli ".$sq["login"]." ".$site_url." reklam sistemine elave etdiyiniz sayt deaktiv edildi..\n";
        if($_POST['text']!=''){
            $text .= "----\n";
            $text .= "Sebeb: ".$_POST['text']."\n";
        }
        $text .= "----\n";
        $text .= "Reklam paneli: http://".$site_url."/sites.php?cid=".$mcr->encode($sq["id"]."::".$sq["pass"])."\n";
        $fnc->message_send($to, $subject, $text);
    }
}

echo '<table>';

echo '<tr align="center">';
echo '<td class="tab_t">#</td>';
echo '<td class="tab_t">Sayt</td>';
echo '<td class="tab_t">User</td>';
echo '<td class="tab_t">N&#252;mayi&#351;ler</td>';
echo '<td class="tab_t">Qazanc</td>';
echo '<td class="tab_t" colspan="2">Status</td>';
echo '</tr>';

$query = @mysql_Query("select `id` as `uid`,`usid` as `user_id`, (select `login` from `users` where `id`=`user_id`) as `username`, (select sum(`user_money`) from `clicks` where `site_id`=`uid`) as `money`,`looks`,`url` from `sites` where `status`='1' order by `money` desc");

if(!mysql_affected_rows()){
    echo '<tr>';
    echo '<td class="tab_r">0</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '</tr>';
}

$i=1;
while($r = @mysql_fetch_array($query)){
    $rid = $r['uid'];
    $usid = $r['user_id'];
    $url = $r['url'];
    $user = $r['username'];
    echo '<tr>';
    echo '<td class="tab_r">'.($i).'</td>';
    echo '<td class="tab_r"><a href="'.($url).'">'.($url).'</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case=select_user'.$takep.'&amp;usid='.($usid).'">'.($user).'</a></td>';
    echo '<td class="tab_r">'.$r['looks'].'</td>';
    echo '<td class="tab_r">'.(sprintf("%01.2f", $r['money']/100)).'$</td>';

    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;d='.($rid).'">D</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;x='.($rid).'">X</a></td>';
    echo '</tr>';
    $i++;
}

echo '</table>';
break;

case ("sites_deactive"):
echo '<div class="title">Deaktiv saytlar</div>';
echo '<br />';

if(isset($_GET['x'])){
    $x = int($_GET['x']);
    @mysql_query("delete from `sites` where `id`='".$x."'");
}

if(isset($_GET['a'])){
    $a = int($_GET['a']);
    @mysql_query("update `sites` set `status`='1' where `id`='".$a."'");
    $rk = "SELECT `usid` FROM `sites` WHERE `id`='".$a."'";
    $rk = @Mysql_Query($rk);
    $rk = @Mysql_Fetch_Array($rk);
    $sq = "Select `id`,`login`,`pass`,`email` FROM `users` WHERE `id`='".$rk['usid']."'";
    $sq = @Mysql_Query($sq);
    $sq = @Mysql_Fetch_Array($sq);
    
    $subject = "Saytiniz aktiv edildi. Tebrikler..";
    $to = $sq["email"];
    $text .= "Hormetli ".$sq["login"]." ".$site_url." reklam sistemine elave etdiyiniz sayt aktiv edildi..Tebrikler\n";
    $text .= "----\n";
    $text .= "Reklam paneli: http://".$site_url."/sites.php?cid=".$mcr->encode($sq["id"]."::".$sq["pass"])."\n";
    $fnc->message_send($to, $subject, $text);
}

echo '<table>';

echo '<tr align="center">';
echo '<td class="tab_t">#</td>';
echo '<td class="tab_t">Sayt</td>';
echo '<td class="tab_t">User</td>';
echo '<td class="tab_t">N&#252;meyi&#351;ler</td>';
echo '<td class="tab_t" colspan="2">Status</td>';
echo '</tr>';

$query = @mysql_Query("select `id`,`usid` as `user_id`, (select `login` from `users` where `id`=`user_id`) as `username`,`url`,`looks` from `sites` where `status`='2' order by `id` desc");
if(!mysql_affected_rows()){
    echo '<tr>';
    echo '<td class="tab_r">0</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '</tr>';
}

$i=1;
while($r = @mysql_fetch_array($query)){
    $rid = $r['id'];
    $usid = $r['user_id'];
    $url = $r['url'];
    $user = $r['username'];
    echo '<tr>';
    echo '<td class="tab_r">'.($i).'</td>';
    echo '<td class="tab_r"><a href="'.($url).'">'.($url).'</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case=select_user'.$takep.'&amp;usid='.($usid).'">'.($user).'</a></td>';
    echo '<td class="tab_r">'.($r['looks']).'</td>';

    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;a='.($rid).'">A</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;x='.($rid).'">X</a></td>';
    echo '</tr>';
    $i++;
}

echo '</table>';
break;

case ("sites_no_active"):
echo '<div class="title">Tesdiq g&#246;zleyen saytlar</div>';
echo '<br />';
echo '<table>';

echo '<tr align="center">';
echo '<td class="tab_t">#</td>';
echo '<td class="tab_t">Sayt</td>';
echo '<td class="tab_t">User</td>';
echo '<td class="tab_t" colspan="3">Status</td>';
echo '</tr>';

if(isset($_GET['x'])){
    $x = int($_GET['x']);
    @mysql_query("delete from `sites` where `id`='".$x."' and `status`='0'");
}

if(isset($_GET['a'])){
    $a = int($_GET['a']);
    @mysql_query("update `sites` set `status`='1' where `id`='".$a."' and `status`='0'");

    $rk = "SELECT `usid` FROM `sites` WHERE `id`='".$a."'";
    $rk = @Mysql_Query($rk);
    $rk = @Mysql_Fetch_Array($rk);

    $sq = "Select `id`,`login`,`pass`,`email` FROM `users` WHERE `id`='".$rk['usid']."'";
    $sq = @Mysql_Query($sq);
    $sq = @Mysql_Fetch_Array($sq);

    $subject = "Saytiniz aktiv edildi. Tebrikler..";
    $to = $sq["email"];
    $text .= "Hormetli ".$sq["login"]." ".$site_url." reklam sistemine elave etdiyiniz sayt tesdiqlendi..Tebrikler\n";
    $text .= "----\n";
    $text .= "Reklam paneli: http://".$site_url."/sites.php?cid=".$mcr->encode($sq["id"]."::".$sq["pass"])."\n";
    $fnc->message_send($to, $subject, $text);
}

if(isset($_GET['d'])){
    if(!isset($_POST['text'])){
        echo '<form action="admin.php?case='.$case.$takep.'&amp;d='.int($_GET['d']).'" method="post">';
        echo 'Sebeb:<br />';
        echo '<input type="text" name="text"><br />';
        echo '<input type="submit" value="Deaktiv et"> ';
        echo '</form>';
        echo '<br />';
    } else {
    $d = int($_GET['d']);
    @mysql_query("update `sites` set `status`='2', `ban_text`='".trim($_POST['text'])."' where `id`='".$d."' and `status`='0'");

    $rk = "SELECT `usid` FROM `sites` WHERE `id`='".$d."'";
    $rk = @Mysql_Query($rk);
    $rk = @Mysql_Fetch_Array($rk);

    $sq = "Select `id`,`login`,`pass`,`email` FROM `users` WHERE `id`='".$rk['usid']."'";
    $sq = @Mysql_Query($sq);
    $sq = @Mysql_Fetch_Array($sq);

    $subject = "Saytiniz deaktiv edildi.";
    $to = $sq["email"];
    $text .= "Hormetli ".$sq["login"]." ".$site_url." reklam sistemine elave etdiyiniz sayt deaktiv edildi..\n";
        if($_POST['text']!=''){
            $text .= "----\n";
            $text .= "Sebeb: ".$_POST['text']."\n";
        }
    $text .= "----\n";
    $text .= "Reklam paneli: http://".$site_url."/sites.php?cid=".$mcr->encode($sq["id"]."::".$sq["pass"])."\n";
    $fnc->message_send($to, $subject, $text);
}
}

$query = @mysql_Query("select `id`,`usid` as `user_id`, (select `login` from `users` where `id`=`user_id`) as `username`,`title`,`url` from `sites` where `status` = '0' order by `id` desc");

if(!mysql_affected_rows()){
    echo '<tr>';
    echo '<td class="tab_r">0</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '</tr>';
}

$i=1;
while($r = @mysql_fetch_array($query)){
    $rid = $r['id'];
    $usid = $r['user_id'];
    $url = $r['url'];
    $user = $r['username'];
    $money = $r['money'];
    echo '<tr>';
    echo '<td class="tab_r">'.($i).'</td>';
    echo '<td class="tab_r"><a href="'.($url).'">'.($url).'</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case=select_user'.$takep.'&amp;usid='.($usid).'">'.($user).'</a></td>';

    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;a='.($rid).'">A</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;d='.($rid).'">D</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;x='.($rid).'">X</a></td>';
    echo '</tr>';
    $i++;
}

echo '</table>';
break;


case ("adver_deactive"):
echo '<div class="title">Deaktiv reklamlar</div>';
echo '<br />';

if(isset($_GET['x'])){
    $x = int($_GET['x']);
    @mysql_query("delete from `advertisers` where `id`='".$x."'");
}

if(isset($_GET['a'])){
    $a = int($_GET['a']);
    @mysql_query("update `advertisers` set `status`='1' where `id`='".$a."'");
    $rk = "SELECT `usid` FROM `advertisers` WHERE `id`='".$a."'";
    $rk = @Mysql_Query($rk);
    $rk = @Mysql_Fetch_Array($rk);
    $sq = "Select `id`,`login`,`pass`,`email` FROM `users` WHERE `id`='".$rk['usid']."'";
    $sq = @Mysql_Query($sq);
    $sq = @Mysql_Fetch_Array($sq);

    $subject = "Reklaminiz aktiv edildi. Tebrikler..";
    $to = $sq["email"];
    $text .= "Hormetli ".$sq["login"]." ".$site_url." reklam sistemine elave etdiyiniz reklam aktiv edildi..Tebrikler\n";
    $text .= "----\n";
    $text .= "Reklam paneli: http://".$site_url."/advertisers.php?cid=".$mcr->encode($sq["id"]."::".$sq["pass"])."\n";
    $fnc->message_send($to, $subject, $text);
}

echo '<table>';

echo '<tr align="center">';
echo '<td class="tab_t">#</td>';
echo '<td class="tab_t">Ba&#351;l&#305;q</td>';
echo '<td class="tab_t">Url</td>';
echo '<td class="tab_t">Banner</td>';
echo '<td class="tab_t">User</td>';
echo '<td class="tab_t">Deyer</td>';
echo '<td class="tab_t" colspan="2">Status</td>';
echo '</tr>';

$query = @mysql_Query("select `id`,`usid` as `user_id`, (select `login` from `users` where `id`=`user_id`) as `username`,`title`,`url`,`banner`,`money` from `advertisers` where `status`='3' order by `id` desc");
if(!mysql_affected_rows()){
    echo '<tr>';
    echo '<td class="tab_r">0</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">0.00$</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '</tr>';
}

$i=1;
while($r = @mysql_fetch_array($query)){
    $rid = $r['id'];
    $usid = $r['user_id'];
    $title = $r['title'];
    $url = $r['url'];
    $banner = strlen($r['banner'])>0 ? '<img src="http://'.$site_url.'/img/ad/'.$r['banner'].'"/>' : '----';
    $user = $r['username'];
    $money = $r['money'];
    echo '<tr>';
    echo '<td class="tab_r">'.($i).'</td>';
    echo '<td class="tab_r">'.($title).'</td>';
    echo '<td class="tab_r"><a href="'.($url).'">'.($url).'</a></td>';
    echo '<td class="tab_r">'.($banner).'</td>';
    echo '<td class="tab_r"><a href="admin.php?case=select_user'.$takep.'&amp;usid='.($usid).'">'.($user).'</a></td>';
    echo '<td class="tab_r">'.(sprintf("%01.2f", $money/100)).'$</td>';

    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;a='.($rid).'">A</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;x='.($rid).'">X</a></td>';
    echo '</tr>';
    $i++;
}

echo '</table>';
break;


case ("adver_no_active"):
echo '<div class="title">Tesdiq g&#246;zleyen reklamlar</div>';
echo '<br />';
echo '<table>';

echo '<tr align="center">';
echo '<td class="tab_t">#</td>';
echo '<td class="tab_t">Ba&#351;l&#305;q</td>';
echo '<td class="tab_t">Url</td>';
echo '<td class="tab_t">Banner</td>';
echo '<td class="tab_t">User</td>';
echo '<td class="tab_t">Deyer</td>';
echo '<td class="tab_t" colspan="3">Status</td>';
echo '</tr>';

if(isset($_GET['x'])){
    $x = int($_GET['x']);
    @mysql_query("delete from `advertisers` where `id`='".$x."' and `status`='0'");
}

if(isset($_GET['a'])){
    $a = int($_GET['a']);
    @mysql_query("update `advertisers` set `status`='1' where `id`='".$a."' and `status`='0'");

    $rk = "SELECT `usid` FROM `advertisers` WHERE `id`='".$a."'";
    $rk = @Mysql_Query($rk);
    $rk = @Mysql_Fetch_Array($rk);

    $sq = "Select `id`,`login`,`pass`,`email` FROM `users` WHERE `id`='".$rk['usid']."'";
    $sq = @Mysql_Query($sq);
    $sq = @Mysql_Fetch_Array($sq);

    $subject = "Reklaminiz aktiv edildi. Tebrikler..";
    $to = $sq["email"];
    $text .= "Hormetli ".$sq["login"]." ".$site_url." reklam sistemine elave etdiyiniz reklam tesdiqlendi..Tebrikler\n";
    $text .= "----\n";
    $text .= "Reklam paneli: http://".$site_url."/advertisers.php?cid=".$mcr->encode($sq["id"]."::".$sq["pass"])."\n";
    $fnc->message_send($to, $subject, $text);
}

if(isset($_GET['d'])){
    $d = int($_GET['d']);
    @mysql_query("update `advertisers` set `status`='3' where `id`='".$d."' and `status`='0'");

    $rk = "SELECT `usid` FROM `advertisers` WHERE `id`='".$d."'";
    $rk = @Mysql_Query($rk);
    $rk = @Mysql_Fetch_Array($rk);

    $sq = "Select `id`,`login`,`pass`,`email` FROM `users` WHERE `id`='".$rk['usid']."'";
    $sq = @Mysql_Query($sq);
    $sq = @Mysql_Fetch_Array($sq);

    $subject = "Reklaminiz deaktiv edildi.";
    $to = $sq["email"];
    $text .= "Hormetli ".$sq["login"]." ".$site_url." reklam sistemine elave etdiyiniz reklam deaktiv edildi..\n";
    $text .= "----\n";
    $text .= "Sebeb: ".$_POST['text']."\n";
    $text .= "----\n";
    $text .= "Reklam paneli: http://".$site_url."/advertisers.php?cid=".$mcr->encode($sq["id"]."::".$sq["pass"])."\n";
    $fnc->message_send($to, $subject, $text);
}

$query = @mysql_Query("select `id`,`usid` as `user_id`, (select `login` from `users` where `id`=`user_id`) as `username`,`title`,`url`,`banner`,`money` from `advertisers` where `status` = '0' order by `id` desc");

if(!mysql_affected_rows()){
    echo '<tr>';
    echo '<td class="tab_r">0</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">0.00$</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '</tr>';
}

$i=1;
while($r = @mysql_fetch_array($query)){
    $rid = $r['id'];
    $usid = $r['user_id'];
    $title = $r['title'];
    $url = $r['url'];
    $banner = strlen($r['banner'])>0 ? '<img src="http://'.$site_url.'/img/ad/'.$r['banner'].'"/>' : '----';
    $user = $r['username'];
    $money = $r['money'];
    echo '<tr>';
    echo '<td class="tab_r">'.($i).'</td>';
    echo '<td class="tab_r">'.($title).'</td>';
    echo '<td class="tab_r"><a href="'.($url).'">'.($url).'</a></td>';
    echo '<td class="tab_r">'.($banner).'</td>';
    echo '<td class="tab_r"><a href="admin.php?case=select_user'.$takep.'&amp;usid='.($usid).'">'.($user).'</a></td>';
    echo '<td class="tab_r">'.(sprintf("%01.2f", $money/100)).'$</td>';

    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;a='.($rid).'">A</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;d='.($rid).'">D</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;x='.($rid).'">X</a></td>';
    echo '</tr>';
    $i++;
}

echo '</table>';
break;

case ("adver_active"):
echo '<div class="title">Aktiv reklamlar</div>';
echo '<br />';

if(isset($_GET['x'])){
    $x = int($_GET['x']);
    @mysql_query("delete from `advertisers` where `id`='".$x."'");
}

if(isset($_GET['d'])){
    if(!isset($_POST['text'])){
        echo '<form action="admin.php?case='.$case.$takep.'&amp;d='.int($_GET['d']).'" method="post">';
        echo 'Sebeb:<br />';
        echo '<input type="text" name="text"><br />';
        echo '<input type="submit" value="Deaktiv et"> ';
        echo '</form>';
        echo '<br />';
    } else {
        $d = int($_GET['d']);
        @mysql_query("update `advertisers` set `status`='3' where `id`='".$d."'");
        $rk = "SELECT `usid` FROM `advertisers` WHERE `id`='".$d."'";
        $rk = @Mysql_Query($rk);
        $rk = @Mysql_Fetch_Array($rk);
        $sq = "Select `id`,`login`,`pass`,`email` FROM `users` WHERE `id`='".$rk['usid']."'";
        $sq = @Mysql_Query($sq);
        $sq = @Mysql_Fetch_Array($sq);

        $subject = "Reklaminiz deaktiv edildi.";
        $to = $sq["email"];
        $text .= "Hormetli ".$sq["login"]." ".$site_url." reklam sistemine elave etdiyiniz reklam deaktiv edildi..\n";
        $text .= "----\n";
        $text .= "Sebeb: ".$_POST['text']."\n";
        $text .= "----\n";
        $text .= "Reklam paneli: http://".$site_url."/advertisers.php?cid=".$mcr->encode($sq["id"]."::".$sq["pass"])."\n";
        $fnc->message_send($to, $subject, $text);
    }
}

echo '<table>';

echo '<tr align="center">';
echo '<td class="tab_t">#</td>';
echo '<td class="tab_t">Ba&#351;l&#305;q</td>';
echo '<td class="tab_t">Url</td>';
echo '<td class="tab_t">Banner</td>';
echo '<td class="tab_t">User</td>';
echo '<td class="tab_t">Deyer</td>';
echo '<td class="tab_t" colspan="2">Status</td>';
echo '</tr>';

$query = @mysql_Query("select `id`,`usid` as `user_id`, (select `login` from `users` where `id`=`user_id`) as `username`,`title`,`url`,`banner`,`money` from `advertisers` where `status`!='0' and `status`!='3' order by `id` desc");

if(!mysql_affected_rows()){
    echo '<tr>';
    echo '<td class="tab_r">0</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">----</td>';
    echo '<td class="tab_r">0.00$</td>';
    echo '<td class="tab_r">--</td>';
    echo '<td class="tab_r">--</td>';
    echo '</tr>';
}

$i=1;
while($r = @mysql_fetch_array($query)){
    $rid = $r['id'];
    $usid = $r['user_id'];
    $title = $r['title'];
    $url = $r['url'];
    $banner = strlen($r['banner'])>0 ? '<img src="http://'.$site_url.'/img/ad/'.$r['banner'].'"/>' : '----';
    $user = $r['username'];
    $money = $r['money'];
    echo '<tr>';
    echo '<td class="tab_r">'.($i).'</td>';
    echo '<td class="tab_r">'.($title).'</td>';
    echo '<td class="tab_r"><a href="'.($url).'">'.($url).'</a></td>';
    echo '<td class="tab_r">'.($banner).'</td>';
    echo '<td class="tab_r"><a href="admin.php?case=select_user'.$takep.'&amp;usid='.($usid).'">'.($user).'</a></td>';
    echo '<td class="tab_r">'.(sprintf("%01.2f", $money/100)).'$</td>';

    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;d='.($rid).'">D</a></td>';
    echo '<td class="tab_r"><a href="admin.php?case='.$case.$takep.'&amp;x='.($rid).'">X</a></td>';
    echo '</tr>';
    $i++;
}

echo '</table>';
break;


}

echo '<br />';
if ($case)echo '<a href="admin.php?'.$takep.'">&#304;dare paneli</a><br />';
echo '<a href="home.php?'.$takep.'">&#304;lk sehife</a><br />';
require path.'/moduls/footer.php';
?>