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(_('At least one language needs to be present. Deleting this language would violate that.')); } if ($bugsys->options['defaultlanguage'] == $bugsys->in['languageid']) { $admin->error(_('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(_('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(_('New Language')); $admin->form_start('language.php', 'insert'); $admin->table_start(); $admin->table_head(_('New Language')); $admin->row_input(_('Title'), 'title'); $admin->row_input(_('Character Set'), 'charset', 'utf-8'); $admin->list_item(_('Left-to-Right'), 'ltr', true); $admin->list_item(_('Right-to-Left'), 'rtl'); $admin->row_list(_('Direction'), 'direction'); $admin->row_input(_('Path to XML'), 'filename'); $admin->row_yesno(_('User Selectable'), 'userselect', true); $admin->row_yesno(_('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(_('Edit Language')); $admin->form_start('language.php', 'update'); $admin->table_start(); $admin->table_head(sprintf(_('Edit Language - %1$s'), $language['title'])); $admin->form_hidden_field('languageid', $language['languageid']); $admin->row_input(_('Title'), 'title', $language['title']); $admin->row_input(_('Character Set'), 'charset', $language['charset']); $admin->list_item(_('Left-to-Right'), 'ltr', (($language['direction'] == 'ltr') ? true : false)); $admin->list_item(_('Right-to-Left'), 'rtl', (($language['direction'] == 'rtl') ? true : false)); $admin->row_list(_('Direction'), 'direction'); $admin->row_input(_('Path to XML'), 'filename', $language['filename']); $admin->row_yesno(_('User Selectable'), 'userselect', $language['userselect']); $admin->row_yesno(_('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(_('Manage Languages')); $admin->table_start(); $admin->table_head(_('Manage Languages'), 4, 'language_manage'); $admin->table_column_head(array(_('Title'), _('Charset'), _('Options'), _('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']) ? '' . _('DEFAULT LANGUAGE') . ' / ' : '') . ($language['userselect'] ? _('User Selectable') : _('Private')) => 'c', "[" . _('Edit Settings') . "] [" . _('Reload XML') . "]" => 'c' )); } $admin->table_end(); $admin->page_end(); } /*=====================================================================*\ || ################################################################### || # $HeadURL$ || # $Id$ || ################################################################### \*=====================================================================*/ ?>