/**
* Routine to check for installation or upgrade
*/
public static function checkVersion()
{
global $db, $user;
$swversion->major = EXPONENT_VERSION_MAJOR;
$swversion->minor = EXPONENT_VERSION_MINOR;
$swversion->revision = EXPONENT_VERSION_REVISION;
$swversion->type = EXPONENT_VERSION_TYPE;
$swversion->iteration = EXPONENT_VERSION_ITERATION;
$swversion->builddate = EXPONENT_VERSION_BUILDDATE;
// check database version against installed software version
if ($db->havedb) {
if ($user->isAdmin()) {
$dbversion = $db->selectObject('version', 1);
if (empty($dbversion)) {
$dbversion->major = 0;
$dbversion->minor = 0;
$dbversion->revision = 0;
$dbversion->type = '';
$dbversion->iteration = '';
}
// check if software version is newer than database version
if (self::compareVersion($dbversion, $swversion)) {
$oldvers = $dbversion->major . '.' . $dbversion->minor . '.' . $dbversion->revision . ($dbversion->type ? $dbversion->type : '') . ($dbversion->iteration ? $dbversion->iteration : '');
$newvers = $swversion->major . '.' . $swversion->minor . '.' . $swversion->revision . ($swversion->type ? $swversion->type : '') . ($swversion->iteration ? $swversion->iteration : '');
flash('message', gt('The database requires upgrading from') . ' v' . $oldvers . ' ' . gt('to') . ' v' . $newvers . '<br><a href="' . makelink(array("controller" => "administration", "action" => "install_exponent")) . '">' . gt('Click here to Upgrade your website') . '</a>');
}
}
} else {
// database is unavailable, so show us as being offline
$template = new standalonetemplate('_maintenance');
$template->assign("db_down", true);
$template->output();
exit;
}
// check if online version is newer than installed software version, but only once per session
if ($user->isAdmin()) {
if (!expSession::is_set('update-check')) {
$onlineVer = self::getOnlineVersion();
expSession::set('update-check', '1');
if (self::compareVersion($swversion, $onlineVer)) {
$newvers = $onlineVer->major . '.' . $onlineVer->minor . '.' . $onlineVer->revision . ($onlineVer->type ? $onlineVer->type : '') . ($onlineVer->iteration ? $onlineVer->iteration : '');
flash('message', gt('A newer version of Exponent is available') . ': v' . $newvers . ' ' . gt('was released') . ' ' . expDateTime::format_date($onlineVer->builddate) . '<br><a href="https://github.com/exponentcms/exponent-cms/downloads" target="_blank">' . gt('Click here to see available Downloads') . '</a>');
}
}
}
}
public function showall_by_date()
{
expHistory::set('viewable', $this->params);
$start_date = mktime(0, 0, 0, $this->params['month'], 1, $this->params['year']);
$end_date = mktime(0, 0, 0, $this->params['month'] + 1, 0, $this->params['year']);
$where = ($this->aggregateWhereClause() ? $this->aggregateWhereClause() . " AND " : "") . 'created_at > ' . $start_date . ' AND created_at < ' . $end_date;
$order = 'created_at';
$limit = empty($this->config['limit']) ? 10 : $this->config['limit'];
$page = new expPaginator(array('model' => 'blog', 'where' => $where, 'limit' => $limit, 'order' => $order, 'dir' => 'desc', 'controller' => $this->baseclassname, 'action' => $this->params['action'], 'columns' => array('Title' => 'title')));
assign_to_template(array('page' => $page, 'moduletitle' => 'Blogs by date "' . expDateTime::format_date($start_date) . '"'));
}
