Function Reference: gdlist_get_user_reviewed_posts

Summary

This function has not been documented yet.

Source File

gdlist_get_user_reviewed_posts() is located in geodir_list_manager/geodir_list_manager.php [Line: 454]

Source Code

function gdlist_get_user_reviewed_posts() {
    $user_id = get_current_user_id();
    if ( ! $user_id ) {
        return false;
    }
    global $wpdb, $tablecomments, $tableposts;
    $tablecomments = $wpdb->comments;
    $tableposts = $wpdb->posts;
    $review_table = GEODIR_REVIEW_TABLE;

    $where = $wpdb->prepare("WHERE post_status=%d AND status=%d AND overall_rating>%d AND user_id=%d ", array(1, 1, 0, $user_id));

    $query = "SELECT post_id FROM $review_table $where";

    $items_per_page = 100;

    $page = isset($_GET['rpage']) ? abs((int)strip_tags(esc_sql($_GET['rpage']))) : 1;
    $offset = ($page * $items_per_page) - $items_per_page;
    $results = $wpdb->get_results($query . " GROUP BY post_id LIMIT ${offset}, ${items_per_page}");

    $p_ids = array();
    foreach($results as $result) {
        $p_ids[] = $result->post_id;
    }

    return $p_ids;
}