chamilo / chamilo-lms

                            }

                        }

                        if (isset($sessionId) && !empty($sessionId)) {

                            if (!empty($enreg['SessionName'])) {

                                $params['name'] = $enreg['SessionName'];

                            }

                            $session_id = $sessionId;

                        } else {

                            $row = Database::query("SELECT id FROM $tbl_session WHERE name = '$session_name'");

                            list($session_id) = Database::fetch_array($row);

                        }

                        if ($session_id) {

    $course_info = api_get_course_info($course_code);

    $table = Database::get_course_table(TABLE_COURSE_SETTING);

    $setting_name = Database::escape_string($setting_name);

    if (!empty($course_info['real_id']) && !empty($setting_name)) {

        $sql = "SELECT value FROM $table

                WHERE c_id = {$course_info['real_id']} AND variable = '$setting_name'";

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

        if (Database::num_rows($res) > 0) {

            $row = Database::fetch_array($res);

            return $row['value'];

        }

    }

    return -1;

}