// Assign vars to template $t->assign('objects', $objects); /********************************** Get Frontpage sets **********************************/ $sql = "SELECT featured_sets.set_id, name, owner_name owner, img_path, aspectR img_ar, tTotal_objects.total_objects\n\t\t\t\tFROM featured_sets\n\t\t\t\t\n\t\t\t\tJOIN \n\t\t\t\t(SELECT set_id, count(*) total_objects\n\t\t\t\tFROM set_objs\n\t\t\t\tGROUP BY set_id) tTotal_objects\n\t\t\t\tON tTotal_objects.set_id = featured_sets.set_id\n\t\t\t\t\n\t\t\t\tORDER BY porder\n\t\t\t\t"; $res =& $db->query($sql); if (PEAR::isError($res)) { die($res->getMessage()); } // If nothing is found, send to object not found. if ($res->numRows() < 1) { $t->assign('heading', "Error"); $t->assign('message', "There are no featured sets!"); $t->display('error.tpl'); die; } $sets = array(); while ($row = $res->fetchRow()) { $imageOptions = array('img_path' => $row['img_path'], 'size' => 118, 'img_ar' => $row['img_ar'], 'linkURL' => $CFG->shortbase . "/set/" . $row['set_id'], 'vAlign' => "center", 'hAlign' => "left"); $set = array('set_id' => $row['set_id'], 'set_name' => $row['name'], 'total_objects' => $row['total_objects'], 'thumb' => outputSimpleImage($imageOptions)); array_push($sets, $set); } // Free the result $res->free(); // Display template $t->assign('sets', $sets); // Display template $t->display('frontpage/frontpage.tpl'); //Die here or additional PHP lines will be excecuted. die;
$res =& $db->query($sql); if (PEAR::isError($res)) { die($res->getMessage()); } // If nothing is found... if ($res->numRows() < 1) { $t->assign('setHasObjects', false); $t->assign('objectCount', null); $t->assign('objects', null); $t->assign('firstObjectID', null); } else { $t->assign('setHasObjects', true); $objects = array(); while ($row = $res->fetchRow()) { $imageOptions = array('img_path' => $row['img_path'], 'size' => 50, 'img_ar' => $row['img_ar'], 'vAlign' => "center", 'hAlign' => "left"); $object = array('id' => $row['id'], 'name' => $row['name'], 'description' => $row['description'], 'thumb' => outputSimpleImage($imageOptions)); array_push($objects, $object); } $t->assign('objectCount', $res->numRows()); $t->assign('objects', $objects); $t->assign('firstObjectID', $objects[0]['id']); } $res->free(); /********************************** DISPLAY TEMPLATE ***********************************/ $t->assign("templateVarsJSON", json_encode($t->_tpl_vars)); $t->display('viewset.tpl'); ?>
// Query objects $objResults = queryObjects($catIDs, $kwds, $tag, $user, $page - 1, $pageSize, $images); // Get object thumbs $objects = array(); if (empty($objResults['objects'])) { $t->assign('pager', ""); $t->assign('results_total', 0); $t->assign('results_start', 0); $t->assign('results_end', 0); //if( $images ) $t->assign('toggleImages', $images); } else { foreach ($objResults['objects'] as $obj) { $obj['img_path'] ? $img_path = $obj['img_path'] : ($obj['img_path'] = "noObjectImage"); $imageOptions = array('img_path' => $obj['img_path'], 'size' => 90, 'img_ar' => $obj['aspectRatio'], 'linkURL' => $CFG->shortbase . "/object/" . $obj['id'], 'vAlign' => "center", 'hAlign' => "center"); $obj['thumb'] = outputSimpleImage($imageOptions); $objects[] = $obj; } $t->assign('pager', themePager($page, $objResults['nPages'], "cats=10004")); $t->assign('results_total', $objResults['nObjs']); $t->assign('results_start', $page * $objResults['pageSize'] - $objResults['pageSize'] + 1); $t->assign('results_end', $page * $objResults['pageSize'] <= $objResults['nObjs'] ? $page * $objResults['pageSize'] : $objResults['nObjs']); $t->assign('facets', queryResultsCategories($catIDs, $kwds, $tag, $user, $images, "HTML_UL_ATAG", "id_")); $t->assign('toggleImages', $images); } // print_r($objects); $t->assign('objects', $objects); $rawfilters = getFilters($kwds, $catIDs); $tagname = $tag ? getTagNameByID($tag) : false; $t->assign('filters', themeFilters($rawfilters, $tagname, $user)); $t->assign('page_title', filtersToNameList($rawfilters, $tagname) . ' - PAHMA Delphi Search Results');
// If there are no more objects in the set, show the "no objects" image $imageOptions = array('img_path' => "noSetObjects", 'size' => 50, 'img_ar' => "1.065", 'linkURL' => $CFG->shortbase . "/set/" . $set_id, 'vAlign' => "center", 'hAlign' => "center"); $response['updateThumb'] = true; $response['thumbDiv'] = outputSimpleImage($imageOptions); $response['set_id'] = $set_id; } elseif ($order == 1) { // If the removed object was first in the set, get the new set thumb $sql = "\tSELECT order_num, set_objs.set_id, objects.id, objects.img_path, objects.img_ar FROM set_objs\n\t\t\t\t\t\tJOIN objects\n\t\t\t\t\t\tON objects.id = set_objs.obj_id\n\t\t\t\t\t\tWHERE set_objs.order_num= 2 AND set_objs.set_id = {$set_id}\n\t\t\t\t\t\tLIMIT 1\n\t\t\t\t\t"; $res =& $db->query($sql); if (PEAR::isError($res)) { die($res->getMessage()); } while ($row = $res->fetchRow()) { $imageOptions = array('img_path' => $row['img_path'], 'size' => 50, 'img_ar' => $row['img_ar'], 'linkURL' => $CFG->shortbase . "/set/" . $row['set_id'], 'vAlign' => "center", 'hAlign' => "center"); $response['updateThumb'] = true; $response['thumbDiv'] = outputSimpleImage($imageOptions); $response['set_id'] = $set_id; } } else { $response['updateThumb'] = false; } // If the order of the deleted object is less than the current number of objects in the set (plus 1) // then we need to update the order column for all the objects in the set between the object // ordered just after the deleted object through to the last object. if ($order < $count + 1) { // Get all the objects that need new orders $sql = "\tSELECT * FROM set_objs\n\t\t\t\t\t\tWHERE set_id = {$set_id} AND order_num > {$order}\n\t\t\t\t\t\tORDER BY order_num ASC\n\t\t\t\t\t"; $res =& $db->query($sql); if (PEAR::isError($res)) { die($res->getMessage()); }