<?php
/*
*********************************************************************************************************
* daloRADIUS - RADIUS Web Platform
* Copyright (C) 2007 - Liran Tal <hide@address.com> All Rights Reserved.
*
* 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.
*
* 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., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*
*********************************************************************************************************
*
* Authors: Liran Tal <hide@address.com>
*
*********************************************************************************************************
*/
include ("library/checklogin.php");
$operator = $_SESSION['operator_user'];
include('library/check_operator_perm.php');
$logAction = "";
$logDebugSQL = "";
if (isset($_POST["submit"])) {
isset($_POST['vendor']) ? $vendor = $_POST['vendor'] : $vendor = "";
isset($_POST['attribute']) ? $attribute = $_POST['attribute'] : $attribute = "";
isset($_POST['type']) ? $type = $_POST['type'] : $type = "";
isset($_POST['RecommendedOP']) ? $RecommendedOP = $_POST['RecommendedOP'] : $RecommendedOP = "";
isset($_POST['RecommendedTable']) ? $RecommendedTable = $_POST['RecommendedTable'] : $RecommendedTable = "";
isset($_POST['RecommendedTooltip']) ? $RecommendedTooltip = $_POST['RecommendedTooltip'] : $RecommendedTooltip = "";
include 'library/opendb.php';
$sql = "SELECT * FROM ".$configValues['CONFIG_DB_TBL_DALODICTIONARY']." WHERE vendor='".$dbSocket->escapeSimple($vendor).
"' AND attribute='".$dbSocket->escapeSimple($attribute)."'";
$res = $dbSocket->query($sql);
$logDebugSQL .= $sql . "\n";
if ($res->numRows() == 0) {
if (trim($vendor) != "" and trim($attribute) != "") {
// insert vendor/attribute pairs to database
$sql = "INSERT INTO ".$configValues['CONFIG_DB_TBL_DALODICTIONARY'].
" (id, type, attribute, vendor, RecommendedOP, RecommendedTable, RecommendedTooltip) VALUES (0, '".
$dbSocket->escapeSimple($type)."', '".$dbSocket->escapeSimple($attribute)."','".
$dbSocket->escapeSimple($vendor)."','". $dbSocket->escapeSimple($RecommendedOP)."','".
$dbSocket->escapeSimple($RecommendedTable)."','".$dbSocket->escapeSimple($RecommendedTooltip)."')";
$res = $dbSocket->query($sql);
$logDebugSQL .= $sql . "\n";
$successMsg = "Added to database new vendor attribute: <b>$attribute</b> of vendor: <b>$vendor</b>";
$logAction .= "Successfully added new vendor [$vendor] and attribute [$attribute] on page: ";
} else {
$failureMsg = "You must provide atleast a vendor name and attribute";
$logAction .= "Failed adding new vendor [$vendor] and attribute [$attribute] on page: ";
}
} else {
$failureMsg = "You have tried to add a vendor's attribute that already exist in the database: $attribute";
$logAction .= "Failed adding new vendor attribute already in database [$attribute] on page: ";
}
include 'library/closedb.php';
}
include_once('library/config_read.php');
$log = "visited page: ";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en">
<head>
<title>daloRADIUS</title>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="css/1.css" type="text/css" media="screen,projection" />
</head>
<script src="library/javascript/pages_common.js" type="text/javascript"></script>
<?php
include ("menu-mng-rad-attributes.php");
?>
<div id="contentnorightbar">
<h2 id="Intro"><a href="#" onclick="javascript:toggleShowDiv('helpPage')"><?php echo $l['Intro']['mngradattributesnew.php'] ?>
<h144>+</h144></a></h2>
<div id="helpPage" style="display:none;visibility:visible" >
<?php echo $l['helpPage']['mngradattributesnew'] ?>
<br/>
</div>
<?php
include_once('include/management/actionMessages.php');
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<fieldset>
<h302> <?php echo $l['title']['VendorAttribute']; ?> </h302>
<br/>
<ul>
<li class='fieldset'>
<label for='vendor' class='form'><?php echo $l['all']['VendorName'] ?></label>
<input name='vendor' type='text' id='vendor' value='' tabindex=100 />
<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('vendorNameTooltip')" />
<div id='vendorNameTooltip' style='display:none;visibility:visible' class='ToolTip'>
<img src='images/icons/comment.png' alt='Tip' border='0' />
<?php echo $l['Tooltip']['vendorNameTooltip'] ?>
</div>
</li>
<li class='fieldset'>
<label for='attribute' class='form'><?php echo $l['all']['Attribute'] ?></label>
<input name='attribute' type='text' id='attribute' value='' tabindex=101 />
<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('attributeTooltip')" />
<div id='attributeTooltip' style='display:none;visibility:visible' class='ToolTip'>
<img src='images/icons/comment.png' alt='Tip' border='0' />
<?php echo $l['Tooltip']['attributeTooltip'] ?>
</div>
</li>
<li class='fieldset'>
<label for='type' class='form'><?php echo $l['all']['Type'] ?></label>
<select name='type' type='text' id='type' class='form' tabindex=102 />
<option value=''>Select Type...</option>
<?php
include_once('include/management/populate_selectbox.php');
drawTypes();
?>
</select>
<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('typeTooltip')" />
<div id='typeTooltip' style='display:none;visibility:visible' class='ToolTip'>
<img src='images/icons/comment.png' alt='Tip' border='0' />
<?php echo $l['Tooltip']['typeTooltip'] ?>
</div>
</li>
<li class='fieldset'>
<label for='RecommendedOP' class='form'><?php echo $l['all']['RecommendedOP'] ?></label>
<select name='RecommendedOP' id='RecommendedOP' class='form' tabindex=103 />
<option value=''>Select OP...</option>
<?php
include_once('include/management/populate_selectbox.php');
drawOptions();
?>
</select>
<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('RecommendedOPTooltip')" />
<div id='RecommendedOPTooltip' style='display:none;visibility:visible' class='ToolTip'>
<img src='images/icons/comment.png' alt='Tip' border='0' />
<?php echo $l['Tooltip']['RecommendedOPTooltip'] ?>
</div>
</li>
<li class='fieldset'>
<label for='RecommendedTable' class='form'><?php echo $l['all']['RecommendedTable'] ?></label>
<select name='RecommendedTable' id='RecommendedTable' class='form' tabindex=104 />
<option value=''>Select Table...</option>
<?php
include_once('include/management/populate_selectbox.php');
drawTables();
?>
</select>
<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('RecommendedTableTooltip')" />
<div id='RecommendedTableTooltip' style='display:none;visibility:visible' class='ToolTip'>
<img src='images/icons/comment.png' alt='Tip' border='0' />
<?php echo $l['Tooltip']['RecommendedTableTooltip'] ?>
</div>
</li>
<li class='fieldset'>
<label for='RecommendedTooltip' class='form'><?php echo $l['all']['RecommendedTooltip'] ?></label>
<textarea class='form' name='RecommendedTooltip' type='text' id='RecommendedTooltip' tabindex=105 /></textarea>
<img src='images/icons/comment.png' alt='Tip' border='0' onClick="javascript:toggleShowDiv('RecommendedTooltipTooltip')" />
<div id='RecommendedTooltipTooltip' style='display:none;visibility:visible' class='ToolTip'>
<img src='images/icons/comment.png' alt='Tip' border='0' />
<?php echo $l['Tooltip']['RecommendedTooltipTooltip'] ?>
</div>
</li>
<li class='fieldset'>
<br/>
<hr><br/>
<input type='submit' name='submit' value='<?php echo $l['buttons']['apply'] ?>' tabindex=10000 class='button' />
</li>
</ul>
</fieldset>
</form>
<?php
include('include/config/logging.php');
?>
</div>
<div id="footer">
<?php
include 'page-footer.php';
?>
</div>
</div>
</div>
</body>
</html>