<?php

function root_action($action)
{
	if($action == "list_user")
		list_user();
}

function list_user()
{
	session_start();

	$link = mysql_connect($_SESSION['BD_server'], $_SESSION['BD_user'], $_SESSION['BD_pass']);
	mysql_select_db($_SESSION['BD_name'], $link);

	$result1 = mysql_query("SELECT * FROM user", $link);

	$n_users = 0;

	echo "<FORM method='post' ACTION='form_action.php'>";
	echo "<FIELDSET>";
	echo "<label>Tipo:";
	echo "<SELECT NAME='type'>";
  	echo "<OPTION>0</OPTION>";
  	echo "<OPTION>1</OPTION>";
  	echo "<OPTION>2</OPTION>";
  	echo "<OPTION>3</OPTION>";
  	echo "<OPTION>4</OPTION>";
  	echo "<OPTION>5</OPTION>";
	echo "</SELECT></label>";
	echo "<input name='user_edit' type='submit' value='Modificar'>";

	echo "<table>";
	echo "<tr class='title'><th></th><th>Nombre</th><th>Tipo</th></tr>";	
	while ($row1 = mysql_fetch_row($result1))
	{
		echo "<tr><th><input name='$n_users' type='checkbox' value='$row1[0]'></th><th>$row1[1]</th><th>$row1[4]</th></tr>";
		$n_users++;
	}
	echo "</table>";

	echo "<input name='n_users' type='hidden' value='$n_users'>";
	echo "</FIELDSET>";
	echo "</FORM>";
}

function edit_user($id, $type)
{
	$link = mysql_connect($_SESSION['BD_server'], $_SESSION['BD_user'], $_SESSION['BD_pass']);
	mysql_select_db($_SESSION['BD_name'], $link);

	$result1 = mysql_query("UPDATE `$_SESSION[BD_name]`.`user` SET `type` = '$type' WHERE `user`.`id` = $id LIMIT 1 ;", $link);

	echo "<META HTTP-EQUIV='Refresh' CONTENT='0; URL=./?root=list_user'>";
}

function load_root_panel()
{
	echo "<img src='files/pics/users.png' alt='Listar usuarios'>";
	echo "<a href='?root=list_user'>Usuarios</a>";
}

?>
