public function getConferenceBookmarks($conference_id)
{
$query = sprintf("SELECT bookmarking.bookmarkingID, bookmarking.userID, bookmarking.contentID \n FROM bookmarking, content \n WHERE (bookmarking.contentID=content.contentID) AND (content.contentType <> %s)", "\"no-paper\"");
$query .= $this->createConferenceIDString($conference_id);
$result = mysql_query($query);
if (!$result) {
$message = 'Invalid Query: ' . mysql_error() . "\n";
$message .= 'Full query: ' . $query;
die($message);
}
$bookmark_array = array();
while ($row = mysql_fetch_assoc($result)) {
library\Toolkit::addOrInitiatlizeArrayKeyNumerical($bookmark_array, $row['contentID']);
}
$return_array = array();
foreach ($bookmark_array as $id => $num) {
$return_array[] = array("id" => $id, "num" => $num);
}
return $return_array;
}
protected function getBookmarks($conference_id, $cut_off)
{
$query = sprintf("SELECT bookmarking.bookmarkingID, bookmarking.userID, bookmarking.contentID \n FROM bookmarking, presentation, eventsession, content \n WHERE (bookmarking.contentID=presentation.contentID) AND (bookmarking.contentID = content.contentID)\n AND (presentation.eventSessionID=eventsession.eventSessionID) AND (content.contentType <> %s)", "\"no-paper\"");
$query .= $this->createConferenceIDString($conference_id);
$result = mysql_query($query);
if (!$result) {
$message = 'Invalid Query: ' . mysql_error() . "\n";
$message .= 'Full query: ' . $query;
die($message);
}
$bookmark_array = array();
while ($row = mysql_fetch_assoc($result)) {
$bookmark_array[] = $row;
library\Toolkit::addOrInitiatlizeArrayKeyNumerical($this->numBookmarks, $row['contentID']);
}
if (count($this->numBookmarks) > 0) {
$this->numBookmarks = array_filter($this->numBookmarks, function ($item) use($cut_off) {
return $item >= $cut_off;
});
}
$library_array = array();
foreach ($bookmark_array as $line) {
if (!isset($library_array[$line['userID']])) {
$library_array[$line['userID']] = array($line['contentID']);
} else {
$library_array[$line['userID']][] = $line['contentID'];
}
}
return $library_array;
}
