public function handleGet($get, $post, $files, $cookies) { if (Models\User::currentUser($cookies)->authorizationLevel < 5) { throw new \Exception('You are not authorized to view this page'); } /* Set up the page view */ $view = new Views\AdminCommentsView(); $view->checkpointId = intval(Models\Preferences::valueForModuleWithKey('CameraLife', 'checkpointcomments')); $view->checkpointDate = Models\Database::selectOne('logs', 'max(user_date)', 'id=' . $view->checkpointId); $view->showFromMe = isset($get['fromMe']) && $get['fromMe']; $view->showFromRegistered = isset($get['fromRegistered']) && $get['fromRegistered']; $view->showFromUnregistered = isset($get['fromUnregistered']) && $get['fromUnregistered']; if (!$view->showFromMe && !$view->showFromRegistered && !$view->showFromUnregistered) { $view->showFromMe = true; $view->showFromRegistered = true; $view->showFromUnregistered = true; } /* Query the comment logs */ $currentUser = Models\User::currentUser($cookies); $condition = "(0 "; $condition .= $view->showFromMe ? "OR username = '******' " : ''; $condition .= $view->showFromRegistered ? "OR (username LIKE '_%' AND username != '" . $currentUser->name . "')" : ''; $condition .= $view->showFromUnregistered ? "OR username = '' " : ''; $condition .= ") "; $condition .= " AND id > " . $view->checkpointId; $query = Models\Database::select('comments', '*', $condition); $commentRecords = array(); while ($record = $query->fetchAssoc()) { $commentRecords[] = $record; } $view->commentRecords = $commentRecords; $this->htmlHeader($cookies); $view->render(); $this->htmlFooter(); }
public function handleGet($get, $post, $files, $cookies) { if (Models\User::currentUser($cookies)->authorizationLevel < 5) { throw new \Exception('You are not authorized to view this page'); } /* Set up the page view */ $view = new Views\AdminLogsView(); $view->checkpointId = intval(Models\Preferences::valueForModuleWithKey('CameraLife', 'checkpointlogs')); $view->checkpointDate = Models\Database::selectOne('logs', 'max(user_date)', 'id=' . $view->checkpointId); $view->showFromMe = isset($get['fromMe']) && $get['fromMe']; $view->showFromRegistered = isset($get['fromRegistered']) && $get['fromRegistered']; $view->showFromUnregistered = isset($get['fromUnregistered']) && $get['fromUnregistered']; $view->showChangedPhotos = isset($get['changedPhotos']) && $get['changedPhotos']; $view->showChangedTags = isset($get['changedTags']) && $get['changedTags']; $view->showChangedUsers = isset($get['changedUsers']) && $get['changedUsers']; $view->showChangedPrefs = isset($get['changedPreferences']) && $get['changedPreferences']; if (!$view->showFromMe && !$view->showFromRegistered && !$view->showFromUnregistered) { $view->showFromMe = true; $view->showFromRegistered = true; $view->showFromUnregistered = true; } if (!$view->showChangedPhotos && !$view->showChangedTags && !$view->showChangedUsers && !$view->showChangedPrefs) { $view->showChangedPhotos = true; $view->showChangedTags = true; $view->showChangedUsers = true; $view->showChangedPrefs = true; } /* Query the audit logs */ $currentUser = Models\User::currentUser($cookies); $condition = "(0 "; $condition .= $view->showChangedPhotos ? "OR record_type = 'photo' " : ''; $condition .= $view->showChangedTags ? "OR record_type = 'album' " : ''; $condition .= $view->showChangedUsers ? "OR record_type = 'user' " : ''; $condition .= $view->showChangedPrefs ? "OR record_type = 'preference' " : ''; $condition .= ") AND (0 "; $condition .= $view->showFromMe ? "OR user_name = '" . $currentUser->name . "' " : ''; $condition .= $view->showFromRegistered ? "OR (user_name LIKE '_%' AND user_name != '" . $currentUser->name . "')" : ''; $condition .= $view->showFromUnregistered ? "OR user_name = '' " : ''; $condition .= ") "; $condition .= " AND logs.id > " . $view->checkpointId; $extra = "GROUP BY record_id, record_type, value_field ORDER BY maxid DESC"; $query = Models\Database::select('logs', 'record_type, record_id, value_field, MAX(logs.id) as maxid', $condition, $extra); $auditTrails = array(); while ($record = $query->fetchAssoc()) { $auditTrails[] = Models\AuditTrail::getAuditTrailWithID($record['maxid']); } $view->auditTrails = $auditTrails; $this->htmlHeader($cookies); $view->render(); $this->htmlFooter(); }
public function handleGet($get, $post, $files, $cookies) { if (Models\User::currentUser($cookies)->authorizationLevel < 5) { throw new \Exception('You are not authorized to view this page'); } ini_set('max_execution_time', 9000); chdir(constant('BASE_DIR')); $lastdone = isset($get['lastdone']) ? (int) $get['lastdone'] : 0; $starttime = isset($get['starttime']) ? (int) $get['starttime'] : time(); $numdone = isset($get['numdone']) ? (int) $get['numdone'] : 0; $phpself = self::getUrl(); /* Rescan */ if (!isset($get['lastdone'])) { Models\Folder::update(); } /* Set up the page view */ $this->htmlHeader($cookies); //TODO BREAKING MVC HERE BECAUSE OF INTREMENTAL RENDERING echo '<h2>Rendering thumbnails <small>To avoid a delay when viewing photos for the first time</small></h2>'; $total = Models\Database::selectOne('photos', 'count(*)'); $done = Models\Database::selectOne('photos', 'count(*)', "id <= {$lastdone}"); $todo = Models\Database::selectOne('photos', 'count(*)', "id > {$lastdone}"); $timeleft = ceil((time() - $starttime) * $todo / ($numdone + $done / 1000 + 1) / 60); echo "<p>Progress: " . number_format($done) . ' of ' . number_format($total) . " done"; echo " (about {$timeleft} minutes left)"; echo "</p>\n"; $percentage = $done / $total * 100; echo "<progress class=\"progress\" value=\"{$percentage}\" max=\"100\">{$percentage}%</progress>"; $next1000 = Models\Database::select('photos', 'id', "id > {$lastdone} AND status != 9", 'ORDER BY id LIMIT 500'); $fixed = 0; flush(); while (($next = $next1000->fetchAssoc()) && $fixed < 10) { $photo = Models\Photo::getPhotoWithID($next['id']); $redo = $photo->isCacheMissing(); if ($redo) { echo "<div>Updating #" . $next['id'] . "</div>\n"; $photo->generateThumbnail(); echo "<div>Updated #" . $next['id'] . "</div>\n"; flush(); $fixed++; $photo->destroy(); } $lastdone = $next['id']; } $numdone += $fixed; if ($todo > 0) { echo "<script language='javascript'>window.setTimeout('window.location=\"" . htmlspecialchars($phpself) . "?lastdone={$lastdone}&starttime={$starttime}&numdone={$numdone}\"',400)</script>\n"; echo "<p><a href=\"?lastdone={$lastdone}&starttime={$starttime}&numdone={$numdone}\">Click here to continue</a> if the Javascript redirect doesn't work.</p>\n"; } $this->htmlFooter(); }
public function handleGet($get, $post, $files, $cookies) { if (Models\User::currentUser($cookies)->authorizationLevel < 5) { throw new \Exception('You are not authorized to view this page'); } /* Set up the page view */ $view = new Views\AdminSecurityView(); $users = array(); $query = Models\Database::select('users', '*', '', 'ORDER by id'); while ($record = $query->fetchAssoc()) { $users[] = new Models\User($record['id']); } $view->users = $users; $policies = array(); $view->securityPolicies = $policies; $this->htmlHeader($cookies); $view->render(); $this->htmlFooter(); }
public function handleGet($get, $post, $files, $cookies) { if (Models\User::currentUser($cookies)->authorizationLevel < 5) { throw new \Exception('You are not authorized to view this page'); } /* Set up the page view */ $view = new Views\AdminView(); $view->runningVersion = constant('CAMERALIFE_VERSION'); $view->latestVersion = $this->latestAvailableVersion(); $checkpointLogs = intval(Models\Preferences::valueForModuleWithKey('CameraLife', 'checkpointlogs')); $view->numNewLogs = Models\Database::selectOne('logs', 'COUNT(*)', 'id>' . $checkpointLogs); $checkpointComments = intval(Models\Preferences::valueForModuleWithKey('CameraLife', 'checkpointcomments')); $view->numNewComments = Models\Database::selectOne('comments', 'COUNT(*)', 'id>' . $checkpointComments); $view->numNewUsers = Models\Database::selectOne('users', 'COUNT(*)', 'auth=1'); $view->numFlagged = Models\Database::selectOne('photos', 'COUNT(*)', 'status=1'); $view->appearanceUrl = AdminAppearanceController::getUrl(); $view->logsUrl = AdminLogsController::getUrl(); $view->commentsUrl = AdminCommentsController::getUrl(); $view->fileStoreUrl = AdminFileStoreController::getUrl(); $view->securityUrl = AdminSecurityController::getUrl(); $view->thumbnailUrl = AdminThumbnailController::getUrl(); $view->rescanUrl = AdminRescanController::getUrl(); $view->photosUrl = AdminPhotosController::getUrl(); $preferences = array(); $preferences[] = ['module' => 'CameraLife', 'key' => 'sitename', 'type' => 'string', 'name' => 'Site name']; $preferences[] = ['module' => 'CameraLife', 'key' => 'sitename', 'type' => 'string', 'name' => 'Site abbreviation']; $preferences[] = ['module' => 'CameraLife', 'key' => 'owner_email', 'type' => 'string', 'name' => 'Owner email address']; $preferences[] = ['module' => 'CameraLife', 'key' => 'rewrite', 'type' => 'yesno', 'name' => 'Use pretty URLs']; $preferences[] = ['module' => 'CameraLife', 'key' => 'autorotate', 'type' => 'yesno', 'name' => 'Autorotate photos']; $preferences[] = ['module' => 'CameraLife', 'key' => 'thumbsize', 'type' => 'number', 'name' => 'Size for thumbnails']; $preferences[] = ['module' => 'CameraLife', 'key' => 'scaledsize', 'type' => 'number', 'name' => 'Size for preview images']; $preferences[] = ['module' => 'CameraLife', 'key' => 'optionsizes', 'type' => 'string', 'name' => 'Other available sizes', 'help' => 'comma separated (you can also leave this blank)']; $view->preferences = $preferences; $this->htmlHeader($cookies); $view->render(); $this->htmlFooter(); }
public function handleGet($get, $post, $files, $cookies) { if (Models\User::currentUser($cookies)->authorizationLevel < 5) { throw new \Exception('You are not authorized to view this page'); } /* Set up the page view */ $checkpointId = intval(Models\Preferences::valueForModuleWithKey('CameraLife', 'checkpointphotos')); $view = new Views\AdminPhotosView(); $view->isUsingHttps = isset($_SERVER['HTTPS']); $view->myUrl = $_SERVER['REQUEST_URI']; $query = Models\Database::select('photos', 'id', 'id>:0 AND status!=9', 'ORDER BY id LIMIT 200', null, array($checkpointId)); $view->photos = array(); while ($row = $query->fetchAssoc()) { $view->photos[] = Models\Photo::getPhotoWithID($row['id']); $view->lastReviewItem = $row['id']; } $done = Models\Database::selectOne('photos', 'count(id)', 'id<=:0 AND status!=9', null, null, array($checkpointId)); $view->reviewsDone = $done; $remaining = Models\Database::selectOne('photos', 'count(id)', 'id>:0 AND status!=9', null, null, array($checkpointId)); $view->reviewsRemaining = $remaining; $this->htmlHeader($cookies); $view->render(); $this->htmlFooter(); }
/** * Handles and routes any HTTP request using a subclass that can handles it. URLs are like: * * index.php?page=Photo&id=1243&... * * But usually the user will see pretty URLs that rewrite to the above such as * * photo/1243?... * * @access public * @param array $get * @param array $post * @param array $files * @param array $cookies * @param array $server * @return void */ public static function handleRequest($get, $post, $files, $cookies, $server) { try { $page = isset($get['page']) ? $get['page'] : 'mainPage'; $dbIsCurrent = Models\Database::installedSchemaIsCorrectVersion(); if (!$dbIsCurrent && substr($page, 0, 5) !== 'setup') { if (!Models\Database::connectionParametersAreSet() && $page != 'setupInstall') { header('Location: ' . SetupInstallController::getUrl()); return; } if ($page != 'setupUpgrade' && $page != 'setupInstall') { header('Location: ' . SetupUpgradeController::getUrl()); return; } } $controllerClass = 'CameraLife\\Controllers\\' . ucfirst($page) . 'Controller'; if (!class_exists($controllerClass)) { throw new \Exception('Page not found'); } if (isset($get['id'])) { $controller = new $controllerClass($get['id']); } else { $controller = new $controllerClass(); } $method = 'handle' . ucfirst(strtolower($server['REQUEST_METHOD'])); $controller->{$method}($get, $post, $files, $cookies); } catch (\Exception $e) { self::handleException($e); } }
public function handlePost($get, $post, $files, $cookies) { session_start(); if (!isset($post['host'])) { throw new \Exception('HOST is missing'); } if (!isset($post['name'])) { throw new \Exception('NAME is missing'); } if (!isset($post['user'])) { throw new \Exception('USER is missing'); } if (!isset($post['pass'])) { throw new \Exception('PASS is missing'); } if (!isset($post['prefix'])) { throw new \Exception('PREFIX is missing'); } if (!isset($_SESSION['openid_identity'])) { throw new \Exception('OpenID login is missing'); } Models\Database::$dsn = "mysql:host={$post['host']};dbname={$post['name']}"; Models\Database::$username = $post['user']; Models\Database::$password = $post['pass']; Models\Database::$prefix = $post['prefix']; Models\Database::setupTables(); Models\Preferences::setFactoryDefaults(); Models\User::userWithOpenId($_SESSION['openid_identity'], $_SESSION['openid_email']); Models\Database::update('users', ['auth' => 5], 'email="' . $_SESSION['openid_email'] . '"'); //todo security header('Location: ' . MainPageController::getUrl()); //todo URL / url http://www.teamten.com/lawrence/writings/capitalization_of_initialisms.html }
/** * Render the view to standard output * * @access public * @return void */ public function render() { if ($this->photo->get('status') != 0) { echo '<p class="alert alert-danger lead"><strong>Notice:</strong> This photo is not publicly viewable</p>'; } $this->referrer = str_replace(constant('BASE_URL'), '', $this->referrer); $this->referrer = preg_replace('|^/|', '', $this->referrer); //todo, photo model needs to know referrer $photoPrev = $this->photo->getPrevious(); $photoNext = $this->photo->getNext(); // Get stuff related to the current user if ($this->currentUser->isLoggedIn) { $rating = $avg = Models\Database::selectOne('ratings', 'AVG(rating)', 'id=' . $this->photo->get('id') . " AND username='******'"); } else { $rating = $avg = Models\Database::selectOne('ratings', 'AVG(rating)', 'id=' . $this->photo->get('id') . " AND user_ip='" . $this->currentUser->remoteAddr . "'"); } ?> <nav class="navbar navbar-light bg-faded navbar-fixed-bottom" style="background:rgba(255,255,255,0.4)"> <div class="container"> <form class="form-inline pull-xs-left" method=POST name="form" style="margin-right:10px"> <input type="hidden" name="action" value="<?php echo $rating ? 'unfavorite' : 'favorite'; ?> "> <?php $count = $this->photo->getLikeCount(); ?> <button class="btn btn-link" type="submit" style="padding:2px"> <span class="fa-stack"> <i class="fa fa-star<?php echo $rating ? '' : '-o'; ?> fa-stack-2x" style="color:gold"></i> <strong class="fa-stack-1x" style="font-size:0.7em;color:black"><?php echo $count ? $count : ''; ?> </strong> </span> </button> </form> <a href="<?php echo $this->photo->getMediaURL('photo'); ?> " class="btn btn-link pull-xs-left" title="<?php echo $this->photo->get('width'); ?> x <?php echo $this->photo->get('height'); ?> px" style="margin-right:10px" > <i class="fa fa-arrows-alt"></i> </a> <a href="<?php echo $this->contextUrl; ?> " class="btn btn-link pull-xs-left" title="Close" style="margin-right:10px" > <i class="fa fa-times"></i> </a> <span class="navbar-brand"><?php echo htmlspecialchars($this->openGraphObject->title); ?> </span> </div> </nav> <div id="mainPic" style="position:absolute;top:0;left:0;width:100%;height:100%;background:url(<?php echo $this->photo->getMediaURL('scaled'); ?> );background-size:contain;background-repeat:no-repeat;background-position:center" > <img src="<?php echo $this->photo->getMediaURL('scaled'); ?> " alt="<?php echo htmlentities($this->photo->get('description')); ?> " style="display:none" > </div> <div class="container" style="position:absolute;top:100%;height:100%;"> <h3>Information</h3> <dl class="dl-horizontal"> <?php if ($this->photo->get('username')) { echo ' <dt>Author</dt><dd>' . $this->photo->get('username') . '</dd>'; } if ($exif = $this->photo->getEXIF()) { foreach ($exif as $key => $val) { if ($key == "Location") { echo " <dt>{$key}</dt><dd><a href=\"http://maps.google.com/maps?q={$val}\">{$val}</a></dd>\n"; } else { if ($key == "Camera Model") { echo " <dt>{$key}</dt><dd><a href=\"http://pbase.com/cameras/{$val}\">{$val}</a></dd>\n"; } else { echo " <dt>{$key}</dt><dd>{$val}</dd>\n"; } } } } ?> </dl> </div> <?php // Cache the next image the user is likely to look at if ($photoNext) { echo '<img style="display:none" src="' . htmlspecialchars($photoNext->getMediaURL('scaled')) . '" alt="hidden photo">'; } }