2 /*=====================================================================*\
3 || ################################################################### ||
4 || # Renapsus [#]version[#]
5 || # --------------------------------------------------------------- # ||
6 || # All parts of this file are ©2003-[#]year[#] Iris Studios, Inc. No # ||
7 || # part of this file may be reproduced in any way: part or whole. # ||
8 || # --------------------------------------------------------------- # ||
9 || # ©2003 - [#]year[#] Iris Studios, Inc. | http://www.iris-studios.com # ||
10 || ################################################################### ||
11 \*=====================================================================*/
13 require_once('./global.php');
14 require_once('./includes/functions_datastore.php');
16 if (!can_perform('canadminfields'))
21 // ###################################################################
23 if (empty($_REQUEST['do']))
25 $_REQUEST['do'] = 'modify';
28 // ###################################################################
30 if ($_REQUEST['do'] == 'kill')
32 sanitize(array('resolutionid' => INT));
33 $DB_sql->query("DELETE FROM " . TABLE_PREFIX
. "resolution WHERE resolutionid = $vars[resolutionid]");
35 $admin->redirect('resolution.php?do=modify');
38 // ###################################################################
40 if ($_REQUEST['do'] == 'delete')
42 sanitize(array('resolutionid' => INT));
43 $admin->page_confirm('Are you sure you want to delete this resolution? Doing so will revert all bugs to the default resolution (which is set in the options panel)?', 'resolution.php?do=kill&resolutionid=' . $vars['resolutionid']);
46 // ###################################################################
48 if ($_POST['do'] == 'insert')
50 sanitize(array('resolution' => STR
, 'displayorder' => INT));
51 $DB_sql->query("INSERT INTO " . TABLE_PREFIX
. "resolution (resolution, displayorder) VALUES ('" . addslasheslike($vars['resolution']) . "', $vars[displayorder])");
53 $admin->redirect('resolution.php?do=modify');
56 // ###################################################################
58 if ($_REQUEST['do'] == 'add')
60 $admin->page_start('Add New Resolution');
62 $admin->form_start('resolution.php', 'insert');
63 $admin->table_start();
64 $admin->table_head('New Resolution');
65 $admin->row_input('Resolution Title<div><dfn>The title of this resolution flag (eg: `Fixed` or `Bogus`)</dfn></div>', 'resolution');
66 $admin->row_input('Display Order<div><dfn>The order in which the resolutions are displayed. The higher the number, the lower down in the list it is.</dfn></div>', 'displayorder');
74 // ###################################################################
76 if ($_POST['do'] == 'update')
78 sanitize(array('resolutionid' => INT, 'resolution' => STR
, 'displayorder' => INT));
79 $DB_sql->query("UPDATE " . TABLE_PREFIX
. "resolution SET resolution = '" . addslasheslike($vars['resolution']) . "', displayorder = $vars[displayorder] WHERE resolutionid = $vars[resolutionid]");
81 $admin->redirect('resolution.php?do=modify');
84 // ###################################################################
86 if ($_REQUEST['do'] == 'edit')
88 sanitize(array('resolutionid' => INT));
90 $resolution = $DB_sql->query_first("SELECT * FROM " . TABLE_PREFIX
. "resolution WHERE resolutionid = $vars[resolutionid]");
91 if (!is_array($resolution))
96 $admin->page_start('Edit Resolution');
98 $admin->form_start('resolution.php', 'update');
99 $admin->form_hidden_field('resolutionid', $resolution['resolutionid']);
100 $admin->table_start();
101 $admin->table_head("Edit Resolution - $resolution[resolution] (resolutionid: $resolution[resolutionid])");
102 $admin->row_input('Resolution Title<div><dfn>The title of this resolution flag (eg: `Fixed` or `Bogus`)</dfn></div>', 'resolution', $resolution['resolution']);
103 $admin->row_input('Display Order<div><dfn>The order in which the resolutions are displayed. The higher the number, the lower down in the list it is.</dfn></div>', 'displayorder', $resolution['displayorder']);
104 $admin->row_submit();
111 // ###################################################################
113 if ($_REQUEST['do'] == 'modify')
115 $admin->page_start('Resolution Manager');
117 $resolutions = $DB_sql->query("SELECT * FROM " . TABLE_PREFIX
. "resolution ORDER BY displayorder");
119 $admin->form_start('resolution.php', 'null');
120 $admin->table_start();
121 $admin->table_head('Resolution Manager');
123 while ($resolution = $DB_sql->fetch_array($resolutions))
125 $admin->row_text("$resolution[displayorder]: <a href=\"resolution.php?do=edit&resolutionid=$resolution[resolutionid]\">$resolution[resolution]</a>", "(resolutionid: $resolution[resolutionid]) <a href=\"resolution.php?do=edit&resolutionid=$resolution[resolutionid]\">[Edit]</a> <a href=\"resolution.php?do=delete&resolutionid=$resolution[resolutionid]\">[Delete]</a>");
127 $DB_sql->free_result($resolutiones);
129 $admin->row_span('<input type="button" name="addug" value=" Add New Resolution " onclick="window.location = \'resolution.php?do=add\';" />', 'tfoot', 'center', 3);
136 /*=====================================================================*\
137 || ###################################################################
140 || ###################################################################
141 \*=====================================================================*/