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; }