function search($database, $settings, $term)
{
if (!isset($database, $settings, $term)) {
return false;
}
$return['albums'] = '';
# Initialize return var
$return = array('photos' => null, 'albums' => null, 'hash' => '');
###
# Photos
###
// Photos
if ($database->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
$stmtP = $database->prepare("SELECT id, title, tags, public, star, album, thumburl, takestamp, url FROM " . LYCHEE_TABLE_PHOTOS . " WHERE title LIKE ? OR description LIKE ? OR tags LIKE ?");
} else {
if ($database->getAttribute(PDO::ATTR_DRIVER_NAME) == 'pgsql') {
$stmtP = $database->prepare("SELECT id, title, tags, public, star, album, thumburl, takestamp, url FROM " . LYCHEE_TABLE_PHOTOS . " WHERE title ILIKE ? OR description ILIKE ? OR tags ILIKE ?");
} else {
$stmtP = $database->prepare("SELECT id, title, tags, public, star, album, thumburl, takestamp, url FROM " . LYCHEE_TABLE_PHOTOS . " WHERE title LIKE ? OR description LIKE ? OR tags LIKE ?");
Log::error($this->database, __METHOD__, __LINE__, 'Unknown database driver: ' . $database->getAttribute(PDO::ATTR_DRIVER_NAME));
}
}
$result = $stmtP->execute(array('%' . $term . '%', '%' . $term . '%', '%' . $term . '%'));
while ($photo = $stmtP->fetch(PDO::FETCH_ASSOC)) {
$photo = Photo::prepareData($photo);
$return['photos'][$photo['id']] = $photo;
}
###
# Albums
###
if ($database->getAttribute(PDO::ATTR_DRIVER_NAME) == 'mysql') {
$stmtA = $database->prepare("SELECT id, title, public, sysstamp, password FROM " . LYCHEE_TABLE_ALBUMS . " WHERE title LIKE ? OR description LIKE ?");
} else {
if ($database->getAttribute(PDO::ATTR_DRIVER_NAME) == 'pgsql') {
$stmtA = $database->prepare("SELECT id, title, public, sysstamp, password FROM " . LYCHEE_TABLE_ALBUMS . " WHERE title ILIKE ? OR description ILIKE ?");
} else {
Log::error($this->database, __METHOD__, __LINE__, 'Unknown database driver: ' . $database->getAttribute(PDO::ATTR_DRIVER_NAME));
}
}
$result = $stmtA->execute(array('%' . $term . '%', '%' . $term . '%'));
while ($album = $stmtA->fetch(PDO::FETCH_ASSOC)) {
# Turn data from the database into a front-end friendly format
$album = Album::prepareData($album);
// Thumbs
$stmtT = $database->prepare("SELECT thumburl FROM " . LYCHEE_TABLE_PHOTOS . " WHERE album = ? " . $settings['sortingPhotos'] . " LIMIT 3 OFFSET 0");
$result2 = $stmtT->execute(array($album['id']));
$k = 0;
while ($thumb = $stmtT->fetchObject()) {
$album['thumbs'][$k] = LYCHEE_URL_UPLOADS_THUMB . $thumb->thumbUrl;
$k++;
}
# Add to return
$return['albums'][$album['id']] = $album;
}
# Hash
$return['hash'] = md5(json_encode($return));
return $return;
}
/**
* @return array|false Returns an array of albums or false on failure.
*/
public function get($public = true)
{
// Call plugins
Plugins::get()->activate(__METHOD__, 0, func_get_args());
// Initialize return var
$return = array('smartalbums' => null, 'albums' => null, 'num' => 0);
// Get SmartAlbums
if ($public === false) {
$return['smartalbums'] = $this->getSmartAlbums();
}
// Albums query
if ($public === false) {
$query = Database::prepare(Database::get(), 'SELECT id, title, public, sysstamp, password FROM ? ' . Settings::get()['sortingAlbums'], array(LYCHEE_TABLE_ALBUMS));
} else {
$query = Database::prepare(Database::get(), 'SELECT id, title, public, sysstamp, password FROM ? WHERE public = 1 AND visible <> 0 ' . Settings::get()['sortingAlbums'], array(LYCHEE_TABLE_ALBUMS));
}
// Execute query
$albums = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
if ($albums === false) {
return false;
}
// For each album
while ($album = $albums->fetch_assoc()) {
// Turn data from the database into a front-end friendly format
$album = Album::prepareData($album);
// Thumbs
if ($public === true && $album['password'] === '0' || $public === false) {
// Execute query
$query = Database::prepare(Database::get(), "SELECT thumbUrl FROM ? WHERE album = '?' ORDER BY star DESC, " . substr(Settings::get()['sortingPhotos'], 9) . " LIMIT 3", array(LYCHEE_TABLE_PHOTOS, $album['id']));
$thumbs = Database::execute(Database::get(), $query, __METHOD__, __LINE__);
if ($thumbs === false) {
return false;
}
// For each thumb
$k = 0;
while ($thumb = $thumbs->fetch_object()) {
$album['thumbs'][$k] = LYCHEE_URL_UPLOADS_THUMB . $thumb->thumbUrl;
$k++;
}
}
// Add to return
$return['albums'][] = $album;
}
// Num of albums
$return['num'] = $albums->num_rows;
// Call plugins
Plugins::get()->activate(__METHOD__, 1, func_get_args());
return $return;
}
function search($settings, $term)
{
if (!isset($settings, $term)) {
return false;
}
$return['albums'] = '';
# Initialize return var
$return = array('photos' => null, 'albums' => null, 'hash' => '');
###
# Photos
###
$pterm = pg_escape_string($term);
$sql = "SELECT id, title, tags, public, star, album, thumbUrl, takestamp, url FROM photos WHERE title ILIKE '%" . $pterm . "%' OR description ILIKE '%" . $pterm . "%' OR tags ILIKE '%" . $pterm . "%'";
$res = pg_query($db, $sql);
while ($row = pg_fetch_array($res)) {
$photo = Photo::prepareData($row);
$return['photos'][$photo['id']] = $photo;
}
pg_free_result($res);
###
# Albums
###
$sql = "SELECT id, title, public, sysstamp, \"password\" FROM albums WHERE title ILIKE '%" . $pterm . "%' OR description ILIKE '%" . $pterm . "%'";
$res = pg_query($db, $sql);
while ($row = pg_fetch_array($res)) {
# Turn data from the database into a front-end friendly format
$album = Album::prepareData($row);
$sql = "SELECT thumUrl FROM photos WHERE album=" . $album['id'] . " " . $settings['sortingPhotos'];
$nres = pg_query($db, $sql);
$k = 0;
while ($nrow = pg_fetch_array($nres)) {
$album['thumbs'][$k] = LYCHEE_URL_UPLOADS_THUMB . $nrow['thumbUrl'];
$k++;
}
pg_free_result($nres);
# Add to return
$return['albums'][$album['id']] = $album;
}
pg_free_result($res);
# Hash
$return['hash'] = hash('sha256', json_encode($return), false);
return $return;
}
function search($database, $settings, $term)
{
if (!isset($database, $settings, $term)) {
return false;
}
$return['albums'] = '';
# Initialize return var
$return = array('photos' => null, 'albums' => null, 'hash' => '');
###
# Photos
###
$query = Database::prepare($database, "SELECT id, title, tags, public, star, album, thumbUrl, takestamp, url FROM ? WHERE title LIKE '%?%' OR description LIKE '%?%' OR tags LIKE '%?%'", array(LYCHEE_TABLE_PHOTOS, $term, $term, $term));
$result = $database->query($query);
while ($photo = $result->fetch_assoc()) {
$photo = Photo::prepareData($photo);
$return['photos'][$photo['id']] = $photo;
}
###
# Albums
###
$query = Database::prepare($database, "SELECT id, title, public, sysstamp, password FROM ? WHERE title LIKE '%?%' OR description LIKE '%?%'", array(LYCHEE_TABLE_ALBUMS, $term, $term));
$result = $database->query($query);
while ($album = $result->fetch_assoc()) {
# Turn data from the database into a front-end friendly format
$album = Album::prepareData($album);
# Thumbs
$query = Database::prepare($database, "SELECT thumbUrl FROM ? WHERE album = '?' " . $settings['sortingPhotos'] . " LIMIT 0, 3", array(LYCHEE_TABLE_PHOTOS, $album['id']));
$thumbs = $database->query($query);
# For each thumb
$k = 0;
while ($thumb = $thumbs->fetch_object()) {
$album['thumbs'][$k] = LYCHEE_URL_UPLOADS_THUMB . $thumb->thumbUrl;
$k++;
}
# Add to return
$return['albums'][$album['id']] = $album;
}
# Hash
$return['hash'] = md5(json_encode($return));
return $return;
}
public function getAll($public)
{
# Check dependencies
self::dependencies(isset($this->database, $this->settings, $public));
# Call plugins
$this->plugins(__METHOD__, 0, func_get_args());
# Initialize return var
$return = array('smartalbums' => null, 'albums' => null, 'num' => 0);
# Get SmartAlbums
if ($public === false) {
$return['smartalbums'] = $this->getSmartInfo();
}
# Albums query
if ($public === false) {
$albums = $this->database->query('SELECT id, title, public, sysstamp, password FROM ' . LYCHEE_TABLE_ALBUMS . ' ' . $this->settings['sortingAlbums']);
} else {
$albums = $this->database->query('SELECT id, title, public, sysstamp, password FROM ' . LYCHEE_TABLE_ALBUMS . ' WHERE public = 1 AND visible <> 0 ' . $this->settings['sortingAlbums']);
}
# check query status
if ($albums === FALSE) {
Log::error($this->database, __METHOD__, __LINE__, 'Could not get all albums (' . print_r($this->database->errorInfo(), TRUE) . ')');
exit('Error: ' . print_r($this->database->errorInfo(), TRUE));
}
# prepare thumbnail statement
$stmtThumbs = $this->database->prepare("SELECT thumburl FROM " . LYCHEE_TABLE_PHOTOS . " WHERE album = ? ORDER BY star DESC, " . substr($this->settings['sortingPhotos'], 9) . " LIMIT 3");
if ($stmtThumbs === FALSE) {
Log::error($this->database, __METHOD__, __LINE__, 'Could not get prepare statement for thumbnails (' . print_r($this->database->errorInfo(), TRUE) . ')');
exit('Error: ' . print_r($this->database->errorInfo(), TRUE));
}
# For each album
while ($album = $albums->fetch(PDO::FETCH_ASSOC)) {
# Turn data from the database into a front-end friendly format
$album = Album::prepareData($album);
# Thumbs
if ($public === true && $album['password'] === '0' || $public === false) {
# Execute query
$resultThumbs = $stmtThumbs->execute(array($album['id']));
if ($resultThumbs === FALSE) {
Log::error($this->database, __METHOD__, __LINE__, 'Could not get thumbnails (' . print_r($this->database->errorInfo(), TRUE) . ')');
exit('Error: ' . print_r($this->database->errorInfo(), TRUE));
}
# For each thumb
$k = 0;
while ($thumb = $stmtThumbs->fetchObject()) {
$album['thumbs'][$k] = LYCHEE_URL_UPLOADS_THUMB . $thumb->thumburl;
$k++;
}
}
# Add to return
$return['albums'][] = $album;
}
# Num of albums
$return['num'] = $albums->rowCount();
# Call plugins
$this->plugins(__METHOD__, 1, func_get_args());
return $return;
}
public function getAll($public)
{
# Check dependencies
self::dependencies(isset($this->database, $this->settings, $public));
# Call plugins
$this->plugins(__METHOD__, 0, func_get_args());
# Initialize return var
$return = array('smartalbums' => null, 'albums' => null, 'num' => 0);
# Get SmartAlbums
if ($public === false) {
$return['smartalbums'] = $this->getSmartInfo();
}
# Albums query
if ($public === false) {
$query = Database::prepare($this->database, 'SELECT id, title, public, sysstamp, password FROM ? ' . $this->settings['sortingAlbums'], array(LYCHEE_TABLE_ALBUMS));
} else {
$query = Database::prepare($this->database, 'SELECT id, title, public, sysstamp, password FROM ? WHERE public = 1 AND visible <> 0 ' . $this->settings['sortingAlbums'], array(LYCHEE_TABLE_ALBUMS));
}
# Execute query
$albums = $this->database->query($query);
if (!$albums) {
Log::error($this->database, __METHOD__, __LINE__, 'Could not get all albums (' . $this->database->error . ')');
exit('Error: ' . $this->database->error);
}
# For each album
while ($album = $albums->fetch_assoc()) {
# Turn data from the database into a front-end friendly format
$album = Album::prepareData($album);
# Thumbs
if ($public === true && $album['password'] === '0' || $public === false) {
# Execute query
$query = Database::prepare($this->database, "SELECT thumbUrl FROM ? WHERE album = '?' ORDER BY star DESC, " . substr($this->settings['sortingPhotos'], 9) . " LIMIT 3", array(LYCHEE_TABLE_PHOTOS, $album['id']));
$thumbs = $this->database->query($query);
# For each thumb
$k = 0;
while ($thumb = $thumbs->fetch_object()) {
$album['thumbs'][$k] = LYCHEE_URL_UPLOADS_THUMB . $thumb->thumbUrl;
$k++;
}
}
# Add to return
$return['albums'][] = $album;
}
# Num of albums
$return['num'] = $albums->num_rows;
# Call plugins
$this->plugins(__METHOD__, 1, func_get_args());
return $return;
}
public function getAll($public)
{
# Check dependencies
self::dependencies(isset($this->settings, $public));
# Initialize return var
$return = array('smartalbums' => null, 'albums' => null, 'num' => 0);
# Get SmartAlbums
if ($public === false) {
$return['smartalbums'] = $this->getSmartInfo();
}
# Albums query
if ($public === false) {
$sql = "SELECT id, title, public, sysstamp, password FROM albums " . $this->settings['sortingAlbums'];
} else {
$sql = "SELECT id, title, public, sysstamp, password FROM albums WHERE public = 1 AND visible != 0 " . $this->settings['sortingAlbums'];
}
# Execute query
$res = pg_query($db, $sql);
# For each album
while ($row = pg_fetch_array($res)) {
# Turn data from the database into a front-end friendly format
$album = Album::prepareData($row);
# Thumbs
if ($public === true && $album['password'] === '0' || $public === false) {
# Execute query
$sql = "SELECT thumbUrl FROM photos WHERE album = " . intval($album['id']) . " ORDER BY star DESC, " . substr($this->settings['sortingPhotos'], 9);
$nres = pg_query($db, $sql);
# For each thumb
$k = 0;
while ($nrow = pg_fetch_array($nres)) {
$album['thumbs'][$k] = LYCHEE_URL_UPLOADS_THUMB . $nrow['thumbUrl'];
$k++;
}
pg_free_result($nres);
}
# Add to return
$return['albums'][] = $album;
}
# Num of albums
$return['num'] = pg_num_rows($res);
pg_free_result($res);
return $return;
}
