Array ( [0] => idmod [Field] => idmod [1] => int(10) [Type] => int(10) [2] => NO [Null] => NO [3] => PRI [Key] => PRI [4] => 0 [Default] => 0 [5] => [Extra] => )
Array ( [0] => idclient [Field] => idclient [1] => int(10) [Type] => int(10) [2] => NO [Null] => NO [3] => MUL [Key] => MUL [4] => 0 [Default] => 0 [5] => [Extra] => )
Array ( [0] => name [Field] => name [1] => varchar(255) [Type] => varchar(255) [2] => NO [Null] => NO [3] => [Key] => [4] => [Default] => [5] => [Extra] => )
Array ( [0] => type [Field] => type [1] => varchar(32) [Type] => varchar(32) [2] => NO [Null] => NO [3] => [Key] => [4] => [Default] => [5] => [Extra] => )
Array ( [0] => error [Field] => error [1] => varchar(32) [Type] => varchar(32) [2] => NO [Null] => NO [3] => [Key] => [4] => none [Default] => none [5] => [Extra] => )
Array ( [0] => description [Field] => description [1] => text [Type] => text [2] => YES [Null] => YES [3] => [Key] => [4] => [Default] => [5] => [Extra] => )
Array ( [0] => deletable [Field] => deletable [1] => tinyint(1) [Type] => tinyint(1) [2] => YES [Null] => YES [3] => [Key] => [4] => [Default] => [5] => [Extra] => )
Array ( [0] => input [Field] => input [1] => longtext [Type] => longtext [2] => NO [Null] => NO [3] => [Key] => [4] => [Default] => [5] => [Extra] => )
Array ( [0] => output [Field] => output [1] => longtext [Type] => longtext [2] => NO [Null] => NO [3] => [Key] => [4] => [Default] => [5] => [Extra] => )
Array ( [0] => template [Field] => template [1] => text [Type] => text [2] => NO [Null] => NO [3] => [Key] => [4] => [Default] => [5] => [Extra] => )
Array ( [0] => static [Field] => static [1] => tinyint(1) [Type] => tinyint(1) [2] => NO [Null] => NO [3] => [Key] => [4] => 0 [Default] => 0 [5] => [Extra] => )
Array ( [0] => author [Field] => author [1] => varchar(32) [Type] => varchar(32) [2] => NO [Null] => NO [3] => [Key] => [4] => [Default] => [5] => [Extra] => )
Array ( [0] => created [Field] => created [1] => datetime [Type] => datetime [2] => NO [Null] => NO [3] => [Key] => [4] => 0000-00-00 00:00:00 [Default] => 0000-00-00 00:00:00 [5] => [Extra] => )
Array ( [0] => lastmodified [Field] => lastmodified [1] => datetime [Type] => datetime [2] => NO [Null] => NO [3] => [Key] => [4] => 0000-00-00 00:00:00 [Default] => 0000-00-00 00:00:00 [5] => [Extra] => )
Array ( [0] => package_guid [Field] => package_guid [1] => varchar(64) [Type] => varchar(64) [2] => YES [Null] => YES [3] => [Key] => [4] => [Default] => [5] => [Extra] => )
Array ( [0] => package_data [Field] => package_data [1] => text [Type] => text [2] => YES [Null] => YES [3] => [Key] => [4] => [Default] => [5] => [Extra] => )



reset();

/*
 * initialize database objects
 */
if ( !is_object($db) ) {
    $db = new DB_Contenido;
}

$query = "select    container, 
        idart,
        title.value,
        title.value,
    STR_TO_DATE(substring(container,3,10), '%d.%m.%Y') date
    from    con_art_lang, 
        con_container_conf, 
        con_template_conf,
        con_content title
    where   con_container_conf.idtplcfg = con_art_lang.idtplcfg and 
        con_art_lang.online = 1 and
        con_container_conf.number = 1 and 
        con_template_conf.idtplcfg = con_art_lang.idtplcfg and 
        con_template_conf.idtpl = 34 and
        title.idartlang = con_art_lang.idartlang and 
        title.idtype = 1 and title.typeid = 1 
    order by date desc";
$result = $db->query($query);
$articleCount = 0;
while( $article = mysql_fetch_array($result) ) {
    $myContainer = $article[0];
    if($articleCount>6) {
        break;
    }
    $fields = explode("&", $article[0]);
    $date = explode("=", $fields[0]);
    $dateFields=date_parse($date[1]);
    $time = mktime($dateFields['hour'], $dateFields['minute'], $dateFields['second'], $dateFields['month'], $dateFields['day'], $dateFields['year']);
    if( (time()-$time) > (60*60*24*27)) {
        continue;
    }
    $tpl->set('s', 'DATE', $date[1]);
    $tpl->set('d', 'ARTID', $article[1]);
    $artid = $article[1];
    $article = new Article($article[1], 1, 1); 
    if($article->get("online") != 1 ) {
        continue;
    }
    preg_match_all("#<.*>(.*)<.*>#U", $article->getContent("htmlhead", 1), $head);
    $tpl->set('d', 'TITEL', $head[1][0]);
    
    preg_match_all("#.*<.*>(.*)<.*>.*#U", $article->getContent("html", 2), $head);
    if( strlen ($head[0][1]) > 0 ) {
        $myAbstract= "
  • ".$head[0][1]."
  • "; $tpl->set('d', 'ABSTRACT', $myAbstract); } else { $tpl->set('d', 'ABSTRACT', ""); } if( $auth->auth['uname'] == 'LTB-046' && !strpos($myContainer,'&2=facebook') ) { $tpl->set('d', 'FACEBOOK', 'Auf Facebook publizieren'); } else { $tpl->set('d', 'FACEBOOK', ''); } $articleCount += 1; $tpl->next(); } if( $articleCount > 0 ) { $tpl->generate('templates/Teaser_Presse.html'); } else { echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo" "; echo"
    "; echo" "; echo"
    Zur Zeit liegen keine aktuellen Pressemeldungen vor
    "; } ?>1
    Zur Zeit liegen keine aktuellen Pressemeldungen vor