function addSubscription()
{
checkPerm('view');
require_once _base_ . '/lib/lib.form.php';
$action = importVar('action', true, 0);
$id_event = importVar('id_event', true, 0);
$lang =& DoceboLanguage::createInstance('reservation');
$out = $GLOBALS['page'];
$out->setWorkingZone('content');
$man_res = new Man_Reservation();
if (isset($_POST['save_profile'])) {
$confirm = importVar('confirm', true, 0);
if ($confirm) {
require_once $GLOBALS['where_lms'] . '/lib/lib.lms_user_profile.php';
$out->add(getTitleArea('_RESERVATION_PROFILE_MODIFY') . '<div class="std_block">', 'content');
$profile = new LmsUserProfile(getLogUserId(), true);
$profile->init('subscription', 'lms', 'modname=reservation&op=add_subscription&id_event=' . $id_event . '&confirm=1&from=2&id_user='******'ap');
$out->add($profile->getTitleArea() . $profile->getHead() . $profile->performAction() . $profile->getFooter() . '</div>', 'content');
}
} elseif (isset($_GET['confirm'])) {
$confirm = importVar('confirm', true, 0);
if ($confirm) {
require_once $GLOBALS['where_lms'] . '/lib/lib.lms_user_profile.php';
$out->add(getTitleArea($lang->def('_RESERVATION_PROFILE_MODIFY')) . '<div class="std_block">', 'content');
$out->add($lang->def('_CONFIRM_DATA') . '<br/>');
$profile = new LmsUserProfile(getLogUserId(), true);
$profile->init('subscription', 'lms', 'modname=reservation&op=add_subscription&id_event=' . $id_event . '&confirm=1&from=2&id_user='******'ap');
//$profile->enableEditMode();
$out->add($profile->getTitleArea() . $profile->getHead() . $profile->performAction() . $profile->getFooter() . '</div>', 'content');
}
} else {
$event_info = $man_res->getEventInfo($id_event);
$out->add(getTitleArea($lang->def('_ADD_SUBSCRIPTION_TITLE'), '', $lang->def('_EVENT')) . '<div class="std_block">' . getModifyUi($lang->def('_AREYOUSURE_ADD_SUBSCRIPTION'), $event_info[EVENT_TITLE], true, 'index.php?modname=reservation&op=add_subscription&id_event=' . $id_event . '&confirm=1&ap=mod_profile&from=2', 'index.php?modname=reservation&op=reservation') . '</div>', 'content');
}
}
function moveThread($id_thread, $id_forum)
{
require_once _base_ . '/lib/lib.form.php';
$lang =& DoceboLanguage::CreateInstance('forum');
$mod_perm = checkPerm('mod', true);
$moderate = checkPerm('moderate', true);
$action = importVar('action', true, 0);
if (isset($_GET['confirm'])) {
$id_new_forum = importVar('new_forum', true, 0);
$id_thread = importVar('id_thread', true, 0);
$id_forum = importVar('id_forum', true, 0);
$confirm = importVar('confirm', true, 0);
if ($confirm) {
// Move the thread to the new forum
$query = "UPDATE " . $GLOBALS['prefix_lms'] . "_forumthread" . " SET idForum = '" . $id_new_forum . "'" . " WHERE idThread = '" . $id_thread . "'";
$result = sql_query($query);
// Select thenumber of the post in the thread
$query_2 = "SELECT num_post" . " FROM " . $GLOBALS['prefix_lms'] . "_forumthread" . " WHERE idThread = '" . $id_thread . "'";
list($num_post) = sql_fetch_row(sql_query($query_2));
// Update the forum info
$query_3 = "SELECT idForum, num_thread, num_post" . " FROM " . $GLOBALS['prefix_lms'] . "_forum" . " WHERE idForum = '" . $id_forum . "'" . " OR idForum = '" . $id_new_forum . "'";
$result_3 = sql_query($query_3);
$num_post_update = array();
$num_thread_update = array();
while (list($idForum, $num_thread_3, $num_post_3) = sql_fetch_row($result_3)) {
if ($idForum == $id_forum) {
$num_post_update[$idForum] = $num_post_3 - $num_post;
$num_thread_update[$idForum] = $num_thread_3 - 1;
} else {
$num_post_update[$idForum] = $num_post_3 + $num_post;
$num_thread_update[$idForum] = $num_thread_3 + 1;
}
}
$last_message_update = array();
$query_4 = "SELECT idMessage" . " FROM " . $GLOBALS['prefix_lms'] . "_forummessage" . " WHERE idThread IN" . "(" . " SELECT idThread" . " FROM " . $GLOBALS['prefix_lms'] . "_forumthread" . " WHERE idForum = '" . $id_forum . "'" . ")" . " ORDER BY posted DESC" . " LIMIT 0,1";
list($last_message_update[$id_forum]) = sql_fetch_row(sql_query($query_4));
$query_5 = "SELECT idMessage" . " FROM " . $GLOBALS['prefix_lms'] . "_forummessage" . " WHERE idThread IN" . "(" . " SELECT idThread" . " FROM " . $GLOBALS['prefix_lms'] . "_forumthread" . " WHERE idForum = '" . $id_new_forum . "'" . ")" . " ORDER BY posted DESC" . " LIMIT 0,1";
list($last_message_update[$id_new_forum]) = sql_fetch_row(sql_query($query_5));
$query_update_1 = "UPDATE " . $GLOBALS['prefix_lms'] . "_forum" . " SET num_post = '" . $num_post_update[$id_forum] . "'," . " num_thread='" . $num_thread_update[$id_forum] . "'," . " last_post = '" . $last_message_update[$id_forum] . "'" . " WHERE idForum = '" . $id_forum . "'";
$result_update_1 = sql_query($query_update_1);
$query_update_2 = "UPDATE " . $GLOBALS['prefix_lms'] . "_forum" . " SET num_post = '" . $num_post_update[$id_new_forum] . "'," . " num_thread='" . $num_thread_update[$id_new_forum] . "'," . " last_post = '" . $last_message_update[$id_new_forum] . "'" . " WHERE idForum = '" . $id_new_forum . "'";
$result_update_2 = sql_query($query_update_2);
}
Util::jump_to('index.php?modname=forum&op=thread&idForum=' . $id_forum);
}
if ($action) {
$id_new_forum = importVar('new_forum', true, 0);
$id_thread = importVar('id_thread', true, 0);
$id_forum = importVar('id_forum', true, 0);
list($title) = sql_fetch_row(sql_query("SELECT title" . " FROM " . $GLOBALS['prefix_lms'] . "_forumthread" . " WHERE idThread = '" . $id_thread . "'"));
list($from_forum) = sql_fetch_row(sql_query("SELECT title" . " FROM " . $GLOBALS['prefix_lms'] . "_forum" . " WHERE idForum = '" . $id_forum . "'"));
list($to_forum) = sql_fetch_row(sql_query("SELECT title" . " FROM " . $GLOBALS['prefix_lms'] . "_forum" . " WHERE idForum = '" . $id_new_forum . "'"));
$GLOBALS['page']->add(getTitleArea($lang->def('_MOVE'), 'forum') . '<div class="std_block">' . getModifyUi($lang->def('_AREYOUSURE_MOVE'), '<span>' . $lang->def('_TITLE') . ' : </span> "' . $title . '"' . ' ' . $lang->def('_FROM_FORUM') . ' "' . $from_forum . '" ' . $lang->def('_TO_FORUM') . ' "' . $to_forum . '"', true, 'index.php?modname=forum&op=movethread&new_forum=' . $id_new_forum . '&id_thread=' . $id_thread . '&id_forum=' . $id_forum . '&confirm=1', 'index.php?modname=forum&op=movethread&id_forum=' . $id_forum . '&confirm=0') . '</div>', 'content');
} else {
$id_course = (int) $_SESSION['idCourse'];
$id_forum = importVar('id_forum', true, 0);
$list_forum = array();
$query = "SELECT idForum, title" . " FROM " . $GLOBALS['prefix_lms'] . "_forum" . " WHERE idCourse = '" . $id_course . "'" . " AND idForum <> '" . $id_forum . "'";
$result = sql_query($query);
while (list($id_forum_b, $title) = sql_fetch_row($result)) {
$list_forum[$id_forum_b] = $title;
}
$GLOBALS['page']->add(getTitleArea($lang->def('_MOVE'), 'forum') . '<div class="std_block">' . Form::openForm('search_forum', 'index.php?modname=forum&op=movethread&id_thread=' . $id_thread . '&id_forum=' . $id_forum . '&action=1') . '<div class="form_line_l">' . Form::getDropdown($lang->def('_MOVE_TO_FORUM'), 'new_forum', 'new_forum', $list_forum) . '<input class="search_b" type="submit" id="move_thread" name="move_thread" value="' . $lang->def('_MOVE') . '" />' . '</div>' . Form::closeForm() . '</div>', 'content');
}
}
