das wäre orginal PHP/mySQL
require('includes/application_top.php');
require_once(DIR_FS_INC . 'esc_get_products_mo_images.inc.php');
if ((int)$_GET['imgID'] == 0) {
$products_query = esc_db_query("select pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '" . (int)$_GET['pID'] . "' and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");
$products_values = esc_db_fetch_array($products_query);
} else {
$products_query = esc_db_query("select pd.products_name, p.products_image, pi.image_name from " . TABLE_PRODUCTS_IMAGES . " pi, " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '" . (int)$_GET['pID'] . "' and pi.products_id = '" . (int)$_GET['pID'] . "' and pi.image_nr = '" . (int)$_GET['imgID'] . "' and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'");
$products_values = esc_db_fetch_array($products_query);
$products_values['products_image'] = $products_values['image_name'];
}
// get x and y of the image
$img = DIR_WS_POPUP_IMAGES.$products_values['products_image'];
$size = GetImageSize("$img");
//get data for mo_images
$mo_images = esc_get_products_mo_images((int)$_GET['pID']);
$img = DIR_WS_THUMBNAIL_IMAGES.$products_values['products_image'];
$osize = GetImageSize("$img");
if (isset($mo_images)){
//$bwidth = $osize[0];
$bheight = $osize[1];
foreach ($mo_images as $mo_img){
$img = DIR_WS_THUMBNAIL_IMAGES.$mo_img['image_name'];
$mo_size = GetImageSize("$img");
// if ($mo_size[0] > $bwidth) $bwidth = $mo_size[0];
if ($mo_size[1] > $bheight) $bheight = $mo_size[1];
}
$bheight += 50;
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<title><?php echo $products_values['products_name']; ?></title>
<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="<?php echo 'templates/'.CURRENT_TEMPLATE.'/stylesheet.css'; ?>">
<script language="javascript"><!--
var i=0;
function resize() {
if (navigator.appName == 'Netscape') i=40;
window.resizeTo(<? echo $size[0] ?> +105, <? echo $size[1] + $bheight ?>+125-i);
self.focus();
}
//--></script>
</head>
<body onLoad="resize();" >
<!-- xtc_image($src, $alt = '', $width = '', $height = '', $params = '') -->
<!-- big image -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="#283758"><div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $products_values['products_name']; ?></strong></font></div></td>
</tr>
<tr>
<td>
<table border=0 align="center" cellpadding=5 cellspacing=0>
<tr>
<td align=center><? echo esc_image(DIR_WS_POPUP_IMAGES . $products_values['products_image'], $products_values['products_name'], $size[0], $size[1]); ?></td>
</tr>
</table>
</table>
<!-- thumbs -->
<center>
<?
if (isset($mo_images))
{
?>
<iframe src="<? echo 'show_product_thumbs.php?pID='.(int)$_GET['pID'].'&imgID='.(int)$_GET['imgID']; ?>" width="<? echo $size[0] +40 ?>" height="<? echo $bheight+5; ?>" border="0" frameborder="0">
<a href="<? echo 'show_product_thumbs.php?pID='.(int)$_GET['pID'].'&imgID='.(int)$_GET['imgID']; ?>">More Images</a>
</iframe><br>
<?
}
?>
<a href="#" onClick='window.close();'><?php echo TEXT_CLOSE_WINDOW ?></a>
</body>
</html>
das wäre meine geänderte auf adoDB
damit bin ich mir nicht ganz sicher ob die alle richtig sind ->fields
require('includes/application_top.php');
require_once(DIR_FS_INC . 'esc_get_products_mo_images.inc.php');
if ((int)$_GET['imgID'] == 0) {
$products_query = "select pd.products_name, p.products_image from " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '" . (int)$_GET['pID'] . "' and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
$products_values = $db->Execute($products_query);
} else {
$products_query = "select pd.products_name, p.products_image, pi.image_name from " . TABLE_PRODUCTS_IMAGES . " pi, " . TABLE_PRODUCTS . " p left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id where p.products_status = '1' and p.products_id = '" . (int)$_GET['pID'] . "' and pi.products_id = '" . (int)$_GET['pID'] . "' and pi.image_nr = '" . (int)$_GET['imgID'] . "' and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'";
$products_values = $db->Execute($products_query);
$products_values->fields['products_image'] = $products_values->fields['image_name'];
}
// get x and y of the image
$img = DIR_WS_POPUP_IMAGES.$products_values->fields['products_image'];
$size = GetImageSize("$img");
//get data for mo_images
$mo_images = esc_get_products_mo_images((int)$_GET['pID']);
$img = DIR_WS_THUMBNAIL_IMAGES.$products_values->fields['products_image'];
$osize = GetImageSize("$img");
if (isset($mo_images)){
//$bwidth = $osize[0];
$bheight = $osize[1];
foreach ($mo_images as $mo_img){
$img = DIR_WS_THUMBNAIL_IMAGES.$mo_img->fields['image_name'];
$mo_size = GetImageSize("$img");
// if ($mo_size[0] > $bwidth) $bwidth = $mo_size[0];
if ($mo_size[1] > $bheight) $bheight = $mo_size[1];
}
$bheight += 50;
}
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title><?php echo $products_values['products_name']; ?></title>
<base href="<?php echo (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="<?php echo 'templates/'.CURRENT_TEMPLATE.'/stylesheet.css'; ?>">
<script language="javascript"><!--
var i=0;
function resize() {
if (navigator.appName == 'Netscape') i=40;
window.resizeTo(<? echo $size[0] ?> +105, <? echo $size[1] + $bheight ?>+125-i);
self.focus();
}
//--></script>
</head>
<body onLoad="resize();" >
<!-- esc_image($src, $alt = '', $width = '', $height = '', $params = '') -->
<!-- big image -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td bgcolor="283758"><div align="center"><font color="#FFFFFF" size="2" face="Verdana, Arial, Helvetica, sans-serif"><strong><?php echo $products_values->fields['products_name']; ?></strong></font></div></td>
</tr>
<tr>
<table border=0 align="center" cellpadding=5 cellspacing=0>
<tr>
<td align=center><? echo esc_image(DIR_WS_POPUP_IMAGES . $products_values->fields['products_image'], $products_values->fields['products_name'], $size[0], $size[1]); ?></td>
</tr>
</table>
</table>
<!-- thumbs -->
<center>
<?
if (isset($mo_images))
{
?>
<iframe src="<? echo 'show_product_thumbs.php?pID='.(int)$_GET['pID'].'&imgID='.(int)$_GET['imgID']; ?>" width="<? echo $size[0] +40 ?>" height="<? echo $bheight+5; ?>" border="0" frameborder="0">
<a href="<? echo 'show_product_thumbs.php?pID='.(int)$_GET['pID'].'&imgID='.(int)$_GET['imgID']; ?>">More Images</a>
</iframe><br>
<?
}
?>
<a href="#" onClick='window.close();'><?php echo TEXT_CLOSE_WINDOW ?></a>
</body>
</html>