Actualités
Cliquez sur les nouvelles qui vous intéressent, ou feuilletez les informations préalables (au-dessous du tableau).
| NEWS: 27-39 700) { die('STOP. Too much EVANA-articles selected. '); } if (!isset($domain)){ if (!isset($_GET['domain'])) { $domain = ''; } else { $domain = $_GET['domain']; }} if (!isset($diary)) { if (!isset($_GET['diary'])) { $diary = ''; } else { $diary = $_GET['diary']; }} if (!isset($t)) { if (!isset($_GET['t'])) { $t = ''; } else { $t = $_GET['t']; }} if (!isset($cat)) { if (!isset($_GET['cat'])) { $cat = ''; } else { $cat = $_GET['cat']; }} if (!isset($limit)) { if (!isset($_GET['limit'])) { $limit = 10; } else { $limit = (int) $_GET['limit']; }} if (!isset($lang)) { if (!isset($_GET['lang'])) { $lang = ''; } else { $lang = $_GET['lang']; }} if (!isset($filter)){ if (!isset($_GET['filter'])) { $filter = ''; } else { $filter = $_GET['filter']; }} if (!isset($country)){if (!isset($_GET['country'])){ $country = ''; } else { $country = $_GET['country']; }} if (!isset($order)) { if (!isset($_GET['order'])) { $order = ''; } else { $order = $_GET['order']; }} if (!isset($encodeUTF8)) { if (!isset($_GET['encodeUTF8'])) { $encodeUTF8 = ''; } else { $encodeUTF8 = $_GET['encodeUTF8']; }} if (!isset($filtertext)) { if (!isset($_GET['filtertext'])) { $filtertext = ''; } else { $filtertext = $_GET['filtertext']; }} if (!isset($count_only)) { if (!isset($_GET['count_only'])) { $count_only = ''; } else { $count_only = (int) $_GET['count_only']; }} if (!isset($myFilename)) { if (!isset($_GET['myFilename'])) { $myFilename = ''; } else { $myFilename = $_GET['myFilename']; }} $maxArticleTextlength = (int) $_GET['maxArticleTextlength']; $maxSubtitleLength = (int) $_GET['maxSubtitleLength']; $maxTitleLength = (int) $_GET['maxTitleLength']; if (!isset($dateformat)){ if (!isset($_GET['dateformat'])) { $dateformat = ''; } else { $dateformat = $_GET['dateformat']; }} if (strlen($lang) > 2) { die(); // HACKER! } $filtertext = strtr($filtertext, "'#", " "); require_once("statistik.php"); $time_start_a = microtime(true); // Call this Script with: // .../get_neu.php?t=1&lang=de // t=1 : Use template No. 1 // lang=de : Language = German (if not set or 'all': show all entries form all languages) // limit=5 : Show only the last 5 entries (if not set: limit = 10) // start=0 : begin with entry 0. // filter=country="CH" : WHERE-clause of SQL // order=country,postalcode : Ordering fieldnames (like ORDER BY in SQL) // If isset: makeheader: put header and foot to the outputfile to make a full HTML-file // Diary/Terminkalender: // diary=y : show only article with catecory diary and date not in then past // diary=past : show diary-article from the past. if (empty($domain)) { echo "The EVANA-script is not correct implemented! Please contact info (at) evana.org."; $domain = "t=".$t; } elseif ($domain === "www.yourdomain.com") { echo "EVANA-script is not correct implemented! Please contact info (at) evana.org."; } $getdata=true; switch ($diary) { case 'y': $WHERE_clause = "(TO_DAYS(NOW()) - TO_DAYS(article.publicationdate) <= 0) AND article.category LIKE '%diary%'"; $order = "publicationdate,id"; //$limit = 200; $dummy = statistik("diary",$domain); $limit = 400; break; case 'past': $WHERE_clause = "(TO_DAYS(NOW()) - TO_DAYS(article.publicationdate) > 0) AND article.category LIKE '%diary%'"; $order = "publicationdate DESC, id DESC"; //$limit = 50; $dummy = statistik("diary",$domain); break; default: $pos = strpos($filter,"article_id=",0); if (!($pos===false)) { $id = (int) substr($filter,$pos+11); $WHERE_clause = " internal = 0"; // show one article with id, no filter is needed. $dummy = statistik("detail",$domain); $dummy = inc_download_counter($id); } else { $WHERE_clause = " internal = 0"; if (isset($lang) & $lang !== 'all' & (strlen($lang)>0)) { $WHERE_clause.= " AND language='$lang' "; } if (isset($comments)) { $WHERE_clause.= " AND comment=1"; } else { $WHERE_clause.= " AND comment=0"; } $WHERE_clause .= " AND (TO_DAYS(NOW()) - TO_DAYS(article.publicationdate) >= 0) AND article.category NOT LIKE '%diary%'"; if (isset($cat) & (strlen($cat)>0)) { $catArray = explode(',',$cat,20); $c = count($catArray); if ($c == 1) { $WHERE_clause.= " AND article.category LIKE '%$cat%' "; } else { $WHERE_clause.= " AND ("; foreach ($catArray as $one) { if ($one == $catArray[0]) { $WHERE_clause.= "article.category LIKE '%$one%' "; } else { $WHERE_clause.= " OR article.category LIKE '%$one%' "; } } $WHERE_clause.= ")"; } } if (isset($newestRecord)) { $order = "id DESC"; $limit = "1"; $dummy = statistik("detail",$domain); } else { if (isset($comments)) { $limit = "100"; } $dummy = statistik("list",$domain); } if (strlen($filtertext)>0) { $ft_list = explode(" OR ", $filtertext); if (count($ft_list)>1) { $WHERE_clause.= " AND ("; $ORblock = 0; foreach($ft_list as $ft_list2) { if ($ORblock > 0) { $WHERE_clause.= " OR "; } else { $ORblock++; } $ft_list3 = explode(" ", $ft_list2); $ANDblock = 0; $WHERE_clause.= "("; foreach($ft_list3 as $x) { if ($ANDblock > 0) { $WHERE_clause.= " AND "; } else { $ANDblock++; } $WHERE_clause.= "(article.title LIKE '%$x%' OR article.subtitle LIKE '%$x%' OR article.arttext LIKE '%$x%')"; } $WHERE_clause.= ")"; } $WHERE_clause.= ")"; } else { $ft_list = explode(" ", $filtertext); foreach($ft_list as $x) { $WHERE_clause.= " AND (article.title LIKE '%$x%' OR article.subtitle LIKE '%$x%' OR article.arttext LIKE '%$x%')"; } } } } break; } // switch $time_start_b = microtime(true); if ($count_only) { require("get_article_count.php"); } else { require("get_neu.php"); } $time_end = microtime(true); $time = $time_end - $time_start; /* if ($time > 5) { $timeA = sprintf("%2.3f", $time_start_a - $time_start); $timeB = sprintf("%2.3f", $time_start_b - $time_start_a); $timeC = sprintf("%2.3f", $time_end - $time_start_b); $s = 'getdata: Statistik einbinden: '.$timeA." / dazwischen: ".$timeB." / require: get_neu: ".$timeC.' / '.$_SERVER['SCRIPT_NAME']."\n"; $s .= $WHERE_clause."\n"; if (strlen($filter)>0) { $s .= 'Filter: '.$filter."\n"; } $s .= "-------------------------------\n\n"; file_put_contents('testlog.txt', $s, FILE_APPEND); } */ ?> << < 27-39 > Newsquelle: EVANA |