/** * @brief function to check if user is a guest user * @global type $uid * @return boolean */ function check_guest($id = FALSE) { //global $uid; if ($id) { $uid = $id; } else { $uid = $GLOBALS['uid']; } if (isset($uid) and $uid) { if (DBHelper::fieldExists("user", "status")) { $status = Database::get()->querySingle("SELECT status FROM user WHERE id = ?d", $uid); if ($status && $status->status == USER_GUEST) { return TRUE; } } } return false; }
if (DBHelper::fieldExists('link', 'hits')) { // not needed delete_field('link', 'hits'); } Database::get()->query("CREATE TABLE IF NOT EXISTS `group_category` ( `id` INT(6) NOT NULL AUTO_INCREMENT, `course_id` INT(11) NOT NULL, `name` VARCHAR(255) NOT NULL, `description` TEXT, PRIMARY KEY (`id`, `course_id`)) $charset_spec"); if (!DBHelper::fieldExists('group', 'category_id')) { Database::get()->query("ALTER TABLE `group` ADD `category_id` INT(11) NULL"); } //Group Mapping due to group_id addition in group_properties table if (!DBHelper::fieldExists('group_properties', 'group_id')) { Database::get()->query("ALTER TABLE `group_properties` ADD `group_id` INT(11) NOT NULL DEFAULT 0"); Database::get()->query("ALTER TABLE `group_properties` DROP PRIMARY KEY"); $group_info = Database::get()->queryArray("SELECT * FROM group_properties"); foreach ($group_info as $group) { $cid = $group->course_id; $self_reg = $group->self_registration; $multi_reg = $group->multiple_registration; $unreg = $group->allow_unregister; $forum = $group->forum; $priv_forum = $group->private_forum; $documents = $group->documents; $wiki = $group->wiki; $agenda = $group->agenda; Database::get()->query("DELETE FROM group_properties WHERE course_id = ?d", $cid);
Database::get()->query("USE `{$mysqlMainDb}`"); Database::get()->query("CREATE TABLE IF NOT EXISTS `theme_options` (\n `id` int(11) NOT NULL AUTO_INCREMENT,\n `name` VARCHAR(300) NOT NULL,\n `styles` LONGTEXT NOT NULL,\n PRIMARY KEY (`id`)) {$charset_spec}"); //Add course home_layout fiels if (!DBHelper::fieldExists('home_layout', 'course')) { Database::get()->query("ALTER TABLE course ADD home_layout TINYINT(1) NOT NULL DEFAULT 1"); Database::get()->query("UPDATE course SET home_layout = 3"); } if (!DBHelper::fieldExists('q_scale', 'poll_question')) { Database::get()->query("ALTER TABLE poll_question ADD q_scale INT(11) NULL DEFAULT NULL"); } //Add course image field if (!DBHelper::fieldExists('course_image', 'course')) { Database::get()->query("ALTER TABLE course ADD course_image VARCHAR(400) NULL"); } // Move course description from unit_resources to new course.description field if (!DBHelper::fieldExists('description', 'course')) { Database::get()->query("ALTER TABLE course ADD description MEDIUMTEXT NOT NULL"); $result = Database::get()->query("UPDATE course, course_units, unit_resources\n SET course.description = unit_resources.comments\n WHERE course.id = course_units.course_id AND\n course_units.id = unit_resources.unit_id AND\n course_units.`order` = -1 AND\n unit_resources.res_id = -1"); if ($result->affectedRows) { Database::get()->query("DELETE FROM unit_resources WHERE res_id = -1"); Database::get()->query("DELETE FROM course_units WHERE `order` = -1"); } } set_config('theme', 'default'); set_config('theme_options_id', 0); } // update eclass version Database::get()->query("UPDATE config SET `value` = '" . ECLASS_VERSION . "' WHERE `key`='version'"); updateInfo(1, $langUpgradeSuccess); $logdate = date("Y-m-d_G:i:s"); $output_result = "<br/><div class='alert alert-success'>{$langUpgradeSuccess}<br/><b>{$langUpgReady}</b><br/><a href=\"../courses/log-{$logdate}.html\" target=\"_blank\">Log output</a></div><p/>";
/** * upgrade to 2.1.3 * @global type $mysqlMainDb * @global type $langEncodeDropBoxDocuments * @global type $langUpgCourse * @param type $code * @param type $extramessage */ function upgrade_course_2_1_3($code) { global $langEncodeDropBoxDocuments, $langUpgCourse; Database::get()->query("USE `$code`"); // added field visibility in agenda if (!DBHelper::fieldExists('agenda', 'visibility', $code)) echo add_field('agenda', 'visibility', "CHAR(1) NOT NULL DEFAULT 'v'"); // upgrade dropbox echo "$langEncodeDropBoxDocuments<br>"; Database::get()->queryFunc("SELECT id, filename, title FROM dropbox_file", function ($dbox) use ($code) { encode_dropbox_documents($code, $dbox->id, $dbox->filename, $dbox->title); }); // upgrade lp_module me to kainourio content type Database::get()->query("ALTER TABLE `lp_module` CHANGE `contentType` `contentType` ENUM('CLARODOC','DOCUMENT','EXERCISE','HANDMADE','SCORM','SCORM_ASSET','LABEL','COURSE_DESCRIPTION','LINK')"); }