traffic9v2 administrator.php

<?php

set_time_limit(0);

ini_set ('memory_limit', '500M');

include('config.php');

include('functions.php');

$mysql = mysql_connect ($db_host, $db_user, $db_password) or die("Ошибка: неудается подключится к MySQL серверу<br>" );

mysql_select_db($db_name);

session_start();

$error = 0;

if($admin_pwd != $_SESSION['pwd'] or $admin_login != $_SESSION['login'])

{

	$error = 1;

	header('Location: login.php');

	exit;

}

if($error == 0)

{

	if($_GET['p'] == 'show_convert')

	{

		if($_GET['date']) $date = $_GET['date']; else $date = date('d.m.Y');

		$content .= 'В данной таблице указана средняя конвертация трафика на платниках за <b>'.$date.'</b><br>';

		$payers = mysql_query ("select pl_id,pl_url from payers;");

		$content .= '<div align="center"><table border="1" width="600" cellspacing="0" cellpadding="0"><tr><td align="center">Дата</td><td align="center">Url</td><td align="center">Пришло</td><td align="center">Колв. смс</td><td align="center">Конвертация</td><td align="center">$/1k</td><td align="center">Доход</td></tr>';

		while($pl = mysql_fetch_assoc($payers))

		{

			$stat_convet = mysql_query ("select pl_unique,pl_access,pl_money from stat_convert where pl_id='".$pl['pl_id']."' and pl_date='".$date."';");

			while($stat = mysql_fetch_assoc($stat_convet))

			{

				$total['pl_unique'] = $total['pl_unique'] + $stat['pl_unique'];

				$total['pl_access'] = $total['pl_access'] + $stat['pl_access'];

				$total['pl_money'] = $total['pl_money'] + $stat['pl_money'];

			}

			

			$content .= '<tr><td align="center">'.$date.'</td><td align="center">'.$pl['pl_url'].'</td><td align="center">'.$total['pl_unique'].'</td><td align="center">'.$total['pl_access'].'</td><td align="center">1:'.@round($total['pl_unique']/$total['pl_access'],0).'</td><td align="center">'.@round(1000*$total['pl_money']/$total['pl_unique'],2).'</td><td align="center"><b>'.$total['pl_money'].'</b></td></tr>';

			$total = '';

		}

		$content .= '</table></div>';

	}

	if($_GET['p'] == 'correct_convert')

	{

		$content .= '<form method="post" action="?p=correct_convert">';

		if($_SESSION['form_min_convert']) $content .= 'Показать партнеров с < мин. конверт: <input type="text" name="min_convert" value="'.$_SESSION['form_min_convert'].'"><br>'; else $content .= 'Показать партнеров с < мин. конверт: <input type="text" name="min_convert" value="30"><br>'; 

		if($_SESSION['form_min_unique']) $content .= 'Мин. уников: <input type="text" name="min_unique" value="'.$_SESSION['form_min_unique'].'"><br>'; else $content .= 'Мин. уников: <input type="text" name="min_unique" value="50"><br>';

		if($_SESSION['form_date']) $content .= 'Дата: <input type="text" name="date" value="'.$_SESSION['form_date'].'"><br>'; else $content .= 'Дата: <input type="text" name="date" value="'.date('d.m.Y').'"><br>';

		/*$content .= 'Начинаем с p_id: <input type="text" name="start" value="1"> до <input type="text" name="end" value="200"><br>'; */

		$content .= '<input type="submit" class="submit" value="  Найти  "><br>

		</form><br><br>';

		if($_POST['min_convert'])

		{

			$_SESSION['form_min_convert'] = $_POST['min_convert'];

			$_SESSION['form_min_unique'] = $_POST['min_unique'];

			$_SESSION['form_date'] = $_POST['date'];

			$access = mysql_query ("select * from access where a_date='".$_POST['date']."' and p_id='' and a_ip='service';");

			$count = 0;

			while($p = mysql_fetch_assoc($access)) $count++;

			$content .= 'Количество свободных смс <b>'.$count.'</b><br>';

			/*if($_POST['start'])

			{

				if(!$_POST['end']) $_POST['end'] = $_POST['start']+100;

				$part = mysql_query ("select * from partners order by p_id LIMIT ".$_POST['start'].",".$_POST['end'].";");

			} else {

				$part = mysql_query ("select * from partners order by p_id;");

			}*/

			$content .= '<table border=1><tr><td>ID</td><td>Принято</td><td>Колв. смс</td><td>Доход</td><td>Коверт(смс)</td><td>Конверт($)</td><td>Referers</td><td>Действие</td></tr>';

			#while($p = mysql_fetch_assoc($part))

			$stat = mysql_query ("select p_id,s_uniqs_1,s_money,s_sms from statistic2 where s_date='".$_POST['date']."' order by p_id;");

			#$content .= "select s_uniqs_1,s_money,s_sms from statistic2 where s_date='".$_POST['date']."';";

		$p['p_cost'] = '2.5';

			while($s = mysql_fetch_assoc($stat))

			{

				

				#$s2 = mysql_fetch_assoc(mysql_query ("select s_uniqs_1,s_money from statistic where s_date='".GetYesterday(time())."' and p_id='".$p['p_id']."';"));

				if($s['s_uniqs_1'] >= $_POST['min_unique'])

				{

					$count_sms = $s['s_sms'];

					$money = $count_sms*$p['p_cost'];

					$konvert = round(1000*$money/$s['s_uniqs_1'],2);

					if($konvert < $_POST['min_convert'])

					{

						$content .= '<tr><td>'.$s['p_id'].'</td><td>'.$s['s_uniqs_1'].'</td><td>'.$count_sms.'</td><td>'.$money.'</td><td><center>1 : '.@round($s['s_uniqs_1']/$count_sms,0).'</center></td><td>'.$konvert.'</td><td><a href="?p=referers&date='.$_POST['date'].'&p_id='.$s['p_id'].'&stop=20">Реферерс</a></td><td><a href="?p=correct_convert&p_id='.$s['p_id'].'&date='.$_POST['date'].'">Корректировать</a></td></tr>';

					}

				}

			}

			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx					>', $tmp[$i]['n_text']).'<br>

				Время добавления: <b>'.date("d.m.Y H:i:s", $tmp[$i]['n_time']).'</b><br>

				<a href="?p=news&action=change_new&n_id='.$tmp[$i]['n_id'].'">Редактировать</a>

				</td></tr></table></td></tr></table>

				</td></tr>';

			}

			$content .= '</table></div>';

		}

	}

	if($_GET['p'] == 'amount_sms')

	{

	

		if(!$_GET['date']) $date = date("d.m.Y"); else $date = $_GET['date'];

		if($_POST['count_services_sms'])

		{

			for($i = 0; $i < $_POST['count_services_sms']; $i++)

			{

				$pwd = GenerationID(10);

				$result = mysql_query ("INSERT INTO access (p_id,a_date,a_pwd,a_ip,a_time,a_type) VALUES (

				'',

				'".$date."',

				'".$pwd."',

				'service',

				'".time()."',

				'1');");

			}

			$content .= 'Добавлено <b>'.$_POST['count_services_sms'].'</b> сервисных смс<br>';

		}

		$content .= 'Дата: <a href="?p=amount_sms&date='.$date .'">'.$date .'</a><br>';

		$access = mysql_query ("select p_id,a_pwd from access where a_date='".$date."' and a_ip<>'service';");

		while($a = mysql_fetch_assoc($access)) if(trim($a['p_id']) > 0) $sms1[] = $a['a_pwd']; else $sms2[] = $a['a_pwd'];

		$access = mysql_query ("select p_id,a_pwd from access where a_date='".$date."' and a_ip='service';");

		while($a = mysql_fetch_assoc($access)) if(trim($a['p_id']) > 0) $sms4[] = $a['a_pwd']; else $sms3[] = $a['a_pwd'];



		

		$count_free = count($sms2);

		$count_service_free = count($sms3);

		$count_service_busy = count($sms4);

		$content .= 'Количество смс принятных: <b>'.(count($sms1)+$count_free).'</b><br>

					Количество свободных смс: <b>'.$count_free.'</b><br>

					Количество сервисных смс: <b>'.($count_service_free+$count_service_busy).'</b><br>

					Количество свободных сервисных смс: <b>'.$count_service_free.'</b><br>

					Количество партнерских смс: <b>'.count($sms1).'</b><br>

					xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx">Найти все ошибки</a><br>';

			if($_POST['submit'])

			{

				$pays = mysql_query ("select * from payouts where pay_date='".$_POST['date']."';");

				$content .= '<table border="1"><tr><td>ID партнера</td><td>К выплате</td><td>Статус</td></tr>';

				while($pay = mysql_fetch_assoc($pays))

				{

					$content .= '<tr><td><center>'.$pay['p_id'].'</center></td><td><center>'.$pay['pay_money'].'</center></td><td><center>'.PayoutStatus($pay['pay_status']).'</center></td></tr>';

				}

				$content .= '</table>';

			}

		}

	

		if($_GET['action'] == 'search_errors')

		{

			$pays = mysql_query ("select * from payouts where pay_status='3';");

			$content .= '<table border="1"><tr><td>ID партнера</td><td>К выплате</td><td>Статус</td></tr>';

			while($pay = mysql_fetch_assoc($pays))

			{

				$content .= '<tr><td><center>'.$pay['p_id'].'</center></td><td><center>'.$pay['pay_money'].'</center></td><td><center>'.PayoutStatus($pay['pay_status']).'</center></td></tr>';

			}

			$content .= '</table>';			

		}

		if($_GET['action'] == 'change_payouts_status')

		{

			$content .= '<form method="post" action="?p=change_all_payouts">

			<input type="text" name="date" value="'.$_GET['date'].'">

			<input type="submit" name="submit" class="submit" value="  Отметить что деньги выплачены  ">

			</form><br>';

			if($_POST['date'])

			{



		xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx			xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx		





?>