\n"; if ($_SESSION['doShow']) echo " Photos

\n"; if (!empty($_REQUEST['webcamphoto'])) { // requested a webcam photo echo " \n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "   "; echo " \n"; echo "
\n"; echo "\n"; echo "\n"; } else { $pList = mysql_query("select * from iphoto where linkref = '{$_SESSION['lastItemSrc']}'"); if (mysql_num_rows($pList)) { $odd = true; echo "\n"; while ($photo = mysql_fetch_assoc($pList)) { $fileName = "./modules/inventory/pictures/{$photo['tid']}.{$photo['ext']}"; $pData = getimagesize($fileName); $w = $pData[0]; $h = $pData[1]; // scale the photo for thumbnail $sw = $w / 128; // thumbnail will be a maximum of 128x96, 1/5 of a std VGA resolution $sh = $h / 96; if ($sw < $sh) { $sw = intval($w / $sh); $sh = 96; } else { $sh = intval($h / $sw); $sw = 128; } if ($odd) { echo " \n"; $odd = false; } else $odd = true; echo " \n"; if ($odd) echo " \n"; } if (!$odd) { echo " \n"; echo " \n"; } echo "
 
\n"; } else { if ($_SESSION['doShow']) echo "
No Photos Available
\n"; } // if this also contains stuff, we can show that too $lastSubShown = ""; $odd = true; // $itemList = sqlSelect("items", "location='{$_REQUEST['item']}'"); // echo "\n"; // while ($item = mysql_fetch_assoc($itemList['r'])) { $hasNotShownItems = true; $photos = sqlSelect("iphotos", "linkref='{$_REQUEST['item']}'", "", "tid"); echo "\n"; if ($photos['n']) { while ($photo = mysql_fetch_assoc($photos['r']) and $hasNotShownItems) { $fileName = "./modules/inventory/pictures/".$photo['tid']; if (file_exists($fileName)) { if ($hasNotShownItems) { $hasNotShownItems = false; // open the table if (!$titleHasShown) { echo "
This contains:
\n"; $titleHasShown = true; } echo "\n"; } $pData = getimagesize($fileName); $w = ($pData[0] > 0)? $pData[0]: 128; $h = ($pData[1] > 0)? $pData[1]: 96; echo "\n"; // scale the photo for thumbnail $sw = $w / 128; // thumbnail will be a maximum of 128x96, 1/5 of a std VGA resolution $sh = $h / 96; if ($sw < $sh) { $sw = intval($w / $sh); $sh = 96; } else { $sh = intval($h / $sw); $sw = 128; } if ($odd) { echo " \n"; $odd = false; } else $odd = true; echo " \n"; if ($odd) echo " \n"; } // else // { sqlDelete("photos", "tid='{$photo['tid']}'"); // } } } } if (!$hasNotShownItems) { // close the table if (!$odd) { echo " \n"; echo " \n"; } echo "
\n"; echo "
\n"; //echo "{$photo['sku']}\n"; echo "
 
\n"; } if ($_SESSION['doShow']) { echo "
\n"; } } ?>