***************************************************************/ require_once dirname(__FILE__) . '/inc.php'; require_once dirname(__FILE__) . '/lib/sharelib.php'; $access = optional_param('access', 0, PARAM_TEXT); require_login(0, true); if (!($user = block_exabis_eportfolio_get_user_from_access($access))) { print_error("nouserforid", "block_exabis_eportfolio"); } $userpreferences = block_exabis_eportfolio_get_user_preferences($user->id); if ($user->access->request == 'intern') { block_exabis_eportfolio_print_header("sharedbookmarks"); } else { print_header(get_string("externaccess", "block_exabis_eportfolio"), get_string("externaccess", "block_exabis_eportfolio") . " " . fullname($user, $user->id)); } $parsedsort = block_exabis_eportfolio_parse_item_sort($userpreferences->itemsort); $order_by = block_exabis_eportfolio_item_sort_to_sql($parsedsort); if ($user->access->request == 'extern') { $extraTable = ""; $extraWhere = "i.externaccess=1"; } else { $extraTable = "LEFT JOIN {$CFG->prefix}block_exabeporitemshar ishar ON i.id=ishar.itemid AND ishar.userid={$USER->id}"; $extraWhere = " ((i.shareall=1 AND ishar.userid IS NULL)"; $extraWhere .= " OR (i.shareall=0 AND ishar.userid IS NOT NULL))"; } $items = get_records_sql("SELECT i.id, i.type, i.url, i.name, i.intro, i.attachment, i.timemodified, ic.name AS cname, ic2.name AS cname_parent\r\n\tFROM {$CFG->prefix}block_exabeporitem i\r\n\tJOIN {$CFG->prefix}block_exabeporcate ic ON i.categoryid = ic.id\r\n\t{$extraTable}\r\n\tLEFT JOIN {$CFG->prefix}block_exabeporcate ic2 on ic.pid = ic2.id\r\n\tWHERE i.userid='{$user->id}' AND {$extraWhere}\r\n\t{$order_by}"); if (!$items) { print_error("nobookmarksall", "block_exabis_eportfolio"); } echo '<table cellspacing="0" class="forumpost blogpost blog" width="100%">'; echo '<tr class="header"><td class="picture left">'; print_user_picture($user->id, 0, $user->picture);
$userpreferences = block_exabis_eportfolio_get_user_preferences(); if (!$sort && $userpreferences && isset($userpreferences->itemsort)) { $sort = $userpreferences->itemsort; } // check sorting $parsedsort = block_exabis_eportfolio_parse_item_sort($sort); $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_set_user_preferences(array('itemsort' => $sort)); $sql_sort = block_exabis_eportfolio_item_sort_to_sql($parsedsort); if ($type == 'all') { $sql_type_where = ''; } else { $sql_type_where = " AND i.type='" . $type . "'"; } if (!empty($_GET['filtercategory'])) { $sql_type_where .= ' AND i.categoryid = ' . $_GET['filtercategory'] . ' '; } $query = "select i.*, ic.name AS cname, ic2.name AS cname_parent, c.fullname As coursename, COUNT(com.id) As comments" . " from {$CFG->prefix}block_exabeporitem i" . " join {$CFG->prefix}block_exabeporcate ic on i.categoryid = ic.id" . " left join {$CFG->prefix}block_exabeporcate ic2 on ic.pid = ic2.id" . " left join {$CFG->prefix}course c on i.courseid = c.id" . " left join {$CFG->prefix}block_exabeporitemcomm com on com.itemid = i.id" . " where i.userid = {$USER->id} {$sql_type_where} group by i.id, i.name, i.intro, i.timemodified, cname, cname_parent, coursename {$sql_sort}"; $items = get_records_sql($query); if ($items) { $table = new stdClass(); $table->width = "100%"; $table->head = array(); $table->size = array();