TimeKeeper/admin_prefs.php

<?php

/*
 * e107 website system
 *
 * Copyright (C) 2008-2016 e107 Inc (e107.org)
 * Released under the terms and conditions of the
 * GNU General Public License (http://www.gnu.org/licenses/gpl.txt)
 *
 * TimeKeeper admin area.
 *
 * Changes from the current repo version:
 *  - the "Pending" screen pointed at a table called `Pending` (it doesn't
 *    exist: the table is timekeeperPending) and its fields were copied from
 *    the Questions screen, so none matched; now uses the real table/columns
 *  - new "Preferences" page with a `stats_key` setting. This is the shared
 *    secret that tk_stats_page.php and timekeeper.php?mode=short check
 *    (?key=...), so it can be set from the admin area instead of a script
 *  - pluginName is the plugin folder name in lower case ('timekeeper'); the
 *    prefs are stored/read under that name (getPlugPref('timekeeper', ...))
 *  - "Spelling Score" page (customPage): user and subject are escaped when
 *    printed and in SQL, `e107.e107_tkReport` -> #tkReport, the three nested
 *    query loops are one GROUP BY query per user, and "next word" no longer
 *    prints blanks (or warns) when every word already has a usage
 *  - removed the leftover rss_url*() methods copied from the RSS plugin
 */


require_once("../../class2.php");
if (!getperms("P") || !e107::isInstalled('timekeeper')) {
    e107::redirect('admin');
    exit;
}

// Maybe later i'll setup languages
//e107::includeLan(e_PLUGIN."timekeeper/languages/".e_LANGUAGE."_admin_timekeeper_menu.php");


class timekeeper_admin extends e_admin_dispatcher {

    protected $modes = array(
        'main' => array(
            'controller' => 'plugin_tk_admin_ui',
            'path' => null,
            'ui' => 'plugin_tk_admin_form_ui',
            'uipath' => null
        ),
        'score' => array(
            'controller' => 'tk_Score_ui',
            'path' => null,
            'ui' => 'tk_Score_form_ui',
            'uipath' => null
        ),
        'pending' => array(
            'controller' => 'tk_Pending_ui',
            'path' => null,
            'ui' => 'tk_Pending_form_ui',
            'uipath' => null
        ),
        'report' => array(
            'controller' => 'tk_Report_ui',
            'path' => null,
            'ui' => 'tk_Report_form_ui',
            'uipath' => null
        ),
        'reportold' => array(
            'controller' => 'tk_Reportold_ui',
            'path' => null,
            'ui' => 'tk_Reportold_form_ui',
            'uipath' => null
        ),
        'wordlist' => array(
            'controller' => 'tk_Wordlist_ui',
            'path' => null,
            'ui' => 'tk_Wordlist_form_ui',
            'uipath' => null
        ),
        'geography' => array(
            'controller' => 'tk_geography_ui',
            'path' => null,
            'ui' => 'tk_geography_form_ui',
            'uipath' => null
        ),
    );
    protected $adminMenu = array(
        'main/list' => array('caption' => 'List Questions', 'perm' => '0'),
        'main/create' => array('caption' => LAN_CREATE, 'perm' => '0'),
        'main/prefs' => array('caption' => LAN_PREFS, 'perm' => '0'),
        'other0' => array('divider' => true),
        //'subjects/list'		=> array('caption'=> 'List Subjects', 'perm' => '0'),
        //'subjects/create'	=> array('caption'=> 'Add Subjects', 'perm' => '0'),
        //'other1' 		=> array('divider' => true),
        'Score/list' => array('caption' => 'List Score', 'perm' => '0'),
        'other2' => array('divider' => true),
        'Pending/list' => array('caption' => 'List Pending', 'perm' => '0'),
        'other3' => array('divider' => true),
        'Report/list' => array('caption' => 'List Report', 'perm' => '0'),
        'Reportold/list' => array('caption' => 'List Report (Old)', 'perm' => '0'),
        'other4' => array('divider' => true),
        'Wordlist/list' => array('caption' => 'Spelling Words', 'perm' => '0'),
        'Wordlist/create' => array('caption' => 'Add Words', 'perm' => '0'),
        'Wordlist/custom' => array('caption' => 'Spelling Score', 'perm' => '0'),
        'other5' => array('divider' => true),
        'Geography/list' => array('caption' => 'Geography', 'perm' => '0'),
    );
    protected $adminMenuAliases = array(
        'main/edit' => 'main/list'
    );
    protected $menuTitle = 'TimeKeeper';

}

/*
  =========================================================================
  =====	Questions table interface (and plugin preferences)
  =========================================================================
 */

class plugin_tk_admin_ui extends e_admin_ui {

    protected $pluginTitle = 'TimeKeeper';
    protected $pluginName = 'timekeeper';
    protected $table = 'timekeeperQuestions';
    protected $pid = 'timekeeper_id';
    protected $perPage = 10;
    protected $fields = array(
        'checkboxes' => array('title' => '', 'type' => null, 'data' => false, 'width' => '5%', 'thclass' => 'center', 'forced' => '1', 'class' => 'center', 'toggle' => 'e-multiselect',),
        'timekeeper_id' => array('title' => LAN_ID, 'data' => 'int', 'width' => '5%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_questiondescription' => array('title' => LAN_TITLE, 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_question' => array('title' => "Question", 'type' => 'text', 'data' => 'str', 'readonly' => 1, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_answers' => array('title' => "Answers", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_subject' => array('title' => "Subject", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_addeddatestamp' => array('title' => LAN_DATESTAMP, 'type' => 'datestamp', 'data' => 'int', 'readonly' => true, 'width' => 'auto', 'filter' => true, 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_yearlevel' => array('title' => "Year Level", 'type' => 'dropdown', 'data' => 'int', 'inline' => true, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => array('optArray' => array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)), 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_correctanswer' => array('title' => "Correct Answer", 'type' => 'number', 'data' => 'int', 'inline' => true, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'options' => array('title' => LAN_OPTIONS, 'type' => null, 'data' => '', 'width' => '10%', 'thclass' => 'center last', 'class' => 'center last', 'forced' => '1',),
    );
    protected $fieldpref = array('checkboxes', 'timekeeper_questiondescription', 'timekeeper_question', 'timekeeper_answers', 'timekeeper_correctanswer', 'timekeeper_yearlevel', 'options');

    // Plugin preferences (Preferences page). Read elsewhere with
    // e107::getPlugPref('timekeeper', 'stats_key', '').
    protected $prefs = array(
        'stats_key' => array(
            'title' => 'Stats / summary key',
            'type' => 'text',
            'data' => 'str',
            'help' => 'Shared secret for tk_stats_page.php and timekeeper.php?mode=short: add &key=<this value> to the URL. Leave empty for no key (tk_stats_page.php is then open to anyone).',
            'writeParms' => array('size' => 'xxlarge'),
        ),
    );

}

class plugin_tk_admin_form_ui extends e_admin_form_ui {
    
}

/*
  =========================================================================
  =====	Score table interface
  =========================================================================
 */

class tk_Score_ui extends e_admin_ui {

    protected $pluginTitle = 'TimeKeeper';
    protected $pluginName = 'timekeeper';
    protected $table = 'timekeeperScore';
    protected $pid = 'timekeeper_id';
    protected $perPage = 10;
    protected $fields = array(
        'checkboxes' => array('title' => '', 'type' => null, 'data' => false, 'width' => '5%', 'thclass' => 'center', 'forced' => '1', 'class' => 'center', 'toggle' => 'e-multiselect',),
        'timekeeper_id' => array('title' => LAN_ID, 'data' => 'int', 'width' => '5%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_username' => array('title' => "User Name", 'type' => 'text', 'data' => 'str', 'readonly' => 1, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_lifetimequestions' => array('title' => "life time Question", 'type' => 'text', 'data' => 'str', 'readonly' => 1, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_lifetimecorrect' => array('title' => "life time correct", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_minutes' => array('title' => "minutes", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_lastquestiondatestamp' => array('title' => LAN_DATESTAMP, 'type' => 'datestamp', 'data' => 'int', 'readonly' => true, 'width' => 'auto', 'filter' => true, 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_yearlevel' => array('title' => "Year Level", 'type' => 'dropdown', 'data' => 'int', 'inline' => true, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => array('optArray' => array(1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12)), 'class' => 'left', 'thclass' => 'left',),
        'options' => array('title' => LAN_OPTIONS, 'type' => null, 'data' => '', 'width' => '10%', 'thclass' => 'center last', 'class' => 'center last', 'forced' => '1',),
    );
    protected $fieldpref = array('checkboxes', 'timekeeper_username', 'timekeeper_lifetimequestions', 'timekeeper_lifetimecorrect', 'timekeeper_minutes', 'options');

}

class tk_Score_form_ui extends e_admin_form_ui {

}

/*
  =========================================================================
  =====	Pending table interface
  =========================================================================
 */

class tk_Pending_ui extends e_admin_ui {

    protected $pluginTitle = 'TimeKeeper';
    protected $pluginName = 'timekeeper';
    protected $table = 'timekeeperPending';
    protected $pid = 'timekeeper_id';
    protected $perPage = 10;
    protected $fields = array(
        'checkboxes' => array('title' => '', 'type' => null, 'data' => false, 'width' => '5%', 'thclass' => 'center', 'forced' => '1', 'class' => 'center', 'toggle' => 'e-multiselect',),
        'timekeeper_id' => array('title' => LAN_ID, 'data' => 'int', 'width' => '5%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_username' => array('title' => "User Name", 'type' => 'text', 'data' => 'str', 'readonly' => 1, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_question' => array('title' => "Question", 'type' => 'number', 'data' => 'int', 'readonly' => 1, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_answereddatestamp' => array('title' => LAN_DATESTAMP, 'type' => 'datestamp', 'data' => 'int', 'readonly' => true, 'width' => 'auto', 'filter' => true, 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_answer' => array('title' => "Answer", 'type' => 'textarea', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'options' => array('title' => LAN_OPTIONS, 'type' => null, 'data' => '', 'width' => '10%', 'thclass' => 'center last', 'class' => 'center last', 'forced' => '1',),
    );
    protected $fieldpref = array('checkboxes', 'timekeeper_username', 'timekeeper_question', 'timekeeper_answereddatestamp', 'timekeeper_answer', 'options');

}

class tk_Pending_form_ui extends e_admin_form_ui {

}

/*
  =========================================================================
  =====	Report table interface
  =========================================================================
 */

class tk_Report_ui extends e_admin_ui {

    protected $pluginTitle = 'TimeKeeper';
    protected $pluginName = 'timekeeper';
    protected $table = 'tkReport';
    protected $pid = 'id';
    protected $perPage = 10;
    protected $fields = array(
        'checkboxes' => array('title' => '', 'type' => null, 'data' => false, 'width' => '5%', 'thclass' => 'center', 'forced' => '1', 'class' => 'center', 'toggle' => 'e-multiselect',),
        'id' => array('title' => LAN_ID, 'data' => 'int', 'width' => '5%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'username' => array('title' => "User Name", 'type' => 'text', 'data' => 'str', 'readonly' => 1, 'width' => 'auto', 'filter' => true, 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'question' => array('title' => "Question", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'userAnswer' => array('title' => "User Answer", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'answer' => array('title' => "Correct Answer", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'subject' => array('title' => "Subject", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'answereddatestamp' => array('title' => LAN_DATESTAMP, 'type' => 'datestamp', 'data' => 'int', 'readonly' => true, 'width' => 'auto', 'filter' => true, 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'correct' => array('title' => "Correct", 'type' => 'bool', 'data' => 'int', 'inline' => true, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'options' => array('title' => LAN_OPTIONS, 'type' => null, 'data' => '', 'width' => '10%', 'thclass' => 'center last', 'class' => 'center last', 'forced' => '1',),
    );
    protected $fieldpref = array('checkboxes', 'username', 'question', 'userAnswer', 'answer', 'options');

}

class tk_Report_form_ui extends e_admin_form_ui {

}

class tk_Reportold_ui extends e_admin_ui {

    protected $pluginTitle = 'TimeKeeper';
    protected $pluginName = 'timekeeper';
    protected $table = 'timekeeperReport';
    protected $pid = 'timekeeper_id';
    protected $perPage = 10;
    protected $fields = array(
        'checkboxes' => array('title' => '', 'type' => null, 'data' => false, 'width' => '5%', 'thclass' => 'center', 'forced' => '1', 'class' => 'center', 'toggle' => 'e-multiselect',),
        'timekeeper_id' => array('title' => LAN_ID, 'data' => 'int', 'width' => '5%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_username' => array('title' => "User Name", 'type' => 'text', 'data' => 'str', 'readonly' => 1, 'width' => 'auto', 'filter' => true, 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_question' => array('title' => "Question", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_userAnswer' => array('title' => "User Answer", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_answer' => array('title' => "Correct Answer", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_subject' => array('title' => "Subject", 'type' => 'text', 'data' => 'str', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_answereddatestamp' => array('title' => LAN_DATESTAMP, 'type' => 'datestamp', 'data' => 'int', 'readonly' => true, 'width' => 'auto', 'filter' => true, 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_yearLevel' => array('title' => "Year Level", 'type' => 'number', 'data' => 'int', 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'timekeeper_correct' => array('title' => "Correct", 'type' => 'bool', 'data' => 'int', 'inline' => true, 'width' => 'auto', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'options' => array('title' => LAN_OPTIONS, 'type' => null, 'data' => '', 'width' => '10%', 'thclass' => 'center last', 'class' => 'center last', 'forced' => '1',),
    );
    protected $fieldpref = array('checkboxes', 'timekeeper_username', 'timekeeper_question', 'timekeeper_userAnswer', 'timekeeper_answer', 'timekeeper_yearLevel', 'options');

}

class tk_Reportold_form_ui extends e_admin_form_ui {

}

/*
  =========================================================================
  =====	Wordlist table interface
  =========================================================================
 */

class tk_Wordlist_ui extends e_admin_ui {

    protected $pluginTitle = 'TimeKeeper';
    protected $pluginName = 'timekeeper';
    protected $table = 'tk_wordList';
    protected $pid = 'indexNo';
    protected $perPage = 10;
    protected $fields = array(
        'checkboxes' => array('title' => '', 'type' => null, 'data' => false, 'width' => '5%', 'thclass' => 'center', 'forced' => '1', 'class' => 'center', 'toggle' => 'e-multiselect',),
        'indexNo' => array('title' => LAN_ID, 'data' => 'int', 'width' => '5%', 'readonly' => 1, 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'word' => array('title' => "Word", 'type' => 'text', 'data' => 'str', 'readonly' => 1, 'width' => '10%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'usage' => array('title' => "Word Usage", 'type' => 'textarea', 'data' => 'str', 'width' => '65%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'year' => array('title' => "Year Level", 'type' => 'number', 'data' => 'int', 'width' => '5%', 'help' => '', 'readParms' => '', 'writeParms' => ['default' => 1, 'min' => 1, 'max' => 13], 'class' => 'left', 'thclass' => 'left',),
        'options' => array('title' => LAN_OPTIONS, 'type' => null, 'data' => '', 'width' => '10%', 'thclass' => 'center last', 'class' => 'center last', 'forced' => '1',),
    );
    protected $fieldpref = array('checkboxes', 'indexNo', 'word', 'usage', 'year', 'options');

    private function esc($value) {
        return htmlspecialchars((string) $value, ENT_QUOTES, 'UTF-8');
    }

    /**
     * "Spelling Score" page: last month's score per user and subject, a
     * difficulty figure per user, and how many words still need a usage.
     */
    public function customPage() {

        $sql = e107::getDb();

        $text = '<table style="width:600px;"><tr><td style="width:25%;">User</td><td style="width:25%;">Subject</td><td style="width:24%;">Percentage</td><td style="width:25%;">Questions last month</td></tr>';

        $users = [];
        $sql->gen("SELECT DISTINCT username FROM `#tkReport` WHERE `answereddatestamp` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 MONTH)");
        while ($row = $sql->fetch()) {
            $users[] = $row['username'];
        }

        foreach ($users as $user) {
            $u = $sql->escape($user);

            // Score per subject, last month.
            $sql->gen("SELECT `subject`, CAST((SUM(correct) / COUNT(id) * 100) AS DECIMAL(5,2)) AS percent, COUNT(id) AS `count`
                FROM `#tkReport`
                WHERE `answereddatestamp` > UNIX_TIMESTAMP(NOW() - INTERVAL 1 MONTH) AND `username` = '{$u}'
                GROUP BY `subject` ORDER BY `subject`");
            while ($row = $sql->fetch()) {
                $text .= '<tr><td>' . $this->esc($user) . '</td><td>' . $this->esc($row['subject']) . '</td><td>' . $this->esc($row['percent']) . '</td><td>' . (int) $row['count'] . '</td></tr>';
            }

            // Difficulty as the game computes it: all-time question count x last month's overall percent.
            $totalQuestionCount = (int) $sql->count('tkReport', '(id)', "username = '{$u}'");

            $sql->gen("SELECT CAST((SUM(correct)/COUNT(id)*100) AS DECIMAL(5,2)) AS percent
                FROM `#tkReport` WHERE username = '{$u}'
                AND answereddatestamp >= UNIX_TIMESTAMP(CURRENT_DATE() - INTERVAL 1 MONTH)
                AND answereddatestamp <= UNIX_TIMESTAMP(CURRENT_DATE() + INTERVAL 1 DAY)");
            $row = $sql->fetch();
            $percent = (is_array($row) && $row['percent'] !== null) ? (float) $row['percent'] : 0;

            $text .= '<tr><td colspan=2>Difficulty</td><td colspan=2>' . ($totalQuestionCount * $percent) . '</td></tr>';
        }

        $text .= '</table><br/><br/>';

        $missing = (int) $sql->retrieve("SELECT COUNT(*) FROM `#tk_wordList` WHERE `usage` = '' OR `usage` IS NULL");
        $text .= $missing . ' words need a usage entered.<br/>';

        $nextWord = $sql->retrieve("SELECT `indexNo`, `word` FROM `#tk_wordList` WHERE `usage` = '' OR `usage` IS NULL ORDER BY `indexNo` LIMIT 1");
        if (is_array($nextWord)) {
            $text .= 'The next word to be entered is "' . $this->esc($nextWord['word']) . '" at position ' . (int) $nextWord['indexNo'] . '.';
        } else {
            $text .= 'Every word has a usage entered.';
        }

        $ns = e107::getRender();
        $ns->tablerender("Scores", $text);
    }

}

class tk_Wordlist_form_ui extends e_admin_form_ui {

}

class tk_geography_ui extends e_admin_ui {

    protected $pluginTitle = 'TimeKeeper';
    protected $pluginName = 'timekeeper';
    protected $table = 'tk_countries';
    protected $pid = 'id';
    protected $perPage = 10;
    protected $fields = array(
        'checkboxes' => array('title' => '', 'type' => null, 'data' => false, 'width' => '5%', 'thclass' => 'center', 'forced' => '1', 'class' => 'center', 'toggle' => 'e-multiselect',),
        'id' => array('title' => LAN_ID, 'data' => 'int', 'width' => '5%', 'readonly' => 1, 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'country' => array('title' => "Country", 'type' => 'text', 'data' => 'str', 'readonly' => 1, 'width' => '10%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'currency' => array('title' => "Currency", 'type' => 'text', 'data' => 'str', 'width' => '10%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'capital' => array('title' => "Capital", 'type' => 'text', 'data' => 'str', 'width' => '10%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'isoCode' => array('title' => "isoCode", 'type' => 'text', 'data' => 'str', 'width' => '5%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'difficulty' => array('title' => "Difficulty", 'type' => 'number', 'data' => 'int', 'inline' => true, 'width' => '5%', 'help' => '', 'readParms' => '', 'writeParms' => ['default' => 10, 'min' => 1, 'max' => 10], 'class' => 'left', 'thclass' => 'left',),
        'culture' => array('title' => "Culture", 'type' => 'textarea', 'data' => 'str', 'width' => '20%', 'help' => '', 'readParms' => '', 'writeParms' => '', 'class' => 'left', 'thclass' => 'left',),
        'continent' => array('title' => "Continent", 'type' => 'dropdown', 'data' => 'str', 'inline' => true, 'width' => '10%', 'help' => '', 'readParms' => '', 'writeParms' => ['optArray' => ['Africa'=>'Africa', 'Asia'=>'Asia', 'Europe'=>'Europe', 'North America'=>'North America', 'South America'=>'South America', 'Oceania'=>'Oceania']], 'class' => 'left', 'thclass' => 'left',),
        'map_coords' => array('title' => "Map Coords", 'type' => 'text', 'data' => 'str', 'width' => '10%', 'help' => '', 'readParms' => '', 'writeParms' => ['default' => '{}'], 'class' => 'left', 'thclass' => 'left',),
        'options' => array('title' => LAN_OPTIONS, 'type' => null, 'data' => '', 'width' => '10%', 'thclass' => 'center last', 'class' => 'center last', 'forced' => '1',),
    );
    protected $fieldpref = array('checkboxes', 'id', 'country', 'isoCode', 'difficulty', 'options');

}

class tk_geography_form_ui extends e_admin_form_ui {

}

new timekeeper_admin();

require_once(e_ADMIN . "auth.php");
e107::getAdminUI()->runPage();

require_once(e_ADMIN . "footer.php");
exit;