set_focus('tab', 'options', null);
if (!can_perform('canadmintools'))
{
admin_login();
}
// ###################################################################
if (empty($_REQUEST['do']))
{
$_REQUEST['do'] = 'modify';
}
// ###################################################################
if ($_REQUEST['do'] == 'kill')
{
$bugsys->input_clean('languageid', TYPE_UINT);
$count = $db->query_first("SELECT COUNT(*) AS count FROM " . TABLE_PREFIX . "language");
if ($count['count'] < 2)
{
$admin->error($lang->string('At least one language needs to be present. Deleting this language would violate that.'));
}
if ($bugsys->options['defaultlanguage'] == $bugsys->in['languageid'])
{
$admin->error($lang->string('You cannot delete the default language. Please select another language to be the default language and then delete this one.'));
}
$db->query("DELETE FROM " . TABLE_PREFIX . "language WHERE languageid = " . $bugsys->in['languageid']);
$db->query("DELETE FROM " . TABLE_PREFIX . "localization WHERE languageid = " . $bugsys->in['languageid']);
build_languages();
$admin->redirect('language.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'delete')
{
$admin->page_confirm($lang->string('Are you sure you want to delete this language?'), 'language.php?do=kill&languageid=' . $bugsys->input_clean('languageid', TYPE_UINT));
}
// ###################################################################
if ($_POST['do'] == 'insert')
{
$languageid = $db->query("
INSERT INTO " . TABLE_PREFIX . "language
(title, charset, direction, userselect, debug, filename)
VALUES
('" . $bugsys->in['title'] . "', '" . $bugsys->in['charset'] . "',
'" . $bugsys->in['direction'] . "', " . $bugsys->input_clean('userselect', TYPE_UINT) . ",
" . $bugsys->input_clean('debug', TYPE_UINT) . ", '" . $bugsys->in['filename'] . "'
)"
);
build_languages();
build_language_cache($db->insert_id());
$admin->redirect('language.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'add')
{
NavLinks::languagesAdd();
$navigator->set_focus('link', 'options-languages-add', 'options-languages');
$admin->page_start($lang->string('New Language'));
$admin->form_start('language.php', 'insert');
$admin->table_start();
$admin->table_head($lang->string('New Language'));
$admin->row_input($lang->string('Title'), 'title');
$admin->row_input($lang->string('Character Set'), 'charset', 'utf-8');
$admin->list_item($lang->string('Left-to-Right'), 'ltr', true);
$admin->list_item($lang->string('Right-to-Left'), 'rtl');
$admin->row_list($lang->string('Direction'), 'direction');
$admin->row_input($lang->string('Path to XML'), 'filename');
$admin->row_yesno($lang->string('User Selectable'), 'userselect', true);
$admin->row_yesno($lang->string('Debug Mode (run directly from XML)'), 'langdebug', false);
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_POST['do'] == 'update')
{
$db->query("
UPDATE " . TABLE_PREFIX . "language
SET title = '" . $bugsys->in['title'] . "',
charset = '" . $bugsys->in['charset'] . "',
direction = '" . $bugsys->in['direction'] . "',
userselect = " . $bugsys->input_clean('userselect', TYPE_UINT) . ",
debug = " . $bugsys->input_clean('langdebug', TYPE_UINT) . ",
filename = '" . $bugsys->in['filename'] . "'
WHERE languageid = " . $bugsys->input_clean('languageid', TYPE_UINT)
);
build_languages();
$admin->redirect('language.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'edit')
{
$bugsys->input_clean('languageid', TYPE_UINT);
NavLinks::languagesEdit($bugsys->in['languageid']);
$navigator->set_focus('link', 'options-languages-edit', 'options-languages');
$language = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "language WHERE languageid = " . $bugsys->in['languageid']);
if (!$language)
{
$admin->error($lang->getlex('error_invalid_id'));
}
$admin->page_start($lang->string('Edit Language'));
$admin->form_start('language.php', 'update');
$admin->table_start();
$admin->table_head(sprintf($lang->string('Edit Language - %1$s'), $language['title']));
$admin->form_hidden_field('languageid', $language['languageid']);
$admin->row_input($lang->string('Title'), 'title', $language['title']);
$admin->row_input($lang->string('Character Set'), 'charset', $language['charset']);
$admin->list_item($lang->string('Left-to-Right'), 'ltr', (($language['direction'] == 'ltr') ? true : false));
$admin->list_item($lang->string('Right-to-Left'), 'rtl', (($language['direction'] == 'rtl') ? true : false));
$admin->row_list($lang->string('Direction'), 'direction');
$admin->row_input($lang->string('Path to XML'), 'filename', $language['filename']);
$admin->row_yesno($lang->string('User Selectable'), 'userselect', $language['userselect']);
$admin->row_yesno($lang->string('Debug Mode (run directly from XML)'), 'langdebug', (bool)$language['debug']);
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_REQUEST['do'] == 'reload')
{
$language = $db->query_first("SELECT * FROM " . TABLE_PREFIX . "language WHERE languageid = " . $bugsys->input_clean('languageid', TYPE_UINT));
if (!$language)
{
$admin->error($lang->getlex('error_invalid_id'));
}
build_language_cache($language['languageid']);
$admin->redirect('language.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'modify')
{
NavLinks::languagesAdd();
$navigator->set_focus('link', 'options-pages-languages', 'options-pages');
$admin->page_start($lang->string('Manage Languages'));
$admin->table_start();
$admin->table_head($lang->string('Manage Languages'), 4, 'language_manage');
$admin->table_column_head(array($lang->string('Title'), $lang->string('Charset'), $lang->string('Options'), $lang->string('Actions')));
$languages = $db->query("SELECT * FROM " . TABLE_PREFIX . "language ORDER BY languageid ASC");
while ($language = $db->fetch_array($languages))
{
$admin->row_multi_item(array(
$language['title'] => 'l',
$language['charset'] => 'c',
(($bugsys->options['defaultlanguage'] == $language['languageid']) ? '' . $lang->string('DEFAULT LANGUAGE') . ' / ' : '') . ($language['userselect'] ? $lang->string('User Selectable') : $lang->string('Private')) => 'c',
"[" . $lang->string('Edit Settings') . "] [" . $lang->string('Reload XML') . "]" => 'c'
));
}
$admin->table_end();
$admin->page_end();
}
/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>