if ($invalidArg === false) {
$error = arg('error');
if ($error === false) {
$invalidArg = 'error';
}
}
if ($invalidArg === false) {
reportError($playerId, $error);
}
break;
case 'info':
phpinfo();
break;
case 'testEmail':
require_once "emails.php";
testEmail();
break;
default:
$invalidArg = 'cmd';
break;
}
if ($invalidArg !== false) {
$ret = array("status" => "INVALID_ARG", "arg" => $invalidArg);
print json_encode($ret);
}
function getPlayerStats($playerId)
{
$playerStats = array();
$sql2 = "SELECT gameAssassinations.playerId, gameAssassinations.name, MAX(killsPerGame) as killingSpree FROM\r\n(SELECT players.playerId, players.name, gamesInquery.gameId, COUNT(gamesInquery.gameId) as killsPerGame\r\nFROM players LEFT JOIN (SELECT * FROM assassinations WHERE assassinations.state = 'SUCCESS') as assassinInquery on assassinInquery.assassinId = players.playerId \r\nLEFT JOIN (SELECT * FROM games WHERE games.state = 'FINISHED') as gamesInquery ON assassinInquery.gameId = gamesInquery.gameId \r\nGROUP BY players.playerId, players.name, gamesInquery.gameId) as gameAssassinations WHERE gameAssassinations.playerId = '{$playerId}' \r\nGROUP BY gameAssassinations.playerId, gameAssassinations.name";
$sql = "SELECT players.playerId, players.name, ";
$sql .= "(SELECT COUNT(*) FROM assassinations INNER JOIN games ON assassinations.gameId = games.gameId WHERE assassinations.assassinId = players.playerId AND assassinations.state = 'SUCCESS' AND games.state = 'FINISHED') AS assassinationsCompleted, ";
$pass &= testEmail("\"Abc@def\"@example.com");
$pass &= testEmail("\"Fred Bloggs\"@example.com");
$pass &= testEmail("customer/department=shipping@example.com");
$pass &= testEmail("\$A12345@example.com");
$pass &= testEmail("!def!xyz%abc@example.com");
$pass &= testEmail("*****@*****.**");
$pass &= testEmail("*****@*****.**");
$pass &= testEmail("*****@*****.**");
$pass &= testEmail("Doug\\ \\\"Ace\\\"\\ Lovell@example.com");
$pass &= testEmail("\"Doug \\\"Ace\\\" L.\"@example.com");
echo "\nAll of these should fail:\n";
$pass &= !testEmail("abc@def@example.com");
$pass &= !testEmail("abc\\\\@def@example.com");
$pass &= !testEmail("abc\\@example.com");
$pass &= !testEmail("@example.com");
$pass &= !testEmail("doug@");
$pass &= !testEmail("\"*****@*****.**");
$pass &= !testEmail("ote\"@example.com");
$pass &= !testEmail("*****@*****.**");
$pass &= !testEmail("*****@*****.**");
$pass &= !testEmail("*****@*****.**");
$pass &= !testEmail("\"Doug \"Ace\" L.\"@example.com");
$pass &= !testEmail("Doug\\ \\\"Ace\\\"\\ L\\.@example.com");
$pass &= !testEmail("hello world@example.com");
$pass &= !testEmail("gatsby@f.sc.ot.t.f.i.tzg.era.l.d.");
echo "\nThe email validation ";
if ($pass) {
echo "passes all tests.\n";
} else {
echo "is deficient.\n";
}
