host,$config->user,$config->password); mysql_select_db($config->db,$con); mysql_query("SET NAMES 'utf8'",$con); function umlaute($the_string){ $upas = array("ä" => "ae", "ü" => "ue", "ö" => "oe", "Ä" => "Ae", "Ü" => "Ue", "Ö" => "Oe", "ß" => "ss", "„" => "\""); return strtr($the_string, $upas); } $limit = ''; if($_GET['max']) { $limit = " LIMIT " . $_GET['max']; } echo ' Meinkino http://mein-kino.ch/ Meinkino MediaMechanics Meinkino'; $result_article = mysql_query("SELECT * FROM ".$config->dbprefix."meinkino_articles WHERE category_id<>4 AND published=1 ORDER BY createdate DESC" . $limit); while ($r = mysql_fetch_array($result_article)) { $title=umlaute($r['name']); $title=preg_replace("/[^a-zA-Z0-9\s]/", "", $title); $title=str_replace(" ", "+", $title); $r['name'] = str_replace("&", "-", $r['name']); $des = html_entity_decode($r['description'],ENT_QUOTES); //$des = strip_tags($des); $des = substr($des,0,500) . '...'; //$des=umlaute($des); $des = preg_replace('/[^0-9a-z[ä|ü|ö|Ä|Ü|Ö|ß]\`\~\!\@\#\$\%\^\*\(\)\; \,\.\„\'\/\_\-<>\\\=\&:"]/i', ' ', $des); echo ' '.$r['name'].' http://mein-kino.ch/component/meinkino/'.$r['category_id'].'/'.$r['id'].'/'.$title.'.html
'.$des.$limit.'
'.$r['name'].' ]]> '.date('D, j M Y H:i:s T',$r['createdate']).' '; } echo ''; echo ''; ?>