/tiquit-2.5.1.1/univ.php
PHP | 399 lines | 335 code | 35 blank | 29 comment | 31 complexity | 9efb8088fea15ef528694cda05b7c250 MD5 | raw file
Possible License(s): GPL-2.0
- <?php
- /*
- Tiquit Is Quality User Incident Tracking
- Copyright (C) 2006 Jonathan Ciesla
-
- This program is free software; you can redistribute it and/or
- modify it under the terms of the GNU General Public License
- as published by the Free Software Foundation; either version 2
- of the License, or (at your option) any later version.
-
- This program is distributed in the hope that it will be useful,
- but WITHOUT ANY WARRANTY; without even the implied warranty of
- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- GNU General Public License for more details.
-
- You should have received a copy of the GNU General Public License
- along with this program; if not, write to the Free Software
- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA
- */
- require_once("config.php");
- require_once("functionlib.php");
- session_start();
- favicon();
- $link = dbms_connect($dbhost, $dbuser, $dbpass, $dbname);
- $user_id = dbms_escape_string($_SESSION['tiquitid']);
- $query3 = "SELECT admin FROM agent where id = '$user_id';";
- $result3 = dbms_query($query3);
- $line3 = dbms_fetch_array($result3, "NUM");
- $flag_me = $line3[0];
- dbms_free_result($result3);
- authentication($flag_me, 2);
-
- echo "<link rel=stylesheet href=css.php>";
- echo "<title>$sitetitle</title>";
- echo "<h1>$sitetitle</h1>";
- if($_POST['updatedeltheme']=="yes"){
- $deltheme = dbms_escape_string($_POST['themenumber']);
- $query = "DELETE FROM theme WHERE number = '$deltheme';";
- $result = dbms_query($query, $link);
- };
- if($_POST['updateaddtheme']=="yes"){
- $query = "SELECT number FROM theme ORDER BY number DESC LIMIT 1;";
- $result = dbms_query($query);
- $line = dbms_fetch_array($result, "NUM");
- $value = $line[0];
- $value++;
- dbms_free_result($result);
- $themename = dbms_escape_string($_POST['themename']);
- $back = dbms_escape_string($_POST['themeback']);
- $tabback = dbms_escape_string($_POST['themetabback']);
- $tabbord = dbms_escape_string($_POST['themetabbord']);
- $query = "INSERT INTO theme (number, name, background, table_background, table_border) VALUES ('$value', '$themename', '$back', '$tabback', '$tabbord');";
- $result = dbms_query($query, $link);
- };
- if($_POST['updateacttheme']=="yes"){
- $newtheme = dbms_escape_string($_POST['acttheme']);
- $query = "UPDATE universal SET theme='$newtheme';";
- $result = dbms_query($query, $link);
- };
- if($_POST['updateedittheme']=="yes"){
- $edittheme = dbms_escape_string($_POST['themenumber']);
- $themename = dbms_escape_string($_POST['themename']);
- $back = dbms_escape_string($_POST['themeback']);
- $tabback = dbms_escape_string($_POST['themetabback']);
- $tabbord = dbms_escape_string($_POST['themetabbord']);
- $query = "UPDATE theme SET name='$themename',background='$back',table_background='$tabback',table_border='$tabbord' WHERE number = '$edittheme';";
- $result = dbms_query($query, $link);
- };
- if($_POST['updateacttheme']=="yes"){
- $newtheme = dbms_escape_string($_POST['acttheme']);
- $query = "UPDATE universal SET theme='$newtheme';";
- $result = dbms_query($query, $link);
- };
- $optimize = $_POST['optimize'];
- if($optimize=="yes"){
- if($dbtype=="my"){
- $query = "SHOW TABLES";
- $result = dbms_query($query);
- while($tables = dbms_fetch_array($result, "NUM")){
- $tab = $tables[0];
- $query = "OPTIMIZE TABLE `$tab`;";
- $result2 = dbms_query($query);
- };
- dbms_free_result($result);
- };
- if($dbtype=="pg"){
- $query = "VACUUM FULL;";
- $result = dbms_query($query);
- };
- };
- $update = $_POST['update'];
- if($update=="yes"){
- $notify=dbms_escape_string($_POST['notify']);
- $address=dbms_escape_string($_POST['address']);
- $name=dbms_escape_string($_POST['name']);
- $textsize = $_POST['textsize'];
- $tabletextsize = $_POST['tabletextsize'];
- $attach=dbms_escape_string($_POST['attach']);
- $diary=dbms_escape_string($_POST['diary']);
- $user_sub=dbms_escape_string($_POST['usersub']);
- $user_search=dbms_escape_string($_POST['usersearch']);
- $user_reg=dbms_escape_string($_POST['userreg']);
- $res_text=dbms_escape_string($_POST['restext']);
- $use_res_text=dbms_escape_string($_POST['userestext']);
- $query = "UPDATE universal SET notify='$notify',address='$address',name='$name',textsize='$textsize',tabletextsize='$tabletextsize',assign_attach='$attach',assign_diary='$diary',user_sub='$user_sub',user_search='$user_search',user_reg='$user_reg',res_text='$res_text',use_res_text='$use_res_text';";
- $result = dbms_query($query, $link);
- echo "Configuration updated.";
- };
- echo "<h2>Global Configuration</h2>";
- echo "<table border=1 align=center>";
- $query = "SELECT notify,address,name,textsize,tabletextsize,theme,assign_attach,assign_diary,user_sub,user_search,user_reg,res_text,use_res_text FROM universal";
- $result = dbms_query($query);
- while($line = dbms_fetch_array($result, "ASSOC")){
- $active_theme = $line['theme'];
- echo "<tr>";
- echo "<form action=univ.php method=post>";
- echo "<th>Notification</th>";
- echo "<td align=center>";
- if($line['notify']=="0"){$flagzero="checked";}else{$flagzero="";};
- if($line['notify']=="1"){$flagone="checked";}else{$flagone="";};
- echo "On<input type=radio name=notify value=1 $flagone />";
- echo "Off<input type=radio name=notify value=0 $flagzero />";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Organization name</th>";
- echo "<td align=center>";
- echo "<input type=text size=30 name=name value=\"{$line['name']}\">";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Address</th>";
- echo "<td align=center>";
- echo "<input type=text size=30 name=address value=\"{$line['address']}\">";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Text Size</th>";
- $sizearray = array("xx-small", "x-small", "small", "medium", "large", "x-large", "xx-large");
- echo "<td align=center>";
- echo "<select name=textsize>";
- foreach($sizearray as $size){
- if($size==$line['textsize']){$flag="selected";}else{$flag="";};
- echo "<option value=\"$size\" $flag>$size";
- };
- echo "</select>";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Table Text</th>";
- echo "<td align=center>";
- echo "<select name=tabletextsize>";
- foreach($sizearray as $size){
- if($size==$line['tabletextsize']){$flag="selected";}else{$flag="";};
- echo "<option value=\"$size\" $flag>$size";
- };
- echo "</select>";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Include file attachments in assignment emails</th>";
- echo "<td align=center>";
- if($line['assign_attach']=="0"){$flagzero="checked";}else{$flagzero="";};
- if($line['assign_attach']=="1"){$flagone="checked";}else{$flagone="";};
- echo "On<input type=radio name=attach value=1 $flagone />";
- echo "Off<input type=radio name=attach value=0 $flagzero />";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Include diary entries in assignment emails</th>";
- echo "<td align=center>";
- if($line['assign_diary']=="0"){$flagzero="checked";}else{$flagzero="";};
- if($line['assign_diary']=="1"){$flagone="checked";}else{$flagone="";};
- echo "On<input type=radio name=diary value=1 $flagone />";
- echo "Off<input type=radio name=diary value=0 $flagzero />";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Allow incident submission by users</th>";
- echo "<td align=center>";
- if($line['user_sub']=="0"){$flagzero="checked";}else{$flagzero="";};
- if($line['user_sub']=="1"){$flagone="checked";}else{$flagone="";};
- echo "On<input type=radio name=usersub value=1 $flagone />";
- echo "Off<input type=radio name=usersub value=0 $flagzero />";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Allow incident search by users</th>";
- echo "<td align=center>";
- if($line['user_search']=="0"){$flagzero="checked";}else{$flagzero="";};
- if($line['user_search']=="1"){$flagone="checked";}else{$flagone="";};
- echo "On<input type=radio name=usersearch value=1 $flagone />";
- echo "Off<input type=radio name=usersearch value=0 $flagzero />";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Allow registration requests by users</th>";
- echo "<td align=center>";
- if($line['user_reg']=="0"){$flagzero="checked";}else{$flagzero="";};
- if($line['user_reg']=="1"){$flagone="checked";}else{$flagone="";};
- echo "On<input type=radio name=userreg value=1 $flagone />";
- echo "Off<input type=radio name=userreg value=0 $flagzero />";
- echo "</td>";
- echo "</tr><tr>";
- echo "<th>Use custom resolution text</th>";
- echo "<td align=center>";
- if($line['use_res_text']=="0"){$flagzero="checked";}else{$flagzero="";};
- if($line['use_res_text']=="1"){$flagone="checked";}else{$flagone="";};
- echo "On<input type=radio name=userestext value=1 $flagone />";
- echo "Off<input type=radio name=userestext value=0 $flagzero />";
- echo "</td></tr>";
- echo "<tr><th colspan=2>Custom Resolution Text</th></tr>";
- echo "<tr><th colspan=2>Symbols: &incident& = incident number </th></tr>";
- echo "<tr>";
- echo "<td align=center colspan=2>";
- echo "<textarea rows=20 cols=80 name=restext>{$line['res_text']}</textarea></td>";
- echo "</tr><tr>";
- echo "<td colspan=2 align=center>";
- echo "<input type=hidden name=update value=yes>";
- echo "<input type=submit value=Change>";
- echo "</td>";
- echo "</form>";
- echo "</tr>";
- };
- echo "</table>";
- dbms_free_result($result);
- //theme table
- echo "<table border=1 align=center>";
- echo "<CAPTION>Theme Management</CAPTION>";
- $query = "SELECT number,name,background,table_background,table_border FROM theme ORDER BY number ASC;";
- $result = dbms_query($query);
- //select active theme
- echo "<tr>";
- echo "<td>Active Theme:</td>";
- echo "<td align=center colspan=2>";
- echo "<form action=univ.php method=post>";
- echo "<select name=acttheme>";
- while($theme = dbms_fetch_array($result, "ASSOC")){
- if($theme['number']==$active_theme){$flag="selected";}else{$flag="";};
- echo "<option value=\"{$theme['number']}\" $flag style=\"background-color: #{$theme['table_background']}\">{$theme['name']}";
- };
- echo "</select>";
- echo "</td><td colspan=6 align=center>";
- echo "<input type=hidden name=updateacttheme value=yes>";
- echo "<input type=submit value=\"Submit\">";
- echo "</form>";
- echo "</td>";
- echo "</tr>";
- //edit themes
- dbms_result_seek($result, 0);
- while($theme = dbms_fetch_array($result, "ASSOC")){
- echo "<tr>";
- echo "<form action=univ.php method=post>";
- echo "<input type=hidden name=themenumber value=\"{$theme['number']}\">";
- echo "<td>";
- echo "<input type=text name=themename value=\"{$theme['name']}\">";
- echo "</td>";
- //background
- echo "<td>";
- echo "Background:";
- echo "</td>";
- echo "<td>";
- echo "<select name=themeback style=\"background-color: #{$theme['background']}\">";
- foreach($html_colors as $color){
- if($color==$theme['background']){$flag="selected";}else{$flag="";};
- echo "<option value=\"$color\" $flag style=\"background-color: #$color\" title=\"$color\"> ";
- };
- echo "</select>";
- echo "</td>";
- //table background
- echo "<td>";
- echo "Table Background:";
- echo "</td>";
- echo "<td>";
- echo "<select name=themetabback style=\"background-color: #{$theme['table_background']}\">";
- foreach($html_colors as $color){
- if($color==$theme['table_background']){$flag="selected";}else{$flag="";};
- echo "<option value=\"$color\" $flag style=\"background-color: #$color\" title=\"$color\"> ";
- };
- echo "</select>";
- echo "</td>";
- //table border
- echo "<td>";
- echo "Table Border:";
- echo "</td>";
- echo "<td>";
- echo "<select name=themetabbord style=\"background-color: #{$theme['table_border']}\">";
- foreach($html_colors as $color){
- if($color==$theme['table_border']){$flag="selected";}else{$flag="";};
- echo "<option value=\"$color\" $flag style=\"background-color: #$color\" title=\"$color\"> ";
- };
- echo "</select>";
- echo "</td>";
- echo "<td>";
- echo "<input type=hidden name=updateedittheme value=yes>";
- echo "<input type=submit value=\"Submit\">";
- echo "</form>";
- echo "</td>";
- //remove theme
- echo "<form action=univ.php method=post>";
- echo "<td valign=center>";
- echo "<input type=hidden name=themenumber value=\"{$theme['number']}\">";
- echo "<input type=hidden name=updatedeltheme value=yes>";
- echo "<input type=submit value=\"Delete\">";
- echo "</td>";
- echo "</form>";
- echo "</tr>";
- };
- dbms_free_result($result);
- //form for new theme
- echo "<tr>";
- echo "<form action=univ.php method=post>";
- echo "<td>";
- echo "<input type=text name=themename>";
- echo "</td>";
- //background
- echo "<td>";
- echo "Background:";
- echo "</td>";
- echo "<td>";
- echo "<select name=themeback>";
- foreach($html_colors as $color){
- echo "<option value=\"$color\" style=\"background-color: #$color\" title=\"$color\"> ";
- };
- echo "</select>";
- echo "</td>";
- //table background
- echo "<td>";
- echo "Table Background:";
- echo "</td>";
- echo "<td>";
- echo "<select name=themetabback>";
- foreach($html_colors as $color){
- echo "<option value=\"$color\" style=\"background-color: #$color\" title=\"$color\"> ";
- };
- echo "</select>";
- echo "</td>";
- //table border
- echo "<td>";
- echo "Table Border:";
- echo "</td>";
- echo "<td>";
- echo "<select name=themetabbord>";
- foreach($html_colors as $color){
- echo "<option value=\"$color\" style=\"background-color: #$color\" title=\"$color\"> ";
- };
- echo "</select>";
- echo "</td>";
- echo "<td>";
- echo "<input type=hidden name=updateaddtheme value=yes>";
- echo "<input type=submit value=\"Add\">";
- echo "</form>";
- echo "</td>";
- echo "</tr>";
- echo "</table>";
- echo "<br />";
- echo "<form action=univ.php method=post>";
- echo "<input type=hidden name=optimize value=yes>";
- if($dbtype=="my"){
- echo "<input type=submit value=\"Optimize Database\">";
- };
- if($dbtype=="pg"){
- echo "<input type=submit value=\"Vacuum(FULL) Database\">";
- };
- echo "</form>";
- echo "<br />";
- echo "<form action=upgrade.php method=post>";
- echo "<input type=submit value=\"Check/Upgrade DB\" />";
- echo "</form>";
- echo "<br />";
- echo "<form action=main.php method=post>";
- echo "<input type=submit value=Back />";
- echo "</form>";
- ?>