<?php

$Hostname = "localhost";
$DBName = "arenashooter";
$User = "root";
$DBPassword = "";

mysql_connect($Hostname, $User, $DBPassword) or die("can't connect into database");
mysql_select_db($DBName) or die("Can't connect into database");

$Email = $_REQUEST["Email"];
$Password = $_REQUEST["Password"];


if (!$Email || !$Password) {

    echo "Login or password cant be empty";

} else {
    $SQL = "SELECT * FROM accounts WHERE Email = '" . $Email . "'";
$result_id = @mysql_query($SQL) or die("DATABASE ERROR");
$total = mysql_num_rows($result_id);
if($total){

    $datas = @mysql_fetch_array($result_id);
    if(!strcmp($Password, $datas["Password"])){

        $sql2 = "SELECT Characters FROM accounts WHERE Email = '" . $Email . "'";
        $result_id2 = @mysql_query($sql2) or die("DATABASE ERROR!");
        while ($row = mysql_fetch_array($result_id2))
        {

            echo $row['Characters'];
            echo":";
            echo"Succes";
        }
    }else {

        echo "WrongPassword";

    }
}   else {
        echo "Emaildoesntexist";

    }

}

mysql_close();
?>