$host = "localhost";
$user = "******";
$pass = "";
$dbname = "quiz";
$sesion = "200";
$singular1 = "Hay";
$singular2 = "Invitado Online.";
$plural1 = "Hay";
$plural2 = "Invitados Online.";
$remoteAdd = $_SERVER['REMOTE_ADDR'];
$phpSelf = $_SERVER['PHP_SELF'];
$tiempo = time();
$timeout = $tiempo - $sesion;
mysqli_connect($host, $user, $pass) or die('No se puede conectar al servidor.');
mysqli_db_query($dbname, "INSERT INTO useronline VALUES ('{$tiempo}','{$remoteAdd}','{$phpSelf}')") or die("ERROR DEL INSERT");
mysqli_db_query($dbname, "DELETE FROM useronline WHERE tiempo<{$timeout}") or die("ERROR AL BORRAR");
session_start();
$user = $_SESSION["user"];
$resultado = mysql_db_query($dbname, "SELECT DISTINCT ip FROM useronline WHERE file='{$phpSelf}'") or die("ERROR EN SELECT");
$resultado2 = mysql_db_query($dbname, "SELECT * FROM preguntas") or die("ERROR EN SELECT");
$resultado3 = mysql_db_query($dbname, "SELECT * FROM preguntas WHERE Email='{$user}'") or die("ERROR EN SELECT");
$usuario = mysql_num_rows($resultado);
$numpreguntastot = mysql_num_rows($resultado2);
$numpreguntasusr = mysql_num_rows($resultado3);
mysql_close();
if ($usuario == 1) {
echo "<font size=5>" . $singular1 . $usuario . $singular2 . "</font></br>";
echo "Preguntas en la base de datos: ";
echo "<font size=5>" . $numpreguntastot . "</font>";
echo "/";
echo "<font size=5>" . $numpreguntasusr . "</font>";
function reset_password($username, $email)
{
$new_password = rand_string(10);
$query = "UPDATE Users SET password={$new_password} WHERE username='******' AND email='{$email}'";
mysqli_db_query($con, $query);
}
