<script type="text/javascript" src="https://www.google.com/jsapi"></script> <script type="text/javascript" src="http://stat.onlysites.ru/assets/js/jquery.tablesorter.js"></script> <script type="text/javascript" src="http://stat.onlysites.ru/assets/js/jquery.colorbox-min.js"></script> <script type="text/javascript"> $(document).ready(function(){ $("#maintable").tablesorter(); $(".inline").colorbox(); }); </script> </head> <body> <?php $params = new Config(); $dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base); $dbID->Query("SET NAMES UTF8"); $projects = $dbID->SelectSet("SELECT * from projects WHERE id = '{$_GET['project_id']}' AND is_active = '1'"); $project = $projects[0]["name"]; $region = $projects[0]["region"]; $keywords = $dbID->SelectSet("SELECT * from keywords WHERE project_id = '{$_GET['project_id']}' AND is_active = '1'"); $keywords = $keywords[0]; $current_date = date('Y-m-d'); //current_date $yesterday_date = date("Y-m-d", time() - 60 * 60 * 24); //yesterday_date $positions = $dbID->SelectSet("SELECT * from positions WHERE project_id = '{$_GET['project_id']}' AND is_active = '1' AND date = '{$current_date}'"); $positions = $positions[0]; $positions_2 = $dbID->SelectSet("SELECT * from positions WHERE project_id = '{$_GET['project_id']}' AND is_active = '1' AND date = '{$yesterday_date}'"); $positions_2 = $positions_2[0]; $keys = $keywords["phrase"]; $positions_yandex = $positions["positions_yandex"]; $positions_yandex_2 = $positions_2["positions_yandex"];
<head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Статистика позиций сайтов. Проекты</title> <link rel="stylesheet" href="http://www.onlysites.ru/assets/css/style.css" type="text/css" /> <link rel="stylesheet" href="http://stat.onlysites.ru/assets/css/style.css" type="text/css" /> <link rel="icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" /> <link rel="shortcut icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" /> <script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script> <?php if (isset($_GET["project_id"])) { $project_id = $_GET["project_id"]; } $params = new Config(); $dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base); $dbID->Query("SET NAMES UTF8"); $project = $dbID->SelectSet("SELECT * from projects WHERE is_active = 1 AND id = {$project_id}"); $project = $project["0"]; $keywords = $dbID->SelectSet("SELECT * from keywords WHERE is_active = 1 AND project_id = {$project_id}"); if (sizeof($keywords) > 0) { $keywords = $keywords["0"]; } ?> <?php $current_reg_id = $project['region']; ?> <script type="text/javascript"> jQuery(document).ready(function() { jQuery('#<?php echo $current_reg_id; ?> ').attr('selected', true);
<html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Статистика позиций сайтов. Проекты</title> <link rel="stylesheet" href="http://www.onlysites.ru/assets/css/style.css" type="text/css" /> <link rel="stylesheet" href="http://stat.onlysites.ru/assets/css/style.css" type="text/css" /> <link rel="icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" /> <link rel="shortcut icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" /> <script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script> </head> <body> <?php $params = new Config(); $dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base); $dbID->Query("SET NAMES UTF8"); $res = $dbID->SelectSet("SELECT * from projects WHERE is_active = 1"); /* include external php scripts */ include_once "project_get_tic.php"; include_once "project_get_pr.php"; include_once "project_pages_in_google.php"; include_once "project_pages_in_yandex.php"; echo "<table width='100%' id='maintable'>"; echo "<tr>\r\n\t\t\t<th>id</th>\r\n\t\t\t<th>Проект</th>\r\n\t\t\t<th>Запросы (шт)</th>\r\n\t\t\t<th>Рост ↑ (шт)</th>\r\n\t\t\t<th>Падение ↓ (шт)</th>\r\n\t\t\t<th>ТИЦ</th>\r\n\t\t\t<th>PR</th>\r\n\t\t\t<th>индекс Yandex</th>\r\n\t\t\t<th>индекс Google (основной)</th>\r\n\t\t\t<th>индекс Google (supplemental)</th>\r\n\t\t\t<th>Статистика</th>\t\r\n\t\t\t<th>Редактировать</th>\r\n\t\t</tr>"; foreach ($res as $key => $value) { $keys = $dbID->SelectValue("SELECT phrase from keywords WHERE is_active = 1 AND project_id = {$value['id']}"); $keys = explode(";", $keys); $num_keys = sizeof($keys); $num_keys_up = 0; $num_keys_down = 0; echo "<tr>\r\n\t\t\t<td>" . $value["id"] . "</td>\r\n <td><a href='project_view.php?project_id=" . $value["id"] . "'>" . $value["name"] . "</a></td>\r\n\t\t\t<td>" . $num_keys . "</td>\r\n\t\t\t<td>" . $num_keys_up . "</td>\r\n\t\t\t<td>" . $num_keys_down . "</td>\r\n\t\t\t<td style='color: #BF390A;'>" . get_yandex($value["name"]) . "</td>\r\n\t\t\t<td style='color: #BF390A;'>" . GetPageRank($value["name"]) . "</td>\r\n\t\t\t<td style='color: #BF390A;'><div style='white-space: nowrap; width: 50px; overflow: hidden;'>" . YandexPagesXml($value["name"]) . "</div></td>\r\n\t\t\t<td style='color: #BF390A;'>" . GoogleIndex($value["name"]) . "</td>\r\n\t\t\t<td>-</td>\r\n\t\t\t<td><a href='project_edit.php?project_id=" . $value["id"] . "' style='text-align: center;'><img src='assets/images/view.png' width='20' height='20' alt='' /></a><a href='project_view.php?project_id=" . $value["id"] . "' style='float: left;'>смотреть</a><div class='clear: both;'></div></td>\r\n\t\t\t<td><a href='project_edit.php?project_id=" . $value["id"] . "' style='text-align: center;'><img src='assets/images/edit.png' width='20' height='20' alt='' /></a><a href='project_edit.php?project_id=" . $value["id"] . "' style='float: left;'>редактировать</a><div class='clear: both;'></div></td>\r\n\t\t</tr>"; }
<title>Статистика позиций сайтов. Проекты</title> <link rel="stylesheet" href="http://www.onlysites.ru/assets/css/style.css" type="text/css" /> <link rel="stylesheet" href="http://stat.onlysites.ru/assets/css/style.css" type="text/css" /> <link rel="icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" /> <link rel="shortcut icon" href="http://www.onlysites.ru/assets/images/faviconst.ico" type="image/x-icon" /> <script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script> </head> <body style="padding: 12px;"> <?php if (isset($_POST)) { $data = $_POST; } $params = new Config(); $dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base); $dbID->Query("SET NAMES UTF8"); $project_id = $dbID->SelectSet("SELECT project_id from keywords WHERE is_active = 1 AND project_id = '{$data['project_id']}'"); if (sizeof($project_id) > 0) { $dbID->Query("UPDATE projects SET name = '{$data['name']}' WHERE is_active = '1' AND id = '{$data['project_id']}'"); $dbID->Query("UPDATE projects SET url = '{$data['url']}' WHERE is_active = '1' AND id = '{$data['project_id']}'"); $dbID->Query("UPDATE projects SET region = '{$data['region']}' WHERE is_active = '1' AND id = '{$data['project_id']}'"); $str = $data["keys"]; $keys = str_replace("\r\n", ";", $str); $dbID->Query("UPDATE keywords SET phrase = '{$keys}' WHERE is_active = '1' AND project_id = '{$data['project_id']}'"); } else { $str = $data["keys"]; $keys = str_replace("\r\n", ";", $str); $dbID->Query("INSERT INTO keywords VALUES ('','{$data['project_id']}', '2013-07-01', '{$keys}', '1')"); } $dbID->Destroy(); header('Location: http://stat.onlysites.ru/index.php'); ?>
<?php require_once 'config.php'; require_once 'lib/db/db.class.php'; require_once 'lib/yandex.xml/Yandex.php'; /* Проекты из таблицы projects пробиваем на ключи из таблицы keywords, результат пишем в positions с учетом даты пробивки. */ header("Content-Type: text/html;charset=utf-8"); $params = new Config(); $dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base); $dbID->Query("SET NAMES UTF8"); $projects = $dbID->SelectSet("SELECT * from projects WHERE is_active = 1"); $i = 0; foreach ($projects as $key => $value) { $keys = $dbID->SelectSet("SELECT * from keywords WHERE project_id = '{$value['id']}' AND is_active = 1"); $keys = $keys["0"]; $projects[$i]["keys"] = $keys; $i++; } foreach ($projects as $key => $project) { $host = $project["url"]; $host_esc = htmlspecialchars($host); $host = preg_replace("[^http://|www\\.]", '', $host); $phrase = $project["keys"]["phrase"]; $phrases = explode(";", $phrase); $reg = $region = $project["region"]; $reg_esc = htmlspecialchars($reg); $page = 0; $pages = 3; $error = false;