public function getTeamPhotoLink() { if (file_exists(public_path() . self::PHOTO_PATH . str2url($this->team) . self::PHOTO_TYPE)) { return self::PHOTO_PATH . str2url($this->team) . self::PHOTO_TYPE; } else { return self::DEFAULT_PHOTO; } }
public function addParsedGame(GameMlsEntity $gameEntity) { $gameBO = new GameMlsBO($gameEntity); $data = $gameBO->toArray(); $validator = Validator::make($data, GameRequest::getRules()); if (!$validator->fails()) { $game = Game::where('mls_url', $data['mls_url'])->first(); if (!$game) { $game = Game::create($data); if (strpos($data['icon'], 'players-ico.png') === false && $data['icon'] != config('mls.domain')) { copy($data['icon'], public_path() . '/img/team_logos/' . str2url($game->team) . '.png'); } return $game; } } return false; }
/** * Execute the console command. * * @return mixed */ public function handle() { $path = public_path('img/team_logos'); $files = File::allFiles($path); $this->info('Files found: ' . count($files)); foreach ($files as $file) { $currentFilePath = $file->getRealPath(); $ext = '.' . $file->getExtension(); $filename = basename($currentFilePath, $ext); $fileslug = str2url($filename); $newfilepath = $path . '/' . $fileslug . $ext; if ($currentFilePath != $newfilepath) { copy($currentFilePath, $newfilepath); $this->info('File updated: ' . $fileslug); } } $this->info('Finished'); }
} } elseif ($name == 'category') { $value = str2url($value); } elseif ($name == 'url') { $exploded = explode('/', $value); $city = explode('.', $exploded[2]); $city_translit = str_replace('moskva', 'www', str_replace('sankt-peterburg', 'spb', str2url($city[0]))); $exploded[2] = str_replace($city[0], $city_translit, $exploded[2]); $exploded[6] = str2url($exploded[6]); $exploded[7] = str2url($exploded[7]); $value = implode('/', $exploded); $exploded = explode('&', $value); foreach ($exploded as &$one) { if (strpos($one, 'body=') !== FALSE) { $tmp = substr($one, strpos($one, 'body=') + strlen('body=')); $translit = str2url($tmp); $one = str_replace($tmp, $translit, $one); } } $value = implode('&', $exploded); $value = str_replace('http://www.', 'http://', $value); } $writer->startElement($name); $writer->text($value); $writer->endElement(); } $writer->endElement(); } $writer->endDocument(); $writer->flush(); echo "\nFinished";
if (count($page['tag_ids']) > 1) { $page['meta_robots'] = array('noindex' => 1, 'nofollow' => 1); } } elseif ('recent_cats' == $page['section']) { $page['meta_robots']['noindex'] = 1; } elseif ('search' == $page['section']) { $page['meta_robots']['nofollow'] = 1; } if ($filter['enabled']) { $page['meta_robots']['noindex'] = 1; } // see if we need a redirect because of a permalink if ('categories' == $page['section'] and isset($page['category'])) { $need_redirect = false; if (empty($page['category']['permalink'])) { if ($conf['category_url_style'] == 'id-name' and @$page['hit_by']['cat_url_name'] !== str2url($page['category']['name'])) { $need_redirect = true; } } else { if ($page['category']['permalink'] !== @$page['hit_by']['cat_permalink']) { $need_redirect = true; } } if ($need_redirect) { $redirect_url = script_basename() == 'picture' ? duplicate_picture_url() : duplicate_index_url(); if (!headers_sent()) { // this is a permanent redirection set_status_header(301); redirect_http($redirect_url); } redirect($redirect_url);
$dates2 = htmlspecialchars($_POST[dates2], ENT_QUOTES); $bus = htmlspecialchars($_POST[bus], ENT_QUOTES); $bus2 = htmlspecialchars($_POST[bus2], ENT_QUOTES); $hotel = htmlspecialchars($_POST[hotel], ENT_QUOTES); $hotel2 = htmlspecialchars($_POST[hotel2], ENT_QUOTES); $number = htmlspecialchars($_POST[number], ENT_QUOTES); $price = htmlspecialchars($_POST[price], ENT_QUOTES); $cat = htmlspecialchars($_POST[cat], ENT_QUOTES); $message = htmlspecialchars($_POST[message], ENT_QUOTES); $message2 = htmlspecialchars($_POST[text], ENT_QUOTES); $food_ru = htmlspecialchars($_POST[food_ru], ENT_QUOTES); $food_ro = htmlspecialchars($_POST[food_ro], ENT_QUOTES); if (empty($title) || empty($title2) || empty($dates) || empty($dates2) || empty($price) || empty($bus) || empty($bus2)) { echo "Не все заполнено"; } else { $page = str2url($title); $page_text = $page . '_text'; $page_food = $page . '_food'; $page_dates = $page . '_dates'; $page_bus = $page . '_bus'; $page_hotel = $page . '_hotel'; $file = $_FILES['fl']['tmp_name']; $filename = $_FILES['fl']['name']; if (!empty($file)) { ini_set('memory_limit', '32M'); $maxsize = "100000000"; $extentions = array("jpg", "png", "gif", "jpeg"); $size = filesize($_FILES['fl']['tmp_name']); $type = strtolower(substr($filename, 1 + strrpos($filename, "."))); $new_name = $page . $visit . '.' . $type; $to = '../images/tur/' . $new_name;
function getUrl($item) { global $fuels, $colors, $bodyTypes; $subDomain = empty($item['subdomain']) ? '' : $item['subdomain'] . '.'; $uriParamsString = ''; $maker = isset($item['maker']) && !empty($item['maker']) ? str2url($item['maker']) : ''; $model = isset($item['model']) && !empty($item['model']) ? str2url($item['model']) : ''; if (!empty($maker)) { $uriParamsString = '/all/' . $maker . '/' . $model; } $getParamsString = ''; $getParamsArray = array('region' => $item['city_translit'] == $item['subdomain'] ? '' : $item['city_translit'], 'region_id' => $item['city_translit'] == $item['subdomain'] ? '' : $item['city_id'], 'body' => !empty($item['body_type']) ? $bodyTypes[mb_strtolower($item['body_type'], 'utf8')] : '', 'new' => isset($item['type']) ? $item['type'] === 'new' ? 1 : 2 : '', 'year' => !empty($item['year']) ? $item['year'] . '-' . $item['year'] : '', 'fuel' => isset($item['fuel']) ? $fuels[mb_strtolower($item['fuel'], 'utf8')] : '', 'color' => isset($item['color']) ? $colors[mb_strtolower(mb_ereg_replace('ё', 'е', $item['color']), 'utf8')] : ''); $url = 'http://' . $subDomain . BASE_DOMAIN . '/auto/search' . $uriParamsString; $delimiter = '?'; foreach ($getParamsArray as $key => &$param) { if (empty($param)) { continue; } if (!empty($getParamsString) && $delimiter === '?') { $delimiter = '&'; } $getParamsString .= $delimiter . $key . '=' . $param; } return $url . $getParamsString; }
function load_file($file_owner, $owner_id, $url, $dir = 'files') { $pricefile = @$_FILES["pricefile"]["tmp_name"]; $pricefile_name = @$_FILES["pricefile"]["name"]; if (!is_file(@$pricefile) || !($filename = @basename($pricefile_name))) { $_SESSION['message'] = "Не найден файл!"; Header("Location: " . $url); exit; } $ext = substr($filename, strrpos($filename, ".") + 1); $fn = str2url(substr($filename, 0, strrpos($filename, "."))); $filename = $fn . "." . $ext; if (file_exists("{$dir}/{$filename}")) { $i = 1; while (file_exists("{$dir}/{$filename}")) { $filename = $fn . "_{$i}." . $ext; $i++; } } $filesize = filesize($pricefile) / 1024; mysql_query("INSERT INTO " . TABLE_FILE . " SET datetime=NOW(), owner='{$file_owner}', owner_id={$owner_id}, ext='{$filename}', filesize={$filesize}, ord=1") or Error(1, __FILE__, __LINE__); $file_id = @mysql_insert_id(); $big = "{$dir}/{$filename}"; if (file_exists($big)) { unlink($big); } copy($pricefile, $big); }
$city = explode('.', $exploded[2]); $city_translit = str_replace('moskva', 'www', str_replace('sankt-peterburg', 'spb', str2url($city[0]))); $exploded[2] = str_replace($city[0], $city_translit, $exploded[2]); if (in_array(str_replace('_', '/', $exploded[5]), array_keys($l_aCategories))) { $exploded[5] = $l_aCategories[str_replace('_', '/', $exploded[5])]; } else { $exploded[5] = 'all'; } $value = implode('/', $exploded); $value = str_replace('http://www.', 'http://', $value); if (isset($l_aAssetTypes[$arr['assetType']])) { $delimiter = '?'; if (strpos($value, '?') !== FALSE) { $delimiter = '&'; } $value .= $delimiter . str2url($arr['assetType']) . '=1'; } } $writer->startElement($name); $writer->text($value); $writer->endElement(); } $writer->endElement(); } $writer->endDocument(); $writer->flush(); } else { print "Error fetching groups: " . $mysqli->error; exit; } }
$data['mes'] = "Файл слишком большой. Загружать можно только изображения (gif|png|jpg|jpeg) размером до 2МБ"; $data['url'] = ''; } else { if (!in_array($file['type'][0], $types)) { $data['status'] = 'NO'; $data['mes'] = "Загружать можно только изображения (gif|png|jpg|jpeg) размером до 2МБ"; $data['url'] = ''; } else { if ($file['error'][0] == 0) { // получаем имя файла $filename = basename($file['name'][0]); // получаем расширение файла $extension = pathinfo($file['name'][0], PATHINFO_EXTENSION); // перемещаем файл из временной папки в нужную if (move_uploaded_file($file['tmp_name'][0], $uploadDir . str2url($filename) . '.' . $extension)) { $data['status'] = 'OK'; $data['mes'] = "Изображение успешно загружено"; $data['url'] = $uploadDir . str2url($filename) . '.' . $extension; $data['name'] = $filename; $data['flag'] = $flag; } else { $data['status'] = 'NO'; $data['mes'] = "Возникла неизвестная ошибка при загрузке файла"; $data['url'] = ''; } } } } // Выводим результат в JSON и заверщаем в скрипт echo json_encode($data); exit;
?> <script type="text/javascript" src="<?php echo $admin_page; ?> java_admin.js"></script> <?php $title = htmlspecialchars($_POST[title], ENT_QUOTES); $title2 = htmlspecialchars($_POST[title_ro], ENT_QUOTES); $link = htmlspecialchars($_POST['link'], ENT_QUOTES); $fid = htmlspecialchars($_POST['fid'], ENT_QUOTES); $id = htmlspecialchars($_POST[id], ENT_QUOTES); if (is_numeric($id) && is_numeric($fid) && !empty($title) && !empty($title2)) { $text_ru = $title; $text_ro = $title2; $title = str2url($title); $sql_find = mysql_query("SELECT `id` FROM `translation` WHERE `title`='{$title}' and `lang`='ru'"); if (mysql_num_rows($sql_find) > 0) { $update = mysql_query("UPDATE `translation` SET `text` = '{$text_ru}' WHERE `lang`='ru' and `title`='{$title}'"); if (!$update) { exit(mysql_error()); } $update = mysql_query("UPDATE `translation` SET `text` = '{$text_ro}' WHERE `lang`='ro' and `title`='{$title}'"); if (!$update) { exit(mysql_error()); } } else { $ins = mysql_query("INSERT INTO `translation`(`title`,`text`,`lang`)VALUES('{$title}','{$text_ru}','ru')"); if (!$ins) { exit(mysql_error()); }
function createListing($writer, $arr) { $city = trim($arr['l_geo_city']); $city = str2url($city); $city = str_replace('sankt-peterburg', 'spb', str_replace('moskva', 'www', $city)); $url = 'http://' . $city . '.pingola.ru/auto/search/all?s=' . $arr['l_id']; $writer->startElement('Listing'); $writer->startElement('ID'); $writer->text($arr['l_id']); $writer->endElement(); $writer->startElement('URL'); $writer->writeCData($url); $writer->endElement(); $writer->startElement('BodyType'); $writer->writeCData($arr['l_subcategory']); $writer->endElement(); $writer->startElement('Make'); $writer->writeCData($arr['l_make']); $writer->endElement(); $writer->startElement('Model'); $writer->writeCData($arr['l_model']); $writer->endElement(); $writer->startElement('Year'); $writer->text($arr['l_year']); $writer->endElement(); $writer->startElement('Price'); $writer->text($arr['l_price']); $writer->endElement(); $writer->startElement('Region'); $writer->writeCData($arr['l_region']); $writer->endElement(); $writer->startElement('City'); $writer->writeCData($arr['l_geo_city']); $writer->endElement(); $writer->startElement('Street'); $writer->writeCData($arr['l_geo_street']); $writer->endElement(); $writer->startElement('Metro'); $writer->writeCData($arr['l_metro']); $writer->endElement(); $writer->startElement('ContactName'); $writer->writeCData($arr['l_contact_name']); $writer->endElement(); $writer->startElement('ContactPhone'); $writer->writeCData($arr['l_contact_phone']); $writer->endElement(); $writer->startElement('ContactEmail'); $writer->writeCData($arr['l_contact_email']); $writer->endElement(); $images = explode(' ', $arr['l_image']); for ($ind = 1; $ind <= count($images); $ind++) { $writer->startElement('img' . $ind); $writer->writeCData($images[$ind - 1]); $writer->endElement(); } $writer->startElement('KM'); $writer->text($arr['l_km']); $writer->endElement(); $writer->startElement('Color'); $writer->writeCData($arr['l_color']); $writer->endElement(); $writer->startElement('TransmissionType'); $writer->writeCData($arr['l_trtype']); $writer->endElement(); $writer->startElement('EngineCapacity'); $writer->text($arr['l_encapacity']); $writer->endElement(); $writer->startElement('FuelType'); $writer->writeCData($arr['l_fuel']); $writer->endElement(); $writer->startElement('GearType'); $writer->writeCData($arr['l_gear']); $writer->endElement(); $writer->startElement('Condition'); $writer->writeCData($arr['l_condition']); $writer->endElement(); $writer->startElement('WheelSide'); $writer->writeCData($arr['l_wheelside']); $writer->endElement(); $writer->startElement('MoreInfo'); $writer->writeCData($arr['l_moreinfo']); $writer->endElement(); $writer->startElement('PostDate'); $writer->text($arr['l_postdate']); $writer->endElement(); $writer->endElement(); }
} //Проверяем 'пустые' страницы и выдаём оповещение if ($_GET['page'] > $num_pages) { $error = true; } if ($error == true) { $content = 'Ошибка: Публикаций не найдено'; } } if (isset($_GET['add'])) { if (isset($_POST['submit'])) { $order = array("\r\n", "\n", "\r"); $replace = '<br>'; $news = str_replace($order, $replace, $_POST["news"]); $fullnews = str_replace($order, $replace, $_POST["fullnews"]); $link = str2url($_POST['title']); $stmt = $pdo->prepare('INSERT INTO `jre_news` (`date`,`news`,`fullnews`,`title`,`alt_name`) VALUES (:date,:news,:fullnews,:title,:alt_name)'); $stmt->execute(array('date' => time(), 'news' => $news, 'fullnews' => $fullnews, 'title' => $_POST['title'], 'alt_name' => $link)); echo 'Новость успешно добавлена'; echo '<br><a href="/admin.php?do=news"><button class="button" style="width:auto;">Вернутся назад</button></a>'; } else { $content = '<h1>Добавить новость</h1> <form class="news" action="" method="POST"> <span>Заголовок новости</span><br> <input class="input" required type="text" name="title"><br> <span>Краткое описание</span><br> <textarea required style="padding:10px;" class="input" name="news"></textarea> <span>Текст новости</span><br> <textarea required style="padding:10px;" class="input" name="fullnews"></textarea> <input class="button" type="submit" value="Добавить" name="submit"> </form>';
$str = rus2translit($str); // в нижний регистр $str = strtolower($str); // заменям все ненужное нам на "-" $str = preg_replace('~[^-a-z0-9_]+~u', '-', $str); // удаляем начальные и конечные '-' $str = trim($str, "-"); return $str; } $title_cat = $_POST['title']; $find = mysql_query("SELECT id FROM categories WHERE title_lang='{$title_cat}'"); if (mysql_num_rows($find) > 0) { $f_id = mysql_fetch_array($find); $fid = $f_id[id]; } else { $abb = str2url($title_cat); $ins = mysql_query("INSERT INTO categories(title_lang,abb)VALUES('{$title_cat}','{$abb}')"); $sql_2 = mysql_query("SELECT id FROM categories WHERE title_lang='{$title_cat}'"); $sq = mysql_fetch_array($sql_2); $fid = $sq[id]; } $link = trim($_POST['site']); $text = curl_get_contents($link); $text = explode('"about-product-info">', $text); $text = trim($text[1]); $title_product = explode("</h1>", $text); $title_product = explode('">', $title_product[0]); $title_product = $title_product[1]; $sql_title_pr = mysql_query("SELECT id FROM products WHERE title_lang='{$title_product}'"); if (mysql_num_rows($sql_title_pr) > 0) { } else {
<?php include "lock.php"; ?> <script type="text/javascript" src="<?php echo $admin_page; ?> java_admin.js"></script> <?php $title = htmlspecialchars($_POST[title], ENT_QUOTES); $title2 = htmlspecialchars($_POST[title_ro], ENT_QUOTES); $id = htmlspecialchars($_POST[id], ENT_QUOTES); if (is_numeric($id) && !empty($title) && !empty($title2)) { $text_ru = $title; $text_ro = $title2; $title = str2url($title) . $visit; $file = $_FILES['fl']['tmp_name']; $filename = $_FILES['fl']['name']; if (!empty($file)) { ini_set('memory_limit', '32M'); $maxsize = "100000000"; $extentions = array("jpg", "png", "gif", "jpeg"); $size = filesize($_FILES['fl']['tmp_name']); $type = strtolower(substr($filename, 1 + strrpos($filename, "."))); $new_name = $title . '.' . $type; $to = '../images/tur/' . $new_name; $dr = $home_url . 'images/tur/' . $new_name; if ($size > $maxsize) { exit("Файл больше 100 мб. Уменьшите размер вашего файла или загрузите другой. <br><a href='' onClick=window.close();>Закрыть окно</a>"); } elseif (!in_array($type, $extentions)) { exit(' <b>Файл имеет недопустимое расширение <font color="#FF0000">' . $type . '</font></b>. Допустимыми являются форматы изображений. <br>');
/** * replace old style #images.keywords by #tags. Requires a big data * migration. * * @return void */ function tag_replace_keywords() { // code taken from upgrades 19 and 22 $query = ' CREATE TABLE ' . PREFIX_TABLE . 'tags ( id smallint(5) UNSIGNED NOT NULL auto_increment, name varchar(255) BINARY NOT NULL, url_name varchar(255) BINARY NOT NULL, PRIMARY KEY (id) ) ;'; pwg_query($query); $query = ' CREATE TABLE ' . PREFIX_TABLE . 'image_tag ( image_id mediumint(8) UNSIGNED NOT NULL, tag_id smallint(5) UNSIGNED NOT NULL, PRIMARY KEY (image_id,tag_id) ) ;'; pwg_query($query); // // Move keywords to tags // // each tag label is associated to a numeric identifier $tag_id = array(); // to each tag id (key) a list of image ids (value) is associated $tag_images = array(); $current_id = 1; $query = ' SELECT id, keywords FROM ' . PREFIX_TABLE . 'images WHERE keywords IS NOT NULL ;'; $result = pwg_query($query); while ($row = pwg_db_fetch_assoc($result)) { foreach (preg_split('/[,]+/', $row['keywords']) as $keyword) { if (!isset($tag_id[$keyword])) { $tag_id[$keyword] = $current_id++; } if (!isset($tag_images[$tag_id[$keyword]])) { $tag_images[$tag_id[$keyword]] = array(); } array_push($tag_images[$tag_id[$keyword]], $row['id']); } } $datas = array(); foreach ($tag_id as $tag_name => $tag_id) { array_push($datas, array('id' => $tag_id, 'name' => $tag_name, 'url_name' => str2url($tag_name))); } if (!empty($datas)) { mass_inserts(PREFIX_TABLE . 'tags', array_keys($datas[0]), $datas); } $datas = array(); foreach ($tag_images as $tag_id => $images) { foreach (array_unique($images) as $image_id) { array_push($datas, array('tag_id' => $tag_id, 'image_id' => $image_id)); } } if (!empty($datas)) { mass_inserts(PREFIX_TABLE . 'image_tag', array_keys($datas[0]), $datas); } // // Delete images.keywords // $query = ' ALTER TABLE ' . PREFIX_TABLE . 'images DROP COLUMN keywords ;'; pwg_query($query); // // Add useful indexes // $query = ' ALTER TABLE ' . PREFIX_TABLE . 'tags ADD INDEX tags_i1(url_name) ;'; pwg_query($query); $query = ' ALTER TABLE ' . PREFIX_TABLE . 'image_tag ADD INDEX image_tag_i1(tag_id) ;'; pwg_query($query); // print_time('tags have replaced keywords'); }
/** * @Name: Sofresh CMS v1.0 * @copyright Copyright © 2011 Sofresh */ defined('_ROOT') or die(__FILE__); $_GET["id"] = $_GET["id"] > 0 ? $_GET["id"] : 0; if ($_POST) { $data = array(); if (intval($_POST['delete_image']) > 0) { @unlink(_UPLOAD . $_POST['current_image']); $_POST['current_image'] = ""; $image = ""; } if ($_FILES["image"]) { $filename = $_POST["detail"]["fullname"] ? str2url($_POST["detail"]["fullname"] . "-" . $_POST["detail"]["keys"]) : time(); $image = upload('image', _UPLOAD, $filename . '-', $image_exts); if ($_POST['delete_image'] || !empty($icon) && trim($_POST['current_image']) != "") { @unlink(_UPLOAD . $_POST['current_image']); } if (is_array($image)) { $error .= $image['msg'] . '<br />'; } else { if (empty($image)) { $_POST["detail"]["image"] = $_POST['current_image']; } else { @unlink(_UPLOAD . $_POST['current_image']); $_POST["detail"]["image"] = $image; } } /*if($image){
foreach ($options_array as $options_id) { $opts = array('content_id' => intval($lastid), 'options_type' => $options_type, 'options_id' => $options_id, 'page' => 'content'); $oClass->insertOpt($opts); } } } // update _ln $ln_req = $cfg_type['required_fields'] ? explode(',', $cfg_type['required_fields']) : array('name'); if (!$cfg_type['required_fields'] || $_POST[$ln_req[0]]) { foreach ($_POST[$ln_req[0]] as $ln => $val) { if (!$cfg_type['required_fields'] || $val) { $arr_ln = array(); foreach ($cfg_type['ln_fields'] as $code => $info) { if ($info['chose'] && in_array($code, $ln_fields)) { if ($code == "name") { $arr_ln["name_url"] = $_POST[$code . "_url"][$ln] != "" ? $_POST[$code . "_url"][$ln] : str2url($_POST[$code][$ln]); } $arr_ln[$code] = $_POST[$code][$ln]; } } if (in_array('ln_image', $show_actions)) { // use image if ($cfg_type['ln_main_icon']['chose']) { if (intval($_POST['delete_ln_icon'][$ln]) > 0) { @unlink(_UPLOAD . $_POST['current_ln_icon'][$ln]); $_POST['current_ln_icon'][$ln] = ""; $ln_icon = ""; } $ln_icon = upload('ln_icon', _UPLOAD, time() . '-', $image_exts, $ln); if ($_POST['delete_ln_icon'][$ln] || !empty($icon) && trim($_POST['current_ln_icon'][$ln]) != "") { @unlink(_UPLOAD . $_POST['current_ln_icon'][$ln]);
/** * return the section token of an index or picture URL. * * Depending on section, other parameters are required (see function code * for details) * * @param array * @return string */ function make_section_in_url($params) { global $conf; $section_string = ''; $section = @$params['section']; if (!isset($section)) { $section_of = array('category' => 'categories', 'tags' => 'tags', 'list' => 'list', 'search' => 'search'); foreach ($section_of as $param => $s) { if (isset($params[$param])) { $section = $s; } } if (!isset($section)) { $section = 'none'; } } switch ($section) { case 'categories': if (!isset($params['category'])) { $section_string .= '/categories'; } else { isset($params['category']['name']) or trigger_error('make_section_in_url category name not set', E_USER_WARNING); array_key_exists('permalink', $params['category']) or trigger_error('make_section_in_url category permalink not set', E_USER_WARNING); $section_string .= '/category/'; if (empty($params['category']['permalink'])) { $section_string .= $params['category']['id']; if ($conf['category_url_style'] == 'id-name') { $section_string .= '-' . str2url($params['category']['name']); } } else { $section_string .= $params['category']['permalink']; } } break; case 'tags': $section_string .= '/tags'; foreach ($params['tags'] as $tag) { switch ($conf['tag_url_style']) { case 'id': $section_string .= '/' . $tag['id']; break; case 'tag': if (isset($tag['url_name']) and !is_numeric($tag['url_name'])) { $section_string .= '/' . $tag['url_name']; break; } default: $section_string .= '/' . $tag['id']; if (isset($tag['url_name'])) { $section_string .= '-' . $tag['url_name']; } } } break; case 'search': $section_string .= '/search/' . $params['search']; break; case 'list': $section_string .= '/list/' . implode(',', $params['list']); break; case 'none': break; default: $section_string .= '/' . $section; } return $section_string; }
$sph->setAttribute('lyear', $arr['year']); $sph->setAttribute('lgeocity', $arr1['prop_val']); $sph->setFilter($sph->VALUE_RANGE_INT, array('l_postdate', (int) strtotime(date('Y-m-00', strtotime('-30 day'))), (int) strtotime(date('Y-m-00')), FALSE)); $sph->setOptions($options); $res = $sph->search(); $posted_and_deleted = (int) ($arr1['num'] - $res['total_found']); $total_count += $active_in_city; $regions[] = array('r_name' => $arr1['prop_val'], 'count' => $active_in_city, 'count_post' => $arr1['num'], 'count_deleted' => $posted_and_deleted); } } $arr['count'] = $total_count; foreach ($arr as $name => $value) { if ($name == 'url') { $exploded = explode('/', $value); $exploded[6] = str2url($exploded[6]); $exploded[7] = str2url($exploded[7]); $value = implode('/', $exploded); } $writer->startElement($name); $writer->text($value); $writer->endElement(); } if (!empty($regions)) { $writer->startElement('regions'); foreach ($regions as $region) { $writer->startElement('region'); $writer->startElement('r_name'); $writer->text($region['r_name']); $writer->endElement(); $writer->startElement('count'); $writer->text($region['count']);
echo "\n" . $result; usleep(2000); } $sql = "SELECT * FROM np_vehicles_pv"; $result = $eyezeek->query($sql); if ($result === FALSE) { die("\nCould not make query. reason: " . mysqli_error()); } while ($row = $result->fetch_assoc()) { $l_aValues[] = $row; } foreach ($l_aValues as $l_aValue) { $origin = $l_aValue['vpv_value']; $utf8_sentence = $origin; $utf8_sentence = mb_convert_encoding($utf8_sentence, 'ISO-8859-5', "UTF-8"); $utf8_sentence = str2url($utf8_sentence); $utf8_sentence = mb_convert_encoding($utf8_sentence, 'UTF-8'); $sql = "INSERT IGNORE INTO {$l_sTargetTable} (`origin`,`translit`) VALUES('" . $origin . "','" . $utf8_sentence . "')"; echo "\n" . $sql . ": "; $result = $eyezeek->query($sql); echo "\n" . $result; usleep(2000); } mysqli_close($eyezeek); function rus2translit($string) { $converter = array('а' => 'a', 'б' => 'b', 'в' => 'v', 'г' => 'g', 'д' => 'd', 'е' => 'e', 'ё' => 'e', 'ж' => 'zh', 'з' => 'z', 'и' => 'i', 'й' => 'y', 'к' => 'k', 'л' => 'l', 'м' => 'm', 'н' => 'n', 'о' => 'o', 'п' => 'p', 'р' => 'r', 'с' => 's', 'т' => 't', 'у' => 'u', 'ф' => 'f', 'х' => 'h', 'ц' => 'ts', 'ч' => 'ch', 'ш' => 'sh', 'щ' => 'shch', 'ь' => '', 'ы' => 'i', 'ъ' => '\'', 'э' => 'e', 'ю' => 'yu', 'я' => 'ya', 'А' => 'A', 'Б' => 'B', 'В' => 'V', 'Г' => 'G', 'Д' => 'D', 'Е' => 'E', 'Ё' => 'E', 'Ж' => 'Zh', 'З' => 'Z', 'И' => 'I', 'Й' => 'Y', 'К' => 'K', 'Л' => 'L', 'М' => 'M', 'Н' => 'N', 'О' => 'O', 'П' => 'P', 'Р' => 'R', 'С' => 'S', 'Т' => 'T', 'У' => 'U', 'Ф' => 'F', 'Х' => 'H', 'Ц' => 'Ts', 'Ч' => 'Ch', 'Ш' => 'Sh', 'Щ' => 'Shch', 'Ь' => '', 'Ы' => 'I', 'Ъ' => '\'', 'Э' => 'E', 'Ю' => 'Yu', 'Я' => 'Ya'); $iso_converter = array(); foreach ($converter as $key => $val) { $key = mb_convert_encoding($key, 'ISO-8859-5', "UTF-8"); $iso_converter[$key] = $val;