gdeguglielmo

Hi ryelle, if I put BusinessBuildingAcademy I get that error.

I retrieve my id from:

https://www.meetup.com/meetup_api/console/?path=/groups&group_urlname=BusinessBuildingAcademy

so my Id should be 642700.

Thanks a lot.

I have tried to insert the ID, but there is no way, nothing seems to work.
I retrieved my id in the way explained in the FAQ and in the way explained on a meetup forum.
I still have the same error.

Hi Marventus thanks for your help. I have solved in a different way. Now there is one query, much better and I can order my 2 users’ levels by

meta_key = ‘wp_capabilities’

The order will be in alphabetical order so anyway i Can have an order.

Thanks again for your support.

No problem ??
in this casa it will display just premium users

Hi Marvenuts. I have $query1 and $query2 and so

$premium_users = $wpdb->get_results( $query1 );

and

`$free_users = $wpdb->get_results( $query2 );

the only different thing in the query is this $livello that for $query1
is

$livello1

and for $query2 is

$livello2.

I’ m trying to search and display my users ordering them by their membership level.
There are now 2 membership levels: subscriber (free_users) and s2member_level1 (premium users).

I have tried that one and then also:

$wpdb->flush();

but they don’ t seem to work.

Hi Marventus, thanks a lot for you suggestion. I choose to have 2 queries, one to retrieve my premium user and the second one to retrieve just the free subscribers.

So this is the kind of query that I have:
$query2 = "SELECT * FROM $wpdb->usermeta WHERE (meta_key= 'wp_s2member_custom_fields') AND (meta_valueLIKE '%$professione%') AND (meta_valueLIKE '%$paese%') AND user_id IN (SELECT user_id FROM $wpdb->usermeta WHERE (meta_key = 'wp_capabilities') AND (meta_valueLIKE '%$livello%') ORDER BY $wpdb->usermeta.meta_value ASC )";

where $livello is the variable containing, at first premium level and then free subscriber.

But I just have the premium ones as results. So it just run the first query. Is there any function that can clear the query to the db?
If I remove the first query, then the second one is going to retrieve the free subscribers

Thanks a lot.

Hello, have you found a solution?
Thanks

I tried it, but it’ s not what I need. Anyway I found a solution.
I have a widget to display the form above, with some small changes.
I would like to insert a bit of code, a custom query post in every search.php template file if my plugin is on. Do you know how I can do it?

Thanks! ??

Yes the checkbox is perfect. The problem is how to retrieve posts that are in both categories (in this example we have 2 categories) and not in just one of them.

Hi MrBeta, thanks for your answer. This is the code included in my widget:

<form role="search" method="get" id="searchform" action="<?php bloginfo('home'); ?>">
        <label class="screen-reader-text" for="s">Cerca</label>
		<input type="text" value="" name="s" id="s" /></br>

<?php
$categories = get_categories();
$num_cat_sel = 0;
foreach ($categories as $cat) {
    	$cat_name = $cat->cat_name;
    	$catid = get_cat_ID($cat_name);
   		$termorder = $cat->term_order;
		echo "<input type='checkbox' name='cat' value='".get_cat_ID($cat_name)."'>";
    	echo $cat->cat_name;
		$num_cat_sel++;

    } 

?>		

		</br><input type="submit" id="searchsubmit" value="Cerca" />
    </form>

It prints out a search in this way:

s=mysearchedstring&cat=id_first_cat&cat=id_second_cat

My problem is the it should be in this way:

s=mysearchedstring&cat=id_first_cat,id_second_cat

Any idea? Thanks a lot!

Hello MrBeta, I’ m trying to do something similar, but with checkbox. Any update in your work?

Thanks

Hi,
I have the same issue, I can’t drag and drop widget and I can’t use Screen Options, it doesn’ work. I disable all the plugin but nothing change…

I find a solution.
In EVERY WordPress Installation, in wp-config.php you have to add:

define('CUSTOM_CAPABILITIES_PREFIX', 'wp_');

just under the line: define('CUSTOM_CAPABILITIES_PREFIX', 'wp_');

Then you have to find in wp-includes/capabilities.php the line:

$this->cap_key = $wpdb->prefix . 'capabilities';

and replace it with

if (defined ('CUSTOM_CAPABILITIES_PREFIX')) {
	$this->cap_key = CUSTOM_CAPABILITIES_PREFIX . 'capabilities';
	}
	else {	$this->cap_key = $wpdb->prefix . 'capabilities';
	}

That’ s all! Good luck!