$sqlQuery = "SELECT \r\n\t\t\t\t`RayMp3Files`.`ID` as `medID`,\r\n\t\t\t\t`RayMp3Files`.`Title` as `medTitle`,\r\n\t\t\t\t`RayMp3Files`.`Description` as `medDesc`,\r\n\t\t\t\t`RayMp3Files`.`Owner` as `medProfId`,\r\n\t\t\t\t`RayMp3Files`.`Date` as `medDate`,\r\n\t\t\t\t`RayMp3Files`.`Approved`,\r\n\t\t\t\t`Profiles`.`NickName`\r\n\t\t\t\tFROM `RayMp3Files`\r\n\t\t\t\tLEFT JOIN `Profiles` ON `Profiles`.`ID`=`RayMp3Files`.`Owner`\r\n\t\t\t\t";
$sqlWhere = $iUser == 0 ? "WHERE `Owner`<>'0'" : "WHERE `Owner`='{$iUser}'";
$iTotalNum = db_value("SELECT COUNT( * ) FROM `RayMp3Files` LEFT JOIN `Profiles` ON `Profiles`.`ID`=`RayMp3Files`.`Owner` {$sqlWhere}");
$iPerPage = 10;
$iTotalPages = ceil($iTotalNum / $iPerPage);
$iCurPage = (int) $_GET['page'];
if ($iCurPage > $iTotalPages) {
$iCurPage = $iTotalPages;
}
if ($iCurPage < 1) {
$iCurPage = 1;
}
$sLimitFrom = ($iCurPage - 1) * $iPerPage;
$sqlLimit = "LIMIT {$sLimitFrom}, {$iPerPage}";
$res = db_res($sqlQuery . $sqlWhere . $sqlLimit);
$aFiles = fill_assoc_array($res);
TopCodeAdmin();
ContentBlockHead("");
echo getPostModMediaPage($iUser);
ContentBlockFoot();
BottomCode();
function getPostModMediaPage($iUser = 0)
{
global $dir, $site, $max_thumb_width, $max_thumb_height, $max_photo_width, $max_photo_height;
global $aFiles;
global $iTotalPages, $iCurPage;
$ret = '';
$ret .= "<script>\r\n\tfunction checkAll( _pref, do_check )\r\n\t{\r\n\t\taElems = document.getElementsByTagName( 'input' );\r\n\t\t\r\n\t\tfor( i = 0; i < aElems.length; i ++ )\r\n\t\t{\r\n\t\t\telt = aElems[i];\r\n\t\t\tif( elt.name.substr( 0, _pref.length ) == _pref )\r\n\t\t\t\telt.checked = do_check;\r\n\t\t}\r\n\t}\r\n\t</script>";
$ret .= '<div><form method="post" action="' . $_HTTP['REFERER'] . '">';
$iCounter = 1;
foreach ($aFiles as $aMedia) {
function getUnapprovedFilesArray($sType, $sStatus, $iUser)
{
$ret = '';
$sAdd = "AND `med_status` = '{$sStatus}'";
$sAdd .= " AND `med_type` = '{$sType}'";
$sAdd .= $iUser != 0 ? " AND `med_prof_id`='{$iUser}'" : "";
$sQuery = "\r\n\t\tSELECT\r\n\t `media`.`med_id`,\r\n\t `media`.`med_prof_id`,\r\n\t `media`.`med_type`,\r\n\t `media`.`med_file`,\r\n\t `media`.`med_title`\r\n\t FROM `media`\r\n\t WHERE 1\r\n\t {$sAdd}\r\n \r\n\t ORDER BY `media`.`med_date`\r\n\t";
$res = db_res($sQuery);
$ret = fill_assoc_array($res);
return $ret;
}
function getGroupsCategList($sOrderBy = 'ID')
{
$resCategs = db_res("\r\n\t\tSELECT\r\n\t\t\t`GroupsCateg`.*,\r\n\t\t\tCOUNT(`Groups`.`ID`) AS `groupsCount`\r\n\t\tFROM `GroupsCateg`\r\n\t\tLEFT JOIN `Groups`\r\n\t\tON ( `Groups`.`categID` = `GroupsCateg`.`ID` AND `Groups`.`status` = 'Active' )\r\n\t\tGROUP BY `GroupsCateg`.`ID`\r\n\t\tORDER BY `GroupsCateg`.`{$sOrderBy}`\r\n\t\t");
$arrCategs = fill_assoc_array($resCategs);
return $arrCategs;
}
function getUnapprovedFilesArray($sType, $sStatus, $iUser, $sqlLimit = '')
{
$ret = '';
$sAdd = "AND `med_status` = '{$sStatus}'";
$sAdd .= " AND `med_type` = '{$sType}'";
$sAdd .= $iUser != 0 ? " AND `med_prof_id`='{$iUser}'" : "";
$sQuery = "\r\n\t\tSELECT\r\n\t `media`.`med_id` as `medID`,\r\n\t `media`.`med_prof_id` as `medProfId`,\r\n\t `media`.`med_type` as `medType`,\r\n\t `media`.`med_file` as `medFile`,\r\n\t `media`.`med_title` as `medTitle`,\r\n\t UNIX_TIMESTAMP(`media`.`med_date`) as `medDate`,\r\n\t `Profiles`.`NickName`\r\n\t FROM `media`\r\n\t LEFT JOIN `Profiles` ON `Profiles`.`ID`=`media`.`med_prof_id`\r\n\t WHERE 1\r\n\t {$sAdd}\r\n \r\n\t ORDER BY `media`.`med_date`\r\n\t\t{$sqlLimit}\r\n\t";
$res = db_res($sQuery);
$ret = fill_assoc_array($res);
return $ret;
}
