iamonlythird

I aim to do a weekly bump to this thread until we have some official words on this issue. Google is of no help and I have come across other threads with no actual confirmation.

This is amazing, thank you VERY much!

Nice thank you.

I have another question. What is the technology behind the badge system? How well does it do in terms of performance?

For example, does it save the values in the user’s metadata? Does it save each task in a separate metadata entry or does it saved them all in one (via an array)?

I have a lot of user activity and concerns that adding this hook will affect my performance too much.

For a few years ago, I actually created my own badge system but removed it specifically because it was affecting performance too much.

I have put this code into test and it is not working. I tested it on fresh install of WP4 too.

Subscribers are still awarded daily points. Maybe there is a bug in your code or do you have a different working approach to this?

Thank you and hope you are having a good weekend!

Can you please tell me where exactly you are running this code? Using your code as a template, I added $user_id as an argument and simply called the function but yet again, nothing was returned. Here is the code I used:

function mycred_pro_days_since_last_comment($user_id) {

	if ( ! is_user_logged_in() ) return;

	global $wpdb, $mycred;

	$last_time = $wpdb->get_var( $wpdb->prepare( "
	SELECT time
	FROM {$mycred->log_table}
	WHERE ref = %s
	AND user_id = %d
	ORDER BY time DESC
	LIMIT 0,1;", 'approved_comment', $user_id ) );

	if ( $last_time === NULL ) {
		// User has not received points for a comment at all
		$return = 'no comments made yet';
	}
	else {
		// Now you have the timestamp for the last time the user
		// got points for a comment. Convert this unix timestamp
		// to number of days
		$days_since = human_time_diff( $last_time );
		$return = "$days_since since last comment";
	}

	return $return;

}

mycred_pro_days_since_last_comment(1);

I am calling this on the front-end, in a page. Did you test this with WP4.0? (sorry about the stupid question, but I can’t see how it is working for you and not me, I’m on a fresh install of WP and mycred install)

EDIT: Please ignore, it works fine. Simply didn’t echo it =) It’s been a long day. Thank you very much!

EDIT 2: Sorry I have one last question. Is it possible to just GET the number in days since last comment? Currently it returns “1 month”, I would want only “30”.

Thank you for the response.

I tried your query but $days_since is empty. Is there maybe a typo in your query (or code)? I tried with with a couple of user IDs and all of them have an “approved_comment” entry in the DB, but nothing was returned.

As far as I can see, it should be fine but I think we are missing something…?