| 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: bilder.php 754 2011-10-12 07:53:03Z tiefland $
|
|
|
21 |
|
|
|
22 |
require_once "../toolbox/common.php";
|
|
|
23 |
|
|
|
24 |
$a_id = Weban_Utils::clean_global_input( "a_id", "post", "int" );
|
|
|
25 |
|
|
|
26 |
$sql = "SELECT
|
|
|
27 |
b.*
|
|
|
28 |
FROM
|
|
|
29 |
bilder b
|
|
|
30 |
JOIN
|
|
|
31 |
artikel_bilder ab
|
|
|
32 |
ON
|
|
|
33 |
ab.bild_id=b.id
|
|
|
34 |
WHERE
|
|
|
35 |
ab.artikel_id=" . $a_id . "
|
|
|
36 |
";
|
|
|
37 |
$res = mysql_query( $sql );
|
|
|
38 |
while ( $row = mysql_fetch_assoc( $res ) )
|
|
|
39 |
{
|
|
|
40 |
$row["url"] = "http://www.$site_full/images/upload/" . $row["folder"] .
|
|
|
41 |
$row["name"];
|
|
|
42 |
$row["url_mini"] = "http://www.$site_full/images/upload/" . $row["folder"] .
|
|
|
43 |
"mini/" . $row["name"];
|
|
|
44 |
$row["path_mini"] = $webs["verzeichnis"] . "/images/upload/" . $row["folder"] .
|
|
|
45 |
"mini/" . $row["name"];
|
|
|
46 |
$row["path"] = $webs["verzeichnis"] . "/images/upload/" . $row["folder"] .
|
|
|
47 |
$row["name"];
|
|
|
48 |
$row["size"] = filesize( $row["path"] );
|
|
|
49 |
$row["img_size"] = GetImageSize( $row["path"] );
|
|
|
50 |
$bilder[] = $row;
|
|
|
51 |
}
|
|
|
52 |
$GLOBALS["ui"]->assign( "bilder", $bilder );
|
|
|
53 |
$GLOBALS["ui"]->display( "bilder.tpl" );
|
|
|
54 |
?>
|