summaryrefslogtreecommitdiffstats
path: root/apps/gallery/index.php
blob: c8d5892e5552f0c20995b806a6f656a9af99acbc (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
<?php
require_once('../../lib/base.php');

OC_Util::checkLoggedIn();
OC_App::setActiveNavigationEntry( 'gallery_index' );


if (!isset($_GET['view'])) {
  $stmt = OC_DB::prepare('SELECT * FROM *PREFIX*gallery_albums WHERE uid_owner = ?');
  $result = $stmt->execute(array(OC_User::getUser()));

  $r = array();
  while ($row = $result->fetchRow())
    $r[] = $row;

  $tmpl = new OC_Template( 'gallery', 'index', 'user' );
  $tmpl->assign('r', $r);
  $tmpl->printPage();
} else {
  $stmt = OC_DB::prepare('SELECT * FROM *PREFIX*gallery_photos, *PREFIX*gallery_albums WHERE uid_owner = ? AND album_name = ? AND *PREFIX*gallery_albums.album_id = *PREFIX*gallery_photos.album_id');
  
  $result = $stmt->execute(array(OC_User::getUser(), $_GET['view']));

  $photos = array();
  while ($p = $result->fetchRow())
    $photos[] = $p['file_path'];
  
  $tmpl = new OC_Template( 'gallery', 'view_album', 'user' );
  $tmpl->assign('photos', $photos);
  $tmpl->assign('albumName', $_GET['view']);
  $tmpl->printPage();
}
?>