function block_exabis_eportfolio_view_sort_to_sql($sort) { $sort = block_exabis_eportfolio_parse_view_sort($sort); $column = $sort[0]; $order = $sort[1]; $sql_sort = "v." . $column . " " . $order . ", v.timemodified DESC"; return ' order by ' . $sql_sort; }
***************************************************************/ require_once dirname(__FILE__) . '/inc.php'; require_once dirname(__FILE__) . '/lib/sharelib.php'; $courseid = required_param('courseid', PARAM_INT); $sort = optional_param('sort', '', PARAM_RAW); $access = optional_param('access', 0, PARAM_TEXT); require_login($courseid); $context = get_context_instance(CONTEXT_SYSTEM); require_capability('block/exabis_eportfolio:use', $context); if (!($course = get_record("course", "id", $courseid))) { error("That's an invalid course id"); } if (!($user = block_exabis_eportfolio_get_user_from_access($access))) { print_error("nouserforid", "block_exabis_eportfolio"); } $parsedsort = block_exabis_eportfolio_parse_view_sort($sort); $sql_sort = block_exabis_eportfolio_view_sort_to_sql($parsedsort); $sort = $parsedsort[0] . '.' . $parsedsort[1]; $sortkey = $parsedsort[0]; if ($parsedsort[1] == "desc") { $newsort = $sortkey . ".asc"; } else { $newsort = $sortkey . ".desc"; } $sorticon = $parsedsort[1] . '.gif'; block_exabis_eportfolio_print_header("sharedbookmarks"); $strheader = get_string("sharedbookmarks", "block_exabis_eportfolio"); /* $navlinks = array(); $navlinks[] = array('name' => $strheader, 'link' => null, 'type' => 'misc');