/**
* @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')");
}
