chamilo / chamilo-lms

        $course_id = api_get_course_int_id();

        switch ($cat) {

            case 'Basic' :

                $condition_display_tools = ' WHERE a.c_id = '.$course_id.' AND  a.link=t.link AND t.position="basic" ';

                if ((api_is_coach() || api_is_course_tutor()) && $_SESSION['studentview'] != 'studentview') {

                    $condition_display_tools = ' WHERE a.c_id = '.$course_id.' AND a.link=t.link AND (t.position="basic" OR a.name = "'.TOOL_TRACKING.'") ';

                }

                $sql = "SELECT a.*, t.image img, t.row, t.column  FROM $TBL_ACCUEIL a, $TABLE_TOOLS t

                        $condition_display_tools ORDER BY t.row, t.column";

                break;

            case 'External' :

                if (api_is_allowed_to_edit()) {

                    $sql = "SELECT a.*, t.image img FROM $TBL_ACCUEIL a, $TABLE_TOOLS t

        $course_id = api_get_course_int_id();

        switch ($course_tool_category) {

            case TOOL_PUBLIC:

                $condition_display_tools = ' WHERE c_id = '.$course_id.' AND visibility = 1 ';

                if ((api_is_coach() || api_is_course_tutor()) && $_SESSION['studentview'] != 'studentview') {

                    $condition_display_tools = ' WHERE c_id = '.$course_id.' AND (visibility = 1 OR (visibility = 0 AND name = "'.TOOL_TRACKING.'")) ';

                }

                $result = Database::query("SELECT * FROM $course_tool_table $condition_display_tools ORDER BY id");

                $col_link = "##003399";

                break;

            case TOOL_PUBLIC_BUT_HIDDEN:

                $result = Database::query("SELECT * FROM $course_tool_table WHERE c_id = $course_id AND visibility=0 AND admin=0 ORDER BY id");

                $col_link = "##808080";