INT));
$DB_sql->query("DELETE FROM " . TABLE_PREFIX . "status WHERE statusid = $vars[statusid]");
build_statuses();
$admin->redirect('status.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'delete')
{
sanitize(array('statusid' => INT));
$admin->page_confirm(phrase('confirm_delete_status'), 'status.php?do=kill&statusid=' . $vars['statusid']);
}
// ###################################################################
if ($_POST['do'] == 'insert')
{
sanitize(array('status' => STR, 'displayorder' => INT));
$DB_sql->query("INSERT INTO " . TABLE_PREFIX . "status (status, displayorder) VALUES ('" . addslasheslike($vars['status']) . "', $vars[displayorder])");
build_statuses();
$admin->redirect('status.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'add')
{
$admin->page_start(phrase('add_new_status'));
$admin->form_start('status.php', 'insert');
$admin->table_start();
$admin->table_head(phrase('new_status'));
$admin->row_input(phrase('status_title'), 'status');
$admin->row_input(phrase('status_display_order'), 'displayorder');
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_POST['do'] == 'update')
{
sanitize(array('statusid' => INT, 'status' => STR, 'displayorder' => INT));
$DB_sql->query("UPDATE " . TABLE_PREFIX . "status SET status = '" . addslasheslike($vars['status']) . "', displayorder = $vars[displayorder] WHERE statusid = $vars[statusid]");
build_statuses();
$admin->redirect('status.php?do=modify');
}
// ###################################################################
if ($_REQUEST['do'] == 'edit')
{
sanitize(array('statusid' => INT));
$status = $DB_sql->query_first("SELECT * FROM " . TABLE_PREFIX . "status WHERE statusid = $vars[statusid]");
if (!is_array($status))
{
$admin->error('-1');
}
$admin->page_start(phrase('edit_status'));
$admin->form_start('status.php', 'update');
$admin->form_hidden_field('statusid', $status['statusid']);
$admin->table_start();
$admin->table_head(phrase('edit_status_title', $status['status'], $status['statusid']));
$admin->row_input(phrase('status_title'), 'status', $status['status']);
$admin->row_input(phrase('status_display_order'), 'displayorder', $status['displayorder']);
$admin->row_submit();
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
// ###################################################################
if ($_REQUEST['do'] == 'modify')
{
$admin->page_start('Status Manager');
$statuses = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX . "status");
$admin->form_start('status.php', 'null');
$admin->table_start();
$admin->table_head('Status Manager');
while ($status = $DB_sql->fetch_array($statuses))
{
$admin->row_text("$status[displayorder]: $status[status]", "(statusid: $status[statusid]) " . phrase('edit_wraplink') . " " . phrase('delete_wraplink') . "");
}
$DB_sql->free_result($statuses);
$admin->row_span('', 'tfoot', 'center', 3);
$admin->table_end();
$admin->form_end();
$admin->page_end();
}
/*=====================================================================*\
|| ###################################################################
|| # $HeadURL$
|| # $Id$
|| ###################################################################
\*=====================================================================*/
?>