/** *сохраняет информацию из поля $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; }