Subversion-Projekte lars-tiefland.content-management

<?php

    /**
     * @package   Content-management
     * @author    Webagentur Niewerth <tiefland@weban.de>
     * @copyright 2011 Webagentur Niewerth
     * @license   propietary http://www.weban.de
     * @version   $Rev: 754 $
     * @filesource
     * 
     */

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

    // SVN: $Id: eu_label.php 754 2011-10-12 07:53:03Z tiefland $

    require_once "../toolbox/common.php";
    $label = filter_input( INPUT_GET, "label", FILTER_VALIDATE_INT );
    if ( !$label )
    {
        exit;
    }
    $sql = "SELECT
            formular
        FROM
            eu_labels
        WHERE
            id=$label
    ";
    $res = mysql_query( $sql );
    $row = mysql_fetch_assoc( $res );
    $tpl_file = $row["formular"];

    $sql = "SELECT
            id,
            name
        FROM
            Herstellerkatalog
        ORDER BY
            name
    ";
    $res = mysql_query( $sql );
    $hersteller[-1] = "Bitte wählen";
    while ( $row = mysql_fetch_assoc( $res ) )
    {
        $hersteller[$row["id"]] = $row["name"];
    }
    $GLOBALS["ui"]->assign( "label", $label );
    $GLOBALS["ui"]->assign( "hersteller", $hersteller );
    $GLOBALS["ui"]->assign( "tpl_file", $tpl_file );
    $GLOBALS["ui"]->display( "eu_label/page.tpl" );
?>