"; include_once('startup.php'); // Установка параметров, подключение к БД, запуск сессии. startup(); //прооверяем, что мы админ include('variables.php'); ?> "; ?>





Добавление дат
Добавление правителей
Перепись событий
Добавление тем в группе дат
Режим бота
Режим пользователя
Грабить новости
Выйти

format('d-m-Y'); $newtime = $time->modify('-1 week')->format('d-m-Y'); $Date_b = $newtime; //$Date_e = date("d-m-Y"); $_SESSION['Date_b'] = $Date_b; $_SESSION['Date_e'] = $Date_e; echo "Новости за '11ne неделю с ".$_SESSION['Date_b']." по ".$_SESSION['Date_e']; } */ /* if(isset($_GET['ThisWeek'])){ //значит показываем новости на этой неделе //ThisWeek&scale=10 echo "Новости за неделю"; $_SESSION['NewsUsage'] = 1; $time = new DateTime('now'); $newtime = $time->modify('-1 week')->format('d-m-Y'); $Date_b = $newtime; $Date_e = date("d-m-Y"); $_SESSION['Date_b'] = $Date_b; $_SESSION['Date_e'] = $Date_e; } */ $onlyNews = 0; //только новости //echo "onlyNews-".$_GET['onlyNews']."
"; if(isset($_SESSION['onlyNews'])){ $onlyNews = $_SESSION['onlyNews']; } if(isset($_GET['onlyNews'])){ //echo "onlyNews-".$_GET['onlyNews']; if($_GET['onlyNews']=='1'){ // echo "ON"; EraseSession(); $onlyNews = $_SESSION['onlyNews']='1'; //выставляем день от сегодня $time = new DateTime('now'); $newtime = $time->modify('-1 week')->format('d-m-Y'); $Date_b =$_SESSION['Date_b'] = $newtime; $Date_e = $_SESSION['Date_e'] = date("d-m-Y"); }else{ // echo "NOON"; $onlyNews = $_SESSION['onlyNews']='0'; } } //echo "onlyNews-".$onlyNews; if(isset($_GET['dBEnd'])){//если перешли по сайт мапу $dBEnd= mysql_real_escape_string($_GET['dBEnd']); $dd = explode("|",$dBEnd); if(count($dd)>1){ }else{die("косяк с датами!");} //echo $_GET['dBEnd']; $MonthArr = array('','янв','фев','мар','апр','май','июн','июл','авг','сен','окт','ноя','дек'); $ddB = explode("-",$dd[0]); $ddB1 = $ddB[2]."-".$ddB[1]."-".$ddB[0]; $ddTiB = ''; if($ddB[2] !='00'){$ddTiB.=$ddB[2]." ";} if($ddB[1] !='00'){$ddTiB.=$MonthArr[(int)$ddB[1]]." ";} if($ddB[0] !='0000'){$ddTiB.=$ddB[0];} $ddE = explode("-",$dd[1]); $ddE1 = $ddE[2]."-".$ddE[1]."-".$ddE[0]; $ddTiE = ''; if($ddE[2] !='00'){$ddTiE.=$ddE[2]." ";} if($ddE[1] !='00'){$ddTiE.=$MonthArr[(int)$ddE[1]]." ";} if($ddE[0] !='0000'){$ddTiE.=$ddE[0];} $Date_b = $_SESSION['Date_b'] = $ddB1; $Date_e = $_SESSION['Date_e'] = $ddE1; //echo "Date_b -".$Date_b." Date_e-".$Date_e; //делаем титульник if($ddTiB !=''){$ddTiB = "c ".$ddTiB." года"; } if($ddTiE !=''){$ddTiB .= " по ".$ddTiE." год"; } if($ddTiB !=''){ $titleStr = "Все основные даты и события в истории в период ".$ddTiB; } $_SESSION['id_theme'] = null; } if(isset($_GET['id_theme'])){//номер темы событий $onlyNews = $_SESSION['onlyNews']='0'; $_GET['id_theme']= mysql_real_escape_string($_GET['id_theme']); $_SESSION['id_theme'] = $_GET['id_theme']; $_SESSION['KeyWords'] = ''; } if(isset($_GET['WeekFrom'])){ //значит показываем новости за неделе с указаной даты //ThisWeek&scale=10 //echo "Новости за неделю с "; //$_SESSION['NewsUsage'] = 1; $_GET['WeekFrom']= mysql_real_escape_string($_GET['WeekFrom']); $time = new DateTime($_GET['WeekFrom']); $timeN = $time->format('d-m-Y'); $newtime = $time->modify('+1 week')->format('d-m-Y'); $Date_b = $timeN; $Date_e = $newtime; $_SESSION['Date_b'] = $Date_b; $_SESSION['Date_e'] = $Date_e; echo "Новости за неделю с ".$Date_b." по ".$Date_e."
"; } if(isset($_POST['eraseFilter']) or isset($_GET['eraseFilter'])){ EraseSession(); } function EraseSession(){ $_SESSION['eventN'] = null; $_SESSION['id_theme'] = null; //выставляем один день год вперед $time = new DateTime($_GET['WeekFrom']); //$timeN = $time->format('d-m-Y'); $newtime = $time->modify('+1 year')->format('d-m-Y'); $_SESSION['Date_b'] = $newtime; $_SESSION['Date_e'] = $newtime; $Date_b = $newtime; $Date_e = $newtime; //$_SESSION['Date_b'] = null; //$_SESSION['Date_e'] = null; $_SESSION['KeyWords'] = null; $_SESSION['included'] = null; $_SESSION['DateNoInTheme'] = null; $_SESSION['onlyNews'] = '0'; } $id_theme = ''; //номер темы if(isset($_SESSION['id_theme'])){ $id_theme = $_SESSION['id_theme']; } /* if(isset($_POST['eventN'])){ $eventN = mysql_real_escape_string($_POST['eventN']); $_SESSION['eventN'] = $eventN; } */ //echo "eventN-".$eventN."
"; /* if($eventN !=''){ $arrNEv = explode('|',$eventN); $arrNEv = array_diff($arrNEv, array('')); $strIn = ''; $hArr = Array(); foreach($arrNEv as $evt){ $id_ev = sprintf("%d",$evt);//номер/ключ речи в новости if($id_ev){ $hArr[] = $id_ev;//7 } } //var_dump($hArr); if(count($hArr) >0){ $strIn = implode("','",$hArr); $strIn = "'".$strIn."'"; //echo "strIn-".$strIn."

"; } }*/ //дата начала и окончания $Date_b = ''; $Date_e = ''; if(isset($_SESSION['Date_b']) AND isset($_SESSION['Date_e'])){ $Date_b = $_SESSION['Date_b']; $Date_e = $_SESSION['Date_e']; } $KeyWords = ''; if(isset($_SESSION['KeyWords'])){ $KeyWords = $_SESSION['KeyWords']; } $included = 0; if($_POST['included']){ $_SESSION['included'] = 1; $included = $_POST['included']; //echo "here"; } //if(isset($_POST['included'])){ $DateNoInTheme = 0; if($_POST['DateNoInTheme']){ $_SESSION['DateNoInTheme'] = 1; $DateNoInTheme = $_POST['DateNoInTheme']; //echo "here"; } if($_POST['postback']){ //если это постбак то обнуляем if($_POST['included'] ==null){ $_SESSION['included'] = 0; $included = 0; //echo "here1"; } if($_POST['DateNoInTheme'] ==null){ $_SESSION['DateNoInTheme'] = 0; $DateNoInTheme = 0; //echo "here1"; } } //echo "_POST['included']-".$_POST['included']."
"; //var_dump($_POST['included']); if(isset($_SESSION['included'])){ $included = $_SESSION['included']; } if(isset($_SESSION['DateNoInTheme'])){ $DateNoInTheme = $_SESSION['DateNoInTheme']; } if(isset($_POST['DateBeg']) AND isset($_POST['DateEnd'])){ $Date_b = mysql_real_escape_string($_POST['DateBeg']); $Date_e = mysql_real_escape_string($_POST['DateEnd']); }elseif(isset($_GET['DateBeg']) AND isset($_GET['DateEnd'])){ $Date_b = mysql_real_escape_string($_GET['DateBeg']); $Date_e = mysql_real_escape_string($_GET['DateEnd']); } //http://localhost/socset/index.php?DateBeg=25-03-2014&DateEnd=25-12-2014&scale=12 if(isset($_POST['KeyWords'])){ $KeyWords = mysql_real_escape_string($_POST['KeyWords']); } if(($Date_b =='') OR ($Date_e =='')){//если время так и не определенно, то выбираем сами $time = new DateTime('now'); /* $newtime = $time->modify('-1 year')->format('d-m-Y'); $Date_b = $newtime; $Date_e = date("d-m-Y"); */ //ставим год вперед, чтобы ничего не показывалось $Date_b = $time->modify('+1 year')->format('d-m-Y'); $Date_e = $Date_b; // echo "
php Date_b-".$Date_b; // echo "
php Date_e-".$Date_e; } //все страны относяшиеся к теме $allCountryInTheme = array(); $whereDate = ''; if(($Date_b !='') AND ($Date_e !='')){ $_SESSION['Date_b'] = $Date_b; $_SESSION['Date_e'] = $Date_e; $arrBeg = explode("-",$Date_b); $DateBeg = $arrBeg[2]."-".$arrBeg[1]."-".$arrBeg[0]; $arrEnd = explode("-",$Date_e); $DateEnd = $arrEnd['2']."-".$arrEnd['1']."-".$arrEnd['0']; //$whereDate = " AND date_Beg >= STR_TO_DATE('".$DateBeg." 00:00:00', '%Y-%m-%d %H:%i:%s') AND date_End <= STR_TO_DATE('".$DateEnd." 23:59:59', '%Y-%m-%d %H:%i:%s')"; $whereDate = " AND date_Beg >= STR_TO_DATE('".$DateBeg." 00:00:00', '%Y-%m-%d %H:%i:%s') AND date_Beg <= STR_TO_DATE('".$DateEnd." 23:59:59', '%Y-%m-%d %H:%i:%s') AND date_End <= STR_TO_DATE('".$DateEnd." 23:59:59', '%Y-%m-%d %H:%i:%s')"; if($included){ $_SESSION['included'] = 1; //echo "included-".$_POST['included']; $whereDate = " AND (date_Beg BETWEEN STR_TO_DATE('".$DateBeg." 00:00:00', '%Y-%m-%d %H:%i:%s') AND STR_TO_DATE('".$DateEnd." 23:59:59', '%Y-%m-%d %H:%i:%s') OR date_End BETWEEN STR_TO_DATE('".$DateBeg." 00:00:00', '%Y-%m-%d %H:%i:%s') AND STR_TO_DATE('".$DateEnd." 23:59:59', '%Y-%m-%d %H:%i:%s') OR STR_TO_DATE('".$DateEnd." 23:59:59', '%Y-%m-%d %H:%i:%s') BETWEEN date_Beg AND date_End)"; } } $whereKeyWords = ''; if($KeyWords !=''){ //echo "gggggggggggggggggggggggggggggggggggggggggggggggggggggg1".$KeyWords."
"; $_SESSION['KeyWords'] = $KeyWords; $whereKeyWords = " AND event LIKE '%".$KeyWords."%' "; //echo "gggggggggggggggggggggggggggggggggggggggggggggggggggggg"; } $whereIdIn = ''; if($strIn !=''){ //echo "gggggggggggggggggggggggggggggggggggggggggggggggggggggg1".$KeyWords."
"; //$_SESSION['KeyWords'] = $KeyWords; $whereIdIn = " OR id in (".$strIn.") "; //echo "gggggggggggggggggggggggggggggggggggggggggggggggggggggg"; } /* echo "
Date_b-".$Date_b; echo "
Date_e-".$Date_e; echo "
";*/ /**/ $QueryTheme =''; //подключение новостей //echo "
2Date_b -".$Date_b." Date_e-".$Date_e." id_theme".$id_theme; //какой столбец вытаскиваем /* $eventNeed = ''; if($_SESSION['ISBot'] == 'no'){ $eventNeed = 'event'; }else{ $eventNeed = 'event_changed'; } */ //вытаскиваем все страны $CountryArr = array(); $query = "SELECT * FROM countrys "; $result = mysql_query($query) or die(mysql_error()); $n = mysql_num_rows($result); if($n >0){ for ($i = 0; $i < $n; $i++) { $row = mysql_fetch_assoc($result); $CountryArr[$row['id']] = $row['country']; //if($row['id'] ==$SpeechArr[0]['id_avtor']){ $titleStr = $row['Who']; } } } //вытаскиваем все категории $CategoryArr = array(); $query = "SELECT * FROM category "; $result = mysql_query($query) or die(mysql_error()); $n = mysql_num_rows($result); if($n >0){ for ($i = 0; $i < $n; $i++) { $row = mysql_fetch_assoc($result); $CategoryArr[$row['id']] = $row['category']; //if($row['id'] ==$SpeechArr[0]['id_avtor']){ $titleStr = $row['Who']; } } } //var_dump($CountryArr); $eventNeed = 'event, event_changed'; //где ищем, в новостях или истории $WhereSearch = 'Date_Of_Events'; $WhereSearchCountry = 'Date_vs_country'; if($onlyNews){ $WhereSearch = 'Date_of_News'; $WhereSearchCountry = 'Date_vs_countryN'; } if(($id_theme!='')){ //echo "rrrrrrrrrrrrrrrrrrrrr"; //вытаскиваем все события по теме $query = "SELECT * FROM Theme_of_Events WHERE id='$id_theme' ORDER BY id" ; $result = mysql_query($query) or die(mysql_error()); $n = mysql_num_rows($result); if($n >0){ $row = mysql_fetch_assoc($result); $ThemeGlob = $row['Theme']; $titleStr = "Все даты и события по теме: ".$row['Theme']; $textThema = $row['text']; $ids_events = explode("|",$row['ids_events']); if(count($ids_events)>0){ $ids_events = array_diff($ids_events, array('')); $strTh = implode("','",$ids_events); $strTh = "'".$strTh."'"; } //если стоит галочка - даты по теме, то находим минимальную и макс if(!$DateNoInTheme){ $query = "SELECT min(date_Beg) as Beg, max(date_Beg) as End1, max(date_End) as End2 FROM $WhereSearch WHERE id in (".$strTh.") ORDER BY id" ; $result = mysql_query($query) or die(mysql_error()); $row = mysql_fetch_assoc($result); //echo "min(date_Beg)".$row['Beg']."
"; //echo "max(date_End1)".$row['End1']."
"; //echo "max(date_End2)".$row['End2']."
"; //находи макс Енд if(strtotime($row['End1'])<= strtotime($row['End2'])) { $resultEnd = $row['End2']; }else{ $resultEnd = $row['End1']; } // echo "resultEnd".$resultEnd."
"; //преобразуем даты $time = new DateTime($row['Beg']); $_SESSION['Date_b'] = $Date_b = $time->format('d-m-Y'); $newtime = new DateTime($resultEnd); $_SESSION['Date_e'] = $Date_e = $newtime->modify('+1 month')->format('d-m-Y'); // echo "Date_b".$Date_b."
"; // echo "Date_e".$Date_e."
"; } //ISNULL(NULLIF(fieldname,'')) //вытаскиваем сами даты $query = "SELECT id, date_Beg, date_End,bс_ac, $eventNeed, ids_Theme, date_of_add, ids_country, category, ISNULL(NULLIF(map_objects,'')) as map_objects, mapPict FROM $WhereSearch WHERE id in (".$strTh.") ORDER BY bс_ac DESC,date_Beg" ; //ISNULL(NULLIF(fieldname,'')) 0 - если есть координаты, 1 - если пусто }else{ echo "
Нет Событий в этой теме!!!
"; $query = "SELECT id, date_Beg, date_End,bс_ac, $eventNeed, ids_Theme, date_of_add, ids_country, category, ISNULL(NULLIF(map_objects,'')) as map_objects, mapPict FROM $WhereSearch WHERE '1'='1' ".$whereDate." ".$whereKeyWords." ".$whereIdIn." ".$QueryNews." ORDER BY bс_ac DESC,date_Beg" ; } }else{ //вытаскиваем все события $query = "SELECT id, date_Beg, date_End,bс_ac, $eventNeed, ids_Theme, date_of_add, ids_country, category, ISNULL(NULLIF(map_objects,'')) as map_objects, mapPict FROM $WhereSearch WHERE '1'='1' ".$whereDate." ".$whereKeyWords." ".$whereIdIn." ".$QueryNews." ORDER BY bс_ac DESC ,date_Beg" ; } //echo $query; $result = mysql_query($query) or die(mysql_error()); $n = mysql_num_rows($result); if($n >0){ $arrEv = array(); for ($i = 0; $i < $n; $i++) { $row = mysql_fetch_assoc($result); if($_SESSION['ISBot'] == 'yes'){ if($row['event_changed'] !=''){ $row['event']="*".$row['event_changed']; /**/ } } //вытаскиваем страны $ids_country = explode("|",$row['ids_country']); //удаляем повторяюшиеся $ids_country = array_unique($ids_country); //удаляем пустые $ids_country = array_diff($ids_country, array('','0')); $allCountryInTheme = array_unique(array_merge($allCountryInTheme,$ids_country)); //$allCountryInTheme $row['country'] = array(); //var_dump($ids_country); foreach($ids_country as $id_c){ $row['country'][$id_c]=$CountryArr[$id_c]; } unset($row['event_changed']); $arrEv[] = $row; //if($row['id'] ==$SpeechArr[0]['id_avtor']){ $titleStr = $row['Who']; } } } //var_dump($arrEv); if($arrEv !=null){ //die("

хана"); // var_dump($arrEv); //пробегаемся по всем массивам и находим все даты начала и конца $arrOfDate = array(); // var_dump($SpeechArr); foreach($arrEv as $event){ //if($event['date_Beg'] !=){ $arrOfDate[] =$event['date_Beg']; $arrOfDate[] =$event['date_End']; //} //echo "
"; } //удаляем повторяюшиеся даты $arrOfDate = array_unique($arrOfDate); //удаляем пустые $arrOfDate = array_diff($arrOfDate, array('0000-00-00 00:00:00')); //порядочиваем массив arsort($arrOfDate); // echo "

arrOfDate"; // var_dump($arrOfDate); //находим минимальную и мкксимальную дату $maxDate = max($arrOfDate); $minDate = min($arrOfDate); //$minDate = "2012-07-02 00:00:00"; //$maxDate = "2014-09-07 00:00:00"; // echo "
maxDate-".$maxDate; // echo "
minDate-".$minDate; $Arr1 = explode(' ',$maxDate); $Arr2 = explode(' ',$minDate); } if(($Date_b !='') AND ($Date_e !='')){//если даты у нас заданы (то тогда ставим промежуток за последний год) $ss = explode('-',$Date_b); $ssss = explode('-',$Date_e); // echo $Date_b."hhhhh
"; $ss1 = $ss[2]."-".$ss[1]."-".$ss[0]; $ssss1 = $ssss[2]."-".$ssss[1]."-".$ssss[0]; $ArrDMin = explode('-',$ss1); // var_dump($ArrDMin); $ArrDMax = explode('-',$ssss1); /* echo "

"; var_dump($ArrDMin); echo "
Date_b-".$Date_b; echo "
Date_e-".$Date_e; */ }else{ //$ArrDMax = explode('-',$Arr1[0]); //$ArrDMin = explode('-',$Arr2[0]); /* $ss = explode('-',$ArrDMin[0]); $ssss = explode('-',$ArrDMax[0]); $Date_b = $ss[0]."-".$ss[1]."-".$ss[2]; $Date_e = $ssss[0]."-".$ssss[1]."-".$ssss[2]; */ } //определяем сколько лет нужно $num_years = $ArrDMax[0]-$ArrDMin[0]; /*echo "

minDate-".$minDate; echo "
maxDate-".$maxDate; echo "
num_years-".$num_years;*/ /* if($num_years>1000){ $_SESSION['Date_b'] = null; $_SESSION['id_theme'] = null; $_SESSION['Date_e'] = null; ?>
Очистить фильтр
5) AND ($num_years<=10)){ $scale = 2; }elseif(($num_years>10) AND ($num_years<=20)){ $scale = 1; }elseif(($num_years>20) AND ($num_years<=30)){ $scale = '0.5'; }elseif(($num_years>30) AND ($num_years<=50)){ $scale = '0.2'; }elseif(($num_years>50) AND ($num_years<=300)){ $scale = '0.1'; }elseif($num_years>300){ $scale = '0.05'; } } ?>




kkkkkkkkkkkk"; $allCountryInThemeAss = array(); foreach($allCountryInTheme as $id_c){ $allCountryInThemeAss[$id_c]=$CountryArr[$id_c]; } //$allCountryInThemeAss = array_merge($allCountryInThemeAssNew,$allCountryInThemeAss); //var_dump($allCountryInThemeAss); ?> <?if($titleStr !=''){ echo $titleStr; }else{ echo "Все важные даты и события мировой истории";}?> "; //echo "dayFromEnd-".$dayFromEnd."
"; $piksFromBeg = ceil($dayFromBeg*10*$scale/30); $piksAllMonthEar = ceil(360*10*$scale/30)+3; $year = $ArrDMax[0]-$ArrDMin[0]; $yearPiks = $year*$piksAllMonthEar; $piksFromEnd = ceil($dayFromEnd*10*$scale/30)+$yearPiks; $alPiks = ($year+1)*$piksAllMonthEar; /*echo "piksFromBeg-".$piksFromBeg."
"; echo "piksFromEnd-".$piksFromEnd."
"; echo "piksAllMonthEar-".$piksAllMonthEar."
"; echo "alPiks-".$alPiks."
";*/ $DateForFormBeg = $ArrDMin[2]."-".$ArrDMin[1]."-".$ArrDMin[0]; $DateForFormEnd = $ArrDMax[2]."-".$ArrDMax[1]."-".$ArrDMax[0]; $DateForFormEnd = $ArrDMax[2]."-".$ArrDMax[1]."-".$ArrDMax[0]; //$_POST['DateBeg'] //$_POST['DateEnd'] $theme = ''; //вытаскиваем все темы новостей (если в дальнейшем будет висеть, то сделать при клике на ссылку) $query = "SELECT * FROM Theme_of_Events ORDER BY Theme"; $result = mysql_query($query) or die(mysql_error()); $n = mysql_num_rows($result); if($n >0){ $arrTheme = array(); for ($i = 0; $i < $n; $i++) { $row = mysql_fetch_assoc($result); $arrTheme[] = $row; if($row['id'] == $_GET['id_theme']){ $theme = $row['Theme'];} //if($row['id'] ==$SpeechArr[0]['id_avtor']){ $titleStr = $row['Who']; } } } ?>

    
  
<< Главная страница | Список событий и дат | Список новостей   



300){ $smeshenie = $piksFromBeg - 300; } ?> 5){ $arrSent[$j] = trim($arrSent[$j]); try {//делаем прописную букву $char= mb_strtolower(mb_substr($arrSent[$j],0,2,"utf-8"),"utf-8"); // это первый символ $arrSent[$j][0]=$char[0]; $arrSent[$j][1]=$char[1]; }catch (Exception $e) {} //перемещиваем предложение $arr_slov = explode(" ",$arrSent[$j]); $nslov = count($arr_slov); $nslov = floor($nslov/3); $titl_n1 = array(); $titl_e1 = array(); $titl_n2 = array(); $titl_e2 = array(); for($d=0; $d= ($nslov*2-1)){ if(mb_strlen($arr_slov[$d],"utf-8")>3){ $titl_n2[] =$arr_slov[$d]; } }else{ $titl_n2[] =$arr_slov[$d]; } }else{ $titl_e2[] =$arr_slov[$d]; } } //$titl_n1 = implode(" ",$titl_n1); $titl_e1 = implode(" ",$titl_e1); //$titl_nT = $titl_e1." ".$titl_n1; $titl_n2 = implode(" ",$titl_n2); $titl_e2 = implode(" ",$titl_e2); $titl_nE = $titl_e2." ".$titl_n2; $arrSent[$j] = $titl_nE; try {//делаем заглавную букву $char= mb_strtoupper(mb_substr($arrSent[$j],0,2,"utf-8"),"utf-8"); // это первый символ $arrSent[$j][0]=$char[0]; $arrSent[$j][1]=$char[1]; }catch (Exception $e) {} // echo $string; } } //var_dump($arrSent); echo "

"; $str = ''; //в зависимости от остатка от деления составляем назад строку for($j=0; $j"; } $string =$str."."; //$string = implode(". ", $arrSent); $string.="."; //echo $string . "\n"; //раньше менялось здесь для ботов, сейчас просто вытаскивается другое поле $arrEv[$i]['titl_nE'] = $arrEv[$i]['event_changed']; } */ ?>

        

        По заданым критериям найдены следующие события/даты 0){?>

 + 
 – */?>  – 
xmlns="http://www.w3.org/2000/svg" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:ev="http://www.w3.org/2001/xml-events">

koord
Добавление картинки/карты

Подстановка файла

Нахождение координат (пикселей) на картинке
Первая точка Вторая точка
x1 x2
y1 y2
Нахождение координат (широта/долгота) на карте Yandex
Первая точка Вторая точка
Lat1 Lat2
Lon1 Lon2




"; var_dump($arrMap); echo "

arrOtm
"; var_dump($arrOtm);*/ ?>
0 or count($arrOtm)>0){?>
0){?>
Карты 
"; }?>
0){?>
Отметки 
"; }?>
 ↕ 
0){?>
0){?>

0){?>

style="background-color:#eee" >
>
mapIn"; echo ""; echo "карта"; }else{ echo ""; } }?>
1){ echo "".count($arrEv[$i]['country'])."";}?> -- > посмотреть |||удалить Дату ||| редактировать Дату RED map"; // mapPict //echo $arrEv[$i]['mapPict']; if($arrEv[$i]['mapPict'] !=''){ //echo "mapIn"; echo ""; } echo ""; }*/ ?>
       Ничего не найдено. Измените параметры фильтра.
"; //выводим темы с картинками (по приоритету/или по джате создания) //print_r($arrTheme); //вытаскиваем все темы новостей (если в дальнейшем будет висеть, то сделать при клике на ссылку) //$query = "SELECT * FROM Theme_of_Events ORDER BY Theme"; //ISNULL(NULLIF(map_objects,'')) as map_objects //вытаскиваем войны // $query = "SELECT * FROM Theme_of_Events WHERE img <>'' ORDER BY prior "; $query = "SELECT * FROM Theme_of_Events WHERE img <>'' AND prior=10 ORDER BY Theme "; $result = mysql_query($query) or die(mysql_error()); $n = mysql_num_rows($result); if($n >0){ $arrTh = array(); for ($i = 0; $i < $n; $i++) { $row = mysql_fetch_assoc($result); $arrTh[] = $row; if($row['id'] == $_GET['id_theme']){ $theme = $row['Theme'];} //if($row['id'] ==$SpeechArr[0]['id_avtor']){ $titleStr = $row['Who']; } } } //print_r($arrTh); if(count($arrTh)>0){ ?>

       Войны

'' ORDER BY prior "; $query = "SELECT * FROM Theme_of_Events WHERE img <>'' AND prior=9 ORDER BY Theme "; $result = mysql_query($query) or die(mysql_error()); $n = mysql_num_rows($result); if($n >0){ $arrTh1 = array(); for ($i = 0; $i < $n; $i++) { $row = mysql_fetch_assoc($result); $arrTh1[] = $row; if($row['id'] == $_GET['id_theme']){ $theme = $row['Theme'];} //if($row['id'] ==$SpeechArr[0]['id_avtor']){ $titleStr = $row['Who']; } } } if(count($arrTh)>0){ ?>

       Империи

-code-".$code; //заносится в сессию и в БД $agent = mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']); $ip = mysql_real_escape_string($_SERVER['REMOTE_ADDR']); $agent = mysql_real_escape_string($_SERVER['HTTP_USER_AGENT']); $date = date('Y-m-d H:i:s'); $query = "INSERT INTO Bot_info (uid_for_bot,Bot_name,user_agent,mouse_move,mouse_move_latet,ip,IsBot,date,visits) VALUES ('$code','$bname','$agent',0,'','$ip','','$date',1)"; //$query = "INSERT INTO Date_Of_Events (date_Beg,date_End,event) VALUES (STR_TO_DATE('15-8-1990 00:00:00', '%d-%m-%Y %H:%i:%s'),STR_TO_DATE('00-00-0000 00:00:00', '%d-%m-%Y %H:%i:%s'),'Начал писать события1111')"; //echo $query; $result = mysql_query($query) or die(mysql_error()); $_SESSION['uid_for_bot'] = $code; }else{ //если уже зареган в базе, то просто меняем чиcло визитов $t = "UPDATE Bot_info SET visits = visits+1 WHERE uid_for_bot = '".$_SESSION['uid_for_bot']."'"; //die($eventStr); $result = mysql_query($t); } //echo "
mouse_move -".$_SESSION['mouse_move']; ?>