chamilo-lms2/main/newscorm/resourcelinker.php

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

/**
 * @author Patrick Cool, original code
 * @author Denes Nagy - many bugfixes and improvements, adjusted for learning path
 * @author Roan Embrechts - refactoring, code cleaning
 * @package chamilo.resourcelinker
 * @todo reorganise code,
 * use Database API instead of creating table names locally.
 */
/**
 * Code
 */
/* INIT SECTION */

// Flag to allow for anonymous user - needs to be set before global.inc.php.

use \ChamiloSession as Session;

$use_anonymous = true;

// Name of the language file that needs to be included.
$language_file = 'resourcelinker';

require_once '../inc/global.inc.php';

$this_section = SECTION_COURSES;

api_protect_course_script();

/* Libraries */

include 'resourcelinker.inc.php';

/* Constants and variables */

$link_table = Database :: get_course_table(TABLE_LINK);
$item_property_table = Database :: get_course_table(TABLE_ITEM_PROPERTY);

//$tbl_learnpath_main = Database :: get_course_table(TABLE_LEARNPATH_MAIN);
//$tbl_learnpath_chapter = Database :: get_course_table(TABLE_LEARNPATH_CHAPTER);
//$tbl_learnpath_item = Database :: get_course_table(TABLE_LEARNPATH_ITEM);
$tbl_lp = Database::get_course_table(TABLE_LP_MAIN);
$tbl_lp_item = Database::get_course_table(TABLE_LP_ITEM);

$action = $_REQUEST['action'];
$add = $_REQUEST['add'];
$chapter_id = $_REQUEST['parent_item_id'];
$content = $_REQUEST['content'];
// Note by Patrick Cool: This has been solved belowd. This piece of code hacking produced too much errors.
/*
if (empty($content)) {
    // Adds a default to the item-type selection.
    $content = 'Document';
}
*/
$folder = $_REQUEST['folder'];
$id = $_REQUEST['id'];
$learnpath_id = $_REQUEST['lp_id'];
$originalresource = $_REQUEST['originalresource'];
$show_resources = $_REQUEST['show_resources'];
$source_forum = $_REQUEST['source_forum'];
$source_id = $_REQUEST['source_id'];
$target = $_REQUEST['target'];
$external_link = $_REQUEST['external_link'];

$from_learnpath = $_SESSION['from_learnpath'];

// This variable controls wether the link to add a chapter in a module or
// another chapter is shown. This allows to create multi-level learnpaths,
// but export features are not ready for this, yet, so use at your own risks
// default : false -> do not display link
// This setting should be moved to the platform configuration page in time...
$multi_level_learnpath = true;

/* MAIN CODE */

if ($from_learnpath == 'yes') {
    // Start from clear every time in LearnPath Builder.
    $_SESSION['addedresource'] = null;
    $_SESSION['addedresourceid'] = null;
    $_SESSION['addedresourceassigned'] = null;
    unset ($_SESSION['addedresource']);
    unset ($_SESSION['addedresourceid']);
    unset ($_SESSION['addedresourceassigned']);
}

$course_id = api_get_course_int_id();

// Process a new chapter?
if (!empty ($_POST['add_chapter']) && !empty ($_POST['title'])) {
    $title = $_POST['title'];
    $description = '';
    /*if (!empty ($_POST['description'])) {
        $description = $_POST['description'];
    }*/

    // Get max display_order so far in this parent chapter.
    $sql = "SELECT MAX(display_order) as maxi FROM $tbl_lp_item ".
        "WHERE c_id = $course_id AND lp_id = $learnpath_id ".
        " AND parent_item_id = $chapter_id";
    $res = Database::query($sql);
    $row = Database::fetch_array($res);
    $lastorder_item = $row['maxi'];
    if (empty($lastorder_item)) {
        $lastorder_item = 0;
        $previous = 0;
    } else {
        $sql = "SELECT id FROM $tbl_lp_item ".
            "WHERE lp_id = $learnpath_id AND parent_item_id=$chapter_id AND display_order = $lastorder_item";
        $result = Database::query($sql);
        $row = Database::fetch_array($result);
        $previous = $row['id'];
    }
    $order = $lastorder_item + 1;

    $sql = "INSERT INTO $tbl_lp_item "."(c_id, lp_id,item_type,title,parent_item_id,previous_item_id, next_item_id, display_order) ".
        "VALUES "."($course_id, $learnpath_id,'dokeos_chapter','$title', $chapter_id, $previous, 0, $order )";
    //error_log('New LP - Inserting new resource: '.$sql, 0);
    $res = Database::query($sql);
    $my_id = Database::insert_id($res);
    if ($previous > 0) {
        $sql = "UPDATE $tbl_lp_item SET next_item_id = $my_id WHERE id=$previous";
        $res = Database::query($sql);
    }
    if ($res !== false) {
        $title = '';
        $description = '';
    }
    $resource_added = true;
}

// This if when a external link is submitted.
if (!empty ($_POST['external_link_submit'])) {
    if ($external_link == '' || $external_link == 'http://') {
        $InvalidURL = 1;
    } else {
        $add = true;
        if ($add_2_links != 'niet toevoegen') {
            // Add external link to the links table.
            $pos = strpos($external_link, 'ttp:');
            if ($pos == '') {
                $external_link = 'http://'.$external_link;
            }

            $sql = "INSERT INTO $link_table (c_id, url, title, category_id) VALUES ($course_id, '$external_link','$external_link','$add_2_links')";
            $result = Database::query($sql);
            $addedresource[] = "Link";
            $addedresourceid[] = Database::insert_id();
            $_SESSION['addedresource'] = $addedresource;
            $_SESSION['addedresourceid'] = $addedresourceid;
        } else {
            // Do not add external link to the links table.
            $addedresource[] = "Externallink";
            $addedresourceid[] = $external_link;
            $_SESSION['addedresource'] = $addedresource;
            $_SESSION['addedresourceid'] = $addedresourceid;
        }
    }
}

// Loading the session variables into local array.
$addedresource = $_SESSION['addedresource'];
$addedresourceid = $_SESSION['addedresourceid'];

// This is when a resource was added to the session.
if ($add) {
    // Adding the new variable to the local array.
    if (empty($_POST['external_link_submit'])) {
        // That case is already arranged, see upwards.
        $addedresource[] = $content;
        $addedresourceid[] = $add;
    }
    $addedresourceassigned[] = 0;

    // Loading the local array into the session variable.
    $_SESSION['addedresource'] = $addedresource;
    $_SESSION['addedresourceid'] = $addedresourceid;

    // We assign to chapters immediately!
    $resource_added = false;
    if ($from_learnpath == 'yes') {
        $i = 0;
        // Calculating the last order of the items of this chapter.
        $sql = "SELECT MAX(display_order) as maxi FROM $tbl_lp_item ".
            "WHERE c_id = $course_id AND lp_id = $learnpath_id AND parent_item_id=$chapter_id";
        $result = Database::query($sql);
        $row = Database::fetch_array($result);
        $lastorder_item = $row['maxi'];
        if (empty($lastorder_item)) {
            $lastorder_item = 0;
            $previous = 0;
        } else {
            $sql = "SELECT id FROM $tbl_lp_item ".
                "WHERE lp_id = $learnpath_id AND parent_item_id=$chapter_id AND display_order = $lastorder_item";
            //error_log('New LP - resourcelinker.php - '.$sql, 0);
            $result = Database::query($sql);
            $row = Database::fetch_array($result);
            $previous = $row['id'];
        }
        $lastorder = $lastorder_item + 1;
        foreach ($addedresource as $addedresource_item) {
            // In the case we added a chapter, add this into the chapters list with the correct parent_id.
            if ($addedresource_item == 'Chap') {
                $sql = "INSERT INTO $tbl_lp_item ".
                    "(c_id, lp_id,item_type,title,parent_item_id,previous_item_id,next_item_id,display_order) ".
                    "VALUES ($course_id, ".$learnpath_id.",'dokeos_chapter','".$learnpath_chapter_name."',".$chapter_id.",$previous,0,".$lastorder.")";
                //error_log('New LP - Inserting new resource: '.$sql, 0);
                $res = Database::query($sql);
                $my_id = Database::insert_id($res);
                if ($previous > 0) {
                    $sql = "UPDATE $tbl_lp_item SET next_item_id = $my_id WHERE id=$previous";
                    $res = Database::query($sql);
                }
            }

            if (!$addedresourceassigned[$i]) {
                // Not to assign it twice
                switch ($addedresource_item) {
                    case 'Assignment':
                    case 'Ass':
                        //set tool type
                        $addedresource_item = 'Assignments';
                        $title = get_lang('Assignments');
                        break;
                    case 'Drop':
                        //$addedresource_item = 'Dropbox';
                        $addedresource_item = TOOL_DROPBOX;
                        $title = get_lang('Dropbox');
                        break;
                    case 'Intro':
                        $addedresource_item = 'Introduction_text';
                        //$addedresource_item = TOOL_INTRO;
                        $title = get_lang('IntroductionText');
                        break;
                    case 'Course_desc':
                        //$addedresource_item = 'Course_description';
                        $addedresource_item = TOOL_COURSE_DESCRIPTION;
                        $title = get_lang('CourseDescription');
                        break;
                    case 'Group':
                        //$addedresource_item = 'Groups';
                        $addedresource_item = TOOL_GROUP;
                        $title = get_lang('Groups');
                        break;
                    case 'User':
                        //$addedresource_item = 'Users';
                        $addedresource_item = TOOL_USER;
                        $title = get_lang('Users');
                        break;
                    case 'Link':
                        /*
                        if ($target == '') {
                            $target = '_self';
                        }
                        */
                        //$addedresource_item .= ' '.$target;
                        //error_log('New LP - resourcelinker.php - In Link addition: '.$external_link);
                        $addedresource_item = TOOL_LINK;
                        $title = $external_link;
                        break;
                    case 'Document':
                        $addedresource_item = TOOL_DOCUMENT;
                        //get title from tool-type table
                        $tooltable = Database::get_course_table(TABLE_DOCUMENT);
                        $result = Database::query("SELECT * FROM $tooltable WHERE id=".$addedresourceid[$i]);
                        $myrow = Database::fetch_array($result);
                        $title = $myrow['title'];
                        break;
                    case 'Exercise':
                        $addedresource_item = TOOL_QUIZ;
                        //get title from tool-type table
                        $tooltable = Database::get_course_table(TABLE_QUIZ_TEST);
                        $result = Database::query("SELECT * FROM $tooltable WHERE iid = ".$addedresourceid[$i]);
                        $myrow = Database::fetch_array($result);
                        $title = $myrow['title'];
                        break;
                    case 'Forum':
                        $addedresource_item = TOOL_FORUM;
                        //TODO
                        break;
                    case 'Agenda':
                        $addedresource_item = TOOL_CALENDAR_EVENT;
                        //get title from tool-type table
                        $tooltable = Database::get_course_table(TABLE_AGENDA);
                        $result = Database::query("SELECT * FROM $tooltable WHERE id=".$addedresourceid[$i]);
                        $myrow = Database::fetch_array($result);
                        $title = $myrow['title'];
                        break;
                    case 'Ad_Valvas':
                        $addedresource_item = TOOL_ANNOUNCEMENT;
                        //get title from tool-type table
                        $tooltable = Database::get_course_table(TABLE_ANNOUNCEMENT);
                        $result = Database::query("SELECT * FROM $tooltable WHERE id=".$addedresourceid[$i]);
                        $myrow = Database::fetch_array($result);
                        $title = $myrow['title'];
                        break;

                }
                $sql = "INSERT INTO $tbl_lp_item (c_id, lp_id, title, parent_item_id, item_type, ref, previous_item_id, next_item_id, display_order) ".
                    "VALUES ($course_id, $learnpath_id, '$title','$chapter_id', '$addedresource_item','$addedresourceid[$i]',$previous,0,'".$lastorder."')";
                //error_log('New LP - Inserting new resource: '.$sql, 0);
                $result = Database::query($sql);
                $my_id = Database::insert_id($result);
                if ($previous > 0) {
                    $sql = "UPDATE $tbl_lp_item SET next_item_id = $my_id WHERE id = $previous";
                    //error_log($sql, 0);
                    $res = Database::query($sql);
                }
                $addedresourceassigned[$i] = 1;
                $resource_added = true;
            }
            $i++;
            $lastorder++;
        }
        //$_SESSION['addedresource']=null;
        //$_SESSION['addedresourceid']=null;
        // cleaning up the session once again
        $_SESSION['addedresource'] = null;
        $_SESSION['addedresourceid'] = null;
        $_SESSION['addedresourceassigned'] = null;
        unset ($_SESSION['addedresource']);
        unset ($_SESSION['addedresourceid']);
        unset ($_SESSION['addedresourceassigned']);
    }
}

/*
    BREADCRUMBS
    This part is to allow going back to the tool where you came from
    in a previous version I used the table tool_list, but since the forum can access the
    resource_linker from two different pages (newtopic.php and editpost.php) and this is different
    from the link field in tool_list, I decide to hardcode this stuff here.
    By doing this, you can easily control which pages can access the toollinker and which not.
*/

if (isset($_SESSION['gradebook'])) {
    $gradebook = $_SESSION['gradebook'];
}

if (!empty($gradebook) && $gradebook == 'view') {
    $interbreadcrumb[] = array(
        'url' => '../gradebook/'.$_SESSION['gradebook_dest'],
        'name' => get_lang('ToolGradebook')
    );
}

if ($_GET['source_id']) {
    switch ($_GET['source_id']) {
        case '1': // coming from Agenda
            if ($action == 'edit') {
                $url = "../calendar/agenda.php?action=edit&id=49&originalresource=$originalresource";
            } elseif ($action == 'add') {
                $url = "../calendar/agenda.php?action=add&originalresource=$originalresource";
            } else {
                $url = "../calendar/agenda.php?action=add";
            }
            $originaltoolname = get_lang('Agenda');
            $breadcrumbelement = array('url' => $url, 'name' => $originaltoolname);
            session_unregister('from_learnpath');
            unset ($from_learnpath);
            break;
        case '2': // coming from forum: new topic
            $url = "../phpbb/newtopic.php?forum=$source_forum&md5=$md5";
            $originaltoolname = get_lang('ForumAddNewTopic');
            $breadcrumbelement = array('url' => $url, 'name' => $originaltoolname);
            session_unregister('from_learnpath');
            unset ($from_learnpath);
            break;
        case '3': // coming from forum: edit topic
            $url = "../phpbb/editpost.php?post_id=$post_id&topic=$topic&forum=$forum&md5=$md5&originalresource=no";
            $originaltoolname = get_lang('ForumEditTopic');
            $breadcrumbelement = array('url' => $url, 'name' => $originaltoolname);
            session_unregister('from_learnpath');
            unset ($from_learnpath);
            break;
        case '4': // coming from exercises: edit topic
            $url = "../exercice/admin.php?modifyAnswers=$modifyAnswers";
            $originaltoolname = get_lang('ExerciseAnswers');
            $breadcrumbelement = array('url' => $url, 'name' => $originaltoolname);
            session_unregister('from_learnpath');
            unset ($from_learnpath);
            break;
        case '5': // coming from learning path
            $from_learnpath = 'yes';
            Session::write('from_learnpath', $from_learnpath);
            break;
        case '6': // coming from forum: reply
            $url = "../phpbb/reply.php?topic=$topic&forum=$forum&parentid=$parentid";
            $url = $_SESSION['origintoolurl'];
            $originaltoolname = get_lang('ForumReply');
            $breadcrumbelement = array('url' => $url, 'name' => $originaltoolname);
            session_unregister('from_learnpath');
            unset ($from_learnpath);
            break;

        /* add Frederik.Vermeire@pandora.be */

        case '7': // coming from Ad_Valvas
            if ($action == 'edit') {
                $url = "../announcements/announcements.php?action=edit&id=49&originalresource=$originalresource";
            } elseif ($action == 'add') {
                $url = "../announcements/announcements.php?action=add&originalresource=$originalresource";
            } else {
                $url = "../announcements/announcements.php?action=add";
            }
            $originaltoolname = get_lang('AdValvas');
            $breadcrumbelement = array('url' => $url, 'name' => $originaltoolname);
            session_unregister('from_learnpath');
            unset ($from_learnpath);
            break;

        /*  end add Frederik.Vermeire@pandora.be */

    }
    // We do not come from the learning path. We store the name of the tool & url in a session.
    if ($from_learnpath != 'yes') {
        if (!$_SESSION['origintoolurl'] || $_SESSION['origintoolurl'] != $interbreadcrumb['url']) {
            $_SESSION['origintoolurl'] = $breadcrumbelement['url'];
            $_SESSION['origintoolname'] = $breadcrumbelement['name'];
            $interbreadcrumb = '';
        }
    }

}

// This part of the code is the actual breadcrumb mechanism. If we do not come from the learning path we use
// the information from the session. Else we use the information of the learningpath itself.
if ($from_learnpath != 'yes') {
    $nameTools = get_lang('Attachment');
    $interbreadcrumb[] = array('url' => $_SESSION['origintoolurl'], 'name' => $_SESSION['origintoolname']);
} else {
    $learnpath_select_query = "	SELECT * FROM $tbl_lp
                                          WHERE id=$learnpath_id";
    $sql_result = Database::query($learnpath_select_query);
    $therow = Database::fetch_array($sql_result);

    $learnpath_chapter_query = "	SELECT * FROM $tbl_lp_item
                                          WHERE (lp_id = '$learnpath_id' and id = '$chapter_id')";
    $sql_result = Database::query($learnpath_chapter_query);
    $therow2 = Database::fetch_array($sql_result);

    $from_learnpath = 'yes';
    session_register('from_learnpath');
    $interbreadcrumb[] = array(
        'url' => "../newscorm/lp_controller.php?action=list",
        'name' => get_lang('LearningPath')
    );
    $interbreadcrumb[] = array(
        'url' => "../newscorm/lp_controller.php?action=admin_view&lp_id=$learnpath_id",
        'name' => stripslashes("{$therow['name']}")
    );
    $interbreadcrumb[] = array(
        'url' => api_get_self()."?action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&originalresource=no",
        'name' => "{$therow2['title']}"
    );
}

$htmlHeadXtra[] = '<script type="text/javascript">
/* <![CDATA[ */
    function targetfunc(input)
    {
        window.location=window.location+"&amp;target="+document.learnpath_link.target.value;
    }
/* ]]> */
</script>';

Display :: display_header($nameTools);

echo "<h3>".$nameTools;
if ($from_learnpath == 'yes') {
    echo get_lang('AddResource')." - {$therow2['title']}";
}
echo "</h3>";

// We retrieve the tools that are active.
// We use this to check which resources a student may add (only the modules that are active).
// See http://www.dokeos.com/forum/viewtopic.php?t=4858
$active_modules = array();
$tool_table = Database::get_course_table(TABLE_TOOL_LIST);
$sql_select_active = "SELECT * FROM $tool_table WHERE visibility='1'";
$result_select_active = Database::query($sql_select_active);
while ($row = Database::fetch_array($result_select_active)) {
    $active_modules[] = $row['name'];
}
?>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="300" valign="top" style='padding-right:15px;'>
    <table width="300" border="0" cellspacing="0" cellpadding="0" style='border-right:1px solid grey;'>
    <?php if ($from_learnpath != 'yes') { ?>
    <tr>
        <td width="26%"><b><?php echo get_lang('CourseResources'); ?></b></td>
    </tr>
        <?php
        if (api_is_allowed_to_edit() || in_array(TOOL_DOCUMENT, $active_modules)) {
            ?>
        <tr>
            <td><?php echo "<a href=\"".api_get_self(
            )."?content=Document&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
                'Documents'
            )."</a>"; ?></td>
        </tr>
            <?php
        }
        if (api_is_allowed_to_edit() || in_array(TOOL_CALENDAR_EVENT, $active_modules)) {
            ?>
        <tr>
            <td><?php echo "<a href=\"".api_get_self(
            )."?content=Agenda&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
                'Agenda'
            )."</a>"; ?></td>
        </tr>
            <?php
        }
        if (api_is_allowed_to_edit() || in_array(TOOL_ANNOUNCEMENT, $active_modules)) {
            ?>
        <tr>
            <td><?php echo "<a href=\"".api_get_self(
            )."?content=Ad_Valvas&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
                'AdValvas'
            )."</a>"; ?></td>
        </tr>
            <?php
        }
        if (api_is_allowed_to_edit() || in_array(TOOL_BB_FORUM, $active_modules)) {
            ?>
        <tr>
            <td><?php echo "<a href=\"".api_get_self(
            )."?content=Forum&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
                'Forum'
            )."</a>"; ?></td>
        </tr>
            <?php
        }
        if (api_is_allowed_to_edit() || in_array(TOOL_LINK, $active_modules)) {
            ?>
        <tr>
            <td><?php echo "<a href=\"".api_get_self(
            )."?content=Link&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
                'Links'
            )."</a>"; ?></td>
        </tr>
            <?php
        }
        if (api_is_allowed_to_edit() || in_array(TOOL_QUIZ, $active_modules)) {
            ?>
        <tr>
            <td><?php echo "<a href=\"".api_get_self(
            )."?content=Exercise&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
                'Exercise'
            )."</a>"; ?></td>
        </tr>
            <?php
        }
    } else {
        ?>
    <!--tr>
          <td width="26%"><b><?php echo get_lang('ExportableCourseResources'); ?></b></td>
        </tr-->
        <?php if ($multi_level_learnpath === true) { ?>
        <tr>
            <td><?php echo "<a href=\"".api_get_self(
            )."?content=chapter&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
                'Chapter'
            )."</a>"; ?></td>
        </tr>
            <?php } ?>
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Document&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'Document'
        )."</a>"; ?></td>
    </tr>
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Exercise&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'Exercise'
        )."</a>"; ?></td>
    </tr>
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Link&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'Link'
        )."</a>"; ?></td>
    </tr>
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Forum&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'Forum'
        )."</a>"; ?></td>
    </tr>
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Agenda&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'Agenda'
        )."</a>"; ?></td>
    </tr>
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Ad_Valvas&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'AdValvas'
        )."</a>"; ?></td>
    </tr>
    <!--tr>
          <td><?php echo "<a href=\"".api_get_self(
    )."?content=Course_description&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
        'CourseDescription'
    )."</a>"; ?></td>
        </tr-->
    <!--tr>
          <td><?php echo "<a href=\"".api_get_self(
    )."?content=Introduction_text&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
        'IntroductionText'
    )."</a>"; ?></td>
        </tr-->
    <!--tr>
      <td>&nbsp;</td>
    </tr-->
    <!--tr>
          <td width="26%"><b><?php echo get_lang('DokeosRelatedCourseMaterial'); ?></b></td>
        </tr-->
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Dropbox&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'Dropbox'
        )."</a>"; ?></td>
    </tr>
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Assignment&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'Assignments'
        )."</a>"; ?></td>
    </tr>
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Groups&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'Groups'
        )."</a>"; ?></td>
    </tr>
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Users&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'Users'
        )."</a>"; ?></td>
    </tr>

        <?php
    }
    ?>
    <!--tr>
      <td>&nbsp;</td>
    </tr-->
    <!--tr>
          <td><b><?php echo get_lang('ExternalResources'); ?></b></td>
        </tr-->
    <tr>
        <td><?php echo "<a href=\"".api_get_self(
        )."?content=Externallink&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'ExternalLink'
        )."</a>"; ?></td>
    </tr>
    <?php

    if ($from_learnpath != 'yes') {
        echo "<tr><td>&nbsp;</td></tr>";
        echo "<tr><td><b>".get_lang('ResourcesAdded')." (";
        echo count($addedresource);
        echo ")</b></td></tr>";
        echo "<tr><td nowrap><a href=\"".api_get_self(
        )."?showresources=true&action=$action&id=$id&lp_id=$learnpath_id&parent_item_id=$chapter_id&source_forum=$source_forum&originalresource=no\">".get_lang(
            'ShowDelete'
        )."</a>";
        echo "</td></tr>";
    }
    ?>
    <tr>
        <td>&nbsp;</td>
    </tr>
    <!--<tr>
          <td><b><?php echo get_lang('BackTo'); ?></b></td>
        </tr>//-->
    <tr>
        <td>

            <?php

            if ($from_learnpath != 'yes') {
                echo "<form method=\"post\" action=\"{$_SESSION['origintoolurl']}\" style=\"margin: 0px;\"><input type=\"submit\" value=\"".'  '.get_lang(
                    'Ok'
                ).'  '."\"></form>";
            } else {
                echo "<form method=\"get\" action=\"lp_controller.php\" style=\"margin: 0px;\"><input type=\"hidden\" name=\"lp_id\" value=\"".htmlentities(
                    $learnpath_id
                )."\"><input type=\"hidden\" name=\"action\" value=\"admin_view\"><input type=\"submit\" value=\"".'  '.get_lang(
                    'Ok'
                ).'  '."\"></form>";
            }
            ?>

        </td>
    </tr>
    <tr>
        <td>&nbsp;</td>
    </tr>
    </table>
    </td>
    <td valign="top">
      <?php

if ($resource_added) {
    Display :: display_normal_message(get_lang('ResourceAdded'));
}
if ($InvalidURL) {
    Display :: display_normal_message(get_lang('GiveURL'));
}

if ($from_learnpath != 'yes') {
    echo count($addedresource)." ".strtolower(get_lang('ResourcesAdded'))."<br />";
}
//echo "<hr />";

// Agenda items -->
if ($content == 'Agenda') {
    $TABLEAGENDA = Database::get_course_table(TABLE_AGENDA);
    $TABLE_ITEM_PROPERTY = Database::get_course_table(TABLE_ITEM_PROPERTY);

    $sql = "SELECT agenda.*, toolitemproperties.*
                    FROM ".$TABLEAGENDA." agenda, ".$TABLE_ITEM_PROPERTY." toolitemproperties
                    WHERE agenda.id = toolitemproperties.ref
                    AND toolitemproperties.tool='".TOOL_CALENDAR_EVENT."'
                    AND toolitemproperties.to_group_id='0'
                    AND toolitemproperties.visibility='1'";

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

    while ($myrow = Database::fetch_array($result)) {
        echo "<table width=\"100%\"><tr><td bgcolor=\"#E6E6E6\">";
        echo "<img src='../img/agenda.gif' alt='agenda'>";
        echo api_convert_and_format_date($myrow['start_date'], null, date_default_timezone_get())."<br />";
        echo "<b>".$myrow['title']."</b></td></tr><tr><td>";
        echo $myrow['content']."<br />";
        showorhide_addresourcelink($content, $myrow['id']);
        echo "</td></tr></table><br />";
    }
} // end if ($_GET['resource'] == 'Agenda')

/* Chapter */

if ($content == 'chapter') {
    echo '<table><form name="add_chapter" action="'.'" method="POST">'."\n";
    echo '  <tr><td>'.get_lang(
        'Title'
    ).'</td><td><input type="text" name="title" value="'.$title.'"></input></td></tr>'."\n";
    echo '  <tr><td>'.get_lang(
        'Description'
    ).'</td><td><input type="text" name="description" value="'.$description.'"></input></td></tr>'."\n";
    echo '  <tr><td></td><td><input type="submit" name="add_chapter" value="'.get_lang('AddIt').'"/></td></tr>'."\n";
    echo '</form></table>'."\n";
    //echo "<hr />";
}

/* Documents */

// We show the documents in the following cases
// 1. the link to add documenets in the resource linker was clicked
// 2. we come to the resource linker for the first time (documents = default). In this case it can only be shown if
//  			a. one is a teacher (documents can be shown even if the tool is inactive)
//				b. one is a student AND the documents tool is active. Student cannot add documents if the documents tool is inactive (teacher can do this)
if ($content == 'Document' || (empty($content) && (api_is_allowed_to_edit() || in_array(
    TOOL_DOCUMENT,
    $active_modules
))) && !$_GET['showresources']
) {
    // setting variables for file locations
    $baseServDir = api_get_path(SYS_PATH);
    $courseDir = $_course['path'].'/document';
    $baseWorkDir = $baseServDir.$courseDir;
    // showing the link to move one folder up (when not in the root folder)
    show_folder_up();
    // showing the blue bar with the path in it when we are not in the root
    if (FileManager::get_levels($folder)) {
        echo "<table width=\"100%\"><tr><td bgcolor=\"#4171B5\">";
        echo "<img src=\"../img/opendir.gif\" alt='directory'><font color=\"#ffffff\"><b>";
        echo $folder."</b></font></td></tr></table>";
    }

    // Showing the documents and subfolders of the folder we are in.
    show_documents($folder);
    //echo "<hr />";
}

/* Ad Valvas */

if ($content == 'Ad_Valvas') {
    $tbl_announcement = Database :: get_course_table(TABLE_ANNOUNCEMENT);
    $sql = "SELECT * FROM ".$tbl_announcement." a, ".$item_property_table." i  WHERE i.tool = '".TOOL_ANNOUNCEMENT."' AND a.id=i.ref AND i.visibility='1' AND i.to_group_id = 0 AND i.to_user_id IS NULL ORDER BY a.display_order ASC";
    //error_log($sql, 0);
    $result = Database::query($sql);
    while ($myrow = Database::fetch_array($result)) {
        echo "<table width=\"100%\"><tr><td>";
        echo "<img src='../img/valves.gif' alt='advalvas'>";
        echo api_convert_and_format_date($myrow['end_date'], DATE_FORMAT_LONG, date_default_timezone_get());
        echo "</td></tr><tr><td>";
        echo $myrow['title']."<br />";
        showorhide_addresourcelink($content, $myrow['id']);
        echo "</td></tr></table>";
    }
}

/* Forums */

if ($content == 'Forum') {
    $TBL_FORUMS = Database::get_course_table(TABLE_FORUM);
    $TBL_CATAGORIES = Database::get_course_table(TABLE_FORUM_CATEGORY);
    $TBL_FORUMTOPICS = Database::get_course_table(TABLE_FORUM_THREAD);
    $tbl_posts = Database::get_course_table(TABLE_FORUM_POST);

    echo "<table width='100%'>";

    // Displaying the categories and the forums.
    if (!$forum and !$thread) {
        $sql = "SELECT * FROM ".$TBL_FORUMS." forums, ".$TBL_CATAGORIES." categories WHERE forums.forum_category=categories.cat_id ORDER BY forums.forum_category DESC";
        //error_log($sql, 0);
        $result = Database::query($sql);
        while ($myrow = Database::fetch_array($result)) {
            if ($myrow['cat_title'] !== $old_cat_title) {
                echo "<tr><td bgcolor='#4171B5' colspan='2'><font color='white'><b>".$myrow['cat_title']."</b></font></td></tr>";
            }
            $old_cat_title = $myrow['cat_title'];
            echo "<tr><td><img src='../img/forum.gif'><a href='".api_get_self(
            )."?content=Forum&category=".$myrow['cat_id']."&forum=".$myrow['forum_id']."&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&originalresource=no'>".$myrow['forum_name']."</td><td>";
            showorhide_addresourcelink('Forum', $myrow['forum_id']);
            echo "</td></tr>";
        }
    }
    // Displaying all the threads of one forum.
    if ($forum) {
        // Displaying the category title.
        $sql = "SELECT * FROM ".$TBL_CATAGORIES." WHERE cat_id=$category";
        $result = Database::query($sql);
        $myrow = Database::fetch_array($result);
        echo "<tr><td bgcolor='#4171B5' colspan='2'><font color='white'><b>".$myrow['cat_title']."</b></font></td></tr>";

        // Displaying the forum title.
        $sql = "SELECT * FROM ".$TBL_FORUMS." forums, ".$TBL_FORUMTOPICS." topics WHERE forums.forum_id=topics.forum_id";
        $result = Database::query($sql);
        $myrow = Database::fetch_array($result);
        echo "<tr><td bgcolor='#cccccc' colspan='2'><b>".$myrow['forum_name']."</b></td></tr>";

        if (!$thread) {
            // Displaying all the threads of this forum.
            $sql = "SELECT * FROM ".$TBL_FORUMTOPICS." WHERE forum_id=$forum";
            $result = Database::query($sql);
            while ($myrow = Database::fetch_array($result)) {
                echo "<tr><td><a href='".api_get_self(
                )."?content=Forum&category=$category&forum=1&thread=".$myrow['topic_id']."&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&originalresource=no'>".$myrow['topic_title']."</a>  (".$myrow['prenom']." ".$myrow['nom'].")</td><td>";
                showorhide_addresourcelink("Thread", $myrow['topic_id']);
                echo "</td></tr>";
            }
        } else {
            // Displaying all the replies.
            $sql = "SELECT * FROM ".$tbl_posts." post WHERE post.topic_id=$thread ORDER BY post.post_id ASC";
            $result = Database::query($sql);
            while ($myrow = Database::fetch_array($result)) {
                echo "<tr><td><b>".$myrow['post_title']."</b><br />";
                echo $myrow['post_text']."</td>";
                echo "<td>";
                showorhide_addresourcelink('Post', $myrow['post_id']);
                echo "</td></tr><tr><td colspan='2'><hr noshade></td></tr>";
            }

        }
    }
    echo "</table>";
}

/* Links */

if ($content == 'Link') {
    // Including the links language file.
    include "../lang/$language/link.inc.php";

    // Including the links functions file.
    require_once api_get_path(LIBRARY_PATH).'link.lib.php';

    $tbl_categories = Database::get_course_table(TABLE_LINK_CATEGORY);
    if (($learnpath_id != '') and ($content == 'Link')) {
        echo "<form name='learnpath_link'><table>";
        echo "<tr></td><td align='left'>".get_lang(
            'LinkTarget'
        )." :</td><td align='left'><select name='target' onchange='javascript: targetfunc();'><option value='_self' ";
        if ($target == '_self') {
            echo "selected";
        }
        echo ">".get_lang('SameWindow')."</option><option value='_blank'";
        if ($target == '_blank') {
            echo "selected";
        }
        echo ">".get_lang('NewWindow')."</option></select></td></tr></table></form>";
    }

    // Showing the links that are in the root (having no category).
    $sql = "SELECT * FROM ".$link_table." l, ".$item_property_table." ip WHERE (l.category_id=0 or l.category_id IS NULL) AND ip.tool = '".TOOL_LINK."' AND l.id=ip.ref AND ip.visibility='1'";
    $result = Database::query($sql);
    if (Database::num_rows($result) > 0) {
        echo "<table width=\"100%\"><tr><td bgcolor=\"#E6E6E6\"><i>".get_lang('NoCategory')."</i></td></tr></table>";
        while ($myrow = Database::fetch_array($result)) {
            echo "<img src='../img/links.gif'>".$myrow['title'];
            echo "<br />";
            showorhide_addresourcelink($content, $myrow['id']);
            echo "<br /><br />";
        }
    }

    // Showing the categories and the links in it.
    $sqlcategories = "SELECT * FROM ".$tbl_categories." ORDER by display_order DESC";
    $resultcategories = Database::query($sqlcategories) or die;
    while ($myrow = @ Database::fetch_array($resultcategories)) {
        $sql_links = "SELECT * FROM ".$link_table." l, ".$item_property_table." ip WHERE l.category_id='".$myrow['id']."' AND ip.tool = '".TOOL_LINK."' AND l.id=ip.ref AND ip.visibility='1' ORDER BY l.display_order DESC";
        echo "<table width=\"100%\"><tr><td bgcolor=\"#E6E6E6\"><i>".$myrow['category_title']."</i></td></tr></table>";
        $result_links = Database::query($sql_links);
        while ($myrow = Database::fetch_array($result_links)) {
            echo "<img src='../img/links.gif' />".$myrow['title'];
            echo "<br />";
            showorhide_addresourcelink($content, $myrow['id']);
            echo "<br /><br />";
        }
    }
}

/* Exercise */

if (($content == 'Exercise') || ($content == 'HotPotatoes')) {
    $TBL_EXERCICES = Database::get_course_table(TABLE_QUIZ_TEST);
    $result = Database::query("SELECT * FROM ".$TBL_EXERCICES." WHERE active='1' ORDER BY iid ASC");
    while ($myrow = Database::fetch_array($result)) {
        echo "<img src='../img/quiz.gif'>".$myrow['title']."<br />";
        showorhide_addresourcelink($content, $myrow["id"]);
        echo "<br /><br />";
    }

    if ($from_learnpath == 'yes') {
        $uploadPath = '/HotPotatoes_files';
        $TBL_DOCUMENT = Database::get_course_table(TABLE_DOCUMENT);
        $documentPath = api_get_path(SYS_COURSE_PATH).$_course['path'].'/document';
        $sql = "SELECT * FROM ".$TBL_DOCUMENT." WHERE (path LIKE '%htm%' OR path LIKE '%html%') AND path LIKE '".$uploadPath."/%/%' ORDER BY iid ASC";
        $result = Database::query($sql);
        while ($myrow = Database::fetch_array($result)) {
            $path = $myrow['path'];
            echo "<img src='../img/jqz.jpg'>".GetQuizName($path, $documentPath)."<br />";
            showorhide_addresourcelink('HotPotatoes', $myrow['id']);
            echo "<br /><br />";

        }
    }
}

/* External Links */

if ($content == 'Externallink') {
    ?>
<form name="form1" method="post" action="">
    <table width="80%" border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td align="right"><?php echo get_lang('ExternalLink'); ?> : &nbsp;</td>
            <td align="left"><input name="external_link" type="text" id="external_link" value="http://"></td>
            <?php

            if ($learnpath_id != '') {
                echo "</tr><tr><td align='right'>".get_lang(
                    'LinkTarget'
                )." :</td><td align='left'><select name='target'><option value='_self'>".get_lang(
                    'SameWindow'
                )."</option><option value='_blank'>".get_lang('NewWindow')."</option></select></td>";
            }
            ?>
        </tr>
        <tr>
            <td><?php if ($is_allowedToEdit) {
                echo get_lang('AddToLinks');
            } ?></td>
            <td>
                <?php if ($is_allowedToEdit) { ?>
                <select name="add_2_links" id="add_2_links">
                    <option value="niet toevoegen" selected="selected">-<?php echo get_lang('DontAdd'); ?>-</option>
                    <option value="0"><?php echo get_lang('MainCategory'); ?></option>
                    <?php

                    $tbl_categories = Database::get_course_table(TABLE_LINK_CATEGORY);
                    $sql = "SELECT * FROM $tbl_categories ORDER BY display_order ASC";
                    echo $sql;
                    $result = Database::query($sql);
                    while ($row = Database::fetch_array($result)) {
                        echo "<option value='".$row['id']."'>".$row['category_title']."</option>";
                    }
                    ?>

                </select><?php } ?></td>
        </tr>
        <tr>
            <td>&nbsp;</td>
            <td><input name="external_link_submit" type="submit" id="external_link_submit"
                       value="<?php echo get_lang('AddIt'); ?>"></td>
        </tr>
        <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
        </tr>
        <tr>
            <td colspan="2">&nbsp;</td>
        </tr>
    </table>
</form>
<?php

}

/* Assignments */

if ($content == 'Assignment') {
    echo "<a href=".api_get_self(
    )."?content=Ass&add=Ass&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&originalresource=no>".get_lang(
        'AddAssignmentPage'
    )."</a>";
}

/* Dropbox */

if ($content == 'Dropbox') {
    echo "<a href='".api_get_self(
    )."?content=Drop&add=Drop&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&originalresource=no'>".get_lang(
        'DropboxAdd'
    )."</a>";
}

/* Introduction text */

if ($content == 'Introduction_text') {
    echo "<a href='".api_get_self(
    )."?content=Intro&add=Intro&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&originalresource=no'>".get_lang(
        'IntroductionTextAdd'
    )."</a>";
}

/* Course description */

if ($content == 'Course_description') {
    echo "<a href='".api_get_self(
    )."?content=Course_desc&add=Course_desc&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&originalresource=no'>".get_lang(
        'CourseDescriptionAdd'
    )."</a>";
}

/* Groups */

if ($content == 'Groups') {
    echo "<a href='".api_get_self(
    )."?content=Group&add=Group&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&originalresource=no'>".get_lang(
        'GroupsAdd'
    )."</a>";
}

/* Users */

if ($content == 'Users') {
    echo "<a href='".api_get_self(
    )."?content=User&add=User&action=$action&lp_id=$learnpath_id&parent_item_id=$chapter_id&originalresource=no'>".get_lang(
        'UsersAdd'
    )."</a>";
}

if ($showresources) {
    //echo "<h4>".get_lang('ResourceAdded')."</h4>";
    display_resources(1);
}

echo "</td></tr></table>";

/* FOOTER */

Display :: display_footer();