";
};
};
$i=0;
$aSQL = "SELECT CONCAT(AllUrlInSity,path) AS fullpath,DATE_FORMAT(date, '%d.%m.%Y') AS date_pub,DATE_FORMAT(date, '%d%m') AS date_cal,CONCAT(IFNULL(NameRus,''),' ',SurNameRus) AS fullname, title, AllUrlInSity FROM news JOIN persons ON news.KodPersons=persons.Persons_id WHERE news.date ='$date_calendar' ORDER BY RAND() LIMIT 3";
$result = $my->get_link()->query($aSQL);
while($row = $result->fetch_array()){
$date_cal=$row['date_cal'];
if ($i==0) { $text.= "
$prevlink страница $page из $pages, показывается $start - $end из $count $nextlink
";
// $listofpages="
$listofpages
\n";
$text=$listofpages;
$aSQL = "SELECT id,CONCAT(LEFT(event_txt,200),'...') AS article,LEFT(event_txt,100) AS title,DATE_FORMAT(date_calendar, '%d.%m') AS date_pub,DATE_FORMAT(date_calendar, '%d%m') AS date_cal,DATE_FORMAT(date_calendar, '%Y') AS date_year FROM Calendar_Event WHERE do_n_ery=0 AND date_calendar < CURDATE() ORDER BY date_calendar DESC LIMIT $onpage OFFSET $offset";
$result = $my->get_link()->query($aSQL);
while($row = $result->fetch_array()){
$date_cal=$row['date_cal'];
$date_year=$row['date_year'];
$link="".$row['date_pub'].".$date_year";
if ($i==0) { $text.= "