Method updatePlayerResult

src/main/java/dbProcs/Setter.java:761–790

Updates a users result of a specific module @param ApplicationRoot The current running context of the application @param moduleId Identifier of the module the user is completing @param userId Identifier of the user completing the module @param extra The additional comments submitted in feedback by t

(String ApplicationRoot, String moduleId, String userId, String extra, int before, int after, int difficulty)

	 * @return The module name of the module completed by the user
	 */
	public static String updatePlayerResult(String ApplicationRoot, String moduleId, String userId, String extra, int before, int after, int difficulty)
	{
		log.debug("*** Setter.updatePlayerResult ***");
		
		String result = null;
		Connection conn = Database.getCoreConnection(ApplicationRoot);
		try
		{
			log.debug("Preparing userUpdateResult call");
			CallableStatement callstmnt = conn.prepareCall("call userUpdateResult(?, ?, ?, ?, ?, ?)");
			callstmnt.setString(1, moduleId);
			callstmnt.setString(2, userId);
			callstmnt.setInt(3, before);
			callstmnt.setInt(4, after);
			callstmnt.setInt(5, difficulty);
			callstmnt.setString(6, extra);
			log.debug("Executing userUpdateResult");
			callstmnt.execute();
			//User Executed. Now Get the Level Name Langauge Key
			result = Getter.getModuleNameLocaleKey(ApplicationRoot, moduleId);
		}
		catch(SQLException e)
		{
			log.error("userUpdateResult Failure: " + e.toString());
			result = null;
		}
		Database.closeConnection(conn);
		log.debug("*** END updatePlayerResult ***");
		return result;
	}
	
	/**
	 * Adds or Subtracts points from a user.