/**
* @brief Enter the modified info submitted from the link form into the database
* @global type $course_id
* @global type $langLinkMod
* @global type $langLinkAdded
* @global type $urllink
* @global type $title
* @global type $description
* @global type $selectcategory
* @global type $langLinkNotPermitted
* @global string $state
* @return type
*/
function submit_link() {
global $course_id, $langLinkMod, $langLinkAdded, $course_code, $uid, $langSocialCategory,
$urllink, $title, $description, $selectcategory, $langLinkNotPermitted, $state;
register_posted_variables(array('urllink' => true,
'title' => true,
'description' => true), 'all', 'trim');
$urllink = canonicalize_url($urllink);
if (!is_url_accepted($urllink,"(https?|ftp)")){
$message = $langLinkNotPermitted;
if (isset($_POST['id'])) {
$id = getDirectReference($_POST['id']);
redirect_to_home_page("modules/link/index.php?course=$course_code&action=editlink&id=" . getIndirectReference($id) . "&urlview=");
} else {
redirect_to_home_page("modules/link/index.php?course=$course_code&action=addlink&urlview=");
}
}
$set_sql = "SET url = ?s, title = ?s, description = ?s, category = ?d";
$terms = array($urllink, $title, purify($description), intval(getDirectReference($_POST['selectcategory'])));
if (isset($_POST['id'])) {
$id = intval(getDirectReference($_POST['id']));
Database::get()->query("UPDATE `link` $set_sql WHERE course_id = ?d AND id = ?d", $terms, $course_id, $id);
$log_type = LOG_MODIFY;
} else {
$order = Database::get()->querySingle("SELECT MAX(`order`) as maxorder FROM `link`
WHERE course_id = ?d AND category = ?d", $course_id, getDirectReference($_POST['selectcategory']))->maxorder;
$order++;
$id = Database::get()->query("INSERT INTO `link` $set_sql, course_id = ?d, `order` = ?d, user_id = ?d", $terms, $course_id, $order, $uid)->lastInsertID;
$log_type = LOG_INSERT;
}
Indexer::queueAsync(Indexer::REQUEST_STORE, Indexer::RESOURCE_LINK, $id);
// find category name
if ($selectcategory == -2) {
$category = $langSocialCategory;
} else {
$category_object = Database::get()->querySingle("SELECT link_category.name as name FROM link, link_category
WHERE link.category = link_category.id
AND link.course_id = ?s
AND link.id = ?d", $course_id, $id);
$category = $category_object ? $category_object->name : 0;
}
$txt_description = ellipsize_html(canonicalize_whitespace(strip_tags($description)), 50, '+');
Log::record($course_id, MODULE_ID_LINKS, $log_type, @array('id' => $id,
'url' => $urllink,
'title' => $title,
'description' => $txt_description,
'category' => $category));
}
$link = explode(" ", $r->url);
$path = substr($link[0], 6);
$file2Delete = $webDir . "/" . $path;
unlink($file2Delete);
}
Database::get()->query("DELETE FROM link WHERE id = ?d", $delete);
Log::record($course_id, MODULE_ID_TOOLADMIN, LOG_DELETE, array('id' => $delete, 'link' => $r->url, 'name_link' => $r->title));
$tool_content .= "<div class='alert alert-success'>{$langLinkDeleted}</div>";
}
/**
* Add external link
*/
if (isset($_POST['submit'])) {
$link = isset($_POST['link']) ? $_POST['link'] : '';
$name_link = isset($_POST['name_link']) ? $_POST['name_link'] : '';
if (trim($link) == 'http://' or trim($link) == 'ftp://' or empty($link) or empty($name_link) or !is_url_accepted($link)) {
$tool_content .= "<div class='alert alert-danger'>{$langInvalidLink}</div>" . action_bar(array(array('title' => $langBack, 'url' => "{$_SERVER['SCRIPT_NAME']}?course={$course_code}&action=2", 'icon' => 'fa-reply', 'level' => 'primary-label')));
draw($tool_content, 2, null, $head_content);
exit;
}
$sql = Database::get()->query("INSERT INTO link (course_id, url, title, category, description)\n VALUES (?d, ?s, ?s, -1, ' ')", $course_id, $link, $name_link);
$id = $sql->lastInsertID;
$tool_content .= "<div class='alert alert-success'>{$langLinkAdded}</div>";
Log::record($course_id, MODULE_ID_TOOLADMIN, LOG_INSERT, array('id' => $id, 'link' => $link, 'name_link' => $name_link));
} elseif (isset($_GET['action'])) {
// add external link
$pageName = $langAddExtLink;
$tool_content .= action_bar(array(array('title' => $langBack, 'url' => "index.php?course={$course_code}", 'icon' => 'fa-reply', 'level' => 'primary')));
$navigation[] = array('url' => "{$_SERVER['SCRIPT_NAME']}?course={$course_code}", 'name' => $langToolManagement);
$helpTopic = 'Module';
$tool_content .= "<div class='form-wrapper'>\n <form class='form-horizontal' role='form' method='post' action='{$_SERVER['SCRIPT_NAME']}?course={$course_code}&action=true'>\n <fieldset> \n <div class='form-group'>\n <label for='link' class='col-sm-2 control-label'>{$langLink}:</label>\n <div class='col-sm-10'>\n <input id='link' type='text' name='link' size='50' value='http://'>\n </div>\n </div>\n <div class='form-group'>\n <label for-'name_link' class='col-sm-2 control-label'>{$langLinkName}:</label>\n <div class='col-sm-10'>\n <input type='Text' name='name_link' size='50'>\n </div> \n </div>\n <div class='col-sm-offset-2 col-sm-10'>\n <input class='btn btn-primary' type='submit' name='submit' value='{$langAdd}'>\n </div> \n </fieldset>\n </form>\n </div>";
if ($redirect)
$_SESSION[$drive->getName() . "_" . CloudDriveManager::CALLBACK] = $redirect;
$callback_auth = $drive->getCallbackToken();
if (!$callback_auth) {
header('Location: ' . $drive->getAuthURL());
die();
} else if ($callback_auth) {
if ($drive->authorize($callback_auth)) {
$useragent = $_SERVER['HTTP_USER_AGENT'];
if (preg_match('/(android|bb\d+|meego).+mobile|avantgo|bada\/|blackberry|blazer|compal|elaine|fennec|hiptop|iemobile|ip(hone|od)|iris|kindle|lge |maemo|midp|mmp|netfront|opera m(ob|in)i|palm( os)?|phone|p(ixi|re)\/|plucker|pocket|psp|series(4|6)0|symbian|treo|up\.(browser|link)|vodafone|wap|windows (ce|phone)|xda|xiino/i', $useragent) || preg_match('/1207|6310|6590|3gso|4thp|50[1-6]i|770s|802s|a wa|abac|ac(er|oo|s\-)|ai(ko|rn)|al(av|ca|co)|amoi|an(ex|ny|yw)|aptu|ar(ch|go)|as(te|us)|attw|au(di|\-m|r |s )|avan|be(ck|ll|nq)|bi(lb|rd)|bl(ac|az)|br(e|v)w|bumb|bw\-(n|u)|c55\/|capi|ccwa|cdm\-|cell|chtm|cldc|cmd\-|co(mp|nd)|craw|da(it|ll|ng)|dbte|dc\-s|devi|dica|dmob|do(c|p)o|ds(12|\-d)|el(49|ai)|em(l2|ul)|er(ic|k0)|esl8|ez([4-7]0|os|wa|ze)|fetc|fly(\-|_)|g1 u|g560|gene|gf\-5|g\-mo|go(\.w|od)|gr(ad|un)|haie|hcit|hd\-(m|p|t)|hei\-|hi(pt|ta)|hp( i|ip)|hs\-c|ht(c(\-| |_|a|g|p|s|t)|tp)|hu(aw|tc)|i\-(20|go|ma)|i230|iac( |\-|\/)|ibro|idea|ig01|ikom|im1k|inno|ipaq|iris|ja(t|v)a|jbro|jemu|jigs|kddi|keji|kgt( |\/)|klon|kpt |kwc\-|kyo(c|k)|le(no|xi)|lg( g|\/(k|l|u)|50|54|\-[a-w])|libw|lynx|m1\-w|m3ga|m50\/|ma(te|ui|xo)|mc(01|21|ca)|m\-cr|me(rc|ri)|mi(o8|oa|ts)|mmef|mo(01|02|bi|de|do|t(\-| |o|v)|zz)|mt(50|p1|v )|mwbp|mywa|n10[0-2]|n20[2-3]|n30(0|2)|n50(0|2|5)|n7(0(0|1)|10)|ne((c|m)\-|on|tf|wf|wg|wt)|nok(6|i)|nzph|o2im|op(ti|wv)|oran|owg1|p800|pan(a|d|t)|pdxg|pg(13|\-([1-8]|c))|phil|pire|pl(ay|uc)|pn\-2|po(ck|rt|se)|prox|psio|pt\-g|qa\-a|qc(07|12|21|32|60|\-[2-7]|i\-)|qtek|r380|r600|raks|rim9|ro(ve|zo)|s55\/|sa(ge|ma|mm|ms|ny|va)|sc(01|h\-|oo|p\-)|sdk\/|se(c(\-|0|1)|47|mc|nd|ri)|sgh\-|shar|sie(\-|m)|sk\-0|sl(45|id)|sm(al|ar|b3|it|t5)|so(ft|ny)|sp(01|h\-|v\-|v )|sy(01|mb)|t2(18|50)|t6(00|10|18)|ta(gt|lk)|tcl\-|tdg\-|tel(i|m)|tim\-|t\-mo|to(pl|sh)|ts(70|m\-|m3|m5)|tx\-9|up(\.b|g1|si)|utst|v400|v750|veri|vi(rg|te)|vk(40|5[0-3]|\-v)|vm40|voda|vulc|vx(52|53|60|61|70|80|81|83|85|98)|w3c(\-| )|webc|whit|wi(g |nc|nw)|wmlb|wonu|x700|yas\-|your|zeto|zte\-/i', substr($useragent, 0, 4))) {
$redirect = $_SESSION[$drive->getName() . "_" . CloudDriveManager::CALLBACK];
if ($redirect) {
if (strpbrk($redirect, "\r\n"))
die();
if (!is_url_accepted($redirect))
die();
if (!preg_match('#^(https?://)?(www\.)?' . $_SERVER['SERVER_NAME'] .'(/.*)?#i', $redirect))
die();
$encoded_url = preg_replace_callback('#://([^/]+)/([^?]+)#', function ($match) { return '://' . $match[1] . '/' . join('/', array_map('rawurlencode', explode('/', $match[2])));}, $redirect);
header('Location: ' . $encoded_url);
} else {
echo "Unable to redirect to base URL. Please go back and try once more. Sorry for the inconvenience.";
}
} else {
echo "<script type='text/javascript'>";
echo "window.close();";
echo "</script>";
}
} else {
echo "Unable to authorize user";
