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"; }