$where .= "{$cidw},";
}
$where = substr($where, 0, -1);
$where = "(cid IN({$where}) or cid1 IN({$where}) or cid2 IN({$where}) or cid3 IN({$where}) or cid4 IN({$where}) )";
} else {
$where = "( cid={$cid} or cid1={$cid} or cid2={$cid} or cid3={$cid} or cid4={$cid} )";
}
$prs = $xoopsDB->query("SELECT COUNT(lid) FROM {$table_photos} WHERE {$where} AND status>0");
list($photo_small_sum) = $xoopsDB->fetchRow($prs);
$xoopsTpl->assign('photo_small_sum', $photo_small_sum);
//breadcrumbs
$xoops_breadcrumbs[] = array('url' => XOOPS_URL . '/modules/' . $mydirname . '/index.php', 'name' => $xoopsModule->getVar('name'));
if ($gnavi_indexpage == 'map') {
$xoops_breadcrumbs[] = array('url' => XOOPS_URL . '/modules/' . $mydirname . '/index.php?page=category', 'name' => _MD_GNAV_CAT_ITEMLIST);
}
$xoops_breadcrumbs = gnavi_add_breadcrumbs($pid, "index.php" . ($page_cat ? '?' . $page_cat : ''), $xoops_breadcrumbs);
$xoops_breadcrumbs[] = array('name' => $myts->makeTboxData4show($cat_title));
$xoopsTpl->assign('imgurl', $imgurl);
$xoopsTpl->assign('description', $description);
$get_append = "cid={$cid}";
} else {
if ($uid != 0) {
if ($uid < 0) {
// This means 'my photo'
$where = "submitter={$my_uid}";
$get_append = "uid=-1";
$xoopsTpl->assign('uid', -1);
$pagetitle = _MD_GNAV_CAT_MYPOST;
} else {
// uid Specified
$where = "submitter={$uid}";
if ($cid > 0) {
$rs = $xoopsDB->query("SELECT title,imgurl,kmlurl,description FROM {$table_cat} WHERE cid='{$cid}'");
list($cat_title, $imgurl, $kmlurl, $description) = $xoopsDB->fetchRow($rs);
$xoopsTpl->assign('cattitle', $cat_title);
$xoopsTpl->assign('catimgurl', $imgurl);
$xoopsTpl->assign('catdescription', $description);
}
$get_append = 'cid=' . $cid . '&lid=' . $lid;
$xoopsTpl->assign('link_option', $get_append ? "?" . $get_append : '');
$mapget_append = $get_append ? $get_append . '&page=map' : 'page=map';
$xoopsTpl->assign('maplink_option', $mapget_append ? "?" . $mapget_append : '');
$xoopsTpl->assign('category_id', $cid);
$cids = $cattree->getAllChildId($cid);
//breadcrumbs
$xoops_breadcrumbs[] = array('url' => XOOPS_URL . '/modules/' . $mydirname . '/index.php', 'name' => $xoopsModule->getVar('name'));
$xoops_breadcrumbs = gnavi_add_breadcrumbs($cid, "index.php?", $xoops_breadcrumbs);
$xoops_breadcrumbs[] = array('name' => $photo['title']);
$xoopsTpl->assign('xoops_breadcrumbs', $xoops_breadcrumbs);
//get icon
$icon = $photo['icd'] > 0 ? $photo['icd'] : gnavi_get_icon($cattree, $photo['cid'], $photo['cid1'], $photo['cid2'], $photo['cid3'], $photo['cid4'], $cid);
$arricon = gnavi_get_gicon($icon);
//kml settings
$mykmls = "";
if ($photo['mykmls']) {
$kmlurl = $kmlurl ? $photo['mykmls'] . ",'" . $kmlurl . "'" : $photo['mykmls'];
} else {
$kmlurl = $kmlurl ? "'" . $kmlurl . "'" : "";
}
if ($kmlurl) {
$mykmls = "gn_mykmls = new Array(" . $kmlurl . ");";
}