$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; }