| 09.06.26, 06:23 | |
| if ($row["img"]) { ?> |
if ($_GET["mode"] != "archive") { ?>Архив новостей } else { ?>Выбор даты } ?>
if (!$archyear) { $archyear = date("Y"); } if (!$archmonth and $_GET["mode"] == "archive") { $archmonth = date("n"); } $months=array("","Янв","Фев","Мар","Апр","Май","Июн","Июл","Авг","Сен","Окт","Ноя","Дек"); $query = "select (select id from news where date > ".mktime(-1,0,0,1,1,$archyear)." and date < ".mktime(0,0,0,2,1,$archyear)." limit 0,1) as mth1, (select id from news where date > ".mktime(0,0,-1,2,1,$archyear)." and date < ".mktime(0,0,0,3,1,$archyear)." limit 0,1) as mth2, (select id from news where date > ".mktime(0,0,-1,3,1,$archyear)." and date < ".mktime(0,0,0,4,1,$archyear)." limit 0,1) as mth3, (select id from news where date > ".mktime(0,0,-1,4,1,$archyear)." and date < ".mktime(0,0,0,5,1,$archyear)." limit 0,1) as mth4, (select id from news where date > ".mktime(0,0,-1,5,1,$archyear)." and date < ".mktime(0,0,0,6,1,$archyear)." limit 0,1) as mth5, (select id from news where date > ".mktime(0,0,-1,6,1,$archyear)." and date < ".mktime(0,0,0,7,1,$archyear)." limit 0,1) as mth6, (select id from news where date > ".mktime(0,0,-1,7,1,$archyear)." and date < ".mktime(0,0,0,8,1,$archyear)." limit 0,1) as mth7, (select id from news where date > ".mktime(0,0,-1,8,1,$archyear)." and date < ".mktime(0,0,0,9,1,$archyear)." limit 0,1) as mth8, (select id from news where date > ".mktime(0,0,-1,9,1,$archyear)." and date < ".mktime(0,0,0,10,1,$archyear)." limit 0,1) as mth9, (select id from news where date > ".mktime(0,0,-1,10,1,$archyear)." and date < ".mktime(0,0,0,11,1,$archyear)." limit 0,1) as mth10,(select id from news where date > ".mktime(0,0,-1,11,1,$archyear)." and date < ".mktime(0,0,0,12,1,$archyear)." limit 0,1) as mth11, (select id from news where date > ".mktime(0,0,-1,12,1,$archyear)." and date < ".mktime(0,0,0,1,1,$archyear+1)." limit 0,1) as mth12 from news"; $result = mysql_query($query); $row = mysql_fetch_array($result); for ($i=1;$i<13;$i++) { if ($row["mth".$i] and $i != $archmonth) { ?> } else if ($archmonth == $i) { ?> } else { ?> } if ($i != 12) { ?> | } } ?>
if ($archyear == date("Y")) { $starto=2; $query = "select (select id from news where date < ".mktime(0,0,0,1,1,$archyear-2)." limit 0,1) as year1, (select id from news where date > ".mktime(0,0,-1,1,1,$archyear-2)." and date < ".mktime(0,0,0,1,1,$archyear-1)." limit 0,1) as year2, (select id from news where date > ".mktime(0,0,-1,1,1,$archyear-1)." and date < ".mktime(0,0,0,1,1,$archyear)." limit 0,1) as year3 from news"; } else { $starto=1; $query = "select (select id from news where date < ".mktime(0,0,0,1,1,$archyear-1)." limit 0,1) as year1, (select id from news where date > ".mktime(0,0,-1,1,1,$archyear-1)." and date < ".mktime(0,0,0,1,1,$archyear)." limit 0,1) as year2, (select id from news where date > ".mktime(0,0,-1,1,1,$archyear+1)." and date < ".mktime(0,0,0,1,1,$archyear+2)." limit 0,1) as year3, (select id from news where date > ".mktime(0,0,-1,1,1,$archyear+2)." limit 0,1) as year4 from news"; } $result = mysql_query($query); $row = mysql_fetch_array($result); if ($row["year1"]) { ?><< } else { ?><< } if ($row["year2"]) { ?>0 | } else { ?>0 | } if ($row["year3"] and $archyear == date("Y")) { ?>1 | } else if ($archyear != date("Y")) { ?>1 | } else { ?>1 | } if ($row["year3"] and $archyear != date("Y")) { ?>2 | } else if ($archyear == date("Y")) { ?>2 } else { ?>2 } if ($row["year1"]) { ?>>> } else { ?>>> } $query = "select * from news where date > $starttime and date < $endtime order by date"; ?>