/**
* @brief Process resource actions
* @global type $tool_content
* @global type $id
* @global type $langResourceCourseUnitDeleted
* @global type $langResourceUnitModified
* @global type $course_id
* @global type $course_code
* @return string
*/
function process_actions()
{
global $tool_content, $id, $langResourceCourseUnitDeleted, $langResourceUnitModified, $course_id, $course_code, $webDir;
// update index and refresh course metadata
require_once 'modules/search/indexer.class.php';
require_once 'modules/course_metadata/CourseXML.php';
if (isset($_REQUEST['edit'])) {
$res_id = intval($_GET['edit']);
if ($id = check_admin_unit_resource($res_id)) {
return edit_res($res_id);
}
} elseif (isset($_REQUEST['edit_res_submit'])) {
// edit resource
$res_id = intval($_REQUEST['resource_id']);
if ($id = check_admin_unit_resource($res_id)) {
@($restitle = $_REQUEST['restitle']);
$rescomments = purify($_REQUEST['rescomments']);
$result = Database::get()->query("UPDATE course_weekly_view_activities SET\n title = ?s,\n comments = ?s\n WHERE course_weekly_view_id = ?d AND id = ?d", $restitle, $rescomments, $id, $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_UNITRESOURCE, $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_COURSE, $course_id);
CourseXMLElement::refreshCourse($course_id, $course_code);
}
$tool_content .= "<div class='alert alert-success'>{$langResourceUnitModified}</div>";
} elseif (isset($_REQUEST['del'])) {
// delete resource from course unit
$res_id = intval($_GET['del']);
if ($id = check_admin_unit_resource($res_id)) {
Database::get()->query("DELETE FROM course_weekly_view_activities WHERE id = ?d", $res_id);
Indexer::queueAsync(Indexer::REQUEST_REMOVE, Indexer::RESOURCE_UNITRESOURCE, $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_COURSE, $course_id);
CourseXMLElement::refreshCourse($course_id, $course_code);
$tool_content .= "<div class='alert alert-success'>{$langResourceCourseUnitDeleted}</div>";
}
} elseif (isset($_REQUEST['vis'])) {
// modify visibility in text resources only
$res_id = intval($_REQUEST['vis']);
if ($id = check_admin_unit_resource($res_id)) {
$vis = Database::get()->querySingle("SELECT `visible` FROM course_weekly_view_activities WHERE id = ?d", $res_id)->visible;
$newvis = $vis == 1 ? 0 : 1;
Database::get()->query("UPDATE course_weekly_view_activities SET visible = '{$newvis}' WHERE id = ?d", $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_UNITRESOURCE, $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_COURSE, $course_id);
CourseXMLElement::refreshCourse($course_id, $course_code);
}
} elseif (isset($_REQUEST['down'])) {
// change order down
$res_id = intval($_REQUEST['down']);
if ($id = check_admin_unit_resource($res_id)) {
move_order('course_weekly_view_activities', 'id', $res_id, 'order', 'down', "course_weekly_view_id={$id}");
}
} elseif (isset($_REQUEST['up'])) {
// change order up
$res_id = intval($_REQUEST['up']);
if ($id = check_admin_unit_resource($res_id)) {
move_order('course_weekly_view_activities', 'id', $res_id, 'order', 'up', "course_weekly_view_id={$id}");
}
}
return '';
}
if ($course_info->view_type == 'units' or $course_info->view_type == 'simple') {
move_order('course_units', 'id', $id, 'order', 'down', "course_id=$course_id");
} else {
$res_id = intval(getDirectReference($_REQUEST['down']));
if (($id = check_admin_unit_resource($res_id))) {
move_order('course_weekly_view_activities', 'id', $res_id, 'order', 'down', "course_weekly_view_id=$id");
}
}
} elseif (isset($_REQUEST['up'])) { // change order up
$id = intval(getDirectReference($_REQUEST['up']));
if ($course_info->view_type == 'units' or $course_info->view_type == 'simple') {
move_order('course_units', 'id', $id, 'order', 'up', "course_id=$course_id");
} else {
$res_id = intval(getDirectReference($_REQUEST['up']));
if (($id = check_admin_unit_resource($res_id))) {
move_order('course_weekly_view_activities', 'id', $res_id, 'order', 'up', "course_weekly_view_id=$id");
}
}
}
if (isset($_REQUEST['visW'])) { // modify visibility of the Week
$id = intval(getDirectReference($_REQUEST['visW']));
$vis = Database::get()->querySingle("SELECT `visible` FROM course_weekly_view WHERE id = ?d", $id)->visible;
$newvis = ($vis == 1) ? 0 : 1;
Database::get()->query("UPDATE course_weekly_view SET visible = ?d WHERE id = ?d AND course_id = ?d", $newvis, $id, $course_id);
}
}
//style='color:#999999; font-size:13px;'
$bar_content .= "<b>" . $langCode . ":</b> " . q($public_code) . "" .
function processActions() {
global $tool_content, $langResourceCourseUnitDeleted, $course_id, $course_code;
if (isset($_REQUEST['del'])) { // delete resource from course unit
$res_id = intval(getDirectReference($_REQUEST['del']));
Database::get()->query("DELETE FROM course_description WHERE id = ?d AND course_id = ?d", $res_id, $course_id);
CourseXMLElement::refreshCourse($course_id, $course_code);
Session::Messages($langResourceCourseUnitDeleted, "alert-success");
redirect_to_home_page("modules/course_description/index.php?course=$course_code");
} elseif (isset($_REQUEST['vis'])) { // modify visibility in text resources only
$res_id = intval(getDirectReference($_REQUEST['vis']));
$vis = Database::get()->querySingle("SELECT `visible` FROM course_description WHERE id = ?d AND course_id = ?d", $res_id, $course_id);
$newvis = (intval($vis->visible) === 1) ? 0 : 1;
Database::get()->query("UPDATE course_description SET `visible` = ?d, update_dt = NOW() WHERE id = ?d AND course_id = ?d", $newvis, $res_id, $course_id);
CourseXMLElement::refreshCourse($course_id, $course_code);
redirect_to_home_page("modules/course_description/index.php?course=$course_code");
} elseif (isset($_REQUEST['down'])) { // change order down
$res_id = intval(getDirectReference($_REQUEST['down']));
move_order('course_description', 'id', $res_id, 'order', 'down', "course_id = $course_id");
redirect_to_home_page("modules/course_description/index.php?course=$course_code");
} elseif (isset($_REQUEST['up'])) { // change order up
$res_id = intval(getDirectReference($_REQUEST['up']));
move_order('course_description', 'id', $res_id, 'order', 'up', "course_id = $course_id");
redirect_to_home_page("modules/course_description/index.php?course=$course_code");
}
}
<input name='BID' type="hidden" value="<?php
echo $BID;
?>
">
</form>
<?php
//print_r($_REQUEST);
//echo "bannerid is --- ".$BID;
if ($_REQUEST['move_type'] != '') {
if ($_REQUEST['move_type'] == 'B') {
// move block
move_block($_REQUEST['cb_from'], $_REQUEST['cb_to'], $BID);
} else {
move_order($_REQUEST['cb_from'], $_REQUEST['cb_to'], $BID);
}
}
$sql = "SELECT * FROM blocks WHERE banner_id='{$BID}'";
$result = mysql_query($sql) or die(mysql_error());
?>
<IMG name='button_move' SRC="move.gif" WIDTH="24" HEIGHT="20" BORDER="0" ALT="Move Order" onclick='bm_state_change("MOVE_ORDER")'>
<IMG name='button_move_b' SRC="move_b.gif" WIDTH="24" HEIGHT="20" BORDER="0" ALT="Move Block" onclick='bm_state_change("MOVE_BLOCK")' >
<map name="main" id="main" onmousemove="cancelIt()">
<?php
while ($row = mysql_fetch_array($result)) {
$sql = "select * from users where ID='" . $row['user_id'] . "'";
$res = mysql_query($sql) or die(mysql_error() . $sql);
$user_row = mysql_fetch_array($res);
/**
* @brief Process resource actions
* @global type $tool_content
* @global type $id
* @global type $langResourceCourseUnitDeleted
* @global type $langResourceUnitModified
* @global type $course_id
* @global type $course_code
* @return string
*/
function process_actions() {
global $tool_content, $id, $langResourceCourseUnitDeleted, $langResourceUnitModified,
$course_id, $course_code, $webDir, $cnt, $langBack, $urlAppend, $head_content;
// update index and refresh course metadata
require_once 'modules/search/indexer.class.php';
require_once 'modules/course_metadata/CourseXML.php';
if (isset($_REQUEST['edit'])) {
$res_id = intval($_GET['edit']);
if ($id = check_admin_unit_resource($res_id)) {
$tool_content .= action_bar(array(
array(
'title' => $langBack,
'url' => "{$urlAppend}modules/weeks/index.php?course=$course_code&id=$id&cnt=$cnt",
'icon' => 'fa-reply',
'level' => 'primary-label')));
$tool_content .= edit_res($res_id);
draw($tool_content, 2, null, $head_content);
exit;
}
} elseif (isset($_REQUEST['edit_res_submit'])) { // edit resource
$res_id = intval($_REQUEST['resource_id']);
if ($id = check_admin_unit_resource($res_id)) {
@$restitle = $_REQUEST['restitle'];
$rescomments = purify($_REQUEST['rescomments']);
$result = Database::get()->query("UPDATE course_weekly_view_activities SET
title = ?s,
comments = ?s
WHERE course_weekly_view_id = ?d AND id = ?d", $restitle, $rescomments, $id, $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_UNITRESOURCE, $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_COURSE, $course_id);
CourseXMLElement::refreshCourse($course_id, $course_code);
redirect_to_home_page("modules/weeks/index.php?course=$course_code&id=$id&cnt=$cnt");
}
$tool_content .= "<div class='alert alert-success'>$langResourceUnitModified</div>";
} elseif (isset($_REQUEST['del'])) { // delete resource from course unit
$res_id = intval($_GET['del']);
if ($id = check_admin_unit_resource($res_id)) {
Database::get()->query("DELETE FROM course_weekly_view_activities WHERE id = ?d", $res_id);
Indexer::queueAsync(Indexer::REQUEST_REMOVE, Indexer::RESOURCE_UNITRESOURCE, $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_COURSE, $course_id);
CourseXMLElement::refreshCourse($course_id, $course_code);
Session::Messages($langResourceCourseUnitDeleted, 'alert-success');
redirect_to_home_page("modules/weeks/index.php?course=$course_code&id=$id&cnt=$cnt");
}
} elseif (isset($_REQUEST['vis'])) { // modify visibility in text resources only
$res_id = intval($_REQUEST['vis']);
if ($id = check_admin_unit_resource($res_id)) {
$vis = Database::get()->querySingle("SELECT `visible` FROM course_weekly_view_activities WHERE id = ?d", $res_id)->visible;
$newvis = ($vis == 1) ? 0 : 1;
Database::get()->query("UPDATE course_weekly_view_activities SET visible = '$newvis' WHERE id = ?d", $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_UNITRESOURCE, $res_id);
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_COURSE, $course_id);
CourseXMLElement::refreshCourse($course_id, $course_code);
redirect_to_home_page("modules/weeks/index.php?course=$course_code&id=$id&cnt=$cnt");
}
} elseif (isset($_REQUEST['down'])) { // change order down
$res_id = intval($_REQUEST['down']);
if ($id = check_admin_unit_resource($res_id)) {
move_order('course_weekly_view_activities', 'id', $res_id, 'order', 'down', "course_weekly_view_id=$id");
redirect_to_home_page("modules/weeks/index.php?course=$course_code&id=$id&cnt=$cnt");
}
} elseif (isset($_REQUEST['up'])) { // change order up
$res_id = intval($_REQUEST['up']);
if ($id = check_admin_unit_resource($res_id)) {
move_order('course_weekly_view_activities', 'id', $res_id, 'order', 'up', "course_weekly_view_id=$id");
redirect_to_home_page("modules/weeks/index.php?course=$course_code&id=$id&cnt=$cnt");
}
}
return '';
}
</form>
</div>";
}
}
}
}
}
if (isset($_GET['down'])) {
move_order('link', 'id', intval(getDirectReference($_GET['down'])), 'order', 'down', "course_id = $course_id");
} elseif (isset($_GET['up'])) {
move_order('link', 'id', intval(getDirectReference($_GET['up'])), 'order', 'up', "course_id = $course_id");
} elseif (isset($_GET['cdown'])) {
move_order('link_category', 'id', intval(getDirectReference($_GET['cdown'])), 'order', 'down', "course_id = $course_id");
} elseif (isset($_GET['cup'])) {
move_order('link_category', 'id', intval(getDirectReference($_GET['cup'])), 'order', 'up', "course_id = $course_id");
}
$display_tools = $is_editor && !$is_in_tinymce;
if (!in_array($action, array('addlink', 'editlink', 'addcategory', 'editcategory', 'settings'))) {
if ($social_bookmarks_enabled == 1) {
$countlinks = Database::get()->querySingle("SELECT COUNT(*) AS cnt FROM `link` WHERE course_id = ?d AND category <> ?d", $course_id, -1)->cnt;
} else {
$countlinks = Database::get()->querySingle("SELECT COUNT(*) AS cnt FROM `link` WHERE course_id = ?d AND category <> ?d AND category <> ?d", $course_id, -1, -2)->cnt;
}
if ($countlinks > 0) {
$numberofzerocategory = count(Database::get()->queryArray("SELECT * FROM `link` WHERE course_id = ?d AND (category = 0 OR category IS NULL)", $course_id));
// making the show none / show all links. Show none means urlview=0000 (number of zeros depending on the
// number of categories). Show all means urlview=1111 (number of 1 depending on teh number of categories).
$resultcategories = Database::get()->queryArray("SELECT * FROM `link_category` WHERE course_id = ?d ORDER BY `order`", $course_id);
$aantalcategories = count($resultcategories);
$title = $r->title;
Database::get()->query("DELETE FROM ebook_subsection WHERE section_id IN\n (SELECT id FROM ebook_section WHERE ebook_id = ?d)", $id);
Database::get()->query("DELETE FROM ebook_section WHERE ebook_id = ?d", $id);
Database::get()->query("DELETE FROM ebook WHERE id = ?d", $id);
$basedir = $webDir . 'courses/' . $course_code . '/ebook/' . $id;
my_delete($basedir);
Database::get()->query("DELETE FROM document WHERE\n subsystem = " . EBOOK . " AND\n subsystem_id = ?d AND\n course_id = ?d", $id, $course_id);
$tool_content .= "<div class='alert-success'>" . q(sprintf($langEBookDeleted, $title)) . "</div>";
}
} elseif (isset($_GET['create'])) {
$navigation[] = array('url' => "{$_SERVER['SCRIPT_NAME']}?course={$course_code}", 'name' => $langEBook);
$tool_content .= "\n <div class='form-wrapper'>\n <form class='form-horizontal' role='form' method='post' action='create.php?course={$course_code}' enctype='multipart/form-data'> \n <div class='form-group'>\n <label for='ebook_title' class='col-sm-2 control-label'>{$langTitle}: </label>\n <div class='col-sm-10'>\n <input type='text' class='form-control' id='ebook_title' name='title' placeholder='{$langTitle}'> \n </div>\n </div>\n <div class='form-group'>\n <label for='fileUpload' class='col-sm-2 control-label'>{$langZipFile}:</label>\n <div class='col-sm-10'> \n <input type='file' name='file' id='fileUpload'> \n </div>\n </div>\n <div class='row'>\n <div class='col-sm-10 col-sm-offset-2 '>\n <input type='submit' class='btn btn-primary' name='submit' value='{$langSend}' />\n <a href='index.php?course={$course_code}' class='btn btn-default'>{$langCancel}</a> \n </div>\n </div> \n </form>\n </div>";
} elseif (isset($_GET['down'])) {
move_order('ebook', 'id', intval($_GET['down']), 'order', 'down', "course_id = {$course_id}");
} elseif (isset($_GET['up'])) {
move_order('ebook', 'id', intval($_GET['up']), 'order', 'up', "course_id = {$course_id}");
} elseif (isset($_GET['vis'])) {
Database::get()->query("UPDATE ebook SET visible = NOT visible\n WHERE course_id = ?d AND\n id = ?d", $course_id, $_GET['vis']);
}
}
if ($is_editor) {
$visibility_check = '';
} else {
$visibility_check = "AND visible = 1 AND ebook_subsection.id IS NOT NULL";
}
$q = Database::get()->queryArray("SELECT ebook.id, ebook.title, visible, MAX(ebook_subsection.id) AS sid\n FROM ebook LEFT JOIN ebook_section ON ebook.id = ebook_id\n LEFT JOIN ebook_subsection ON ebook_section.id = section_id\n WHERE course_id = ?d\n {$visibility_check}\n GROUP BY ebook.id\n ORDER BY `order`", $course_id);
if (!$q) {
$tool_content .= "<div class='alert alert-warning'>{$langNoEBook}</div>";
} else {
$tool_content .= "<div class='table-responsive'>";
$tool_content .= "<table class='table-default'>\n <tr>\n <th class = 'text-left'>{$langEBook}</th>" . ($is_editor ? "<th width='70' class='text-center'>" . icon('fa-gears') . "</th>" : '<th> </th>') . "\n </tr>";
$form_legend = $langCategoryMod;
} else {
$form_name = $form_description = '';
$form_legend = $langCategoryAdd;
}
$tool_content .= "<fieldset>\n <div class='form-group'>\n <label for='CatName' class='col-sm-2 control-label'>{$langCategoryName}:</label>\n <div class='col-sm-10'>\n <input class='form-control' type='text' name='categoryname' size='53' placeholder='{$langCategoryName}' {$form_name}>\n </div>\n </div>\n <div class='form-group'>\n <label for='CatDesc' class='col-sm-2 control-label'>{$langDescription}:</label>\n <div class='col-sm-10'>\n <textarea class='form-control' rows='5' name='description'>{$form_description}</textarea>\n </div>\n </div> \n <div class='col-sm-offset-2 col-sm-10'>\n <input type='submit' class='btn btn-primary' name='submitCategory' value='{$form_legend}' />\n <a href='{$_SERVER['SCRIPT_NAME']}?course={$course_code}' class='btn btn-default'>{$langCancel}</a> \n </div> \n </fieldset>\n </form>\n </div>";
}
}
if (isset($_GET['down'])) {
move_order('link', 'id', intval($_GET['down']), 'order', 'down', "course_id = {$course_id}");
} elseif (isset($_GET['up'])) {
move_order('link', 'id', intval($_GET['up']), 'order', 'up', "course_id = {$course_id}");
} elseif (isset($_GET['cdown'])) {
move_order('link_category', 'id', intval($_GET['cdown']), 'order', 'down', "course_id = {$course_id}");
} elseif (isset($_GET['cup'])) {
move_order('link_category', 'id', intval($_GET['cup']), 'order', 'up', "course_id = {$course_id}");
}
if (!in_array($action, array('addlink', 'editlink', 'addcategory', 'editcategory'))) {
$countlinks = Database::get()->querySingle("SELECT COUNT(*) AS cnt FROM `link` WHERE course_id = ?d", $course_id)->cnt;
if ($countlinks > 0) {
$numberofzerocategory = count(Database::get()->queryArray("SELECT * FROM `link` WHERE course_id = ?d AND (category = 0 OR category IS NULL)", $course_id));
// making the show none / show all links. Show none means urlview=0000 (number of zeros depending on the
// number of categories). Show all means urlview=1111 (number of 1 depending on teh number of categories).
$resultcategories = Database::get()->queryArray("SELECT * FROM `link_category` WHERE course_id = ?d ORDER BY `order`", $course_id);
$aantalcategories = count($resultcategories);
$tool_content .= "\n <div class='row'>\n <div class='col-sm-12'>\n <div class='table-responsive'>\n <table class='table-default'>";
// uncategorized links
if ($numberofzerocategory !== 0) {
$tool_content .= "<tr><th class='text-left'>{$langNoCategory}</th><th class='text-center'>" . icon('fa-gears') . "</th></tr>";
showlinksofcategory(0);
}
