mycred_count_ref_instances not working accordingly?

Hi.

No changes has been made to this function.
If you provide a user id then the number of existing log entries with the given reference is returned. Have you checked that $userID provides an actual user ID? Try removing $userID and just query the total number of approved comments are returned.

If not, then enable WP_DEBUG and see if you get any error messages. I also assume you have not replaced this function with your own version as it is pluggable.

Gabriel,

Yes, I have already confirmed that $userID provides a User ID. Also, I tried to set the user ID to $userID = 1; and the same problem.

I tried to also to remove the $userID and query the total number of approved comments and it still returned as zero!

I enabled WP_DEBUG but it did not provide anything of relevance.

I should note that I am calling this function in the wp-admin area. Can you please quickly confirm if this is working for you? The reason why I ask is because I believe that I tested this code for about a month ago and it was working then.

Update: I tried this on a fresh install of WP and same problem. Can this function be called the way I do it in the WP-admin area or do I need to global something?

Hi.

The mycred_count_ref_instances function is available and used both in the front end and in the admin area and is a very straight forward DB Query that counts the reference instances in your log.

So in the above example, you would get the number of rows that have the reference “approved_comments”, which by the way will return zero since myCRED saves comments under the reference “approved_comment” (singular).

You could use the same query directly without the function to see if that works:

global $wpdb, $mycred;

$comments = $wpdb->get_var( $wpdb->prepare( "
SELECT COUNT(*)
FROM {$mycred->log_table}
WHERE ref = %s
AND user_id = %d", 'approved_comment', $userID ) );

echo 'This user has a total of ' . $comments . ' approved comments in the log.';

Ah, so the problem was character issue in the reference. Perfect, this worked great! Thanks!!