getExtraJs(); if ( !( $logged['admin'] = member_auth( 1, false ) ) ) { if ( !( $logged['member'] = member_auth( 0, false ) ) ) { if ( !( $logged['aff'] = member_auth( 2, false ) ) ) { $logged['moderator'] = member_auth( 3, false ); } } } $_page['header'] = _t( "_browseVideo" ); $_page['header_text'] = _t("_browseVideo"); $_ni = $_page['name_index']; $member['ID'] = (int)$_COOKIE['memberID']; $aWhere = array(); $aWhere[] = '1'; if (isset($_GET['userID'])) { $iUser = (int)$_GET['userID']; $aWhere[] = "`RayMovieFiles`.`Owner`=$iUser"; } if (isset($_GET['tag'])) { $sTag = htmlspecialchars_adv($_GET['tag']); $aWhere[] = "`RayMovieFiles`.`Tags` like '%$sTag%'"; } if (isset($_GET['action'])) { $sAct = htmlspecialchars_adv($_GET['action']); $sAddon = defineBrowseAction($sAct,'Video',$member['ID']); } $sqlWhere = "WHERE " . implode( ' AND ', $aWhere ).$sAddon." AND `Approved`= 'true'"; $iTotalNum = db_value( "SELECT COUNT( * ) FROM `RayMovieFiles` $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 ) $iCurPage = $iTotalPages; if( $iCurPage < 1 ) $iCurPage = 1; $sLimitFrom = ( $iCurPage - 1 ) * $iPerPage; $sqlOrderBy = 'ORDER BY `medDate` DESC'; if (isset($_GET['rate'])) { $oVotingView = new BxTemplVotingView ('gvideo', 0, 0); $aSql = $oVotingView->getSqlParts('`RayMovieFiles`', '`ID`'); $sHow = $_GET['rate'] == 'top' ? "DESC" : "ASC"; $sqlOrderBy = $oVotingView->isEnabled() ? "ORDER BY `voting_rate` $sHow, `voting_count` $sHow, `medDate` $sHow" : $sqlOrderBy ; $sqlFields = $aSql['fields']; $sqlLJoin = $aSql['join']; } $sqlLimit = "LIMIT $sLimitFrom, $iPerPage"; $sQuery = " SELECT `RayMovieFiles`.`ID` as `medID`, `RayMovieFiles`.`Owner` as `medProfId`, `RayMovieFiles`.`Title` as `medTitle`, `RayMovieFiles`.`Date` as `medDate`, `RayMovieFiles`.`Views` as `medViews`, `Profiles`.`NickName` $sqlFields FROM `RayMovieFiles` LEFT JOIN `Profiles` ON `Profiles`.`ID` = `RayMovieFiles`.`Owner` $sqlLJoin $sqlWhere $sqlOrderBy $sqlLimit "; $rData = db_res($sQuery); $_page_cont[$_ni]['page_main_code'] = PageCompPageMainCode(); PageCode(); function PageCompPageMainCode() { global $site; global $rData; global $iTotalPages; global $iCurPage; global $iPerPage; global $member; $sCode = '
';
$sVidTitle = strlen($aData['medTitle']) > 0 ? $aData['medTitle'] : _t("_Untitled");
$sDelLink = $member['ID'] == $aData['medProfId'] ? '' : "" ;
$sCode .= '