<?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>&nbsp;</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"); ?>
