>
>
>
>
>
>
sitemap_generator.php
<?php /** * Файл для генерации sitemap.xml * * ВНИМАНИЕ! этот файл автономный, поэтому методы App:: ему недоступны! */ require_once (__DIR__ . '/app/commands/autoloader.php'); error_reporting(E_ALL); ini_set('display_errors', 1); /** * ===================================================================================================================== * ========================================= СПИСОК ОСНОВНЫХ СТРАНИЦ =================================================== * ===================================================================================================================== */ $links = [ 'https://www.infoorel.ru/index.php', // 'https://www.infoorel.ru/maps/', 'https://www.infoorel.ru/afisha/', 'https://www.infoorel.ru/restoran/', 'https://www.infoorel.ru/forum/', 'https://www.infoorel.ru/fotogal/', // 'https://www.infoorel.ru/job/', 'https://www.infoorel.ru/news/', 'https://www.infoorel.ru/katalog_firm.php', 'https://www.infoorel.ru/oblast/?type=otrasl', // 'https://www.infoorel.ru/realty/' ]; $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($links as $link) { $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('daily')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/index.xml', $xml->saveHTML()); /** * ===================================================================================================================== * ================================================= СПИСОК НОВОСТЕЙ =================================================== * ===================================================================================================================== */ $sth = $pdo->prepare(' SELECT COUNT(id) as total FROM news WHERE `data` <= NOW() AND status in (3, 4) '); $sth->execute(); $totalNews = $sth->fetch()['total']; $newsPerSiteMap = 30000; $pages = ceil($totalNews / $newsPerSiteMap); for ($i = 1; $i <= $pages; $i++) { $sth = $pdo->prepare(' SELECT id, data, url, erid FROM news WHERE data <= NOW() and status IN (3, 4) ORDER BY id DESC LIMIT '.(($i - 1) * $newsPerSiteMap).','.$newsPerSiteMap.' '); $sth->execute(); $newsItems = $sth->fetchAll(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($newsItems as $newsItem) { $date = strtotime($newsItem['data']); if ($date < 0 or empty($date)) { continue; } $eridUrl = ''; if (!empty($newsItem['erid'])) { $eridUrl = "/?erid={$newsItem['erid']}"; } $link = 'https://www.infoorel.ru/news/' . $newsItem['url'] . '.html'.$eridUrl; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d', strtotime($newsItem['data'])))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/infoorel_news_'.$i.'.xml', $xml->saveHTML()); } // Разделы новостей $sth = $pdo->prepare(' SELECT id, name FROM news_razdel WHERE status = 3 '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $section) { $link = 'https://www.infoorel.ru/news/?section_id=' . $section['id']; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('daily')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/news_sections.xml', $xml->saveHTML()); /** * ===================================================================================================================== * ================================================= СПИСОК ПОСЛЕДНИХ НОВОСТЕЙ (GOOGLE NEWS) =================================================== * ===================================================================================================================== */ $sth = $sth = $pdo->prepare(' SELECT id, news_header, data, url, erid FROM news WHERE razdel not in (5, 25, 28, 29 ) AND status in(3) AND data between DATE_SUB(curdate(),INTERVAL 2 day) and now() '); $sth->execute(); $newsItems = $sth->fetchAll(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); $urlset->setAttribute('xmlns:news','http://www.google.com/schemas/sitemap-news/0.9'); foreach ($newsItems as $newsItem) { $date = strtotime($newsItem['data']); if ($date < 0 or empty($date)) { continue; } $eridUrl = ''; if (!empty($newsItem['erid'])) { $eridUrl = "/?erid={$newsItem['erid']}"; } $link = 'https://www.infoorel.ru/news/' . $newsItem['url']. '.html'.$eridUrl; $title = $newsItem['news_header']; $title = str_replace(['«','»'], '', $title); $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $news = $url->appendChild($xml->createElement('news:news')); $publication= $news->appendChild($xml->createElement('news:publication')); $publicationDate= $news->appendChild($xml->createElement('news:publication_date')); $newsTitle= $news->appendChild($xml->createElement('news:title')); $pubName = $publication->appendChild($xml->createElement('news:name')); $pubLanguage = $publication->appendChild($xml->createElement('news:language')); $loc->appendChild($xml->createTextNode($link)); $pubName->appendChild($xml->createTextNode('Новости')); $pubLanguage->appendChild($xml->createTextNode('ru')); $publicationDate->appendChild($xml->createTextNode(date('Y-m-d', $date))); $newsTitle->appendChild($xml->createTextNode($title)); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/infoorel_google_news.xml', $xml->saveHTML()); /** * ===================================================================================================================== */ /** * ===================================================================================================================== * ========================================= Список категорий организаций ============================================== * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/industry/1/Vlast_i_politika_Orel/ */ $sth = $pdo->prepare(' SELECT id, translit_name FROM otrasl2 '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $otrasl) { $link = "https://www.infoorel.ru/industry/{$otrasl['id']}/{$otrasl['translit_name']}/"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('0.8')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/infoorel_industry_catalog.xml', $xml->saveHTML()); /** * ===================================================================================================================== */ /** * ===================================================================================================================== * ============================================= Список организаций ==================================================== * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/firma.php?id=11389 */ $sth = $pdo->prepare(' SELECT id, last_modified, firma_url, data_registr FROM firma ORDER BY id DESC '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $firma) { $dataRegister = strtotime($firma['data_registr']); $lastmod = strtotime($firma['last_modified']); if ($lastmod < 0 or empty($lastmod)) { if ($dataRegister < 0 or empty($dataRegister)) { continue; } $date = $dataRegister; } else { $date = $lastmod; } $link = "https://www.infoorel.ru/company/{$firma['firma_url']}.html"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d', $date))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/infoorel_firma.xml', $xml->saveHTML()); /** * ===================================================================================================================== */ /** * ===================================================================================================================== * ================================================== Афиша ============================================================ * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/afisha/?id=3374 */ $sth = $pdoAfisha->prepare(' SELECT a.id, a.url, a.id_grp, g.url as group_url FROM infostrana.afisha_event a INNER JOIN infoorel.afisha_new c ON c.id_activity = a.id INNER JOIN infostrana.afisha_groups g ON g.id = a.id_grp WHERE c.date_do>=curdate() '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $afisha) { $link = "https://www.infoorel.ru/afisha/{$afisha['group_url']}/{$afisha['url']}.html"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/infoorel_afisha.xml', $xml->saveHTML()); /** * ===================================================================================================================== */ /** * ===================================================================================================================== * ================================================== Рестораны ======================================================== * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/restoran/pelmennyy-dom-puzikovyh.html */ $sth = $pdoRestoran->prepare(' SELECT id, restoran_url FROM restoran where status = 3 ORDER BY id DESC '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $restoran) { $link = "https://www.infoorel.ru/restoran/{$restoran['restoran_url']}.html"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/infoorel_restoran.xml', $xml->saveHTML()); /** * ===================================================================================================================== */ /** * ===================================================================================================================== * ================================================== Форумы =========================================================== * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/forum/forum_list.php?f=1 */ $links = []; // Код для генерации forum_list.php // считаем количество записей $sth = $pdo->prepare(' SELECT id FROM forum '); $sth->execute(); foreach ($sth->fetchAll() as $forum) { $sth = $pdo->prepare(' SELECT COUNT(id) as total FROM articl where id_forum = '.$forum['id'].' GROUP BY id_parent '); $sth->execute(); $totalForum = $sth->fetchAll(); $totalForumThemes = ceil(count($totalForum) / 30); // выводим количество страниц. for ($i = 1; $i <= $totalForumThemes; $i++) { if ($i == 1) { $link = "https://www.infoorel.ru/forum/forum_list.php?f={$forum['id']}"; } else { $link = "https://www.infoorel.ru/forum/forum_list.php?f={$forum['id']}&sort_type=0&sort_kind=0&sort_date=0&ofs=".(($i-1) * 30)."&page={$i}"; } $links[] = $link; } // выводим список тем форума, а также страницы темы. $sth = $pdo->prepare(' select id from articl where id = id_parent AND id_forum = '.$forum['id'].' '); $sth->execute(); $forumThemes = $sth->fetchAll(); foreach ($forumThemes as $forumTheme) { $links[] = "https://www.infoorel.ru/forum/forum_read.php?f={$forum['id']}&id={$forumTheme['id']}"; // считаем количество записей $sth = $pdo->prepare(' select count(*) as total from articl where id_parent='.($forumTheme['id']).' '); $sth->execute(); $total = $sth->fetch()['total']; $total = ceil($total / 20); for ($i = 2; $i <= $total; $i++) { $links[] = "https://www.infoorel.ru/forum/forum_read.php?f={$forum['id']}&id={$forumTheme['id']}&ofs=".(($i - 1) * 20)."&page={$i}"; } } } $forumFileIndex = 1; $createNewFile = true; $i = 0; foreach ($links as $key => $link) { if ($createNewFile == true) { $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); $createNewFile = false; } $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('daily')); $priority->appendChild($xml->createTextNode('1')); $i = $i + 1; if ($i >= 45000) { $i = 0; $createNewFile = true; $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/infoorel_forum_'.$forumFileIndex.'.xml', $xml->saveHTML()); $forumFileIndex = $forumFileIndex + 1; } else { if (count($links) == $key + 1) { $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/infoorel_forum_'.$forumFileIndex.'.xml', $xml->saveHTML()); } } } /** * ===================================================================================================================== * ================================================== Работа в орле ==================================================== * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/job/all.php?id=30291 */ $sth = $pdo->prepare(' SELECT id, data FROM job WHERE status = 3 ORDER BY id DESC '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $job) { $link = "https://www.infoorel.ru/job/all.php?id={$job['id']}"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d', strtotime($job['data'])))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/job.xml', $xml->saveHTML()); /** * ===================================================================================================================== * ================================================== Публикации ======================================================= * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/public/public_echo.php?id=2 * https://www.infoorel.ru/public/public.php?id_razdel=1&id_pr=65 */ $sth = $pdo->prepare(' SELECT id, data FROM `public` where status = 3 and id_razdel <> 238 ORDER BY id DESC '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $public) { $link = "https://www.infoorel.ru/public/public_echo.php?id={$public['id']}"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d', strtotime($public['data'])))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } // разделы публикаций $sth = $pdo->prepare(' SELECT id, id_parent FROM public_razdel WHERE id_razdel <> 238 ORDER BY id DESC '); $sth->execute(); foreach ($sth->fetchAll() as $publicRazdel) { if ($publicRazdel['id_parent'] == 0) { $link = "https://www.infoorel.ru/public/public.php?id_razdel={$publicRazdel['id']}"; } else { $link = "https://www.infoorel.ru/public/public.php?id_razdel={$publicRazdel['id_parent']}&id_pr={$publicRazdel['id']}"; } $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/publics.xml', $xml->saveHTML()); // раздел лайф $sth = $pdo->prepare(' SELECT id, data, url FROM `public` where status = 3 and id_razdel = 238 ORDER BY id DESC '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); $link = "https://www.infoorel.ru/life/"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); foreach ($sth->fetchAll() as $public) { $link = "https://www.infoorel.ru/life/{$public['url']}"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d', strtotime($public['data'])))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/life.xml', $xml->saveHTML()); /** * ===================================================================================================================== * ==============================================Отрасли области ======================================================= * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/oblast/otrasl.php?parent=0&id_otrasl=99 */ $sth = $pdo->prepare(' SELECT id, id_parent FROM oblast_otrasl '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $otrasl) { $link = "https://www.infoorel.ru/oblast/otrasl.php?parent={$otrasl['id_parent']}&id_otrasl={$otrasl['id']}"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/oblast_otrasl.xml', $xml->saveHTML()); /** * ===================================================================================================================== * ==============================================Фирмы области ======================================================= * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/oblast/firma.php?type=otrasl&id=4036 */ $sth = $pdo->prepare(' SELECT id FROM oblast_firma '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $firma) { $link = "https://www.infoorel.ru/oblast/firma.php?type=otrasl&id={$firma['id']}"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/oblast_firma.xml', $xml->saveHTML()); /** * ===================================================================================================================== * ============================================== Недвижимость в орле ================================================== * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/realty/realty_echo.php?id=441127 */ $sth = $pdo->prepare(' SELECT id, data FROM realty '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $realty) { $link = "https://www.infoorel.ru/realty/realty_echo.php?id={$realty['id']}"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d', strtotime($realty['data'])))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/realty.xml', $xml->saveHTML()); /** * ===================================================================================================================== * ============================================== Консультации специалистов ============================================ * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/konsult/kons_echo.php?id_razdel=1 */ $sth = $pdo->prepare(' SELECT id FROM faq_razdel '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $faqRazdel) { // // Считаем, сколько записей в разделе. // $totalPerPage = 10; $sth = $pdo->prepare(' SELECT COUNT(id) as total FROM faq WHERE id_razdel = '.$faqRazdel['id'].' and status = 3 '); $sth->execute(); $totalAnswers = $sth->fetch()['total']; $pages = ceil($totalAnswers / $totalPerPage); for ($i = 1; $i <= $pages; $i++) { if ($i == 1) { $link = "https://www.infoorel.ru/konsult/kons_echo.php?id_razdel={$faqRazdel['id']}"; } else { $link = "https://www.infoorel.ru/konsult/kons_echo.php?id_razdel={$faqRazdel['id']}&page={$i}"; } $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/konsult.xml', $xml->saveHTML()); /** * ===================================================================================================================== * ============================================== Фотоконкурсы ========================================================= * ===================================================================================================================== * * Пример такой ссылки: * https://www.infoorel.ru/realty/realty_echo.php?id=441127 */ $sth = $pdo->prepare(' SELECT id, data FROM miss '); $sth->execute(); $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('urlset')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); foreach ($sth->fetchAll() as $fotoKonkurs) { $link = "https://www.infoorel.ru/konkurs/konkurs.php?id_konkurs={$fotoKonkurs['id']}"; $url = $urlset->appendChild($xml->createElement('url')); $loc = $url->appendChild($xml->createElement('loc')); $lastmod = $url->appendChild($xml->createElement('lastmod')); $changefreq = $url->appendChild($xml->createElement('changefreq')); $priority = $url->appendChild($xml->createElement('priority')); $loc->appendChild($xml->createTextNode($link)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d', strtotime($fotoKonkurs['data'])))); $changefreq->appendChild($xml->createTextNode('weekly')); $priority->appendChild($xml->createTextNode('1')); } $xml->formatOutput = true; file_put_contents(__DIR__ .'/sitemaps/konkurs.xml', $xml->saveHTML()); /** * Создаем один файл индекс */ // создаем файл индекс $xml = new \DomDocument('1.0','utf-8'); $urlset = $xml->appendChild($xml->createElement('sitemapindex')); $urlset->setAttribute('xmlns','http://www.sitemaps.org/schemas/sitemap/0.9'); $files = scandir(__DIR__ .'/sitemaps/'); foreach ($files as $file) { if ($file == '.' || $file == '..' || $file == 'infoorel_sitemap_generated.xml' || $file == 'infoorel_google_news.xml') { continue; } $sitemap = $urlset->appendChild($xml->createElement('sitemap')); $loc = $sitemap->appendChild($xml->createElement('loc')); $lastmod = $sitemap->appendChild($xml->createElement('lastmod')); $loc->appendChild($xml->createTextNode('https://infoorel.ru/sitemaps/'.$file)); $lastmod->appendChild($xml->createTextNode(date('Y-m-d'))); } $xml->formatOutput = true; file_put_contents(__DIR__ . '/sitemaps/infoorel_sitemap_generated.xml', $xml->saveHTML());
/
..
2026-10-02
.well-known
2022-05-24
0419be9f6cf559b70d22f61f9fc82f38
2013-06-02
FirmClasses
2015-12-22
PHPMailer
2014-06-23
adadurov
2013-04-27
admin
2026-10-02
afisha
2023-12-27
ajax
2018-07-13
api
2018-01-23
app
2026-10-01
auth
2016-12-20
banner
2020-08-31
bootstrap
2019-02-07
busines
2020-01-15
captcha
2013-04-27
chat
2013-04-27
cron
2026-10-02
css
2019-12-13
error
2013-04-27
feedback
2017-01-27
filechange
2017-06-02
firma
2020-04-06
fonts
2020-04-06
forum
2026-10-01
fotogal
2019-04-15
friends
2017-02-13
fstat
2026-10-02
horoscop
2016-02-15
iframe_banners
2023-11-01
images
2023-12-26
img
2024-09-23
imgprivat
2013-04-27
inc
2026-10-01
job
2023-12-21
js
2019-02-14
kcaptcha
2015-12-30
klient
2018-10-18
konkurs
2016-04-14
konsult
2016-02-15
less
2015-09-25
lib
2013-04-27
library
2010-05-05
life
2024-01-25
maps
2017-11-10
news
2024-04-27
oblast
2017-02-02
partners
2018-05-08
photo_loop
2016-03-01
php_sess
2016-12-23
plugins
2016-02-17
pogoda
2026-10-02
politics
2026-05-25
private
2026-10-01
public
2013-04-27
realty
2017-03-15
realty2
2016-04-11
realty_old
2016-05-05
restoran
2017-07-13
saplnk
2018-10-15
scripts
2013-04-27
search
2019-03-04
sitemaps
2024-09-20
stat
2016-03-01
task
2017-02-14
temp
2015-04-04
template
2016-11-18
tests
2020-02-11
user
2017-08-17
user_file
2020-03-10
user_foto
2026-10-02
vendor
2020-02-07
vendor_old
2020-02-11
viktorina
2017-03-21
visitka
2020-02-26
widgets
2016-11-18
.ftpaccess
2025-04-01
322
.ftpaccess~
2024-10-07
323
.htaccess
2026-05-25
2 .
.htaccess~
2024-03-21
2 .
403.html
2011-08-08
532
404.php
2017-02-16
42
Class.firma.php
2015-12-22
2 .
SimpleImage.php
2016-02-18
43 .
_firma.php
2015-12-22
11 .
add_moder.php
2016-02-15
426
ajax.php
2016-01-18
3 .
app.js
2016-11-23
2 .
autoloader.php
2026-10-02
8 .
autoloader.php.bak_hostallow
2020-02-04
8 .
autoloader_back.php
2019-04-02
7 .
autoloader_cli.php
2020-02-07
4 .
ban_site.php
2017-02-17
787
banlist.php
2019-01-28
2 .
banner_klient.php
2017-03-20
14 .
banner_right.inc
2010-05-03
101
bridge.swf
2014-10-17
308
change_password_all.php
2022-04-11
1 .
change_password_all.php~
2020-03-05
930
check_iframe.php
2018-05-29
324
check_test.html
2018-06-08
467
class.upload.php
2015-11-02
267 .
click_b.php
2017-03-21
652
click_banner.php
2017-02-14
365
composer.json
2020-02-07
528
composer.lock
2020-02-07
46 .
config.inc.php
2026-10-02
9 .
config.inc.php.bak.cutover
2026-10-01
9 .
config.inc.php.bak_mysql_host_20261001213242
2026-10-01
9 .
config.inc.php.bak_mysql_host_20261001213307
2026-10-01
9 .
config.inc.php.bak_prod_urls
2024-01-09
9 .
config.inc.php~
2022-03-03
9 .
config_lang.php
2016-11-18
195
confirm.php
2016-12-23
503
confirm_wait.php
2019-05-07
3 .
count.php
2017-03-01
6 .
custom_user_login.php
2021-09-08
362
da4020760cc057069ee2048b32378410.flv
2016-03-23
19443 .
example.php
2016-03-21
32 .
favicon.ico
2006-05-11
1 .
fb.php
2015-12-14
2 .
fb_reg.php
2015-12-14
3 .
firm_indexator.php
2017-08-18
303
firma.php
2024-08-23
5 .
firma.php~
2020-04-10
5 .
firma_back.php
2019-04-03
5 .
forma_firm.php
2026-05-25
11 .
forma_firm.php~
2023-11-10
11 .
forum_reindex.php
2017-09-12
245
func.php
2026-10-02
286 .
func.php.bak.authorize_20261002
2026-10-02
286 .
func.php.bak.pagination_20261002
2026-10-02
286 .
func.php.bak.setnames_20261002
2022-03-03
286 .
func.php~
2021-03-15
286 .
func_new.php
2019-08-08
12 .
go_to_site.php
2017-03-24
674
google3734f948a59c1f00.html
2017-10-10
53
index.php
2026-01-14
13 .
index.php~
2024-03-14
12 .
index1.html
2015-09-25
70 .
index2.html
2023-11-14
62 .
index2.html~
2023-05-11
62 .
index_back.php
2023-11-14
14 .
index_back.php~
2023-09-13
14 .
index_old.php
2018-07-11
6 .
industry.php
2026-05-25
14 .
industry.php~
2021-01-14
15 .
industry_03.02.php
2017-02-07
2 .
ins_user.php
2015-12-18
15 .
katalog_firm.php
2023-12-22
3 .
katalog_firm.php~
2019-03-17
3 .
katalog_firm_new.php
2018-01-16
3 .
katalog_firm_old.php
2016-04-11
3 .
katalog_search.php
2016-01-21
9 .
katalog_tovar.php
2015-11-09
6 .
live-597cb0d9.txt
2018-05-15
22
logout.php
2015-12-14
1 .
mailsock.php
2012-12-18
3 .
md5ttt.php
2017-03-07
56
mechta.jpg
2020-09-04
121 .
modifier.length.php
2015-12-23
745
modifier.length.php~
2026-07-24
745
news.rss
2026-10-02
72 .
news.rss~
2026-09-12
97 .
oauth_user_confirm.php
2017-07-03
762
odkl.php
2015-12-08
2 .
odkl_reg.php
2015-12-14
3 .
otrasl.php
2017-02-07
452
out_password.php
2015-12-14
4 .
password.php
2015-12-15
3 .
phpunit.xml.dist
2020-02-11
386
politics.php
2026-05-25
621
products.php
2020-04-28
2 .
quote_test.php
2017-02-17
636
realdb.php
2016-12-29
108
register_finish.php
2017-07-05
3 .
registration.php
2026-05-25
5 .
registration.php~
2015-12-10
5 .
registrationfb.php
2015-12-14
4 .
registrationok.php
2015-12-14
4 .
registrationvk.php
2015-12-11
4 .
restoran_indexator.php
2017-08-01
997
robots.txt
2026-10-02
2 .
robots.txt.bak_prod
2026-01-14
2 .
robots.txt.stand_noindex
2026-10-02
88
robots.txt~
2024-10-21
2 .
schet.png
2017-03-01
686
schetchik.inc
2019-04-18
441
search.php
2019-04-01
40 .
search_back.php
2019-03-20
39 .
sitemap_generator.php
2024-10-21
34 .
sitemap_generator.php~
2024-01-25
34 .
smtpEmailValidation.php
2015-12-09
7 .
ta.php
2015-12-11
2 .
ta_reg.php
2015-12-14
3 .
test.php
2020-04-06
67 .
user_form.inc.php
2012-05-28
11 .
user_info.php
2017-09-04
1 .
view_b.php
2014-06-16
2 .
view_banner.php
2009-10-26
820
vote_frame.php
2019-03-21
7 .
vote_frame_back.php
2017-08-17
7 .
watermark.php
2014-08-19
1015
yandex_60dbd5831b8ec85b.html
2019-04-25
161
yandex_60dbd5831b8ec85b.html~
2026-07-24
161
yb.php
2016-03-09
2 .
yesno.php
2014-01-17
1 .
Политика конфиденциальности.docx
2024-08-30
25 .
Политика конфиденциальности.docx~
2024-02-15
20 .
Согласие_на_обработку_персональных_данных_с_помощью_сервиса_«Яндекс.docx
2025-04-01
18 .
1
2
3
..
