115 lines
3.1 KiB
PHP
Executable File
115 lines
3.1 KiB
PHP
Executable File
<?php
|
|
/*
|
|
----------------------------------------------------------------------
|
|
LICENSE
|
|
|
|
This program is free software; you can redistribute it and/or
|
|
modify it under the terms of the GNU General Public License (GPL)
|
|
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.
|
|
|
|
To read the license please visit http://www.gnu.org/copyleft/gpl.html
|
|
----------------------------------------------------------------------
|
|
*/
|
|
|
|
/**
|
|
* Manages MySQL users granted rights
|
|
*
|
|
* @copyright AlternC-Team 2000-2017 https://alternc.com/
|
|
*/
|
|
|
|
require_once("../class/config.php");
|
|
include_once("head.php");
|
|
|
|
$fields = array (
|
|
"id" => array ("request", "string", ""),
|
|
);
|
|
getFields($fields);
|
|
?>
|
|
<h3><?php printf(_("Manage MySQL rights for user '%s'"),$id) ?></h3>
|
|
<hr id="topbar"/>
|
|
<br />
|
|
<?php
|
|
$r=$mysql->get_user_dblist($id);
|
|
|
|
if ($msg->has_msgs("ERROR")) {
|
|
require_once('sql_users_list.php');
|
|
exit();
|
|
}
|
|
|
|
if ($r) {
|
|
|
|
?>
|
|
|
|
<form method="post" action="sql_users_dorights.php">
|
|
<?php csrf_get(); ?>
|
|
<input type="hidden" name="id" value="<?php ehe($id); ?>" />
|
|
<table cellspacing="0" cellpadding="4" class="tlist ombrage">
|
|
<tr class="petit">
|
|
<th colspan="2"><?php __("Database"); ?></th>
|
|
<th>SELECT</th>
|
|
<th>INSERT</th>
|
|
<th>UPDATE</th>
|
|
<th>DELETE</th>
|
|
<th>CREATE</th>
|
|
<th>DROP</th>
|
|
<th>REFERENCES</th>
|
|
<th>INDEX</th>
|
|
<th>ALTER</th>
|
|
<th>CREATE_TMP_TABLE</th>
|
|
<th>LOCK</th>
|
|
<th>CREATE VIEW</th>
|
|
<th>SHOW VIEW</th>
|
|
<th>CREATE ROUTINE</th>
|
|
<th>ALTER ROUTINE</th>
|
|
<th>EXECUTE</th>
|
|
<th>EVENT</th>
|
|
<th>TRIGGER</th>
|
|
</tr>
|
|
|
|
<?php
|
|
$sql_right=$mysql->available_sql_rights();
|
|
for($i=0;$i<count($r);$i++) {
|
|
$val=$r[$i];
|
|
?>
|
|
<tr class="lst">
|
|
<td><strong><?php echo $val["db"] ?></strong></td>
|
|
<td><a href="javascript:inverse_sql_right('<?php echo htmlentities($val["db"]);?>');"><?php __('Reverse selection');?></a></td>
|
|
<?php foreach($sql_right as $sr) { ?>
|
|
<td align="center">
|
|
<input type="checkbox" class="inc" id="<?php echo $val["db"]."_$sr"; ?>" name="<?php echo $val["db"]."_$sr"; ?>"<?php if($val[$sr]=="Y") echo " checked=\"checked\""; ?> />
|
|
</td>
|
|
<?php } ?>
|
|
</tr>
|
|
<?php
|
|
|
|
|
|
}
|
|
?>
|
|
</table>
|
|
<p>
|
|
<input type="submit" class="inb ok" value="<?php __("Apply"); ?>"/>
|
|
<input type="button" class="inb cancel" name="cancel" value="<?php __("Cancel"); ?>" onclick="document.location='sql_users_list.php'"/>
|
|
</p>
|
|
</form>
|
|
<p> </p>
|
|
<script type="text/javascript">
|
|
function inverse_sql_right(db) {
|
|
<?php foreach($sql_right as $sr) { ?>
|
|
if ( document.getElementById(db+'_<?php echo $sr;?>').checked ) {
|
|
document.getElementById(db+'_<?php echo $sr;?>').checked=false;
|
|
} else {
|
|
document.getElementById(db+'_<?php echo $sr;?>').checked=true;
|
|
}
|
|
<?php } ?>
|
|
}
|
|
|
|
</script>
|
|
<?php } ?>
|
|
<?php include_once("foot.php"); ?>
|