/** * Filters ``$cwhere`` query portion. * * @package optimizeMember\Queries * @since 110912 * * @attaches-to ``add_filter("comment_feed_where");`` * * @param str $cwhere Expects the SQL `WHERE` portion to be passed through by the Filter. * @param obj $wp_query Expects ``$wp_query`` by reference, from the Filter. * @return str The revised ``$cwhere`` string. */ public static function _query_level_access_coms($cwhere = FALSE, &$wp_query = FALSE) { global $wpdb; /* Need this global DB object reference here. */ /**/ if (is_string($cwhere) && is_object($wpdb) && is_object($wp_query) && !$wp_query->get("suppress_filters")) { $x_terms = array_merge((array) $wp_query->get("category__not_in"), (array) $wp_query->get("tag__not_in")); $x_terms = array_unique(c_ws_plugin__optimizemember_utils_arrays::force_integers($x_terms)); $x_singulars = c_ws_plugin__optimizemember_utils_gets::get_singular_ids_in_terms($x_terms); /**/ $cwhere .= " AND `" . $wpdb->comments . "`.`comment_post_ID` NOT IN('" . implode("','", (array) $wp_query->get("post__not_in")) . "')"; $cwhere .= " AND `" . $wpdb->comments . "`.`comment_post_ID` NOT IN('" . implode("','", $x_singulars) . "')"; } remove_filter("comment_feed_where", "c_ws_plugin__optimizemember_querys::_query_level_access_coms", 100, 2); return apply_filters("_ws_plugin__optimizemember_query_level_access_coms", $cwhere, get_defined_vars()); }
/** * Retrieves a unique array of Singular IDs in the database, within specific term IDs. * * Only returns Singular IDs that are within the ``$terms`` passed through this function. * * @package optimizeMember\Utilities * @since 110912 * * @param array $terms Required. An array of term IDs. * @return array Unique array of all Singular IDs *( as integers )* within the ``$terms`` passed through this function. */ public static function get_singular_ids_in_terms($terms = FALSE) { global $wpdb; /* Need this global DB object reference here. */ /**/ if (!empty($terms) && is_array($terms) && is_array($singular_ids = $wpdb->get_col("SELECT `object_id` FROM `" . $wpdb->term_relationships . "` WHERE `term_taxonomy_id` IN (SELECT `term_taxonomy_id` FROM `" . $wpdb->term_taxonomy . "` WHERE `term_id` IN('" . implode("','", $terms) . "'))"))) { $singular_ids = c_ws_plugin__optimizemember_utils_arrays::force_integers($singular_ids); } /**/ return !empty($singular_ids) && is_array($singular_ids) ? array_unique($singular_ids) : array(); }
/** * Forces integer values on each array value *( also supports multi-dimensional arrays )*. * * @package optimizeMember\Utilities * @since 111101 * * @param array $array An input array. * @return array Returns the ``$array`` after having forced it to set of integer values. */ public static function force_integers($array = FALSE) { $array = (array) $array; /**/ foreach ($array as &$value) { if (is_array($value)) { $value = c_ws_plugin__optimizemember_utils_arrays::force_integers($value); } else { if (!is_integer($value)) { $value = (int) $value; } } } return $array; }