$expectedDBVersion = $_POST['DBVersion']; if (!CheckDBVersion($expectedDBVersion)) { //Invalid DB Version print "Success={$success}&Error='Invalid DB version'"; return; } //Check if username is being used already if (AccountExists($username) != 0) { print "Success={$success}&Error='Username already in use'"; return; } //Login $userID = CreateNewAccount($username, $password); if ($userID == -1) { print "Success={$success}&Error='Unable to create new user'"; return; } //There will never be an existing session for a new user, no sense in even checking for it $sessionID = CreateNewSession($userID); if ($sessionID == 0) { print "Success={$success}&Error='Could not acquire session'"; return; } if (!InitSession($userID, $sessionID)) { print "Success={$success}&Error='Could not init session'"; return; } //We have a session, return it TouchSession($sessionID); $success = 1; print "Success={$success}&SessionID={$sessionID}&Username={$username}";
function TouchValidSession($sessionID) { $expectedDBVersion = $_POST['DBVersion']; if (!CheckDBVersion($expectedDBVersion)) { //Invalid DB Version return 0; } $sessionResults = mysql_query("\r\n SELECT\r\n p_ID\r\n FROM\r\n tblSessions\r\n WHERE\r\n\t\t\tADDTIME(TouchTime, '00:15:00.000000') > CURRENT_TIMESTAMP\r\n LIMIT 1\r\n "); if (!$sessionResults) { //Error with query return 0; } $sessionIDCount = mysql_num_rows($sessionResults); if ($sessionIDCount == 0) { //No valid session return 0; } //If we got this far, there is a valid session TouchSession($sessionID); return 1; }