" maxlength="100" class="shrtwidth" /></div>
<div class="Inline"><input name="Submit" type="submit" value=" <?php
echo $lang["searchbutton"];
?>
" /></div>
<div class="Inline"><input name="Clear" type="button" onclick="document.getElementById('find').value='';submit();" value=" <?php
echo $lang["clearbutton"];
?>
" /></div>
</div>
<div class="clearerleft"> </div>
</div>
</form>
</div>
<?php
$collections = get_user_collections($userref, $find, $col_order_by, $sort);
$results = count($collections);
$totalpages = ceil($results / $per_page);
$curpage = floor($offset / $per_page) + 1;
$jumpcount = 1;
# Create an a-z index
$atoz = "<div class=\"InpageNavLeftBlock\">";
if ($find == "") {
$atoz .= "<span class='Selected'>";
}
$atoz .= "<a href=\"" . $baseurl_short . "pages/collection_manage.php?col_order_by=name&find=\" onClick=\"return CentralSpaceLoad(this);\">" . $lang["viewall"] . "</a>";
if ($find == "") {
$atoz .= "</span>";
}
$atoz .= " ";
for ($n = ord("A"); $n <= ord("Z"); $n++) {
function get_user_collections($user, $find = "", $order_by = "name", $sort = "ASC", $fetchrows = -1, $auto_create = true)
{
global $usergroup;
# Returns a list of user collections.
$sql = "";
$keysql = "";
$extrasql = "";
if ($find == "!shared") {
# only return shared collections
$sql = " where (public='1' or c.ref in (select distinct collection from user_collection where user<>'{$user}' union select distinct collection from external_access_keys))";
} elseif (strlen($find) == 1 && !is_numeric($find)) {
# A-Z search
$sql = " where c.name like '{$find}%'";
} elseif (strlen($find) > 1 || is_numeric($find)) {
$keywords = split_keywords($find);
$keyrefs = array();
$keysql = "";
for ($n = 0; $n < count($keywords); $n++) {
$keyref = resolve_keyword($keywords[$n], false);
if ($keyref !== false) {
$keyrefs[] = $keyref;
}
$keysql .= " join collection_keyword k" . $n . " on k" . $n . ".collection=ref and (k" . $n . ".keyword='{$keyref}')";
//$keysql="or keyword in (" . join (",",$keyrefs) . ")";
}
//$sql.="and (c.name rlike '$search' or u.username rlike '$search' or u.fullname rlike '$search' $spcr )";
}
# Include themes in my collecions?
# Only filter out themes if $themes_in_my_collections is set to false in config.php
global $themes_in_my_collections;
if (!$themes_in_my_collections) {
if ($sql == "") {
$sql = " where ";
} else {
$sql .= " and ";
}
$sql .= " (length(c.theme)=0 or c.theme is null) ";
}
global $anonymous_login, $username, $anonymous_user_session_collection;
if (isset($anonymous_login) && $username == $anonymous_login && $anonymous_user_session_collection) {
// Anonymous user - only get the user's own collections that are for this session - although we can still join to get collections that have been specifically shared with the anonymous user
if ($sql == "") {
$extrasql = " where ";
} else {
$extrasql .= " and ";
}
$rs_session = get_rs_session_id(true);
$extrasql .= " (c.session_id='" . $rs_session . "')";
}
$order_sort = "";
if ($order_by != "name") {
$order_sort = " order by {$order_by} {$sort}";
}
$return = "select * from (select c.*,u.username,u.fullname,count(r.resource) count from user u join collection c on u.ref=c.user and c.user='******' left outer join collection_resource r on c.ref=r.collection {$sql} {$extrasql} group by c.ref\n\tunion\n\tselect c.*,u.username,u.fullname,count(r.resource) count from user_collection uc join collection c on uc.collection=c.ref and uc.user='******' and c.user<>'{$user}' left outer join collection_resource r on c.ref=r.collection left join user u on c.user=u.ref {$sql} group by c.ref\n\tunion\n\tselect c.*,u.username,u.fullname,count(r.resource) count from usergroup_collection gc join collection c on gc.collection=c.ref and gc.usergroup='{$usergroup}' and c.user<>'{$user}' left outer join collection_resource r on c.ref=r.collection left join user u on c.user=u.ref {$sql} group by c.ref) clist {$keysql} group by ref {$order_sort}";
$return = sql_query($return);
if ($order_by == "name") {
if ($sort == "ASC") {
usort($return, 'collections_comparator');
} else {
if ($sort == "DESC") {
usort($return, 'collections_comparator_desc');
}
}
}
// To keep My Collection creation consistent: Check that user has at least one collection of his/her own (not if collection result is empty, which may include shares),
$hasown = false;
for ($n = 0; $n < count($return); $n++) {
if ($return[$n]['user'] == $user) {
$hasown = true;
}
}
if (!$hasown && $auto_create && $find == "") {
# No collections of one's own? The user must have at least one My Collection
global $usercollection;
$name = get_mycollection_name($user);
$usercollection = create_collection($user, $name, 0, 1);
// make not deletable
set_user_collection($user, $usercollection);
# Recurse to send the updated collection list.
return get_user_collections($user, $find, $order_by, $sort, $fetchrows, false);
}
return $return;
}
?>
selected <?php
}
?>
><?php
echo $lang["batchdonotaddcollection"];
?>
</option><?php
}
?>
<?php
if ($upload_force_mycollection) {
$list = get_user_collections($userref, "My Collection");
} else {
$list = get_user_collections($userref);
}
$currentfound = false;
// make sure it's possible to set the collection with collection_add (compact style "upload to this collection"
if ($collection_add != "" && getval("resetform", "") == "" && (!isset($save_errors) || !$save_errors)) {
# Switch to the selected collection (existing or newly created) and refresh the frame.
set_user_collection($userref, $collection_add);
refresh_collection_frame($collection_add);
}
for ($n = 0; $n < count($list); $n++) {
if ($collection_dropdown_user_access_mode) {
$colusername = $list[$n]['fullname'];
# Work out the correct access mode to display
if (!hook('collectionaccessmode')) {
if ($list[$n]["public"] == 0) {
$accessmode = $lang["private"];
/**
* Get the collections associated with a user.
*
* @param string $subtype Optionally, the subtype of result we want to limit to
* @param int $limit The number of results to return
* @param int $offset Any indexing offset
* @return unknown
*/
public function getCollections($subtype = "", $limit = 10, $offset = 0)
{
return get_user_collections($this->getGUID(), $subtype, $limit, $offset);
}
function get_user_collections($user,$find="",$order_by="name",$sort="ASC",$fetchrows=-1,$auto_create=true)
{
# Returns a list of user collections.
$sql="";
$keysql="";
if (strlen($find)==1 && !is_numeric($find))
{
# A-Z search
$sql=" where c.name like '$find%'";
}
elseif (strlen($find)>1 || is_numeric($find))
{
$keywords=split_keywords($find);
$keyrefs=array();
$keysql="";
for ($n=0;$n<count($keywords);$n++)
{
$keyref=resolve_keyword($keywords[$n],false);
if ($keyref!==false) {$keyrefs[]=$keyref;}
$keysql.=" join collection_keyword k" . $n . " on k" . $n . ".collection=ref and (k" . $n . ".keyword='$keyref')";
//$keysql="or keyword in (" . join (",",$keyrefs) . ")";
}
//$sql.="and (c.name rlike '$search' or u.username rlike '$search' or u.fullname rlike '$search' $spcr )";
}
# Include themes in my collecions?
# Only filter out themes if $themes_in_my_collections is set to false in config.php
global $themes_in_my_collections;
if (!$themes_in_my_collections)
{
if ($sql==""){$sql=" where ";} else {$sql.=" and ";}
$sql.=" (length(c.theme)=0 or c.theme is null) ";
}
$order_sort="";
if ($order_by!="name"){$order_sort=" order by $order_by $sort";}
$return="select * from (select c.*,u.username,u.fullname,count(r.resource) count from user u join collection c on u.ref=c.user and c.user='******' left outer join collection_resource r on c.ref=r.collection $sql group by c.ref
union
select c.*,u.username,u.fullname,count(r.resource) count from user_collection uc join collection c on uc.collection=c.ref and uc.user='******' and c.user<>'$user' left outer join collection_resource r on c.ref=r.collection left join user u on c.user=u.ref $sql group by c.ref) clist $keysql $order_sort";
$return=sql_query($return);
if ($order_by=="name"){
if ($sort=="ASC"){usort($return, 'collections_comparator');}
else if ($sort=="DESC"){usort($return,'collections_comparator_desc');}
}
// To keep My Collection creation consistent: Check that user has at least one collection of his/her own (not if collection result is empty, which may include shares),
$hasown=false;
for ($n=0;$n<count($return);$n++){
if ($return[$n]['user']==$user){
$hasown=true;
}
}
if ($find!=""){$hasown=true;} // if doing a search in collections, assume My Collection already exists (to avoid creating new collections due to an empty search result).
if (!$hasown && $auto_create)
{
# No collections of one's own? The user must have at least one My Collection
global $usercollection;
$name=get_mycollection_name($user);
$usercollection=create_collection ($user,$name,0,1); // make not deletable
set_user_collection($user,$usercollection);
# Recurse to send the updated collection list.
return get_user_collections($user,$find,$order_by,$sort,$fetchrows,false);
}
return $return;
}
include "../include/header.php";
?>
<div class="BasicsBox">
<p><a href="<?php
echo $baseurl_short;
?>
pages/collection_manage.php" onClick="return CentralSpaceLoad(this,true);">< <?php
echo $lang["managecollectionslink"];
?>
</a></p>
<h1><?php
echo $lang["shared_collections"];
?>
</h1>
<?php
$collections = get_user_collections($userref, "!shared");
$results = count($collections);
$totalpages = ceil($results / $per_page);
$curpage = floor($offset / $per_page) + 1;
$jumpcount = 1;
$url = $baseurl_short . "pages/view_shares.php?coluser="******"TopInpageNav"><?php
pager(false);
?>
</div><?php
for ($n = $offset; $n < count($collections) && $n < $offset + $per_page; $n++) {
?>
<div class="RecordBox">
<div class="RecordPanel">
<div class="RecordHeader">
$search_includes_themes_now=$search_includes_themes;
$search_includes_public_collections_now=$search_includes_themes;
$search_includes_user_collections_now=$search_includes_themes;
if ($restypes!="") {
$restypes_x=explode(",",$restypes);
$search_includes_themes_now=in_array("themes",$restypes_x);
$search_includes_public_collections_now=in_array("pubcol",$restypes_x);
$search_includes_user_collections_now=in_array("mycol",$restypes_x);
}
if (( ($search_includes_themes_now || $search_includes_public_collections_now || $search_includes_user_collections_now)) && $search!="" && substr($search,0,1)!="!" && $offset==0)
{
$collections=search_public_collections($search,"theme","ASC",!$search_includes_themes_now,!$search_includes_public_collections_now,true);
if ($search_includes_user_collections_now){
$collections=array_merge(get_user_collections($userref,$search,"name",$revsort),$collections);
$condensedcollectionsresults=array();
$colresultsdupecheck=array();
foreach($collections as $collection){
if (!in_array($collection['ref'],$colresultsdupecheck)){
$condensedcollectionsresults[]=$collection;
$colresultsdupecheck[]=$collection['ref'];
}
}
$collections=$condensedcollectionsresults;
}
}
# Special case: numeric searches (resource ID) and one result: redirect immediately to the resource view.
if ((($config_search_for_number && is_numeric($search)) || $searchresourceid > 0) && is_array($result) && count($result)==1)
{
$resource = $get_file_thumbnail_link;
$file = sql_query("SELECT * FROM resource WHERE ref='{$resource}'");
$preview_extension = $file[0]['file_extension'];
if ($preview_extension == 'pdf') {
$preview_extension = $file[0]['preview_extension'];
}
$thumbnail_link = get_resource_path($resource, FALSE, 'col', FALSE, $preview_extension, -1, 1, FALSE);
$file_headers = get_headers($thumbnail_link);
$resourcedata = get_resource_data($resource);
$no_preview_icon = "gfx/" . get_nopreview_icon($resourcedata["resource_type"], $resourcedata["file_extension"], false);
$data = array('thumbnail_link' => $thumbnail_link, 'no_preview_icon' => $no_preview_icon, 'file_header' => $file_headers[0]);
printJson($data);
}
// get all collections
if ($get && $get_all_collections) {
$all_collections = get_user_collections($user_id);
printJson($all_collections);
}
// get all files within a specific collection
if ($get_files_in_collection && $collection_id) {
$fetchFiles = "SELECT * \n FROM resource \n WHERE \n ref IN (SELECT resource FROM collection_resource WHERE collection='{$collection_id}')";
$fetchCollection = "SELECT ref, name FROM collection WHERE ref='{$collection_id}'";
$fileData = sql_query($fetchFiles);
$collectionData = sql_query($fetchCollection);
foreach ($fileData as $k => $file) {
// Get the size of the original file
$filepath = get_resource_path($file['ref'], TRUE, '', FALSE, $file['file_extension'], -1, 1, FALSE, '', -1);
$original_size = get_original_imagesize($file['ref'], $filepath, $file['file_extension']);
$original_size = formatfilesize($original_size[0]);
$original_size = str_replace(' ', ' ', $original_size);
$fileData[$k]['original_size'] = $original_size;