Subversion-Projekte lars-tiefland.content-management

Revision

Revision 1 | Details | Vergleich mit vorheriger | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
 
2 lars 3 
    //$Id: artikelsuche.php 4100 2011-11-22 07:42:29Z tiefland $
1 lars 4 
 
5 
    /**
6 
     * @author Lars Tiefland <tiefland@weban.de>
7 
     * @copyright 2009 Webagentur Niewerth
8 
     * @package Content-management
2 lars 9 
     * @version $Rev: 4100 $
1 lars 10 
     * @license propietary
11 
     * @filesource
12 
     *
13 
     */
14 
 
15 
    /**
16 
     *
17 
     * @author Lars Tiefland <tiefland@weban.de>
18 
     * @copyright 2009 Webagentur Niewerth
19 
     * @package Content-management
20 
     */
21 
 
2 lars 22 
    require_once "Weban_Smarty.class.php";
1 lars 23 
    require_once  "../connect2.php";
24 
    session_start();
25 
    $GLOBALS["ui"] = new Weban_Smarty();
26 
 
27 
    $GLOBALS["ui"]->assign( "bg_color_links", "#" . $webs["bgcolor_links"] );
28 
    $GLOBALS["ui"]->assign( "bg_color_rechts", "#" . $webs["bgcolor_rechts"] );
29 
    $GLOBALS["ui"]->assign( "font_color_links", "#" . $webs["font_color_links"] );
30 
    $GLOBALS["ui"]->assign( "font_color_rechts", "#" . $webs["font_color_rechts"] );
2 lars 31 
    $GLOBALS["ui"]->compile_id = "sonderpreis";
32 
    $GLOBALS["ui"]->compile_dir = $_SERVER["DOCUMENT_ROOT"] . "/templates_c/";
33 
    $GLOBALS["ui"]->use_sub_dirs = true;
34 
 
1 lars 35 
    if ( $_POST["mode"] == "search" )
36 
    {
37 
        unset( $_POST["mode"] );
38 
        foreach ( $_POST as $key => $value )
39 
        {
40 
            if ( $value )
41 
            {
42 
                if ( $key == "ID" || $key == "kennung" ||$key=="language")
43 
                {
44 
                    $such_sql[] = "$key='$value'";
45 
                }
46 
                else
47 
                {
48 
                    $such_sql[] = "$key LIKE '%$value%'";
49 
                }
50 
            }
51 
        }
52 
        $such_sql_str = is_array( $such_sql ) ? "AND " . implode( " AND ", $such_sql ) :
53 
            "";
54 
        $sql = "SELECT * FROM artikel WHERE Father !=-3 $such_sql_str";
55 
        $res = mysql_query( $sql );
56 
        while ( $row = mysql_fetch_assoc($res) )
57 
        {
58 
            $results[] = $row;
59 
        }
60 
        $GLOBALS["ui"]->assign("language", $_POST["language"]);
61 
    }
62 
    else
63 
    {
64 
        $GLOBALS["ui"]->assign("language", $_GET["lang"]);
65 
    }
66 
    $GLOBALS["ui"]->assign( "results", $results );
67 
    $GLOBALS["ui"]->display( "artikelsuche.tpl" );
68 
 
69 
?>