}
$iTotalPages = ceil($iTotalNum / $iPerPage);
$iCurPage = (int) $_GET['page'];
if ($iCurPage > $iTotalPages) {
    $iCurPage = $iTotalPages;
}
if ($iCurPage < 1) {
    $iCurPage = 1;
}
$sLimitFrom = ($iCurPage - 1) * $iPerPage;
$aSqlQuery['sqlLimit'] = "LIMIT {$sLimitFrom}, {$iPerPage}";
$aSqlQuery['sqlOrder'] = "ORDER BY `{$oNew->aTableFields['medDate']}` DESC";
$aManage = array('medID', 'medProfId', 'medTitle', 'medUri', 'medDate', 'medViews', 'medExt', 'Approved');
if ($iTotalNum > 0) {
    $aCount = array('total' => $iTotalPages, 'current' => $iCurPage, 'per_page' => $iPerPage);
    $rData = $oNew->getFilesList($aSqlQuery, $aManage);
    $sCode = browseCode($oNew, $rData, $aCount);
}
TopCodeAdmin();
ContentBlockHead("List of {$sBigType} files");
echo $sCode;
ContentBlockFoot();
BottomCode();
function browseCode($oNew, $rData, $aCount)
{
    $sCode = '<div id="browseMain"><form method="post" action="">';
    $iCount = mysql_num_rows($rData);
    $sCheckAll = $iCount > 1 ? '<input type="checkbox" name=\\"ch_all" onclick="checkAll( \'Check[]\', this.checked )" />Check all' : '';
    if ($iCount) {
        while ($aData = mysql_fetch_array($rData)) {
            $sCode .= $oNew->showBrowseUnit($aData, true);
***************************************************************************/
require_once 'inc/header.inc.php';
require_once BX_DIRECTORY_PATH_INC . 'sharing.inc.php';
require_once BX_DIRECTORY_PATH_CLASSES . 'BxDolSharedMedia.php';
check_logged();
$member['ID'] = (int) $_COOKIE['memberID'];
$oNew = new BxDolSharedMedia('music', $site, $dir, $member);
$_page['name_index'] = 82;
$_page['css_name'] = $oNew->sCssName;
$_page['header'] = _t("_browseMusic");
$_page['header_text'] = _t("_browseMusic");
$_ni = $_page['name_index'];
$aCondition = $oNew->getConditionArray($logged);
if ($aCondition !== false) {
    $aSqlQuery = $aCondition['query'];
    $iTotalPages = $aCondition['total'];
    $iCurPage = $aCondition['cur_page'];
    $iPerPage = $aCondition['per_page'];
} else {
    $_page_cont[$_ni]['page_main_code'] = _t('_Sorry, nothing found');
    PageCode();
    exit;
}
$rData = $oNew->getFilesList($aSqlQuery);
while ($aData = mysql_fetch_assoc($rData)) {
    $sCode .= $oNew->showBrowseUnit($aData);
}
$sCode .= '<div class="clear_both"></div>';
$sCode .= $oNew->showPagination($iTotalPages, $iCurPage, $iPerPage);
$_page_cont[$_ni]['page_main_code'] = $sCode;
PageCode();