chamilo-lms2/main/forum/download.php

<?php
/* For licensing terms, see /license.txt */

/**
 * This file is responsible for  passing requested documents to the browser.
 * Html files are parsed to fix a few problems with URLs,
 * but this code will hopefully be replaced soon by an Apache URL
 * rewrite mechanism.
 *
 * @package chamilo.document
 */

session_cache_limiter('public');

require_once __DIR__.'/../inc/global.inc.php';
$this_section = SECTION_COURSES;

require_once 'forumconfig.inc.php';

// IMPORTANT to avoid caching of documents
header('Expires: Wed, 01 Jan 1990 00:00:00 GMT');
header('Cache-Control: public');
header('Pragma: no-cache');

//protection
api_protect_course_script(true);

$doc_url = $_GET['file'];
//change the '&' that got rewritten to '///' by mod_rewrite back to '&'
$doc_url = str_replace('///', '&', $doc_url);
//still a space present? it must be a '+' (that got replaced by mod_rewrite)
$doc_url = str_replace(' ', '+', $doc_url);
$doc_url = str_replace('/..', '', $doc_url); //echo $doc_url;

if (!isset($_course)) {
    api_not_allowed(true);
}

$full_file_name = api_get_path(SYS_COURSE_PATH).api_get_course_path().'/upload/forum/'.$doc_url;

//if the rewrite rule asks for a directory, we redirect to the document explorer
if (is_dir($full_file_name)) {
    //remove last slash if present
    //mod_rewrite can change /some/path/ to /some/path// in some cases, so clean them all off (René)
    while ($doc_url{$dul = strlen($doc_url) - 1} == '/') {
        $doc_url = substr($doc_url, 0, $dul);
    }
    //create the path
    $document_explorer = api_get_path(WEB_COURSE_PATH).api_get_course_path();
    //redirect
    header('Location: '.$document_explorer);
    exit;
}

$tbl_forum_attachment = Database::get_course_table(TABLE_FORUM_ATTACHMENT);
$tbl_forum_post = Database::get_course_table(TABLE_FORUM_POST);

$course_id = api_get_course_int_id();
$courseInfo = api_get_course_info_by_id($course_id);

// launch event
Event::event_download($doc_url);

$sql = 'SELECT thread_id, forum_id,filename
        FROM '.$tbl_forum_post.'  f
        INNER JOIN '.$tbl_forum_attachment.' a
        ON a.post_id=f.post_id
        WHERE
            f.c_id = '.$course_id.' AND
            a.c_id = '.$course_id.' AND
            path LIKE BINARY "'.$doc_url.'"';

$result = Database::query($sql);
$row = Database::fetch_array($result);

$forum_thread_visibility = api_get_item_visibility(
    $courseInfo,
    TOOL_FORUM_THREAD,
    $row['thread_id'],
    api_get_session_id()
);
$forum_forum_visibility = api_get_item_visibility(
    $courseInfo,
    TOOL_FORUM,
    $row['forum_id'],
    api_get_session_id()
);

if ($forum_thread_visibility == 1 && $forum_forum_visibility == 1) {
    if (Security::check_abs_path(
        $full_file_name,
        api_get_path(SYS_COURSE_PATH).$courseInfo['path'].'/upload/forum/')
    ) {
        DocumentManager::file_send_for_download(
            $full_file_name,
            true,
            $row['filename']
        );
    }
}
exit;