function &SelectSet($sqlString, $idTable = '')
{
$resourseId = DataBaseMysql::Query($sqlString);
$row = array();
while ($rowOne =& mysql_fetch_assoc($resourseId)) {
if ($idTable) {
$row[$rowOne[$idTable]] = $rowOne;
} else {
$row[] = $rowOne;
}
}
@mysql_free_result($resourseId);
return $row;
}
<script src="http://www.onlysites.ru/assets/js/jquery-1.4.2.min.js" language="javascript" type="text/javascript"></script>
<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"];
<?php
require_once 'config.php';
require_once 'lib/db/db.class.php';
require_once 'lib/yandex.xml/Yandex.php';
?>
<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 style="padding: 12px;">
<?php
if (isset($_POST)) {
$data = $_POST;
}
$current_date = date('Y-m-d');
$params = new Config();
$dbID = new DataBaseMysql($params->host, $params->user, $params->pass, $params->base);
$dbID->Query("SET NAMES UTF8");
$dbID->Query("INSERT INTO projects VALUES ('','{$data['name']}','{$data['url']}','{$current_date}','','','','',{$data['region']},'1')");
$dbID->Destroy();
header('Location: http://stat.onlysites.ru/index.php');
?>
</body>
</html>
<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 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;
