// | that is bundled with this package in the file LICENSE, and is |
// | available through the world-wide-web at the following url: |
// | http://www.gnu.org/copyleft/gpl.html. |
// +----------------------------------------------------------------------+
// | Authors: Alexander Mieland <dma147 at mieland-programming dot de> |
// +----------------------------------------------------------------------+
// $Header $
// +----------------------------------------------------------------------+
$CONTENTTITEL .= ' » ' . $_LANGUAGE['database_options'];
$CONTENTINHALT .= '';
$TITLE_LOCATION = $_LANGUAGE['admincenter'] . ' - ' . $_LANGUAGE['database_options'];
require_once $_SESSION['APCMS']['CLASS_DIR'] . "/apcms_admintable.class." . $_SESSION['APCMS']['SUFFIX'];
$ADMINTABLE1 = new APCMS_ADMINTABLE($_SESSION['APCMS']['TABLE']['BGCOLOR'], $_SESSION['APCMS']['HELPSYSTEM']['BGCOLOR'], $_SESSION['APCMS']['HELPSYSTEM']['FGCOLOR']);
$ADMINTABLE1->AddRow('<strong> .: ' . $_LANGUAGE['database_options'] . ' :.</strong><br /><br />' . $_LANGUAGE['database_options_desc'], '', 2);
$CONTENTINHALT .= $ADMINTABLE1->GetTable() . "<br />";
$ADMINTABLE2 = new APCMS_ADMINTABLE($_SESSION['APCMS']['TABLE']['BGCOLOR'], $_SESSION['APCMS']['HELPSYSTEM']['BGCOLOR'], $_SESSION['APCMS']['HELPSYSTEM']['FGCOLOR']);
$ADMINTABLE2->OpenForm('dboptform', $_SERVER['PHP_SELF'] . "?s=handler" . $_SESSION['SID2']);
$ADMINTABLE2->AddRow('<strong>' . $_LANGUAGE['do_querys_in_db'] . '</strong><br />
<span style="color:red">' . $_LANGUAGE['do_querys_in_db_desc'] . '</span>', '', 2);
$ADMINTABLE2->AddRow('<textarea rows="16" style="width:560px" name="NEW[sqlquery]">' . (isset($_SESSION['POSTDATA']) && trim($_SESSION['POSTDATA']['QUERYSTRING']) != "" ? $_SESSION['POSTDATA']['QUERYSTRING'] : "EXPLAIN SELECT * FROM {\$USERTABLE} WHERE `userid`='1';") . '</textarea>', '', 2);
$ADMINTABLE2->AddRow('<strong>' . $_LANGUAGE['following_vars_available'] . '</strong><br />
' . $_LANGUAGE['following_vars_available_desc'] . '<br />', '', 2);
$ADMINTABLE2->AddRow(' <input type="hidden" name="s" value="handler">
<input type="hidden" name="action" value="makesqlquery">
<input type="hidden" name="FROM[s]" value="admin">
<input type="hidden" name="FROM[ainclude]" value="dbopts">
<input type="hidden" name="' . session_name() . '" value="' . session_id() . '">', '', 2);
$ADMINTABLE2->AddRow('<input type="submit" name="submit" value="' . $_LANGUAGE['DO_SQL'] . '"> <input type="reset" name="reset" value="' . $_LANGUAGE['empty_query_field'] . '">', '', 2);
$ADMINTABLE2->CloseForm();
$CONTENTINHALT .= $ADMINTABLE2->GetTable();
unset($_SESSION['POSTDATA']);
$SELECTLANG = '<select name="NEW[language]" style="width:220px">';
$query = "SELECT `name`, `browsercode` FROM `apcms_" . $_SESSION['MYSQLDATA']['SUFFIX'] . "_languagepacks` ";
$dblanguages = $db->unbuffered_getAll_row($query);
for ($a = 0; $a < count($dblanguages); $a++) {
if (isset($_SESSION['POSTDATA']['language']) && $dblanguages[$a][1] == $_SESSION['POSTDATA']['language']) {
$SELECTLANG .= '<option value="' . $dblanguages[$a][1] . '" selected>' . $dblanguages[$a][0] . '</option>';
} elseif (!isset($_SESSION['POSTDATA']['language']) && $dblanguages[$a][1] == $_SESSION['APCMS']['CONFIG']['language']) {
$SELECTLANG .= '<option value="' . $dblanguages[$a][1] . '" selected>' . $dblanguages[$a][0] . '</option>';
} else {
$SELECTLANG .= '<option value="' . $dblanguages[$a][1] . '">' . $dblanguages[$a][0] . '</option>';
}
}
$SELECTLANG .= '</select>';
$ADMINTABLE1 = new APCMS_ADMINTABLE($_SESSION['APCMS']['TABLE']['BGCOLOR'], $_SESSION['APCMS']['HELPSYSTEM']['BGCOLOR'], $_SESSION['APCMS']['HELPSYSTEM']['FGCOLOR']);
$ADMINTABLE1->AddRow('<strong>Allgemeine Einstellungen</strong>', '', 2);
$ADMINTABLE1->OpenForm('optform', $_SERVER['PHP_SELF'] . "?s=handler" . $_SESSION['SID2']);
$ADMINTABLE1->AddRow('<strong>Titel der Seite</strong><br>Tragen Sie hier den Titel der Seite ein (max. 250 Zeichen)', '<input style="width:220px" type="text" name="NEW[title]" value="' . (isset($_SESSION['POSTDATA']['title']) && trim($_SESSION['POSTDATA']['title']) != "" ? _APCMS_trim($_SESSION['POSTDATA']['title']) : _APCMS_trim($_SESSION['APCMS']['CONFIG']['title'])) . '">');
$ADMINTABLE1->AddRow('<strong>Beschreibung der Seite</strong><br>Tragen Sie hier eine kurze Beschreibung der Seite ein (max. 250 Zeichen)', '<input style="width:220px" type="text" name="NEW[description]" value="' . (isset($_SESSION['POSTDATA']['description']) && trim($_SESSION['POSTDATA']['description']) != "" ? _APCMS_trim($_SESSION['POSTDATA']['description']) : _APCMS_trim($_SESSION['APCMS']['CONFIG']['description'])) . '">');
$ADMINTABLE1->AddRow('<strong>Zeitzone</strong><br>Wählen Sie hier die Zeitzone, in der der Server steht. Steht der Server bei einem Provider in Amerika, wählen Sie hier den Ort in Amerika, wo der Server steht.', $SELECTTIMEZONE);
$ADMINTABLE1->AddRow('<strong>Default-Style</strong><br>Wählen Sie hier das Default-Style (Design), das man zu sehen bekommt, wenn man nicht eingeloggt ist, oder sich als User noch kein Style selber ausgewählt hat.', $SELECTSTYLE);
$ADMINTABLE1->AddRow('<strong>Online-Timeout</strong><br>Stellen Sie hier ein, wie lange User als online gelten sollen, wenn sie keine Aktionen mehr ausführen. (in Minuten)', '<input style="width:220px" type="text" name="NEW[online_timeout]" value="' . (isset($_SESSION['POSTDATA']['online_timeout']) && $_SESSION['POSTDATA']['online_timeout'] >= 1 ? $_SESSION['POSTDATA']['online_timeout'] : round($_SESSION['APCMS']['CONFIG']['online_timeout'] / 60, 0)) . '">');
$ADMINTABLE1->AddRow('<strong>Anzahl der News im Portal</strong><br>Tragen Sie hier die ANzahl der News ein, die per default im Portal angezeigt werden sollen. Hat nur Effekt bei Usern, die sich das noch nicht selber im Profil eingestellt haben.', '<input style="width:220px" type="text" name="NEW[news_num]" value="' . (isset($_SESSION['POSTDATA']['news_num']) && $_SESSION['POSTDATA']['news_num'] >= 1 ? $_SESSION['POSTDATA']['news_num'] : $_SESSION['APCMS']['CONFIG']['news_num']) . '">');
$ADMINTABLE1->AddRow(' <input type="hidden" name="s" value="handler">
<input type="hidden" name="action" value="save_globalpref">
<input type="hidden" name="FROM[s]" value="admin">
<input type="hidden" name="FROM[ainclude]" value="globalpref">
<input type="hidden" name="' . session_name() . '" value="' . session_id() . '">', '', 2);
$ADMINTABLE1->AddRow('<input type="submit" name="saveopts" value="Einstellungen speichern..."> <input type="reset" name="reset" value="Formular Zurücksetzen"> <input type="button" name="zurueck" value="Zurück..." OnClick="JavaScript:history.back();">', '', 2);
$ADMINTABLE1->CloseForm();
$CONTENTINHALT .= $ADMINTABLE1->GetTable();
unset($_SESSION['POSTDATA']);
