<?php
	session_start();
	$_SESSION['message'] = "";
    $mysqli = new mysqli("localhost", "root", "", "accounts") or die ("Cannot connect");
    function generateRandomString($length = 10) {
    return substr(str_shuffle(str_repeat($x='0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ', ceil($length/strlen($x)) )),1,$length);
    }
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {

      $emailusername = $mysqli->real_escape_string($_POST['emailusername']);

      if (isset($emailusername)) {
        $sql = "SELECT `id`, `email` FROM `users` WHERE `email` = '$emailusername' OR `username` = '$emailusername'";

        $query = mysqli_query($mysqli, $sql);
        $count = mysqli_num_rows($query);

        if ($count == 1) {
          while($row = mysqli_fetch_array($query)){
            $passreset_code = generateRandomString(32);
            $sql2 = "UPDATE `users` SET `passreset_code`=".$passreset_code." WHERE `id`=".$row['id'];
            $query2 = mysqli_query($mysqli,$sql2);

            if ($query2 != false) {
              $email = $row['email'];
              $subject = 'Salasanan palautus';
              $message = 'Vaihda salasanasi siirtymällä osoitteeseen: http://localhost/activeresetpass.php?resetpass='.$passreset_code;
              $headers = 'From:noreply@hdfinland.com' . "\r\n";
              mail($email, $subject, $message, $headers);
            }else{
              $_SESSION['message'] = "Nollauskoodia ei voitu lisätä."
            }
          }
        }

      }else{
      	$_SESSION['message'] = "Käyttäjää ei löytynyt annetuilla tiedoilla.";
      }
    }
?>