<?php
include ('header.php');
/**********************************************************************
*  Copyright notice Ja2BU 1.1.
*
*  (c) 2011 Predrag Rukavina - admin[at]phpform[dot]net
*  All rights reserved
*
*  This script is part of the Ja2BU project. 
*  The Ja2BU project 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.
*
*  This copyright notice MUST appear in all copies of the script!
************************************************************************/
$id = (int)$_GET['id'];
$ref = (int)$_GET['ref'];
?>
<div id="vforms">
<div id="cconfig">User Privileges and Roles</div>
<?php
if ($ref == 7) {
$sql = 'DELETE FROM users WHERE usid = '.$conn->qstr($id).'';
if($conn->Execute($sql) === false) {
	print '<br /><div id="error">error [3]: '.$conn->ErrorMsg().'</div><br />';
}
echo "<div id ='information'>&nbsp;Successfully! ";
}
if ($ref == 4) {
$sql2 = 'UPDATE users SET active="1" WHERE  usid = '.$conn->qstr($id).'';
if($conn->Execute($sql2) === false) {
	print '<br /><div id="error">error [3]: '.$conn->ErrorMsg().'</div><br />';
}
echo "<div id ='information'>&nbsp;Successfully! ";
}
if ($ref == 1) {
$sql3 = 'UPDATE users SET privilege="1" WHERE  usid = '.$conn->qstr($id).'';
if($conn->Execute($sql3) === false) {
	print '<br /><div id="error">error [3]: '.$conn->ErrorMsg().'</div><br />';
}
echo "<div id ='information'>&nbsp;Successfully! ";
}
if ($ref == 2) {
$sql4 = 'UPDATE users SET privilege="2" WHERE  usid = '.$conn->qstr($id).'';
if($conn->Execute($sql4) === false) {
	print '<br /><div id="error">error [3]: '.$conn->ErrorMsg().'</div><br />';
}
echo "<div id ='information'>&nbsp;Successfully! ";
}
?>
<a href="user.php">Back to User Privileges and Roles</a></div>
</div>
<?php
include ('footer.php');
$conn->Close();
/**************************************
* Revision: v.1.1.
***************************************/
?>