function subscribeToCourse($id_user, $id_course, $id_date = 0) { require_once _lms_ . '/admin/modules/subscribe/subscribe.php'; require_once _lms_ . '/lib/lib.date.php'; require_once _lms_ . '/lib/lib.course.php'; $date_man = new DateManager(); $acl_man =& Docebo::user()->getAclManager(); $query = "SELECT idCourse" . " FROM " . $GLOBALS['prefix_lms'] . "_courseuser" . " WHERE idUser = "******"SELECT subscribe_method FROM " . $GLOBALS['prefix_lms'] . "_course WHERE idCourse = " . $id_course)); $waiting = 0; if ($subscribe_method == '1') { $waiting = 1; } if ($id_date != 0) { if (array_search($id_course, $courses) !== false) { if (array_search($id_date, $dates) === false) { if (!$date_man->addUserToDate($id_date, $id_user, getLogUserId())) { return false; } } } else { $acl_man->addToGroup($level_idst[3], $id_user); $re = sql_query("INSERT INTO " . $GLOBALS['prefix_lms'] . "_courseuser\r\n\t\t\t\t\t\t\t\t\t(idUser, idCourse, edition_id, level, waiting, subscribed_by, date_inscr)\r\n\t\t\t\t\t\t\t\t\tVALUES ('" . $id_user . "', '" . $id_course . "', '0', '3', '" . $waiting . "', '" . getLogUserId() . "', '" . date("Y-m-d H:i:s") . "')"); if ($re) { addUserToTimeTable($id_user, $id_course, 0); if (!$date_man->addUserToDate($id_date, $id_user, getLogUserId())) { return false; } } } } else { if (array_search($id_course, $courses) === false) { $acl_man->addToGroup($level_idst[3], $id_user); $re = sql_query("INSERT INTO " . $GLOBALS['prefix_lms'] . "_courseuser\r\n\t\t\t\t\t\t\t\t\t(idUser, idCourse, edition_id, level, waiting, subscribed_by, date_inscr)\r\n\t\t\t\t\t\t\t\t\tVALUES ('" . $id_user . "', '" . $id_course . "', '0', '3', '" . $waiting . "', '" . getLogUserId() . "', '" . date("Y-m-d H:i:s") . "')"); if ($re) { addUserToTimeTable($id_user, $id_course, 0); } else { return false; } } } return true; }
public function activateCourses($id_transaction, $id_user, $activations) { require_once _lms_ . '/lib/lib.subscribe.php'; require_once _lms_ . '/admin/modules/subscribe/subscribe.php'; require_once _lms_ . '/lib/lib.date.php'; require_once _lms_ . '/lib/lib.course.php'; $subscribe_man = new CourseSubscribe_Management(); $date_man = new DateManager(); $acl_man =& Docebo::user()->getAclManager(); $query = "SELECT idCourse" . " FROM " . $this->table_courseuser . " WHERE idUser = "******"UPDATE " . $this->table_transaction_info . " SET activated = 1" . " WHERE id_transaction = " . $id_transaction . " AND id_course = " . $id_course . " AND id_date = " . $id_date; if (!sql_query($query_up)) { return false; } } } else { $query_up = "UPDATE " . $this->table_transaction_info . " SET activated = 1" . " WHERE id_transaction = " . $id_transaction . " AND id_course = " . $id_course . " AND id_date = " . $id_date; if (!sql_query($query_up)) { return false; } } } else { $acl_man->addToGroup($level_idst[3], $id_user); $re = mysql_query("INSERT INTO " . $GLOBALS['prefix_lms'] . "_courseuser\n\t\t\t\t\t\t\t\t\t\t\t(idUser, idCourse, edition_id, level, waiting, subscribed_by, date_inscr)\n\t\t\t\t\t\t\t\t\t\t\tVALUES ('" . $id_user . "', '" . $id_course . "', '0', '3', '0', '" . getLogUserId() . "', '" . date("Y-m-d H:i:s") . "')"); if ($re) { $courses[$id_course] = $id_course; addUserToTimeTable($id_user, $id_course, 0); if (!$date_man->addUserToDate($id_date, $id_user, getLogUserId())) { return false; } else { $query_up = "UPDATE " . $this->table_transaction_info . " SET activated = 1" . " WHERE id_transaction = " . $id_transaction . " AND id_course = " . $id_course . " AND id_date = " . $id_date; if (!sql_query($query_up)) { return false; } } } else { return false; } } } } else { if (array_search($id_course, $courses) !== false) { $query_up = "UPDATE " . $this->table_transaction_info . " SET activated = 1" . " WHERE id_transaction = " . $id_transaction . " AND id_course = " . $id_course . " AND id_date = 0"; if (!sql_query($query_up)) { return false; } } else { $acl_man->addToGroup($level_idst[3], $id_user); $re = mysql_query("INSERT INTO " . $GLOBALS['prefix_lms'] . "_courseuser\n\t\t\t\t\t\t\t\t\t\t(idUser, idCourse, edition_id, level, waiting, subscribed_by, date_inscr)\n\t\t\t\t\t\t\t\t\t\tVALUES ('" . $id_user . "', '" . $id_course . "', '0', '3', '0', '" . getLogUserId() . "', '" . date("Y-m-d H:i:s") . "')"); if ($re) { $courses[$id_course] = $id_course; addUserToTimeTable($id_user, $id_course, 0); $query_up = "UPDATE " . $this->table_transaction_info . " SET activated = 1" . " WHERE id_transaction = " . $id_transaction . " AND id_course = " . $id_course . " AND id_date = 0"; if (!sql_query($query_up)) { return false; } } else { return false; } } } } return true; }