Subversion-Projekte lars-tiefland.content-management

Revision

Details | Letzte Änderung | Log anzeigen | RSS feed

Revision Autor Zeilennr. Zeile
1 lars 1 
<?php
2 
 
3 
    /**
4 
     * @package   Content-management
5 
     * @author    Webagentur Niewerth <tiefland@weban.de>
6 
     * @copyright 2011 Webagentur Niewerth
7 
     * @license   propietary http://www.weban.de
8 
     * @version   $Rev: 754 $
9 
     * @filesource
10 
     *
11 
     */
12 
 
13 
    /**
14 
     *
15 
     * @package   Content-management
16 
     * @author    Webagentur Niewerth <tiefland@weban.de>
17 
     * @copyright 2011 Webagentur Niewerth
18 
     */
19 
 
20 
    // SVN: $Id: eu_label.php 754 2011-10-12 07:53:03Z tiefland $
21 
 
22 
    require_once "../toolbox/common.php";
23 
    $label = filter_input( INPUT_GET, "label", FILTER_VALIDATE_INT );
24 
    if ( !$label )
25 
    {
26 
        exit;
27 
    }
28 
    $sql = "SELECT
29 
            formular
30 
        FROM
31 
            eu_labels
32 
        WHERE
33 
            id=$label
34 
    ";
35 
    $res = mysql_query( $sql );
36 
    $row = mysql_fetch_assoc( $res );
37 
    $tpl_file = $row["formular"];
38 
 
39 
    $sql = "SELECT
40 
            id,
41 
            name
42 
        FROM
43 
            Herstellerkatalog
44 
        ORDER BY
45 
            name
46 
    ";
47 
    $res = mysql_query( $sql );
48 
    $hersteller[-1] = "Bitte wählen";
49 
    while ( $row = mysql_fetch_assoc( $res ) )
50 
    {
51 
        $hersteller[$row["id"]] = $row["name"];
52 
    }
53 
    $GLOBALS["ui"]->assign( "label", $label );
54 
    $GLOBALS["ui"]->assign( "hersteller", $hersteller );
55 
    $GLOBALS["ui"]->assign( "tpl_file", $tpl_file );
56 
    $GLOBALS["ui"]->display( "eu_label/page.tpl" );
57 
?>