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: bilder.php 754 2011-10-12 07:53:03Z tiefland $

    require_once "../toolbox/common.php";

    $a_id = Weban_Utils::clean_global_input( "a_id", "post", "int" );

    $sql = "SELECT
            b.*
        FROM
            bilder b
        JOIN
            artikel_bilder ab
        ON
            ab.bild_id=b.id
        WHERE
            ab.artikel_id=" . $a_id . "
    ";
    $res = mysql_query( $sql );
    while ( $row = mysql_fetch_assoc( $res ) )
    {
        $row["url"] = "http://www.$site_full/images/upload/" . $row["folder"] .
            $row["name"];
        $row["url_mini"] = "http://www.$site_full/images/upload/" . $row["folder"] .
            "mini/" . $row["name"];
        $row["path_mini"] = $webs["verzeichnis"] . "/images/upload/" . $row["folder"] .
            "mini/" . $row["name"];
        $row["path"] = $webs["verzeichnis"] . "/images/upload/" . $row["folder"] .
            $row["name"];
        $row["size"] = filesize( $row["path"] );
        $row["img_size"] = GetImageSize( $row["path"] );
        $bilder[] = $row;
    }
    $GLOBALS["ui"]->assign( "bilder", $bilder );
    $GLOBALS["ui"]->display( "bilder.tpl" );
?>