/**
*сохраняет информацию из поля $data в базу данных сайта
*/
public function add_db_domini()
{
$db_connect = mysqli_connect(host, user, pass, db);
//сначала проставляем цены элементов
foreach ($this->data as $d) {
if ($d['price'] != 0) {
$d_name = $d['name'];
//echo $d_name."<br>";
$d_price = $d['price'];
$factory_id = 78;
$strSQL = "UPDATE goods " . "SET goods_pricecur={$d_price} " . "WHERE goods.goods_article_link={$d_name} AND factory_id={$factory_id}";
echo $strSQL . "<br>";
//break;
mysqli_query($db_connect, $strSQL);
//break;
}
}
//потом проставляем цены модулей
echo "<br><b>Просчет модулей</b><br>";
foreach ($this->data as $d) {
if ($d['price'] == 0) {
//считаем цену позиции суммируя цены ее составляющих
$name = $d['name'];
//БД в кодировке CP1251 а наши данные в UTF-8
$name = UTF8toCP1251($name);
//$name=("UTF-8","CP1251",$name)
//echo $name."<br>";
$strSQL = "SELECT SUM(goods_pricecur) FROM goods WHERE goods_id IN(" . "SELECT component_child FROM component WHERE component_in_complect=1 AND goods_id=(" . "SELECT goods_id FROM goods WHERE goods_article_link='{$name}' AND factory_id=78))";
$res = mysqli_query($db_connect, $strSQL);
//echo gettype($res);
var_dump($res);
echo "<br>";
//$price=mysqli_fetch_assoc($res);
while ($row = mysqli_fetch_assoc($res)) {
print_r($row);
$price = $row['SUM(goods_pricecur)'];
}
//проставляем цену позиции
if ($price) {
$strSQL = "UPDATE goods " . "SET goods_pricecur={$price} " . "WHERE goods.goods_article_link='{$name}' AND factory_id=78";
echo "<br><b>" . $strSQL . "</b><br>";
//break;
mysqli_query($db_connect, $strSQL);
}
}
}
}
function supertracker_get_keywords($days = false)
{
global $db;
require 'includes/searchengines.php';
$keywords_used = array();
$keywords_row = $db->Execute("SELECT referrer, referrer_query_string\n FROM " . TABLE_SUPERTRACKER . "\n WHERE referrer_query_string > '' " . ($days ? "AND DATE_ADD(time_arrived, INTERVAL " . $days . " DAY) >= NOW() " : ""));
// var_dump($keywords_row->RecordCount());echo '<br />';
$cc = array();
while (!$keywords_row->EOF) {
$cc['total']++;
$raw_search = false;
$url = parse_url(urldecode($keywords_row->fields["referrer"] . '?' . $keywords_row->fields["referrer_query_string"]));
if (empty($url["query"])) {
continue;
}
foreach ($search as $key => $val) {
foreach ($val['rule'] as $pattern) {
if (preg_match('`' . $pattern . '`i', $url["host"] . $url["path"], $regs) == 0) {
continue;
}
$raw_search = supertracker_get_arg($url["query"], $val["argv"], @$val["conv"]);
/*
if(isset($val["encode"]) && $val["encode"] != 'utf-8') {
$raw_search = iconv($val["encode"], 'utf-8', $raw_search);
}
$raw_search = iconv('utf-8', 'windows-1251', $raw_search);
*/
$cc['raw_search']++;
// if(is_ruUTF8($raw_search)){var_dump($cc['total'], $raw_search, is_ruUTF8($raw_search), UTF8toCP1251($raw_search));echo '<br />';}
if (CHARSET == 'windows-1251' && is_ruUTF8($raw_search)) {
$raw_search = UTF8toCP1251($raw_search);
}
break 2;
}
}
if ($raw_search === false) {
$cc['raw_no_search']++;
$key_array = explode('&', $keywords_row->fields['referrer_query_string']);
for ($i = 0; $i < sizeof($key_array); $i++) {
$keywords = false;
if (substr($key_array[$i], 0, 2) == 'q=') {
$keywords = str_replace('+', ' ', substr($key_array[$i], 2, strlen($key_array[$i]) - 2));
}
if (substr($key_array[$i], 0, 2) == 'p=') {
$keywords = str_replace('+', ' ', substr($key_array[$i], 2, strlen($key_array[$i]) - 2));
}
if (strstr($key_array[$i], 'query=')) {
$keywords = str_replace('+', ' ', substr($key_array[$i], 6, strlen($key_array[$i]) - 6));
}
if (strstr($key_array[$i], 'keyword=')) {
$keywords = str_replace('+', ' ', substr($key_array[$i], 8, strlen($key_array[$i]) - 8));
}
if (strstr($key_array[$i], 'keywords=')) {
$keywords = str_replace('+', ' ', substr($key_array[$i], 9, strlen($key_array[$i]) - 9));
}
}
}
$keywords = trim($raw_search);
if (!empty($keywords)) {
$keywords_used[$keywords]++;
}
$keywords_row->MoveNext();
}
//var_dump($cc);echo '<br />';
arsort($keywords_used);
$keywords_data = array();
$i = 0;
foreach ($keywords_used as $kw => $hits) {
$keywords_data[$i]['keywords'] = $kw;
$keywords_data[$i]['hits'] = $hits;
$i++;
}
return $keywords_data;
}
