/tiquit-2.5.1.1/univ.php

<?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\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
  };
  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\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
  };
  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\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
  };
  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\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
};
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\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
};
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\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
};
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>";
?>