Method checkPlayerResult

src/main/java/dbProcs/Getter.java:169–194

Used to determine if a user has completed a module already @param ApplicationRoot The current running context of an application @param moduleId The module identifier @param userId The user identifier @return The module name of the module IF the user has not completed AND the user has previously open

(String ApplicationRoot, String moduleId, String userId)

	 * @return The module name of the module IF the user has not completed AND the user has previously opened the challenge. 
	 */
	public static String checkPlayerResult(String ApplicationRoot, String moduleId, String userId)
	{
		log.debug("*** Getter.checkPlayerResult ***");
		
		String result = null;
		Connection conn = Database.getCoreConnection(ApplicationRoot);
		try
		{
			log.debug("Preparing userCheckResult call");
			CallableStatement callstmnt = conn.prepareCall("call userCheckResult(?, ?)");
			callstmnt.setString(1, moduleId);
			callstmnt.setString(2, userId);
			log.debug("Executing userCheckResult");
			ResultSet resultSet = callstmnt.executeQuery();
			resultSet.next();
			result = resultSet.getString(1);
		}
		catch(SQLException e)
		{
			log.debug("userCheckResult Failure: " + e.toString());
			result = null;
		}
		Database.closeConnection(conn);
		log.debug("*** END checkPlayerResult ***");
		return result;
	}
	
	/**
	 * Used to decipher whether or not a user exists as a player