pay to blog filter

Hi all :slight_smile:

I’m trying to add a column to wpmu-blogs.php via manage_blogs_custom_column, but I can’t get that to work. So, since the deadline for this project is coming closer, I decided to hardcode that column in wpmu-blogs.php

The next problem is that I can’t filter on the new column (the column is the date when the blog expires btw) since the value of this is not in the wp_blogs table, but in the wp_X_options..

I’m not that into MySQL (the easy queries are not a problem, but I can’t seem to get the joins and all into my head :wink:), so I was hoping someone here could help me a little further.

The idea is to add the possibility sort on blog expiration date.

Btw, is there a way to add the possibility to search on (custom) user-fields? Like searching on lastname and get a list of all blogs that have users with that lastname (preferably only the administrators).