function prep_archives_query($q) { global $wpdb; if (isset($_GET["pc"])) { $offset = $_GET["pc"] - 1; $offset = $offset * 10; } else { $offset = 0; } if (isset($_GET['pf-see']) && 'archive-only' == $_GET['pf-see']) { $pagefull = 20; $relate = new PF_RSS_Import_Relationship(); $rt = $relate->table_name; $user_id = get_current_user_id(); $read_id = pf_get_relationship_type_id('archive'); $q = $wpdb->prepare("\n\t\t\t\tSELECT {$wpdb->posts}.*, {$wpdb->postmeta}.* \n\t\t\t\tFROM {$wpdb->posts}, {$wpdb->postmeta}\n\t\t\t\tWHERE {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id\t\n\t\t\t\tAND {$wpdb->posts}.post_type = %s\n\t\t\t\tAND {$wpdb->posts}.post_status = 'draft'\n\t\t\t\tAND {$wpdb->postmeta}.meta_key = 'sortable_item_date'\n\t\t\t\tAND {$wpdb->postmeta}.meta_value > 0\n\t\t\t\tAND {$wpdb->posts}.ID \n\t\t\t\tIN (\n\t\t\t\t\tSELECT item_id \n\t\t\t\t\tFROM {$rt} \n\t\t\t\t\tWHERE {$rt}.user_id = {$user_id} \n\t\t\t\t\tAND {$rt}.relationship_type = {$read_id} \n\t\t\t\t\tAND {$rt}.value = 1\n\t\t\t\t)\n\t\t\t\tGROUP BY {$wpdb->posts}.ID\n\t\t\t\tORDER BY {$wpdb->postmeta}.meta_value DESC\n\t\t\t\tLIMIT {$pagefull} OFFSET {$offset}\n\t\t\t ", 'nomination'); } elseif (isset($_GET['action']) && isset($_POST['search-terms'])) { $pagefull = 20; $relate = new PF_RSS_Import_Relationship(); $rt = $relate->table_name; $user_id = get_current_user_id(); $read_id = pf_get_relationship_type_id('archive'); $search = $_POST['search-terms']; $q = $wpdb->prepare("\n\t\t\t\tSELECT {$wpdb->posts}.*, {$wpdb->postmeta}.* \n\t\t\t\tFROM {$wpdb->posts}, {$wpdb->postmeta}\n\t\t\t\tWHERE {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id\t\n\t\t\t\tAND {$wpdb->postmeta}.meta_key = 'sortable_item_date'\n\t\t\t\tAND {$wpdb->postmeta}.meta_value > 0\n\t\t\t\tAND {$wpdb->posts}.post_type = %s\n\t\t\t\tAND {$wpdb->posts}.post_status = 'draft'\n\t\t\t\tAND ((({$wpdb->posts}.post_title LIKE '%s') OR ({$wpdb->posts}.post_content LIKE '%s')))\n\t\t\t\tGROUP BY {$wpdb->posts}.ID\n\t\t\t\tORDER BY {$wpdb->postmeta}.meta_value DESC\n\t\t\t\tLIMIT {$pagefull} OFFSET {$offset}\n\t\t\t ", 'nomination', '%' . $search . '%', '%' . $search . '%'); } #$archivalposts = $wpdb->get_results($dquerystr, OBJECT); #return $archivalposts; return $q; }
/** * Generic function for getting relationships of a given type for a given user * * @param string $relationship_type * @param int $user_id */ function pf_get_relationships_for_user($relationship_type, $user_id) { $relationship = new PF_RSS_Import_Relationship(); $relationship_type_id = pf_get_relationship_type_id($relationship_type); $rs = $relationship->get(array('relationship_type' => $relationship_type_id, 'user_id' => $user_id)); return $rs; }