123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835 |
- <?php
- define('TABLE_MAIN_COURSE', 'course');
- define('TABLE_MAIN_USER', 'user');
- define('TABLE_MAIN_CLASS', 'class');
- define('TABLE_MAIN_ADMIN', 'admin');
- define('TABLE_MAIN_COURSE_CLASS', 'course_rel_class');
- define('TABLE_MAIN_COURSE_USER', 'course_rel_user');
- define('TABLE_MAIN_CLASS_USER', 'class_user');
- define('TABLE_MAIN_CATEGORY', 'course_category');
- define('TABLE_MAIN_COURSE_MODULE', 'course_module');
- define('TABLE_MAIN_SYSTEM_ANNOUNCEMENTS', 'sys_announcement');
- define('TABLE_MAIN_LANGUAGE', 'language');
- define('TABLE_MAIN_SETTINGS_OPTIONS', 'settings_options');
- define('TABLE_MAIN_SETTINGS_CURRENT', 'settings_current');
- define('TABLE_MAIN_SESSION', 'session');
- define('TABLE_MAIN_SESSION_CATEGORY', 'session_category');
- define('TABLE_MAIN_SESSION_COURSE', 'session_rel_course');
- define('TABLE_MAIN_SESSION_USER', 'session_rel_user');
- define('TABLE_MAIN_SESSION_CLASS', 'session_rel_class');
- define('TABLE_MAIN_SESSION_COURSE_USER', 'session_rel_course_rel_user');
- define('TABLE_MAIN_SHARED_SURVEY', 'shared_survey');
- define('TABLE_MAIN_SHARED_SURVEY_QUESTION', 'shared_survey_question');
- define('TABLE_MAIN_SHARED_SURVEY_QUESTION_OPTION', 'shared_survey_question_option');
- define('TABLE_MAIN_TEMPLATES', 'templates');
- define('TABLE_MAIN_SYSTEM_TEMPLATE', 'system_template');
- define('TABLE_MAIN_OPENID_ASSOCIATION', 'openid_association');
- define('TABLE_MAIN_GRADEBOOK_CATEGORY', 'gradebook_category');
- define('TABLE_MAIN_GRADEBOOK_EVALUATION', 'gradebook_evaluation');
- define('TABLE_MAIN_GRADEBOOK_LINKEVAL_LOG', 'gradebook_linkeval_log');
- define('TABLE_MAIN_GRADEBOOK_RESULT', 'gradebook_result');
- define('TABLE_MAIN_GRADEBOOK_RESULT_LOG', 'gradebook_result_log');
- define('TABLE_MAIN_GRADEBOOK_LINK', 'gradebook_link');
- define('TABLE_MAIN_GRADEBOOK_SCORE_DISPLAY','gradebook_score_display');
- define('TABLE_MAIN_USER_FIELD', 'user_field');
- define('TABLE_MAIN_USER_FIELD_OPTIONS', 'user_field_options');
- define('TABLE_MAIN_USER_FIELD_VALUES', 'user_field_values');
- define('TABLE_MAIN_TAG', 'tag');
- define('TABLE_MAIN_USER_REL_TAG', 'user_rel_tag');
- define('TABLE_MAIN_GROUP', 'groups');
- define('TABLE_MAIN_USER_REL_GROUP', 'group_rel_user');
- define('TABLE_MAIN_GROUP_REL_TAG', 'group_rel_tag');
- define('TABLE_MAIN_SPECIFIC_FIELD', 'specific_field');
- define('TABLE_MAIN_SPECIFIC_FIELD_VALUES', 'specific_field_values');
- define('TABLE_MAIN_SEARCH_ENGINE_REF', 'search_engine_ref');
- define('TABLE_MAIN_ACCESS_URL', 'access_url');
- define('TABLE_MAIN_ACCESS_URL_REL_USER', 'access_url_rel_user');
- define('TABLE_MAIN_ACCESS_URL_REL_COURSE', 'access_url_rel_course');
- define('TABLE_MAIN_ACCESS_URL_REL_SESSION', 'access_url_rel_session');
- define('TABLE_MAIN_SYSTEM_CALENDAR', 'sys_calendar');
- define('TABLE_MAIN_RESERVATION_ITEM', 'reservation_item');
- define('TABLE_MAIN_RESERVATION_RESERVATION', 'reservation_main');
- define('TABLE_MAIN_RESERVATION_SUBSCRIBTION', 'reservation_subscription');
- define('TABLE_MAIN_RESERVATION_CATEGORY', 'reservation_category');
- define('TABLE_MAIN_RESERVATION_ITEM_RIGHTS', 'reservation_item_rights');
- define('TABLE_MAIN_USER_FRIEND', 'user_friend');
- define('TABLE_MAIN_USER_FRIEND_RELATION_TYPE', 'user_friend_relation_type');
- define('TABLE_MAIN_USER_API_KEY', 'user_api_key');
- define('TABLE_MAIN_COURSE_FIELD', 'course_field');
- define('TABLE_MAIN_COURSE_FIELD_VALUES', 'course_field_values');
- define('TABLE_MAIN_SESSION_FIELD', 'session_field');
- define('TABLE_MAIN_SESSION_FIELD_VALUES', 'session_field_values');
- define('TABLE_MAIN_MESSAGE', 'message');
- define('TABLE_MAIN_LEGAL', 'legal');
- define('TABLE_STATISTIC_TRACK_E_LASTACCESS', 'track_e_lastaccess');
- define('TABLE_STATISTIC_TRACK_E_ACCESS', 'track_e_access');
- define('TABLE_STATISTIC_TRACK_E_LOGIN', 'track_e_login');
- define('TABLE_STATISTIC_TRACK_E_DOWNLOADS', 'track_e_downloads');
- define('TABLE_STATISTIC_TRACK_E_LINKS', 'track_e_links');
- define('TABLE_STATISTIC_TRACK_E_ONLINE', 'track_e_online');
- define('TABLE_STATISTIC_TRACK_E_HOTPOTATOES', 'track_e_hotpotatoes');
- define('TABLE_STATISTIC_TRACK_E_COURSE_ACCESS', 'track_e_course_access');
- define('TABLE_STATISTIC_TRACK_E_EXERCICES', 'track_e_exercices');
- define('TABLE_STATISTIC_TRACK_E_ATTEMPT', 'track_e_attempt');
- define('TABLE_STATISTIC_TRACK_E_ATTEMPT_RECORDING', 'track_e_attempt_recording');
- define('TABLE_STATISTIC_TRACK_E_DEFAULT', 'track_e_default');
- define('TABLE_STATISTIC_TRACK_E_UPLOADS', 'track_e_uploads');
- define('TABLE_STATISTIC_TRACK_E_HOTSPOT', 'track_e_hotspot');
- define('TABLE_SCORM_MAIN', 'scorm_main');
- define('TABLE_SCORM_SCO_DATA', 'scorm_sco_data');
- define('TABLE_AGENDA', 'calendar_event');
- define('TABLE_AGENDA_REPEAT', 'calendar_event_repeat');
- define('TABLE_AGENDA_REPEAT_NOT', 'calendar_event_repeat_not');
- define('TABLE_AGENDA_ATTACHMENT', 'calendar_event_attachment');
- define('TABLE_ANNOUNCEMENT', 'announcement');
- define('TABLE_ANNOUNCEMENT_ATTACHMENT', 'announcement_attachment');
- define('TABLE_CHAT_CONNECTED', 'chat_connected');
- define('TABLE_COURSE_DESCRIPTION', 'course_description');
- define('TABLE_DOCUMENT', 'document');
- define('TABLE_ITEM_PROPERTY', 'item_property');
- define('TABLE_LINK', 'link');
- define('TABLE_LINK_CATEGORY', 'link_category');
- define('TABLE_TOOL_LIST', 'tool');
- define('TABLE_TOOL_INTRO', 'tool_intro');
- define('TABLE_SCORMDOC', 'scormdocument');
- define('TABLE_STUDENT_PUBLICATION', 'student_publication');
- define('TABLE_STUDENT_PUBLICATION_ASSIGNMENT', 'student_publication_assignment');
- define('CHAT_CONNECTED_TABLE', 'chat_connected');
- define('TABLE_FORUM_CATEGORY', 'forum_category');
- define('TABLE_FORUM', 'forum_forum');
- define('TABLE_FORUM_THREAD', 'forum_thread');
- define('TABLE_FORUM_POST', 'forum_post');
- define('TABLE_FORUM_ATTACHMENT', 'forum_attachment');
- define('TABLE_FORUM_MAIL_QUEUE', 'forum_mailcue');
- define('TABLE_FORUM_THREAD_QUALIFY', 'forum_thread_qualify');
- define('TABLE_FORUM_THREAD_QUALIFY_LOG', 'forum_thread_qualify_log');
- define('TABLE_FORUM_NOTIFICATION', 'forum_notification');
- define('TABLE_GROUP', 'group_info');
- define('TABLE_GROUP_USER', 'group_rel_user');
- define('TABLE_GROUP_TUTOR', 'group_rel_tutor');
- define('TABLE_GROUP_CATEGORY', 'group_category');
- define('TABLE_DROPBOX_CATEGORY', 'dropbox_category');
- define('TABLE_DROPBOX_FEEDBACK', 'dropbox_feedback');
- define('TABLE_DROPBOX_POST', 'dropbox_post');
- define('TABLE_DROPBOX_FILE', 'dropbox_file');
- define('TABLE_DROPBOX_PERSON', 'dropbox_person');
- define('TABLE_QUIZ_QUESTION', 'quiz_question');
- define('TABLE_QUIZ_TEST', 'quiz');
- define('TABLE_QUIZ_ANSWER', 'quiz_answer');
- define('TABLE_QUIZ_TEST_QUESTION', 'quiz_rel_question');
- define('TABLE_LINKED_RESOURCES', 'resource');
- define('TABLE_LP_MAIN', 'lp');
- define('TABLE_LP_ITEM', 'lp_item');
- define('TABLE_LP_VIEW', 'lp_view');
- define('TABLE_LP_ITEM_VIEW', 'lp_item_view');
- define('TABLE_LP_IV_INTERACTION', 'lp_iv_interaction');
- define('TABLE_LP_IV_OBJECTIVE', 'lp_iv_objective');
- define('TABLE_PERMISSION_USER', 'permission_user');
- define('TABLE_PERMISSION_TASK', 'permission_task');
- define('TABLE_PERMISSION_GROUP', 'permission_group');
- define('TABLE_ROLE', 'role');
- define('TABLE_ROLE_PERMISSION', 'role_permissions');
- define('TABLE_ROLE_USER', 'role_user');
- define('TABLE_ROLE_GROUP', 'role_group');
- define('TABLE_BLOGS', 'blog');
- define('TABLE_BLOGS_POSTS', 'blog_post');
- define('TABLE_BLOGS_COMMENTS', 'blog_comment');
- define('TABLE_BLOGS_REL_USER', 'blog_rel_user');
- define('TABLE_BLOGS_TASKS', 'blog_task');
- define('TABLE_BLOGS_TASKS_REL_USER', 'blog_task_rel_user');
- define('TABLE_BLOGS_RATING', 'blog_rating');
- define('TABLE_BLOGS_ATTACHMENT', 'blog_attachment');
- define('TABLE_BLOGS_TASKS_PERMISSIONS', 'permission_task');
- define('TABLE_USER_INFO', 'userinfo_def');
- define('TABLE_USER_INFO_CONTENT', 'userinfo_content');
- define('TABLE_COURSE_SETTING', 'course_setting');
- define('TABLE_ONLINE_LINK', 'online_link');
- define('TABLE_ONLINE_CONNECTED', 'online_connected');
- define('TABLE_PERSONAL_AGENDA', 'personal_agenda');
- define('TABLE_PERSONAL_AGENDA_REPEAT', 'personal_agenda_repeat');
- define('TABLE_PERSONAL_AGENDA_REPEAT_NOT', 'personal_agenda_repeat_not');
- define('TABLE_USER_COURSE_CATEGORY', 'user_course_category');
- define('TABLE_MAIN_SURVEY', 'survey');
- define('TABLE_MAIN_GROUP', 'survey_group');
- define('TABLE_MAIN_SURVEYQUESTION', 'questions');
- define('TABLE_SURVEY', 'survey');
- define('TABLE_SURVEY_QUESTION', 'survey_question');
- define('TABLE_SURVEY_QUESTION_OPTION', 'survey_question_option');
- define('TABLE_SURVEY_INVITATION', 'survey_invitation');
- define('TABLE_SURVEY_ANSWER', 'survey_answer');
- define('TABLE_SURVEY_QUESTION_GROUP', 'survey_group');
- define('TABLE_SURVEY_REPORT', 'survey_report');
- define('TABLE_WIKI', 'wiki');
- define('TABLE_WIKI_CONF', 'wiki_conf');
- define('TABLE_WIKI_DISCUSS', 'wiki_discuss');
- define('TABLE_WIKI_MAILCUE', 'wiki_mailcue');
- define('TABLE_GLOSSARY', 'glossary');
- define('TABLE_NOTEBOOK', 'notebook');
- define('TABLE_MESSAGE', 'message');
- define('TABLE_MESSAGE_ATTACHMENT', 'message_attachment');
- define('TABLE_METADATA', 'metadata');
- class Database {
-
-
- public static function get_main_database() {
- global $_configuration;
- return $_configuration['main_database'];
- }
-
- public static function get_statistic_database() {
- global $_configuration;
- return $_configuration['statistics_database'];
- }
-
- public static function get_scorm_database() {
- global $_configuration;
- return $_configuration['scorm_database'];
- }
-
- public static function get_user_personal_database() {
- global $_configuration;
- return $_configuration['user_personal_database'];
- }
-
- public static function get_current_course_database() {
- $course_info = api_get_course_info();
- return $course_info['dbName'];
- }
-
- public static function get_current_course_glued_database() {
- $course_info = api_get_course_info();
- return $course_info['dbNameGlu'];
- }
-
- public static function get_database_glue() {
- global $_configuration;
- return $_configuration['db_glue'];
- }
-
- public static function get_database_name_prefix() {
- global $_configuration;
- return $_configuration['db_prefix'];
- }
-
- public static function get_course_table_prefix() {
- global $_configuration;
- return $_configuration['table_prefix'];
- }
-
-
- public static function get_main_table($short_table_name) {
- return self::format_table_name(self::get_main_database(), $short_table_name);
- }
-
- public static function get_course_table($short_table_name, $database_name = '') {
- return self::format_glued_course_table_name(self::fix_database_parameter($database_name), $short_table_name);
- }
-
- public static function get_course_table_from_code($course_code, $table) {
- $course_table = self::get_main_table(TABLE_MAIN_COURSE);
- $course_cat_table = self::get_main_table(TABLE_MAIN_CATEGORY);
- $result = self::fetch_array(self::query(
- "SELECT $course_table.db_name, $course_cat_table.code
- FROM $course_table
- LEFT JOIN $course_cat_table
- ON $course_table.category_code = $course_cat_table.code
- WHERE $course_table.code = '$course_code'
- LIMIT 1", __FILE__, __LINE__));
- return sprintf("%s.%s", $result[0], $table);
- }
-
- public static function get_statistic_table($short_table_name) {
- return self::format_table_name(self::get_statistic_database(), $short_table_name);
- }
-
- public static function get_scorm_table($short_table_name) {
- return self::format_table_name(self::get_scorm_database(), $short_table_name);
- }
-
- public static function get_user_personal_table($short_table_name) {
- return self::format_table_name(self::get_user_personal_database(), $short_table_name);
- }
-
-
- public static function get_course_list() {
- $table = self::get_main_table(TABLE_MAIN_COURSE);
- return self::store_result(self::query("SELECT * FROM $table", __FILE__, __LINE__));
- }
-
- public static function get_course_info($course_code) {
- $course_code = self::escape_string($course_code);
- $table = self::get_main_table(TABLE_MAIN_COURSE);
- $result = self::generate_abstract_course_field_names(
- self::fetch_array(self::query("SELECT * FROM $table WHERE `code` = '$course_code'", __FILE__, __LINE__)));
- return $result === false ? array('db_name' => '') : $result;
- }
-
- public static function get_user_info_from_id($user_id = '') {
- if (empty($user_id)) {
- return $GLOBALS['_user'];
- }
- $table = self::get_main_table(TABLE_MAIN_USER);
- $user_id = self::escape_string($user_id);
- return self::generate_abstract_user_field_names(
- self::fetch_array(self::query("SELECT * FROM $table WHERE user_id = '$user_id'", __FILE__, __LINE__)));
- }
-
- public static function generate_abstract_course_field_names($result_array) {
- $visual_code = isset($result_array['visual_code']) ? $result_array['visual_code'] : null;
- $code = isset($result_array['code']) ? $result_array['code'] : null;
- $title = isset($result_array['title']) ? $result_array['title'] : null;
- $db_name = isset($result_array['db_name']) ? $result_array['db_name'] : null;
- $category_code= isset($result_array['category_code']) ? $result_array['category_code'] : null;
- $result_array['official_code'] = $visual_code;
- $result_array['visual_code'] = $visual_code;
- $result_array['real_code'] = $code;
- $result_array['system_code'] = $code;
- $result_array['title'] = $title;
- $result_array['database'] = $db_name;
- $result_array['faculty'] = $category_code;
-
-
- return $result_array;
- }
-
- public static function generate_abstract_user_field_names($result_array) {
- $result_array['firstName'] = $result_array['firstname'];
- $result_array['lastName'] = $result_array['lastname'];
- $result_array['mail'] = $result_array['email'];
-
-
- return $result_array;
- }
-
-
- public static function glue_course_database_name($database_name) {
- return self::get_course_table_prefix().$database_name.self::get_database_glue();
- }
-
- public static function fix_database_parameter($database_name) {
- if (empty($database_name)) {
- $course_info = api_get_course_info();
- return $course_info['dbNameGlu'];
- }
- return self::glue_course_database_name($database_name);
- }
-
- public static function format_glued_course_table_name($database_name_with_glue, $table) {
-
- return '`'.$database_name_with_glue.$table.'`';
- }
-
- public static function format_table_name($database, $table) {
- return '`'.$database.'`.`'.$table.'`';
- }
-
- public static function count_rows($table) {
- $obj = self::fetch_object(self::query("SELECT COUNT(*) AS n FROM $table", __FILE__, __LINE__));
- return $obj->n;
- }
-
- public static function escape_string($string) {
- return get_magic_quotes_gpc() ? mysql_real_escape_string(stripslashes($string)) : mysql_real_escape_string($string);
- }
-
- public static function fetch_array($res, $option = 'BOTH') {
- return $option == 'ASSOC' ? mysql_fetch_array($res, MYSQL_ASSOC) : ($option == 'NUM' ? mysql_fetch_array($res, MYSQL_NUM) : mysql_fetch_array($res));
- }
-
- public static function fetch_object($res, $class = null, $params = null) {
- return !empty($class) ? (is_array($params) ? mysql_fetch_object($res, $class, $params) : mysql_fetch_object($res,$class)) : mysql_fetch_object($res);
- }
-
- public static function fetch_row($res) {
- return mysql_fetch_row($res);
- }
-
- public static function num_rows($res) {
- return mysql_num_rows($res);
- }
- public static function get_course_chat_connected_table($database_name = '') {
- return self::format_glued_course_table_name(self::fix_database_parameter($database_name), CHAT_CONNECTED_TABLE);
- }
-
- public static function result($resource, $row, $field = '') {
- return mysql_num_rows($resource) > 0 ? (!empty($field) ? mysql_result($resource, $row, $field) : mysql_result($resource, $row)) : null;
- }
-
- public static function insert_id() {
- return mysql_insert_id();
- }
-
- public static function affected_rows($r = null) {
- return !is_null($r) ? mysql_affected_rows($r) : mysql_affected_rows();
- }
-
- public static function query($query, $file = '', $line = 0) {
- if (!($result = @mysql_query($query)) && $line && api_get_setting('server_type') != 'production') {
- $security_ok = class_exists('Security') && class_exists('HTMLPurifier');
- $error = self::error();
- $info = '<pre>';
- $info .= '<strong>DATABASE ERROR :</strong><br /> ';
- $info .= $security_ok ? Security::remove_XSS($error) : api_htmlentities($error, ENT_QUOTES);
- $info .= '<br />';
- $info .= '<strong>QUERY :</strong><br /> ';
- $info .= $security_ok ? Security::remove_XSS($query) : api_htmlentities($query, ENT_QUOTES);
- $info .= '<br />';
- $info .= '<strong>FILE :</strong><br /> ';
- $info .= ($file == '' ? ' unknown ' : $file);
- $info .= '<br />';
- $info .= '<strong>LINE :</strong><br /> ';
- $info .= ($line == 0 ? ' unknown ' : $line);
- $info .= '</pre>';
- echo $info;
- }
- return $result;
- }
- public static function error() {
- return mysql_error();
- }
-
- public static function get_course_by_category($category_id) {
- $info = self::fetch_array(self::query('SELECT course_code FROM '.self::get_main_table(TABLE_MAIN_GRADEBOOK_CATEGORY).' WHERE id='.$category_id, __FILE__, __LINE__), 'ASSOC');
- return $info ? $info['course_code'] : false;
- }
-
- public static function store_result($result, $option = 'BOTH') {
- $array = array();
- if ($result !== false) {
- while ($row = self::fetch_array($result, $option)) {
- $array[] = $row;
- }
- }
- return $array;
- }
-
-
- public static function get_language_isocode($language) {
- return api_get_language_isocode($language);
- }
-
- public static function get_last_insert_id() {
- return mysql_insert_id();
- }
- }
|