Average Karma

[Jackie Bermudez]

Hi,

The average of the karma doesn't show right away. I always try to clean the cache and cookies of the browser, I also login and log out several times, etc..and nothing, it always show the last vote instead of the average. Only, if I run again the project in eclipse again it updates the average (number of stars). For example, if the post already had 2 votes, and then, another user votes 5, the stars become 5 instead of 4 stars. Do you know what is happening?

Thanks.

[Jackie Bermudez]

I haven't resolved this. However, I would like to know how I can get the average in decimals ${post.karma.karmaPoints}

Original code:

public KarmaStatus getPostKarma(final int postId)
	{
		final KarmaStatus karma = new KarmaStatus();

		PreparedStatement pstmt = null;
		ResultSet resultSet = null;
		try {
			pstmt = JForumExecutionContext.getConnection()
					.prepareStatement(SystemGlobals.getSql("KarmaModel.getPostKarma"));
			pstmt.setInt(1, postId);

			resultSet = pstmt.executeQuery();
			if (resultSet.next()) {
				karma.setKarmaPoints(Math.round(resultSet.getDouble(1)));
			}

			return karma;
		}
		catch (SQLException e) {
			throw new DatabaseException(e);
		}
		finally {
			DbUtils.close(resultSet, pstmt);
		}
	}

So, what I'm doing in order to get the decimals, I removed the Math.round; however, the result is always with an integer, no decimals.

Thank you!

[Tim Moores]

Have you checked that resultset.getDouble actually returns a non-integer value?