>
>
>
>
>
>
afisha_utf.php
<?php $base_url="../"; require $base_url."func.php"; //$row = sqlval("SELECT UNIX_TIMESTAMP(`data`) AS `date` FROM `bb_data` WHERE status='3' or status='4' ORDER BY `data` DESC LIMIT 0, 1"); $lastBuildDate = date( 'r', mktime(date("H")-1, 0, 0, date("m") , date("d"), date("Y")) ); $year = date( 'Y' ); $l = db_connect_afisha(); /* $row = sqlval("SELECT c.id, a.name, a.note_small, a.image, a.image_big, b.name as gname, c.id_org, date_format(c.date_ot,'%d') as data, date_format(c.date_do,'%d') as data_do,date_format(date_ot,'%m') as month,date_format(date_do,'%m') as month_do, c.begin, c.price, d.name as org_name FROM infostrana.afisha_event a, infostrana.afisha_groups b, infoorel.afisha_new c, infoorel.firma d WHERE ( c.date_ot<=CURDATE() and c.date_do>=CURDATE() ) AND a.id_grp=b.id AND a.id=c.id_activity AND c.id_org=d.id AND a.image<>'' AND b.id='5' ORDER BY RAND() LIMIT 0, 1"); $rows[5] = $row; $row = sqlval("SELECT c.id, a.name, a.note_small, a.image, a.image_big, b.name as gname, c.id_org, date_format(c.date_ot,'%d') as data, date_format(c.date_do,'%d') as data_do,date_format(date_ot,'%m') as month,date_format(date_do,'%m') as month_do, c.begin, c.price, d.name as org_name FROM infostrana.afisha_event a, infostrana.afisha_groups b, infoorel.afisha_new c, infoorel.firma d WHERE ( c.date_ot<=CURDATE() and c.date_do>=CURDATE() ) AND a.id_grp=b.id AND a.id=c.id_activity AND c.id_org=d.id AND a.image<>'' AND b.id='2' ORDER BY RAND() LIMIT 0, 1"); $rows[2] = $row; $row = sqlval("SELECT c.id, a.name, a.note_small, a.image, a.image_big, b.name as gname, c.id_org, date_format(c.date_ot,'%d') as data, date_format(c.date_do,'%d') as data_do,date_format(date_ot,'%m') as month,date_format(date_do,'%m') as month_do, c.begin, c.price, d.name as org_name FROM infostrana.afisha_event a, infostrana.afisha_groups b, infoorel.afisha_new c, infoorel.firma d WHERE ( c.date_ot<=CURDATE() and c.date_do>=CURDATE() ) AND a.id_grp=b.id AND a.id=c.id_activity AND c.id_org=d.id AND a.image<>'' AND b.id='7' ORDER BY RAND() LIMIT 0, 1"); $rows[7] = $row; $row = sqlval("SELECT c.id, a.name, a.note_small, a.image, a.image_big, b.name as gname, c.id_org, date_format(c.date_ot,'%d') as data, date_format(c.date_do,'%d') as data_do,date_format(date_ot,'%m') as month,date_format(date_do,'%m') as month_do, c.begin, c.price, d.name as org_name FROM infostrana.afisha_event a, infostrana.afisha_groups b, infoorel.afisha_new c, infoorel.firma d WHERE ( c.date_ot<=CURDATE() and c.date_do>=CURDATE() ) AND a.id_grp=b.id AND a.id=c.id_activity AND c.id_org=d.id AND a.image<>'' AND b.id='1' ORDER BY RAND() LIMIT 0, 1"); $rows[1] = $row; $row = sqlval("SELECT c.id, a.name, a.note_small, a.image, a.image_big, b.name as gname, c.id_org, date_format(c.date_ot,'%d') as data, date_format(c.date_do,'%d') as data_do,date_format(date_ot,'%m') as month,date_format(date_do,'%m') as month_do, c.begin, c.price, d.name as org_name FROM infostrana.afisha_event a, infostrana.afisha_groups b, infoorel.afisha_new c, infoorel.firma d WHERE ( c.date_ot<=CURDATE() and c.date_do>=CURDATE() ) AND a.id_grp=b.id AND a.id=c.id_activity AND c.id_org=d.id AND a.image<>'' AND b.id='6' ORDER BY RAND() LIMIT 0, 1"); $rows[6] = $row; */ $rows = sql("SELECT distinct a.id as id, a.name, a.note_small FROM infostrana.afisha_event a, infostrana.afisha_groups b, infoorel.afisha_new c, infoorel.firma d WHERE ( CURDATE( ) between c.date_ot AND c.date_do ) AND a.id_grp = b.id AND a.id = c.id_activity AND c.id_org = d.id AND a.image <> '' ORDER BY RAND() LIMIT 0 , 5"); header("Expires: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT"); header("Cache-Control: no-store, no-cache, must-revalidate"); header("Cache-Control: post-check=0, pre-check=0", false); header("Pragma: no-cache"); header( "Content-type: text/xml" ); $xmlstr = <<<XML <?xml version="1.0" encoding="UTF-8"?> <rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" xml:base="http://www.feedreader.com"> <channel> <title>Афиша г. Орел :: Последние мероприятия</title> <link>{$abs_url}forum</link> <description></description> <language>ru</language> <atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" href="http://feeds.feedburner.com/feedreadernews" type="application/rss+xml" /> <copyright>Copyright 2006-{$year} ООО Инфо-Сити</copyright> <lastBuildDate>{$lastBuildDate}</lastBuildDate> <image> <url>{$abs_url}logo.gif</url> <title>Афиша г. Орел</title> <link>{$abs_url}afisha/</link> </image> XML; while ($row=sqlget($rows)) { if ($row['id'] != '' ) { ( $row['uname'] == '' ) ? $author = 'www.infoorel.ru' : $author = $row['uname']; $pub_date = date('r'); $title = iconv("WINDOWS-1251", "UTF-8", htmlspecialchars( $row['name'], NULL,""));// . '. ' . $row['org_name'] )); $row['note_small'] = htmlspecialchars( strip_tags( $row['note_small'] ), NULL,"" ); $pos = strpos($row['note_small'], ' ', 100); if ( $pos === false ) { $description = iconv("WINDOWS-1251", "UTF-8",substr($row['note_small'], 0 )); } else { $description = iconv("WINDOWS-1251", "UTF-8",substr($row['note_small'], 0, $pos)); } $author = iconv("WINDOWS-1251", "UTF-8", $author); $xmlstr .= <<<XML <item> <title>{$title}</title> <description>{$description}</description> <dc:creator>{$author}</dc:creator> <link>{$abs_url}afisha/index.php?id={$row['id']}</link> <pubDate>{$pub_date}</pubDate> </item> XML; } } $xmlstr .= <<<XML </channel> </rss> XML; echo $xmlstr; ?>
/afisha/
..
2026-10-02
a__ball.png
2019-01-23
1 .
a__cinema.png
2019-01-23
1 .
a__disco.png
2019-01-23
1 .
a__gitar.png
2019-01-23
1 .
a__helicopter.png
2019-01-23
1 .
a__holiday.png
2019-01-23
1 .
a__masterclass.png
2019-01-23
1 .
a__picture.png
2019-01-23
1 .
a__theater.png
2019-01-23
1 .
a__tribune.png
2019-01-23
1 .
afisha.php
1970-01-01
afisha_utf.php
2015-09-29
6 .
bootstrap-grid.css
2019-01-23
44 .
bootstrap.css
2019-01-23
48 .
index.php
2023-12-27
7 .
index.php~
2023-11-15
7 .
index1.php
2012-10-31
12 .
index_new.php
2023-11-15
35 .
index_new.php~
2020-01-17
35 .
theme.css
2019-01-23
5 .
view.php
2023-12-21
4 .
view.php~
2020-09-15
3 .
/afisha
1
2
3
..
