123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902 |
- <?php
- function addlinkcategory($type)
- {
- global $catlinkstatus;
- global $msgErr;
- $ok = true;
- if ($type == "link")
- {
- $tbl_link = Database :: get_course_table(TABLE_LINK);
- $title = Security::remove_XSS($_POST['title']);
- $urllink = Security::remove_XSS($_POST['urllink']);
- $description = Security::remove_XSS($_POST['description']);
- $selectcategory = Security::remove_XSS($_POST['selectcategory']);
- if ($_POST['onhomepage'] == '') {
- $onhomepage = 0;
- $target='_self';
- } else {
- $onhomepage = Security::remove_XSS($_POST['onhomepage']);
- $target = Security::remove_XSS($_POST['target_link']);
- }
- $urllink = trim($urllink);
- $title = trim($title);
- $description = trim($description);
-
- if (empty ($urllink) OR $urllink == 'http://')
- {
- $msgErr = get_lang('GiveURL');
- Display::display_error_message(get_lang('GiveURL'));
- $ok = false;
- }
-
- else
- {
- if (empty ($title))
- {
- $title = $urllink;
- }
-
- if (!strstr($urllink, '://'))
- {
- $urllink = "http://".$urllink;
- }
-
- $result = Database::query("SELECT MAX(display_order) FROM ".$tbl_link." WHERE category_id='".Database::escape_string($_POST['selectcategory'])."'");
- list ($orderMax) = Database::fetch_row($result);
- $order = $orderMax +1;
- $session_id = api_get_session_id();
- $sql = "INSERT INTO ".$tbl_link." (url, title, description, category_id, display_order, on_homepage, target, session_id) VALUES ('$urllink','$title','$description','$selectcategory','$order', '$onhomepage','$target','$session_id')";
- $catlinkstatus = get_lang('LinkAdded');
- Database::query($sql, __FILE__, __LINE__);
- $link_id = Database::insert_id();
- if ( (api_get_setting('search_enabled')=='true') && $link_id && extension_loaded('xapian')) {
- require_once(api_get_path(LIBRARY_PATH) .'search/DokeosIndexer.class.php');
- require_once(api_get_path(LIBRARY_PATH) .'search/IndexableChunk.class.php');
- require_once(api_get_path(LIBRARY_PATH) .'specific_fields_manager.lib.php');
- $courseid = api_get_course_id();
- $specific_fields = get_specific_field_list();
- $ic_slide = new IndexableChunk();
-
- $all_specific_terms = '';
- foreach ($specific_fields as $specific_field) {
- if (isset($_REQUEST[$specific_field['code']])) {
- $sterms = trim($_REQUEST[$specific_field['code']]);
- if (!empty($sterms)) {
- $all_specific_terms .= ' '. $sterms;
- $sterms = explode(',', $sterms);
- foreach ($sterms as $sterm) {
- $ic_slide->addTerm(trim($sterm), $specific_field['code']);
- add_specific_field_value($specific_field['id'], $courseid, TOOL_LINK, $link_id, $sterm);
- }
- }
- }
- }
-
- $ic_slide->addValue("title", $title);
- $ic_slide->addCourseId($courseid);
- $ic_slide->addToolId(TOOL_LINK);
- $xapian_data = array(
- SE_COURSE_ID => $courseid,
- SE_TOOL_ID => TOOL_LINK,
- SE_DATA => array('link_id' => (int)$link_id),
- SE_USER => (int)api_get_user_id(),
- );
- $ic_slide->xapian_data = serialize($xapian_data);
- $description = $all_specific_terms .' '. $description;
- $ic_slide->addValue("content", $description);
-
- if (isset($_POST['selectcategory']) && $selectcategory>0) {
- $table_link_category = Database::get_course_table(TABLE_LINK_CATEGORY);
- $sql_cat = 'SELECT * FROM %s WHERE id=%d LIMIT 1';
- $sql_cat = sprintf($sql_cat, $table_link_category, (int)$selectcategory);
- $result = Database::query($sql_cat, __FILE__, __LINE__);
- if (Database::num_rows($result) == 1) {
- $row = Database::fetch_array($result);
- $ic_slide->addValue("category", $row['category_title']);
- }
- }
- $di = new DokeosIndexer();
- isset($_POST['language'])? $lang=Database::escape_string($_POST['language']): $lang = 'english';
- $di->connectDb(NULL, NULL, $lang);
- $di->addChunk($ic_slide);
-
- $did = $di->index();
- if ($did) {
-
- $tbl_se_ref = Database::get_main_table(TABLE_MAIN_SEARCH_ENGINE_REF);
- $sql = 'INSERT INTO %s (id, course_code, tool_id, ref_id_high_level, search_did)
- VALUES (NULL , \'%s\', \'%s\', %s, %s)';
- $sql = sprintf($sql, $tbl_se_ref, $courseid, TOOL_LINK, $link_id, $did);
- Database::query($sql,__FILE__,__LINE__);
- }
- }
- unset ($urllink, $title, $description, $selectcategory);
- Display::display_confirmation_message(get_lang('LinkAdded'));
- }
- } elseif ($type == "category") {
- $tbl_categories = Database :: get_course_table(TABLE_LINK_CATEGORY);
- $category_title = trim($_POST['category_title']);
- $description = trim($_POST['description']);
- if (empty ($category_title)) {
- $msgErr = get_lang('GiveCategoryName');
- Display::display_error_message(get_lang('GiveCategoryName'));
- $ok = false;
- } else {
-
- $result = Database::query("SELECT MAX(display_order) FROM ".$tbl_categories."");
- list ($orderMax) = Database::fetch_row($result);
- $order = $orderMax +1;
- $session_id = api_get_session_id();
- $sql = "INSERT INTO ".$tbl_categories." (category_title, description, display_order, session_id) VALUES ('".Security::remove_XSS($category_title)."','".Security::remove_XSS($description)."', '$order', '$session_id')";
- Database::query($sql, __FILE__, __LINE__);
- $catlinkstatus = get_lang('CategoryAdded');
- unset ($category_title, $description);
- Display::display_confirmation_message(get_lang('CategoryAdded'));
- }
- }
-
- if ($type == "link")
- {
- global $_user;
- global $_course;
- global $nameTools;
- api_item_property_update($_course, TOOL_LINK, $link_id, "LinkAdded", $_user['user_id']);
- }
- return $ok;
- }
- function deletelinkcategory($type)
- {
- global $catlinkstatus;
- global $_course;
- global $_user;
- $tbl_link = Database :: get_course_table(TABLE_LINK);
- $tbl_categories = Database :: get_course_table(TABLE_LINK_CATEGORY);
- $TABLE_ITEM_PROPERTY = Database :: get_course_table(TABLE_ITEM_PROPERTY);
- if ($type == "link")
- {
- global $id;
-
-
- if (isset($_GET['id']) && $_GET['id']==strval(intval($_GET['id']))) {
- $sql="UPDATE $tbl_link SET on_homepage='0' WHERE id='".Database::escape_string($_GET['id'])."'";
- Database::query($sql,__FILE__,__LINE__);
- }
- api_item_property_update($_course, TOOL_LINK, $id, "delete", $_user['user_id']);
- delete_link_from_search_engine(api_get_course_id(), $id);
- $catlinkstatus = get_lang("LinkDeleted");
- unset ($id);
- Display::display_confirmation_message(get_lang('LinkDeleted'));
- }
- if ($type == "category")
- {
- global $id;
-
- $sql = "DELETE FROM ".$tbl_categories." WHERE id='".Database::escape_string(Security::remove_XSS($_GET['id']))."'";
- Database::query($sql, __FILE__, __LINE__);
- $sql = "DELETE FROM ".$tbl_link." WHERE category_id='".Database::escape_string(Security::remove_XSS($_GET['id']))."'";
- $catlinkstatus = get_lang('CategoryDeleted');
- unset ($id);
- Database::query($sql, __FILE__, __LINE__);
- Display::display_confirmation_message(get_lang('CategoryDeleted'));
- }
- }
- function delete_link_from_search_engine($course_id, $link_id) {
-
- if (api_get_setting('search_enabled') == 'true') {
- $tbl_se_ref = Database::get_main_table(TABLE_MAIN_SEARCH_ENGINE_REF);
- $sql = 'SELECT * FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s LIMIT 1';
- $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_LINK, $link_id);
- $res = Database::query($sql, __FILE__, __LINE__);
- if (Database::num_rows($res) > 0) {
- $row = Database::fetch_array($res);
- require_once(api_get_path(LIBRARY_PATH) .'search/DokeosIndexer.class.php');
- $di = new DokeosIndexer();
- $di->remove_document((int)$row['search_did']);
- }
- $sql = 'DELETE FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s LIMIT 1';
- $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_LINK, $link_id);
- Database::query($sql, __FILE__, __LINE__);
-
- require_once(api_get_path(LIBRARY_PATH) .'specific_fields_manager.lib.php');
- delete_all_values_for_item($course_id, TOOL_DOCUMENT, $link_id);
- }
- }
- function editlinkcategory($type)
- {
- global $catlinkstatus;
- global $id;
- global $submitLink;
- global $submitCategory;
- global $_user;
- global $_course;
- global $nameTools;
- global $urllink;
- global $title;
- global $description;
- global $category;
- global $selectcategory;
- global $description;
- global $category_title;
- global $onhomepage;
- $tbl_link = Database :: get_course_table(TABLE_LINK);
- $tbl_categories = Database :: get_course_table(TABLE_LINK_CATEGORY);
- if ($type == "link")
- {
-
- $sql = "SELECT * FROM ".$tbl_link." WHERE id='".$_GET['id']."'";
- $result = Database::query($sql, __FILE__, __LINE__);
- if ($myrow = Database::fetch_array($result))
- {
- $urllink = $myrow["url"];
- $title = $myrow["title"];
- $description = $myrow["description"];
- $category = $myrow["category_id"];
- if ($myrow["on_homepage"] <> 0)
- {
- $onhomepage = "checked";
- }
- }
-
- if ($_POST['submitLink'])
- {
- if ($_POST['onhomepage'] == '') {
- $onhomepage = 0;
- $mytarget='';
- } else {
- $onhomepage = Security::remove_XSS($_POST['onhomepage']);
- $target = Security::remove_XSS($_POST['target_link']);
- $mytarget=",target='".$target."'";
- }
-
- $sql = "SELECT * FROM ".$tbl_link." WHERE id='".Database::escape_string(Security::remove_XSS($_POST['id']))."'";
- $result = Database::query($sql, __FILE__, __LINE__);
- $row = Database::fetch_array($result);
- $category_id = $row['category_id'];
- if ($category_id <> $_POST['selectcategory']) {
- $sql = "SELECT MAX(display_order) FROM ".$tbl_link." WHERE category_id='".$_POST['selectcategory']."'";
- $result = Database::query($sql);
- list ($max_display_order) = Database::fetch_row($result);
- $max_display_order ++;
- } else {
- $max_display_order = $row['display_order'];
- }
- $sql = "UPDATE ".$tbl_link." set url='".Database::escape_string(Security::remove_XSS($_POST['urllink']))."', title='".Database::escape_string(Security::remove_XSS($_POST['title']))."', description='".Database::escape_string(Security::remove_XSS($_POST['description']))."', category_id='".Database::escape_string(Security::remove_XSS($_POST['selectcategory']))."', display_order='".$max_display_order."', on_homepage='".Database::escape_string(Security::remove_XSS($onhomepage))." ' $mytarget WHERE id='".Database::escape_string(Security::remove_XSS($_POST['id']))."'";
- Database::query($sql, __FILE__, __LINE__);
-
- if (api_get_setting('search_enabled')=='true') {
- $link_id = $_POST['id'];
- $course_id = api_get_course_id();
- $link_url = $_POST['urllink'];
- $link_title = $_POST['title'];
- $link_description = $_POST['description'];
-
-
- $tbl_se_ref = Database::get_main_table(TABLE_MAIN_SEARCH_ENGINE_REF);
- $sql = 'SELECT * FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=%s LIMIT 1';
- $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_LINK, $link_id);
- $res = Database::query($sql, __FILE__, __LINE__);
- if (Database::num_rows($res) > 0) {
- require_once(api_get_path(LIBRARY_PATH) . 'search/DokeosIndexer.class.php');
- require_once(api_get_path(LIBRARY_PATH) . 'search/IndexableChunk.class.php');
- require_once(api_get_path(LIBRARY_PATH) . 'specific_fields_manager.lib.php');
- $se_ref = Database::fetch_array($res);
- $specific_fields = get_specific_field_list();
- $ic_slide = new IndexableChunk();
- $all_specific_terms = '';
- foreach ($specific_fields as $specific_field) {
- delete_all_specific_field_value($course_id, $specific_field['id'], TOOL_LINK, $link_id);
- if (isset($_REQUEST[$specific_field['code']])) {
- $sterms = trim($_REQUEST[$specific_field['code']]);
- if (!empty($sterms)) {
- $all_specific_terms .= ' '. $sterms;
- $sterms = explode(',', $sterms);
- foreach ($sterms as $sterm) {
- $ic_slide->addTerm(trim($sterm), $specific_field['code']);
- add_specific_field_value($specific_field['id'], $course_id, TOOL_LINK, $link_id, $sterm);
- }
- }
- }
- }
-
- $ic_slide->addValue("title", $link_title);
- $ic_slide->addCourseId($course_id);
- $ic_slide->addToolId(TOOL_LINK);
- $xapian_data = array(
- SE_COURSE_ID => $course_id,
- SE_TOOL_ID => TOOL_LINK,
- SE_DATA => array('link_id' => (int)$link_id),
- SE_USER => (int)api_get_user_id(),
- );
- $ic_slide->xapian_data = serialize($xapian_data);
- $link_description = $all_specific_terms .' '. $link_description;
- $ic_slide->addValue("content", $link_description);
-
- if (isset($_POST['selectcategory']) && $selectcategory>0) {
- $table_link_category = Database::get_course_table(TABLE_LINK_CATEGORY);
- $sql_cat = 'SELECT * FROM %s WHERE id=%d LIMIT 1';
- $sql_cat = sprintf($sql_cat, $table_link_category, (int)$selectcategory);
- $result = Database::query($sql_cat, __FILE__, __LINE__);
- if (Database::num_rows($result) == 1) {
- $row = Database::fetch_array($result);
- $ic_slide->addValue("category", $row['category_title']);
- }
- }
- $di = new DokeosIndexer();
- isset($_POST['language'])? $lang=Database::escape_string($_POST['language']): $lang = 'english';
- $di->connectDb(NULL, NULL, $lang);
- $di->remove_document((int)$se_ref['search_did']);
- $di->addChunk($ic_slide);
-
- $did = $di->index();
- if ($did) {
-
- $sql = 'DELETE FROM %s WHERE course_code=\'%s\' AND tool_id=\'%s\' AND ref_id_high_level=\'%s\'';
- $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_LINK, $link_id);
- Database::query($sql,__FILE__,__LINE__);
-
- $sql = 'INSERT INTO %s (id, course_code, tool_id, ref_id_high_level, search_did)
- VALUES (NULL , \'%s\', \'%s\', %s, %s)';
- $sql = sprintf($sql, $tbl_se_ref, $course_id, TOOL_LINK, $link_id, $did);
- Database::query($sql,__FILE__,__LINE__);
- }
- }
- }
-
- api_item_property_update($_course, TOOL_LINK, $_POST['id'], "LinkUpdated", $_user['user_id']);
- Display::display_confirmation_message(get_lang('LinkModded'));
- }
- }
- if ($type == "category")
- {
-
- if (!$submitCategory)
- {
- $sql = "SELECT * FROM ".$tbl_categories." WHERE id='".$_GET['id']."'";
- $result = Database::query($sql, __FILE__, __LINE__);
- if ($myrow = Database::fetch_array($result))
- {
- $category_title = $myrow["category_title"];
- $description = $myrow["description"];
- }
- }
-
- if ($submitCategory)
- {
- $sql = "UPDATE ".$tbl_categories." set category_title='".Database::escape_string(Security::remove_XSS($_POST['category_title']))."', description='".Database::escape_string(Security::remove_XSS($_POST['description']))."' WHERE id='".Database::escape_string(Security::remove_XSS($_POST['id']))."'";
- Database::query($sql, __FILE__, __LINE__);
- Display::display_confirmation_message(get_lang('CategoryModded'));
- }
- }
- }
- function makedefaultviewcode($locatie)
- {
- global $aantalcategories;
- global $view;
- for ($j = 0; $j <= $aantalcategories -1; $j ++)
- {
- $view[$j] = 0;
- }
- $view[intval($locatie)] = "1";
- }
- function change_visibility($id, $scope)
- {
- global $_course;
- global $_user;
- $TABLE_ITEM_PROPERTY = Database :: get_course_table(TABLE_ITEM_PROPERTY);
- if ($scope == "link")
- {
- $sqlselect = "SELECT * FROM $TABLE_ITEM_PROPERTY WHERE tool='".TOOL_LINK."' and ref='".Database::escape_string($id)."'";
- $result = Database::query($sqlselect);
- $row = Database::fetch_array($result);
- api_item_property_update($_course, TOOL_LINK, $id, $_GET['action'], $_user['user_id']);
- }
- Display::display_confirmation_message(get_lang('VisibilityChanged'));
- }
- function showlinksofcategory($catid)
- {
- global $is_allowed, $charset, $urlview, $up, $down, $_user;
- $tbl_link = Database :: get_course_table(TABLE_LINK);
- $TABLE_ITEM_PROPERTY = Database :: get_course_table(TABLE_ITEM_PROPERTY);
-
- $session_id = api_get_session_id();
- $condition_session = api_get_session_condition($session_id);
- $sqlLinks = "SELECT * FROM ".$tbl_link." link, ".$TABLE_ITEM_PROPERTY." itemproperties WHERE itemproperties.tool='".TOOL_LINK."' AND link.id=itemproperties.ref AND link.category_id='".$catid."' AND (itemproperties.visibility='0' OR itemproperties.visibility='1') $condition_session ORDER BY link.display_order DESC";
- $result = Database::query($sqlLinks);
- $numberoflinks = Database::num_rows($result);
- echo '<table class="data_table" width="100%">';
- $i = 1;
- while ($myrow = Database::fetch_array($result)) {
-
- $session_img = api_get_session_image($myrow['session_id'], $_user['status']);
- if($i%2==0) $css_class = 'row_odd';
- else $css_class = 'row_even';
- $myrow[3] = text_filter($myrow[3]);
- if ($myrow['visibility'] == '1')
- {
- echo "<tr class='".$css_class."'>", "<td align=\"center\" valign=\"middle\" width=\"15\">", "<a href=\"link_goto.php?".api_get_cidreq()."&link_id=", $myrow[0], "&link_url=", urlencode($myrow[1]), "\" target=\"_blank\">", "<img src=\"../../main/img/file_html.gif\" border=\"0\" alt=\"".get_lang('Link')."\"/>", "</a></td>", "<td width=\"80%\" valign=\"top\">", "<a href=\"link_goto.php?".api_get_cidreq()."&link_id=", $myrow[0], "&link_url=", urlencode($myrow[1]), "\" target=\"_blank\">", api_htmlentities($myrow[2],ENT_QUOTES,$charset), "</a>", $session_img , "<br/>", $myrow[3], "";
- }
- else
- {
- if (api_is_allowed_to_edit(null,true))
- {
- echo "<tr class='".$css_class."'>", "<td align=\"center\" valign=\"middle\" width=\"15\">", "<a href=\"link_goto.php?".api_get_cidreq()."&link_id=", $myrow[0], "&link_url=", urlencode($myrow[1]), "\" target=\"_blank\" class=\"invisible\">", Display::return_icon('file_html_na.gif', get_lang('Link')),"</a></td>", "<td width=\"80%\" valign=\"top\">", "<a href=\"link_goto.php?".api_get_cidreq()."&link_id=", $myrow[0], "&link_url=", urlencode($myrow[1]), "\" target=\"_blank\" class=\"invisible\">", api_htmlentities($myrow[2],ENT_QUOTES,$charset), "</a>\n", $session_img , "<br />", $myrow[3], "";
- }
- }
- echo '<td style="text-align:center;">';
- if (api_is_allowed_to_edit(null,true))
- {
- echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&action=editlink&category=".(!empty($category)?$category:'')."&id=".$myrow[0]." &urlview=$urlview \" title=\"".get_lang('Modify')."\" >", "<img src=\"../img/edit.gif\" border=\"0\" alt=\"", get_lang('Modify'), "\" />", "</a>";
- echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&action=deletelink&id=", $myrow[0], "&urlview=", $urlview, "\" onclick=\"javascript:if(!confirm('".get_lang('LinkDelconfirm')."')) return false;\" title=\"".get_lang('Delete')."\" >", "<img src=\"../img/delete.gif\" border=\"0\" alt=\"", get_lang('Delete'), "\" />", "</a>";
-
- if ($i != 1)
- {
- echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&urlview=".$urlview."&up=", $myrow["id"], "\" title=\"".get_lang('Up')."\" >", "<img src=../img/up.gif border=0 alt=\"".get_lang('Up')."\"/>", "</a>\n";
- }
- else
- {
- echo '<img src="'.api_get_path(WEB_IMG_PATH).'up_na.gif" border=0 alt="'.get_lang('Up').'"/>';
- }
-
- if ($i < $numberoflinks)
- {
- echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&urlview=".$urlview."&down=".$myrow["id"]."\" title=\"".get_lang('Down')."\" >", "<img src=\"../img/down.gif\" border=\"0\" alt=\"".get_lang('Down')."\"/>", "</a>\n";
- }
- else
- {
- echo '<img src="'.api_get_path(WEB_IMG_PATH).'down_na.gif" border=0 alt="'.get_lang('Down').'"/>';
- }
- if ($myrow['visibility'] == "1")
- {
- echo '<a href="link.php?'.api_get_cidreq().'&action=invisible&id='.$myrow['id'].'&scope=link&urlview='.$urlview.'" title="'.get_lang('Hide').'"><img src="../img/visible.gif" border="0" /></a>';
- }
- if ($myrow['visibility'] == "0")
- {
- echo '<a href="link.php?'.api_get_cidreq().'&action=visible&id='.$myrow['id'].'&scope=link&urlview='.$urlview.'" title="'.get_lang('Show').'"><img src="../img/invisible.gif" border="0" /></a>';
- }
- }
- echo '</td>';
- echo '</tr>';
- $i ++;
- }
- echo '</table>';
- }
- function showcategoryadmintools($categoryid)
- {
- global $urlview;
- global $aantalcategories;
- global $catcounter;
- echo '<a href="'.api_get_self().'?'.api_get_cidreq().'&action=editcategory&id='.$categoryid.'&urlview='.$urlview.'" title='.get_lang('Modify').' "><img src="../img/edit.gif" border="0" alt="'.get_lang('Modify').' "/></a>';
- echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&action=deletecategory&id=", $categoryid, "&urlview=$urlview\" onclick=\"javascript:if(!confirm('".get_lang('CategoryDelconfirm')."')) return false;\">", "<img src=\"../img/delete.gif\" border=\"0\" alt=\"", get_lang('Delete'), "\"/>", "</a>";
-
- if ($catcounter != 1)
- {
- echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&catmove=true&up=", $categoryid, "&urlview=$urlview\" title=\"".get_lang('Up')."\" >", "<img src=../img/up.gif border=0 alt=\"".get_lang('Up')."\"/>", "</a>\n";
- }
- else
- {
- echo '<img src="'.api_get_path(WEB_IMG_PATH).'up_na.gif" border=0 alt="'.get_lang('Up').'"/>';
- }
-
- if ($catcounter < $aantalcategories)
- {
- echo "<a href=\"".api_get_self()."?".api_get_cidreq()."&catmove=true&down=".$categoryid."&urlview=$urlview\">", "<img src=\"../img/down.gif\" border=\"0\" alt=\"".get_lang('Down')."\"/>", "</a>\n";
- }
- else
- {
- echo '<img src="'.api_get_path(WEB_IMG_PATH).'down_na.gif" border=0 alt="'.get_lang('Down').'"/>';
- }
- $catcounter ++;
- }
- function movecatlink($catlinkid)
- {
- global $catmove;
- global $up;
- global $down;
- $tbl_link = Database :: get_course_table(TABLE_LINK);
- $tbl_categories = Database :: get_course_table(TABLE_LINK_CATEGORY);
- if (!empty($_GET['down']))
- {
- $thiscatlinkId = $_GET['down'];
- $sortDirection = "DESC";
- }
- if (!empty($_GET['up']))
- {
- $thiscatlinkId = Security::remove_XSS($_GET['up']);
- $sortDirection = "ASC";
- }
-
- if ($catmove == "true")
- {
- $movetable = $tbl_categories;
- $catid = $catlinkid;
- }
- else
- {
- $movetable = $tbl_link;
-
- if(!empty($thiscatlinkId))
- {
- $sql = "SELECT category_id from ".$movetable." WHERE id='$thiscatlinkId'";
- $result = Database::query($sql, __FILE__, __LINE__);
- $catid = Database::fetch_array($result);
- }
- }
-
- if (!empty($sortDirection))
- {
- if (!in_array(trim(strtoupper($sortDirection)), array ('ASC', 'DESC')))
- die("Bad sort direction used.");
- if ($catmove == "true")
- {
- $sqlcatlinks = "SELECT id, display_order FROM ".$movetable." ORDER BY display_order $sortDirection";
- }
- else
- {
- $sqlcatlinks = "SELECT id, display_order FROM ".$movetable." WHERE category_id='".$catid[0]."' ORDER BY display_order $sortDirection";
- }
- $linkresult = Database::query($sqlcatlinks);
- while ($sortrow = Database::fetch_array($linkresult))
- {
-
-
-
- if (isset ($thislinkFound) && $thislinkFound == true)
- {
- $nextlinkId = $sortrow["id"];
- $nextlinkOrdre = $sortrow["display_order"];
- Database::query("UPDATE ".$movetable."
- SET display_order = '$nextlinkOrdre'
- WHERE id = '$thiscatlinkId'");
- Database::query("UPDATE ".$movetable."
- SET display_order = '$thislinkOrdre'
- WHERE id = '$nextlinkId'");
- break;
- }
- if ($sortrow["id"] == $thiscatlinkId)
- {
- $thislinkOrdre = $sortrow["display_order"];
- $thislinkFound = true;
- }
- }
- }
- Display::display_confirmation_message(get_lang('LinkMoved'));
- }
- function get_cat($catname) // get category id (existing or make new)
- {
- $tbl_categories = Database :: get_course_table(TABLE_LINK_CATEGORY);
- $result = Database::query("SELECT `id` FROM ".$tbl_categories." WHERE `category_title`='".addslashes($catname)."'", __FILE__, __LINE__);
- if (Database::num_rows($result) >= 1 && ($row = Database::fetch_array($result)))
- return $row['id'];
- $result = Database::query("SELECT MAX(display_order) FROM ".$tbl_categories."", __FILE__, __LINE__);
- list ($max_order) = Database::fetch_row($result);
- Database::query("INSERT INTO ".$tbl_categories." (category_title, description, display_order) VALUES ('".addslashes($catname)."','','". ($max_order +1)."')", __FILE__, __LINE__);
- return Database::insert_id();
- }
- function put_link($url, $cat, $title, $description, $on_homepage, $hidden)
- {
- $tbl_link = Database :: get_course_table(TABLE_LINK);
- $urleq = "url='".addslashes($url)."'";
- $cateq = "category_id=".$cat;
- $result = Database::query("SELECT id FROM $tbl_link WHERE ".$urleq.' AND '.$cateq, __FILE__, __LINE__);
- if (Database::num_rows($result) >= 1 && ($row = Database::fetch_array($result)))
- {
- Database::query("UPDATE $tbl_link set title='".addslashes($title)."', description='".addslashes($description)."' WHERE id='".addslashes($id = $row['id'])."'", __FILE__, __LINE__);
- $lang_link = get_lang('update_link');
- $ipu = "LinkUpdated";
- $rv = 1;
- }
- else
- {
- $result = Database::query("SELECT MAX(display_order) FROM $tbl_link WHERE category_id='".addslashes($cat)."'", __FILE__, __LINE__);
- list ($max_order) = Database::fetch_row($result);
- Database::query("INSERT INTO $tbl_link (url, title, description, category_id, display_order, on_homepage) VALUES ('".addslashes($url)."','".addslashes($title)."','".addslashes($description)."','".addslashes($cat)."','". ($max_order +1)."','".$on_homepage."')", __FILE__, __LINE__);
- $id = Database::insert_id();
- $lang_link = get_lang('new_link');
- $ipu = "LinkAdded";
- $rv = 2;
- }
- global $_course, $nameTools, $_user;
- api_item_property_update($_course, TOOL_LINK, $id, $ipu, $_user['user_id']);
- if ($hidden && $ipu == "LinkAdded")
- api_item_property_update($_course, TOOL_LINK, $id, "invisible", $_user['user_id']);
- return $rv;
- }
- function import_link($linkdata) // url, category_id, title, description, ...
- {
-
- $known_fields = array ('url', 'category', 'title', 'description', 'on_homepage', 'hidden');
- $hide_fields = array ('kw', 'kwd', 'kwds', 'keyword', 'keywords');
-
-
- if (!($url = trim($linkdata['url'])) || !($title = trim($linkdata['title'])))
- return 0;
- $cat = ($catname = trim($linkdata['category'])) ? get_cat($catname) : 0;
- $regs = array();
- foreach ($linkdata as $key => $value)
- if (!in_array($key, $known_fields))
- if (in_array($key, $hide_fields) && ereg('^<?([^>]*)>?$', $value, $regs))
- if (($kwlist = trim($regs[1])) != '')
- $kw = '<i kw="'.htmlspecialchars($kwlist).'">';
- else
- $kw = '';
-
-
- elseif (trim($value)) $d .= ', '.$key.':'.$value;
- if ($d)
- $d = substr($d, 2).' - ';
- return put_link($url, $cat, $title, $kw.ereg_replace('\[((/?(b|big|i|small|sub|sup|u))|br/)\]', '<\\1>', htmlspecialchars($d.$linkdata['description'])). ($kw ? '</i>' : ''), $linkdata['on_homepage'] ? '1' : '0', $linkdata['hidden'] ? '1' : '0');
-
- }
- function import_csvfile()
- {
- global $catlinkstatus;
- if (is_uploaded_file($filespec = $_FILES['import_file']['tmp_name']) && filesize($filespec) && ($myFile = @ fopen($filespec, 'r')))
- {
-
- $listsep = strpos($colnames = trim(fgets($myFile)), ',') !== FALSE ? ',' : (strpos($colnames, ';') !== FALSE ? ';' : '');
- if ($listsep)
- {
- $columns = array_map('strtolower', explode($listsep, $colnames));
- if (in_array('url', $columns) && in_array('title', $columns))
- {
- $stats = array (0, 0, 0);
- while (($data = fgetcsv($myFile, 32768, $listsep)))
- {
- foreach ($data as $i => $text)
- $linkdata[$columns[$i]] = $text;
-
- $stats[import_link($linkdata)]++;
- unset ($linkdata);
- }
- $catlinkstatus = '';
- if ($stats[0])
- $catlinkstatus .= $stats[0].' '.get_lang('CsvLinesFailed');
- if ($stats[1])
- $catlinkstatus .= $stats[1].' '.get_lang('CsvLinesOld');
- if ($stats[2])
- $catlinkstatus .= $stats[2].' '.get_lang('CsvLinesNew');
- }
- else
- $catlinkstatus = get_lang('CsvFileNoURL'). ($colnames ? get_lang('CsvFileLine1').htmlspecialchars(substr($colnames, 0, 200)).'...' : '');
- }
- else
- $catlinkstatus = get_lang('CsvFileNoSeps'). ($colnames ? get_lang('CsvFileLine1').htmlspecialchars(substr($colnames, 0, 200)).'...' : '');
- fclose($myFile);
- }
- else
- $catlinkstatus = get_lang('CsvFileNotFound');
- }
- ?>
|