[Plugin: User Access Manager] UAM and wp-postratings

Cyranoz
(@cyranoz)

14 years, 2 months ago

Hello,

I’m using UAM and wp-postratings and I realize restricted posts appear in the widget “highest rated” posts.

I’ve looked into the code of wp-postratings and here is the query executed :

$highest_rated = $wpdb->get_results(“SELECT DISTINCT $wpdb->posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users, (t3.meta_value+0.00) AS ratings_score FROM $wpdb->posts LEFT JOIN $wpdb->postmeta AS t1 ON t1.post_id = $wpdb->posts.ID LEFT JOIN $wpdb->postmeta As t2 ON t1.post_id = t2.post_id LEFT JOIN $wpdb->postmeta AS t3 ON t3.post_id = $wpdb->posts.ID WHERE t1.meta_key = ‘ratings_average’ AND t2.meta_key = ‘ratings_users’ AND t3.meta_key = ‘ratings_score’ AND $wpdb->posts.post_password = ” AND $wpdb->posts.post_date < ‘”.current_time(‘mysql’).”‘ AND $wpdb->posts.post_status = ‘publish’ AND t2.meta_value >= $min_votes AND $where ORDER BY $order_by DESC, ratings_users DESC LIMIT $limit”);

For all sql specialists out there, here is the challenge : what would I need to add in this superb query to verify that the current user has the right to all highest rated posts displayed in the widget?

Thanks for any help 🙂

Brilliant plugin in any case!

http://ww.wp.xz.cn/extend/plugins/user-access-manager/

Viewing 2 replies - 1 through 2 (of 2 total)

Thread Starter Cyranoz
(@cyranoz)

14 years, 2 months ago

I’ve looked a bit more in the code of the UAM plugin and I found the function “showPostSql” in UserAccessManager.class.php, which seems to filter out from an input query the posts id’s that the user can’t have access to.

I’ve tried to play with this function inside “wp-postratings” plugin so do the same, without success so far.

Am I in the right direction?

Thanks.

Thread Starter Cyranoz
(@cyranoz)

14 years, 2 months ago

Well, I think I got it finally. But a little look from the author of the plugin would be great just to confirm. In any case, I hope it can help.

I have replaced the query above by the following :

$qqq = “SELECT DISTINCT $wpdb->posts.*, (t1.meta_value+0.00) AS ratings_average, (t2.meta_value+0.00) AS ratings_users, (t3.meta_value+0.00) AS ratings_score FROM $wpdb->posts LEFT JOIN $wpdb->postmeta AS t1 ON t1.post_id = $wpdb->posts.ID LEFT JOIN $wpdb->postmeta As t2 ON t1.post_id = t2.post_id LEFT JOIN $wpdb->postmeta AS t3 ON t3.post_id = $wpdb->posts.ID WHERE t1.meta_key = ‘ratings_average’ AND t2.meta_key = ‘ratings_users’ AND t3.meta_key = ‘ratings_score’ AND $wpdb->posts.post_password = ” AND $wpdb->posts.post_date < ‘”.current_time(‘mysql’).”‘ AND $wpdb->posts.post_status = ‘publish’ AND t2.meta_value >= $min_votes AND $where”;

global $userAccessManager;
$uamAccessHandler = $userAccessManager->getAccessHandler();
$excludedPosts = $uamAccessHandler->getExcludedPosts();
if (count($excludedPosts) > 0) {
$excludedPostsStr = implode(“,”, $excludedPosts);
$excl = ” AND $wpdb->posts.ID NOT IN($excludedPostsStr)”;
}

$qqq = $qqq.$excl.” ORDER BY $order_by DESC, ratings_users DESC LIMIT $limit”;

$highest_rated = $wpdb->get_results($qqq);

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘[Plugin: User Access Manager] UAM and wp-postratings’ is closed to new replies.