';
return $ret;
}
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 = "
SELECT
`media`.`med_id`,
`media`.`med_prof_id`,
`media`.`med_type`,
`media`.`med_file`,
`media`.`med_title`
FROM `media`
WHERE 1
$sAdd
ORDER BY `media`.`med_date`
";
$res = db_res( $sQuery );
$ret = fill_assoc_array( $res );
return $ret;
}
function deleteItem( $iMedia )
{
global $dir;
$aFile = db_arr("SELECT * FROM `media` WHERE `med_id`='$iMedia'");
$sIconFile = $dir['profileImage'] . $aFile['med_prof_id'] . '/icon_' . $aFile['med_file'];
$sThumbFile = $dir['profileImage'] . $aFile['med_prof_id'] . '/thumb_' . $aFile['med_file'];
$sPhotoFile = $dir['profileImage'] . $aFile['med_prof_id'] . '/photo_' . $aFile['med_file'];
$sqlQuery = "
DELETE FROM `media` WHERE `med_id` = '$iMedia';
";
$res = db_res( $sqlQuery );
// delete votings
require_once( BX_DIRECTORY_PATH_CLASSES . 'BxDolVoting.php' );
$oVotingMedia = new BxDolVoting ('media', 0, 0);
$oVotingMedia->deleteVotings ($aMedia['med_id']);
@unlink( $sIconFile );
@unlink( $sThumbFile );
@unlink( $sPhotoFile );
return $res;
}
function approveItem( $iMedia )
{
$sQuery = "
UPDATE `media`
SET
`med_status` = 'active'
WHERE `med_id` = '$iMedia'
";
return db_res( $sQuery );
}
function approveAllItems()
{
$sQuery = "
UPDATE `media`
SET
`med_status` = 'active'
";
return db_res( $sQuery );
}
?>