$_page['header_text'] = _t("_browsePhoto"); $_ni = $_page['name_index']; $member['ID'] = (int) $_COOKIE['memberID']; $aWhere = array(); $aWhere[] = '1'; if (isset($_GET['userID'])) { $iUser = (int) $_GET['userID']; $aWhere[] = "`sharePhotoFiles`.`medProfId`={$iUser}"; } if (isset($_GET['tag'])) { $sTag = htmlspecialchars_adv($_GET['tag']); $aWhere[] = "`sharePhotoFiles`.`medTags` like '%{$sTag}%'"; } if (isset($_GET['action'])) { $sAct = htmlspecialchars_adv($_GET['action']); $sAddon = defineBrowseAction($sAct, 'Photo', $member['ID']); } $sqlWhere = "WHERE " . implode(' AND ', $aWhere) . $sAddon . " AND `Approved`= 'true'"; $iTotalNum = db_value("SELECT COUNT( * ) FROM `sharePhotoFiles` {$sqlWhere}"); if (!$iTotalNum) { $_page_cont[$_ni]['page_main_code'] = _t('_Sorry, nothing found'); PageCode(); exit; } $iPerPage = (int) $_GET['per_page']; if (!$iPerPage) { $iPerPage = 10; } $iTotalPages = ceil($iTotalNum / $iPerPage); $iCurPage = (int) $_GET['page']; if ($iCurPage > $iTotalPages) {
$_page['header_text'] = _t("_browseMusic"); $_ni = $_page['name_index']; $member['ID'] = (int) $_COOKIE['memberID']; $aWhere = array(); $aWhere[] = '1'; if (isset($_GET['userID'])) { $iUser = (int) $_GET['userID']; $aWhere[] = "`RayMusicFiles`.`Owner`={$iUser}"; } if (isset($_GET['tag'])) { $sTag = htmlspecialchars_adv($_GET['tag']); $aWhere[] = "`RayMusicFiles`.`Tags` like '%{$sTag}%'"; } if (isset($_GET['action'])) { $sAct = htmlspecialchars_adv($_GET['action']); $sAddon = defineBrowseAction($sAct, 'Music', $member['ID']); } $sqlWhere = "WHERE " . implode(' AND ', $aWhere) . $sAddon . " AND `Approved`= 'true'"; $iTotalNum = db_value("SELECT COUNT( * ) FROM `RayMusicFiles` {$sqlWhere}"); if (!$iTotalNum) { $_page_cont[$_ni]['page_main_code'] = _t('_Sorry, nothing found'); PageCode(); exit; } $iPerPage = (int) $_GET['per_page']; if (!$iPerPage) { $iPerPage = 10; } $iTotalPages = ceil($iTotalNum / $iPerPage); $iCurPage = (int) $_GET['page']; if ($iCurPage > $iTotalPages) {