КиноАрхив - KinoArchive - страница 20 - Галереи

function utf8_to_win1251($text) {
	/*if (ord($text) > 192) {
		$str = $text;
	} else {*/
		if (function_exists('iconv')) {
			$str = iconv('UTF-8', 'windows-1251//IGNORE', $text);
		} else {
			$str = strtr($text, array("Р°"=>"а","Р±"=>"б","РІ"=>"в","Рі"=>"г","Рґ"=>"д","Рµ"=>"е","С‘"=>"ё","Р¶"=>"ж","Р·"=>"з","Рё"=>"и","Р№"=>"й","Рє"=>"к","Р»"=>"л","Рј"=>"м","РЅ"=>"н","Рѕ"=>"о","Рї"=>"п","СЂ"=>"р","СЃ"=>"с","С‚"=>"т","Сѓ"=>"у","С„"=>"ф","С…"=>"х","С†"=>"ц","С‡"=>"ч","С?"=>"ш","С‰"=>"щ","СЉ"=>"ъ","С‹"=>"ы","СЊ"=>"ь","СЌ"=>"э","СЋ"=>"ю","СЏ"=>"я","Рђ"=>"А","Р‘"=>"Б","Р’"=>"В","Р“"=>"Г","Р”"=>"Д","Р•"=>"Е","РЃ"=>"Ё","Р–"=>"Ж","Р—"=>"З","Р?"=>"И","Р™"=>"Й","Рљ"=>"К","Р›"=>"Л","Рњ"=>"М","Рќ"=>"Н","Рћ"=>"О","Рџ"=>"П","Р "=>"Р","РЎ"=>"С","Рў"=>"Т","РЈ"=>"У","Р¤"=>"Ф","РҐ"=>"Х","Р¦"=>"Ц","Р§"=>"Ч","РЁ"=>"Ш","Р©"=>"Щ","РЄ"=>"Ъ","Р«"=>"Ы","Р¬"=>"Ь","Р­"=>"Э","Р®"=>"Ю","С–"=>"і","Р†"=>"І","С—"=>"ї","Р‡"=>"Ї","С”"=>"є","Р„"=>"Є","Т‘"=>"ґ","Тђ"=>"Ґ",));
		}
	//}
	return $str;
}

function utf8_to_win1251($text) {
	if (ord($text) > 192) {
		$str = $text;
	} else {
		if (function_exists('iconv')) {
			$str = iconv('UTF-8', 'windows-1251//IGNORE', $text);
		} else {
			$str = strtr($text, array("Р°"=>"а","Р±"=>"б","РІ"=>"в","Рі"=>"г","Рґ"=>"д","Рµ"=>"е","С‘"=>"ё","Р¶"=>"ж","Р·"=>"з","Рё"=>"и","Р№"=>"й","Рє"=>"к","Р»"=>"л","Рј"=>"м","РЅ"=>"н","Рѕ"=>"о","Рї"=>"п","СЂ"=>"р","СЃ"=>"с","С‚"=>"т","Сѓ"=>"у","С„"=>"ф","С…"=>"х","С†"=>"ц","С‡"=>"ч","С?"=>"ш","С‰"=>"щ","СЉ"=>"ъ","С‹"=>"ы","СЊ"=>"ь","СЌ"=>"э","СЋ"=>"ю","СЏ"=>"я","Рђ"=>"А","Р‘"=>"Б","Р’"=>"В","Р“"=>"Г","Р”"=>"Д","Р•"=>"Е","РЃ"=>"Ё","Р–"=>"Ж","Р—"=>"З","Р?"=>"И","Р™"=>"Й","Рљ"=>"К","Р›"=>"Л","Рњ"=>"М","Рќ"=>"Н","Рћ"=>"О","Рџ"=>"П","Р "=>"Р","РЎ"=>"С","Рў"=>"Т","РЈ"=>"У","Р¤"=>"Ф","РҐ"=>"Х","Р¦"=>"Ц","Р§"=>"Ч","РЁ"=>"Ш","Р©"=>"Щ","РЄ"=>"Ъ","Р«"=>"Ы","Р¬"=>"Ь","Р­"=>"Э","Р®"=>"Ю","С–"=>"і","Р†"=>"І","С—"=>"ї","Р‡"=>"Ї","С”"=>"є","Р„"=>"Є","Т‘"=>"ґ","Тђ"=>"Ґ",));
		}
	}
	return $str;
}

error_reporting(E_ALL);

error_reporting(E_NONE);

if ( $itemid == 0 || $itemid == 99999999 ) {
	// security check to see if link exists in a menu

	$link = 'index.php?option=com_kinoarhiv';
	$database->setQuery( "SELECT `id` FROM `#__menu` WHERE (`link` LIKE '%$link' OR `link` LIKE '%$link&%') AND `published` = 1" );
	$exists = $database->loadResult();
	if ( !$exists ) {
		mosNotAuth();
		return;
	}
} else {
	// security check to see if link published in a menu

	$link = 'index.php?option=com_kinoarhiv';
	$database->setQuery( "SELECT `published` FROM `#__menu` WHERE (`link` LIKE '%$link' OR `link` LIKE '%$link&%') AND `published` = 1" );
	$published = $database->loadResult();
	if ( !$published ) {
		mosNotAuth();
		return;
	}
}

echo $query;

SELECT * FROM afisha WHERE ( start_show = '0000-00-00 00:00:00' OR start_show >= '2010-07-18 19:21:18' ) AND published = 1 ORDER BY start_show ASC 

SELECT * FROM afisha WHERE start_show >= '2010-07-18 19:23:50' AND published = 1 ORDER BY start_show ASC