<?php

require_once dirname(__FILE__).'/accesscheck.php';
ob_end_flush();
$upgrade_required = 0;
$canUpgrade = checkAccess('upgrade');

if (Sql_Table_exists($tables['config'], 1)) {
    $dbversion = getConfig('version');
    if ($dbversion != VERSION && $canUpgrade) {
        Error($GLOBALS['I18N']->get('Your database is out of date, please make sure to upgrade').'<br/>'.
     $GLOBALS['I18N']->get('Your version').' : '.$dbversion.'<br/>'.
     $GLOBALS['I18N']->get('phplist version').' : '.VERSION.
    '<br/>'.PageLink2('upgrade', $GLOBALS['I18N']->get('Upgrade'))
     );
        $upgrade_required = 1;
    }
} else {
    Info($GLOBALS['I18N']->get('Database has not been initialised').'. '.
  $GLOBALS['I18N']->get('go to').' '.
  PageLink2('initialise&firstinstall=1', $GLOBALS['I18N']->get('Initialise Database')).' '.
  $GLOBALS['I18N']->get('to continue'), 1);
    $GLOBALS['firsttime'] = 1;
    $_SESSION['firstinstall'] = 1;

    return;
}

## trigger this somewhere else?
refreshTlds();

# check for latest version
$checkinterval = sprintf('%d', getConfig('check_new_version'));
if (!isset($checkinterval)) {
    $checkinterval = 7;
}

$showUpdateAvail = !empty($_GET['showupdate']); ## just to check the design
$thisversion = VERSION;
$thisversion = preg_replace("/[^\.\d]/", '', $thisversion);
$latestversion = getConfig('updateavailable');
$showUpdateAvail = $showUpdateAvail || (!empty($latestversion) && !versionCompare($thisversion, $latestversion));

if (!$showUpdateAvail && $checkinterval) {

  ##https://mantis.phplist.com/view.php?id=16815
  $query = sprintf('select date_add(value, interval %d day) < now() as needscheck from %s where item = "updatelastcheck"', $checkinterval, $tables['config']);
    $needscheck = Sql_Fetch_Row_Query($query);
    if ($needscheck[0] != '0') {
        @ini_set('user_agent', NAME.' (phplist version '.VERSION.')');
        @ini_set('default_socket_timeout', 5);
        if ($fp = @fopen('https://www.phplist.com/files/LATESTVERSION', 'r')) {
            $latestversion = fgets($fp);
            $latestversion = preg_replace("/[^\.\d]/", '', $latestversion);
            @fclose($fp);
            if (!versionCompare($thisversion, $latestversion)) {
                ## remember this, so we can remind about the update, without the need to check the phplist site
        ## hmmm, this causes it to be "stuck" on the last version checked
        SaveConfig('updateavailable', $latestversion, 0, true);
                $showUpdateAvail = true;
            }
        }
        SaveConfig('updatelastcheck', date('Y-m-d H:i:s', time()), 0, true);
    }
}

if ($showUpdateAvail) {
    print '<div class="newversion note">';
    print $GLOBALS['I18N']->get('A new version of phpList is available!');
    print '<br/>';
    print '<br/>'.$GLOBALS['I18N']->get('The new version may have fixed security issues,<br/>so it is recommended to upgrade as soon as possible');
    print '<br/>'.$GLOBALS['I18N']->get('Your version').': <b>'.$thisversion.'</b>';
    print '<br/>'.$GLOBALS['I18N']->get('Latest version').': <b>'.$latestversion.'</b><br/>  ';
    print '<a href="https://www.phplist.com/latestchanges?utm_source=pl'.$thisversion.'&amp;utm_medium=updatenews&amp;utm_campaign=phpList" title="'.s('Read what has changed in the new version').'" target="_blank">'.$GLOBALS['I18N']->get('View what has changed').'</a>&nbsp;&nbsp;';
    print '<a href="https://www.phplist.com/download?utm_source=pl'.$thisversion.'&amp;utm_medium=updatedownload&amp;utm_campaign=phpList" title="'.s('Download the new version').'" target="_blank">'.$GLOBALS['I18N']->get('Download').'</a></div>';
}

print '<div class="accordion">';

$some = 0;
$ls = new WebblerListing('');
if (checkAccess('setup') && !$_GET['pi']) {
    if (!empty($_SESSION['firstinstall'])) {
        $some = 1;
        $element = $GLOBALS['I18N']->get('Continue Configuration');
        $ls->addElement($element, PageURL2('setup'));
        $ls->addColumn($element, '&nbsp;', PageLinkClass('setup', $GLOBALS['I18N']->get('Continue the Configuration process of phpList'), '', 'hometext'));
        $ls->setClass($element, 'config-link');
    }
}
if (checkAccess('send') && !$_GET['pi']) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('Send a campaign');
    $ls->addElement($element, PageURL2('send'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('send', $GLOBALS['I18N']->get('Start or continue a campaign'), '', 'hometext'));
    $ls->setClass($element, 'send-campaign');
}
if (checkAccess('messages')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('Manage Campaigns');
    $ls->addElement($element, PageURL2('messages'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('messages', $GLOBALS['I18N']->get('View current campaigns'), '', 'hometext'));
    $ls->setClass($element, 'manage-campaigns');
}
if (checkAccess('users')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('Manage Subscribers');
    $ls->addElement($element, PageURL2('users'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('users', $GLOBALS['I18N']->get('Search, edit and add Subscribers'), '', 'hometext'));
    $ls->setClass($element, 'manage-users');
}
if (checkAccess('statsoverview')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('View Statistics');
    $ls->addElement($element, PageURL2('statsoverview'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('statsoverview', $GLOBALS['I18N']->get('View statistics'), '', 'hometext'));
    $ls->setClass($element, 'view-statistics');
}

if ($some) {
    print '<h3><a name="main">'.$GLOBALS['I18N']->get('Main').'</a></h3>';
    $ls->noShader();
    $ls->noHeader();
    print '<div>'.$ls->display().'</div>';
}

$some = 0;
$ls = new WebblerListing('');
if (checkAccess('list')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('Manage Lists');
    $ls->addElement($element, PageURL2('list'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('list', $GLOBALS['I18N']->get('View, edit and add lists, that your subscribers can sign up to'), '', 'hometext'));
    $ls->setClass($element, 'manage-lists');
}
if (checkAccess('users')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('users');
    $ls->addElement($element, PageURL2('users'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('users', $GLOBALS['I18N']->get('List all Users'), '', 'hometext'));
    $ls->setClass($element, 'list-users');
}
if (ALLOW_IMPORT && checkAccess('import') && !$_GET['pi']) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('import');
    $ls->addElement($element, PageURL2('import'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('import', $GLOBALS['I18N']->get('Import Users'), '', 'hometext'));
    $ls->setClass($element, 'import-users');
}
if (checkAccess('export') && !$_GET['pi']) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('export');
    $ls->addElement($element, PageURL2('export'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('export', $GLOBALS['I18N']->get('Export Users'), '', 'hometext'));
    $ls->setClass($element, 'export-users');
}
if (checkAccess('reconcileusers')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('reconcileusers');
    $ls->addElement($element, PageURL2('reconcileusers'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('reconcile', $GLOBALS['I18N']->get('Reconcile the User Database'), '', 'hometext'));
    $ls->setClass($element, 'reconcileusers');
}
if ($some) {
    print '<h3><a name="list">'.$GLOBALS['I18N']->get('List and user functions').'</a></h3>';
    $ls->noShader();
    $ls->noHeader();
    print '<div>'.$ls->display().'</div>';
}
$some = 0;
$ls = new WebblerListing('');
if (checkAccess('configure')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('configure');
    $ls->addElement($element, PageURL2('configure'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('configure', $GLOBALS['I18N']->get('Configure').' '.NAME, '', 'hometext'));
    $ls->setClass($element, 'configure');
}
if (checkAccess('attributes') && !$_GET['pi']) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('attributes');
    $ls->addElement($element, PageURL2('attributes'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('attributes', $GLOBALS['I18N']->get('Configure Attributes'), '', 'hometext'));
    $ls->setClass($element, 'configure-attributes');
    if (Sql_table_exists($tables['attribute'])) {
        $res = Sql_Query('select * from '.$tables['attribute'], 0);
        while ($row = Sql_Fetch_array($res)) {
            if ($row['type'] != 'checkbox' && $row['type'] != 'textarea' && $row['type'] != 'textline' && $row['type'] != 'hidden') {
                $ls->addElement($row['name'], PageURL2('editattributes&amp;id='.$row['id']));
                $ls->addColumn($row['name'], '&nbsp;', PageLinkClass('editattributes&amp;id='.$row['id'], $GLOBALS['I18N']->get('Control values for').' '.$row['name'], '', 'hometext'));
                $ls->setClass($row['name'], 'custom-attribute');
            }
        }
    }
}
if (checkAccess('spage')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('spage');
    $ls->addElement($element, PageURL2('spage'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('spage', $GLOBALS['I18N']->get('Configure Subscribe Pages'), '', 'hometext'));
    $ls->setClass($element, 'spage');
}

if ($some) {
    print '<h3><a name="config">'.$GLOBALS['I18N']->get('Configuration Functions').'</a></h3>';
    $ls->noShader();
    $ls->noHeader();
    print '<div>'.$ls->display().'</div>';
}

$some = 0;
$ls = new WebblerListing('');
if (checkAccess('admins')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('admins');
    $ls->addElement($element, PageURL2('admins'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('admins', $GLOBALS['I18N']->get('Add, edit and remove Administrators'), '', 'hometext'));
    $ls->setClass($element, 'admins');
}
if (checkAccess('adminattributes')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('adminattributes');
    $ls->addElement($element, PageURL2('adminattributes'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('adminattributes', $GLOBALS['I18N']->get('Configure Attributes for administrators'), '', 'hometext'));
    $ls->setClass($element, 'adminattributes');
}
if ($some) {
    print '<h3><a name="admin">'.$GLOBALS['I18N']->get('Administrator Functions').'</a></h3>';
    $ls->noShader();
    $ls->noHeader();
    print '<div>'.$ls->display().'</div>';
}

$some = 0;
$ls = new WebblerListing('');
if (checkAccess('send')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('send');
    $ls->addElement($element, PageURL2('send'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('send', $GLOBALS['I18N']->get('Send a Message'), '', 'hometext'));
    $ls->setClass($element, 'send-message');
}
if (USE_PREPARE) {
    if (checkAccess('preparesend')) {
        $some = 1;
        $element = $GLOBALS['I18N']->get('preparesend');
        $ls->addElement($element, PageURL2('preparesend'));
        $ls->addColumn($element, '&nbsp;', PageLinkClass('preparesend', $GLOBALS['I18N']->get('Prepare a Message'), '', 'hometext'));
        $ls->setClass($element, 'preparesend');
    }
    if (checkAccess('sendprepared')) {
        $some = 1;
        $element = $GLOBALS['I18N']->get('sendprepared');
        $ls->addElement($element, PageURL2('sendprepared'));
        $ls->addColumn($element, '&nbsp;', PageLinkClass('sendprepared', $GLOBALS['I18N']->get('Send a Prepared Message'), '', 'hometext'));
        $ls->setClass($element, 'sendprepared');
    }
}
if (checkAccess('templates')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('templates');
    $ls->addElement($element, PageURL2('templates'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('templates', $GLOBALS['I18N']->get('Configure Templates'), '', 'hometext'));
    $ls->setClass($element, 'templates');
}
if (checkAccess('messages')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('messages');
    $ls->addElement($element, PageURL2('messages'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('messages', $GLOBALS['I18N']->get('List all Messages'), '', 'hometext'));
    $ls->setClass($element, 'list-all-msg');
}
if (checkAccess('processqueue') && MANUALLY_PROCESS_QUEUE) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('processqueue');
    $ls->addElement($element, PageURL2('processqueue'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('processqueue', $GLOBALS['I18N']->get('Process the Message Queue'), '', 'hometext'));
    $ls->setClass($element, 'processqueue');
    if (TEST) {
        $ls->addColumn($element, $GLOBALS['I18N']->get('warning'), $GLOBALS['I18N']->get('You have set TEST in config.php to 1, so it will only show what would be sent'));
    }
}
if (checkAccess('processbounces') && MANUALLY_PROCESS_BOUNCES) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('processbounces');
    $ls->addElement($element, PageURL2('processbounces'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('processbounces', $GLOBALS['I18N']->get('Process Bounces'), '', 'hometext'));
    $ls->setClass($element, 'processbounces');
}
if (checkAccess('bounces')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('bounces');
    $ls->addElement($element, PageURL2('bounces'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('bounces', $GLOBALS['I18N']->get('View Bounces'), '', 'hometext'));
    $ls->setClass($element, 'bounces');
}
if ($some) {
    print '<h3><a name="msg">'.$GLOBALS['I18N']->get('Message Functions').'</a></h3>';
    $ls->noShader();
    $ls->noHeader();
    print '<div>'.$ls->display().'</div>';
}

//obsolete, moved to rssmanager plugin
//$some = 0;
//$ls = new WebblerListing($GLOBALS['I18N']->get('rss Functions'));
//if (checkAccess("getrss") && MANUALLY_PROCESS_rss) {
//  $some = 1;
//  $element = $GLOBALS['I18N']->get('getrss');
//  $ls->addElement($element,PageURL2("getrss"));
//  $ls->addColumn($element,"&nbsp;",$GLOBALS['I18N']->get('Get rss feeds'));
//}
//if (checkAccess("viewrss")) {
//  $some = 1;
//  $element = $GLOBALS['I18N']->get('viewrss');
//  $ls->addElement($element,PageURL2("viewrss"));
//  $ls->addColumn($element,"&nbsp;",$GLOBALS['I18N']->get('View rss items'));
//}
//if (checkAccess("purgerss")) {
//  $some = 1;
//  $element = $GLOBALS['I18N']->get('purgerss');
//  $ls->addElement($element,PageURL2("purgerss"));
//  $ls->addColumn($element,"&nbsp;",$GLOBALS['I18N']->get('Purge rss items'));
//}
//
//obsolete, moved to rssmanager plugin
//if ($some && ENABLE_RSS && !array_key_exists("rssmanager", $GLOBALS["plugins"]))
//  print $ls->display();

$some = 0;
$ls = new WebblerListing('');
if (count($GLOBALS['plugins'])) {
    foreach ($GLOBALS['plugins'] as $pluginName => $plugin) {
        $menu = $plugin->adminmenu();
        if (is_array($menu)) {
            foreach ($menu as $page => $desc) {
                $some = 1;
                $ls->addElement($pluginName.' '.$page, PageUrl2("$page&amp;pi=$pluginName"));
                $ls->addColumn($pluginName.' '.$page, '&nbsp;', PageLinkClass("$page&amp;pi=$pluginName", $GLOBALS['I18N']->get($desc), '', 'hometext'));
                $ls->setClass($pluginName.' '.$page, 'plugin');
            }
        }
    }
}
if ($some) {
    print '<h3><a name="plugins">'.$GLOBALS['I18N']->get('Plugins').'</a></h3>';
    $ls->noShader();
    $ls->noHeader();
    print '<div>'.$ls->display().'</div>';
}

$some = 0;
$ls = new WebblerListing('');
if (checkAccess('initialise') && !$_GET['pi']) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('setup');
    $ls->addElement($element, PageURL2('setup'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('setup', $GLOBALS['I18N']->get('Setup ').NAME, '', 'hometext'));
    $ls->setClass($element, 'setup');
}
if (checkAccess('upgrade') && !$_GET['pi'] && $upgrade_required) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('upgrade');
    $ls->addElement($element, PageURL2('upgrade'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('upgrade', $GLOBALS['I18N']->get('Upgrade'), '', 'hometext'));
    $ls->setClass($element, 'upgrade');
}
if (checkAccess('dbcheck')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('dbcheck');
    $ls->addElement($element, PageURL2('dbcheck'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('dbcheck', $GLOBALS['I18N']->get('Check Database structure'), '', 'hometext'));
    $ls->setClass($element, 'dbcheck');
}

if (checkAccess('eventlog')) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('eventlog');
    $ls->addElement($element, PageURL2('eventlog'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('eventlog', $GLOBALS['I18N']->get('View the eventlog'), '', 'hometext'));
    $ls->setClass($element, 'view-log');
}
if (checkAccess('admin') && $GLOBALS['require_login'] && !isSuperUser()) {
    $some = 1;
    $element = $GLOBALS['I18N']->get('admin');
    $ls->addElement($element, PageURL2('admin'));
    $ls->addColumn($element, '&nbsp;', PageLinkClass('admin', $GLOBALS['I18N']->get('Change your details (e.g. password)'), '', 'hometext'));
    $ls->setClass($element, 'change-pass');
}
if ($some) {
    print '<h3><a name="system">'.$GLOBALS['I18N']->get('System Functions').'</a></h3>';
    $ls->noShader();
    $ls->noHeader();
    print '<div>'.$ls->display().'</div>';
}

print '</div>';
