Subversion-Projekte lars-tiefland.content-management

<?php

    //$Id: artikelsuche.php 3931 2011-09-16 08:17:57Z tiefland $

    /**
     * @author Lars Tiefland <tiefland@weban.de>
     * @copyright 2009 Webagentur Niewerth
     * @package Content-management
     * @version $Rev: 3931 $
     * @license propietary
     * @filesource
     * 
     */

    /**
     * 
     * @author Lars Tiefland <tiefland@weban.de>
     * @copyright 2009 Webagentur Niewerth
     * @package Content-management
     */

    require_once  "Weban_Smarty.class.php";
    require_once  "../connect2.php";
    session_start();
    $GLOBALS["ui"] = new Weban_Smarty();

    $GLOBALS["ui"]->assign( "bg_color_links", "#" . $webs["bgcolor_links"] );
    $GLOBALS["ui"]->assign( "bg_color_rechts", "#" . $webs["bgcolor_rechts"] );
    $GLOBALS["ui"]->assign( "font_color_links", "#" . $webs["font_color_links"] );
    $GLOBALS["ui"]->assign( "font_color_rechts", "#" . $webs["font_color_rechts"] );
    if ( $_POST["mode"] == "search" )
    {
        unset( $_POST["mode"] );
        foreach ( $_POST as $key => $value )
        {
            if ( $value )
            {
                if ( $key == "ID" || $key == "kennung" ||$key=="language")
                {
                    $such_sql[] = "$key='$value'";
                }
                else
                {
                    $such_sql[] = "$key LIKE '%$value%'";
                }
            }
        }
        $such_sql_str = is_array( $such_sql ) ? "AND " . implode( " AND ", $such_sql ) :
            "";
        $sql = "SELECT * FROM artikel WHERE Father !=-3 $such_sql_str";
        $res = mysql_query( $sql );
        while ( $row = mysql_fetch_assoc($res) )
        {
            $results[] = $row;
        }
        $GLOBALS["ui"]->assign("language", $_POST["language"]);
    }
    else
    {
        $GLOBALS["ui"]->assign("language", $_GET["lang"]);
    }
    $GLOBALS["ui"]->assign( "results", $results );
    $GLOBALS["ui"]->display( "artikelsuche.tpl" );

?>