//count $prs = $xoopsDB->query("SELECT COUNT(lid) FROM {$table_photos} WHERE status>0"); list($photo_num_total) = $xoopsDB->fetchRow($prs); $xoopsTpl->assign('photo_num_total', sprintf(_MD_GNAV_CAT_THEREARE, $photo_num_total)); $photo_small_sum = $photo_num_total; //breadcrumbs if ($gnavi_indexpage == 'map') { $xoops_breadcrumbs[] = array('url' => XOOPS_URL . '/modules/' . $mydirname . '/index.php', 'name' => $xoopsModule->getVar('name')); $xoops_breadcrumbs[] = array('name' => _MD_GNAV_CAT_ITEMLIST); $pagetitle = _MD_GNAV_CAT_ITEMLIST; } else { $xoops_breadcrumbs[] = array('name' => $xoopsModule->getVar('name')); $pagetitle = $xoopsModule->getVar('name'); } $xoopsTpl->assign('subcategories', gnavi_get_sub_categories(0, $cattree)); $xoopsTpl->assign('category_options', gnavi_get_cat_options()); if ($gnavi_mobile_useqr) { if (!is_file("{$qrimg_dir}/index.png")) { gnavi_check_folders(); if (is_file($gnavi_qrcode_path)) { require_once $gnavi_qrcode_path; $qrimage = new Qrcode_image(); $qrimage->set_module_size($gnavi_mobile_useqr); $qrimage->qrcode_image_out("{$mod_url}/", "png", "{$qrimg_dir}/index.png"); $xoopsTpl->assign('qrimg', "{$qrimg_url}/index.png"); } } else { $xoopsTpl->assign('qrimg', "{$qrimg_url}/index.png"); } } $where = "cid > 0";
$photonavinfo = sprintf(_MD_GNAV_NAV_ITEMPOS, $pos + 1, $last, $numrows); // Options for the number of photos in a display $numbers = explode('|', '10|20|50|100'); $num_options = ''; foreach ($numbers as $number) { $number = intval($number); if ($number < 1) { continue; } $selected = $number == $num ? "selected='selected'" : ""; $num_options .= "<option value='{$number}' {$selected}>" . sprintf(_MD_A_GNAVI_FMT_PHOTONUM, $number) . "</option>\n"; } gnavi_get_cat_options(); // Options for Selecting a category $cat_options = gnavi_get_cat_options('title', $cid, '--', '----'); $cat_options_for_update = gnavi_get_cat_options('title', 0, '--', _MD_A_GNAVI_OPT_NOCHANGE); // Options for Selecting a user $user_options = "<option value='0'>" . _MD_A_GNAVI_OPT_NOCHANGE . "</option>\n"; $urs = $xoopsDB->query("SELECT uid,uname FROM " . $xoopsDB->prefix("users") . " ORDER BY uname"); while (list($uid, $uname) = $xoopsDB->fetchRow($urs)) { $user_options .= "<option value='{$uid}'>" . htmlspecialchars($uname, ENT_QUOTES) . "</option>\n"; } // Start of outputting xoops_cp_header(); include dirname(__FILE__) . '/mymenu.php'; // check $xoopsModule if (!is_object($xoopsModule)) { redirect_header("{$mod_url}/", 1, _NOPERM); } echo "<h3 style='text-align:left;'>" . sprintf(_MD_A_GNAVI_FMT_PHOTOMANAGER, $xoopsModule->name()) . "</h3>\n"; gnavi_opentable();