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'); } }