7,842 reputation
11549
bio website kathyisawesome.com
location
age
visits member for 3 years, 5 months
seen Dec 13 at 17:15

WordPress and WooCommerce developer. I like writing plugins, making guacamole, having adventures and saving the day.


Dec
13
comment Loading a script with a dependency, is unloading another script's dependency
@bonger Thanks for the definitive answer. If you wanted to move your comment to an answer I'd accept it. Apparently, dependencies are hell.
Dec
6
comment How to modify Publish metabox?
I didn't really know all the rules in 2011. I know better now.
Nov
19
comment Self-hosted Plugins & Themes store with auto-updates?
Compared to a brick and mortar store, $200 is pretty low friction, imo. You can sell your software via WooCommerce or EDD, but you can't do license keys and updates without paid extensions. And assuming you aren't selling your software for pennies, you should make your investment back fairly quickly. Good luck!
Nov
18
comment Self-hosted Plugins & Themes store with auto-updates?
Well, developers like to get paid for things that take them a lot of time to build, provide a lot of functionality, and/or allow you to make money... all of which I can sympathize with. WP Updater is free and I've seen several tutorials on the subject, but you won't get license keys or any kind of payment processing with that.
Nov
18
comment Self-hosted Plugins & Themes store with auto-updates?
WooCommerce Software Add-on and Easy Digital Downloads both have a software licensing extension that will do what you are asking. Both options also have plugins for accepting PayPal. In total you could get your store set up for <$200. Consider it an investment in your business.
Nov
18
comment Loading a script with a dependency, is unloading another script's dependency
I wonder what happened to all the other comments? Anyway, @BODA82, no I had not tried that. But adding a priority does keep datepicker loading correctly even when $in_footer is true on my own script.
Oct
11
comment Form element deleted from first row of WP_Lists_Table
Fair enough. @toscho mentioned on twitter that it might have to do with the bulk edit form?
Oct
11
comment How to List CPTs Under One Tax Term
You don't need a "page" template as WordPress already has a term archive template (a page on your site that shows all the posts/CPTs in a specific term). See @Anas' answer.
Oct
11
comment Form element deleted from first row of WP_Lists_Table
Still confused as to why it'd be that way only in the first row, but if you will repost your comment about invalid markup as an answer, I will accept it.
Oct
10
comment Form element deleted from first row of WP_Lists_Table
But the nested form is seemingly allowed in the other rows? As well as it appears in the markup. I can do the inputs without forms, but then I got stuck with the enter keypress submitting the whole page, which I'd like to avoid.
Oct
10
comment Date query not inclusive despite parameter being true
The "inclusive" behavior still doesn't seem totally intuitive to me, but I do understand it now, so thanks for the help.
Oct
10
comment Date query not inclusive despite parameter being true
It turns out that you can write 'before' => '2014-10-10 23:59:59 directly as the date query parameter since that is a supported date string. If you'll add that, I will accept this answer.
Oct
8
comment Query by one meta_key and sort by another (possibly NULL value)
I think that's it. With this in the join clause and the orderby from my previous comment, I am now getting all the null/empty meta key posts at the end of my list, and sorted by date. Thanks so much!
Oct
8
comment Query by one meta_key and sort by another (possibly NULL value)
That is probably the case. Could we treat the non-existing keys the same as the zero-length strings? Based on your last comment: $pieces[ 'orderby' ] = 'ISNULL(MAX(dealer_pm.meta_value)) OR LENGTH(TRIM(MAX(dealer_pm.meta_value))) = 0 ASC, MAX(dealer_pm.meta_value) ASC,' . $wpdb->posts . '.post_date DESC'; is very close. Posts with that meta key come alphabetized at the top, but then there still seems to be a distinction between nulls and zero-length.
Oct
8
comment Query by one meta_key and sort by another (possibly NULL value)
seem to have hit a small hiccup. For some reason there are posts with no "dealer number" before the posts with dealer numbers as well as after. See this screenshot for a better idea. Any idea what is keeping it from displaying all posts with a dealer number and then all the posts where dealer number is null?
Oct
8
comment Query by one meta_key and sort by another (possibly NULL value)
Yeah I missed that too. #facepalm! Anyway, I tried your suggestion and it results in zero posts being found. See Bonger's answer... modifying the posts_join and posts_orderby clauses did it.
Oct
7
comment Query by one meta_key and sort by another (possibly NULL value)
That works great. I had to modify it to $pieces[ 'orderby' ] = 'ISNULL(MAX(dealer_pm.meta_value)) ASC, MAX(dealer_pm.meta_value) ASC, ' . $wpdb->posts . '.post_date DESC'; so that it would be alphabetized and then go by most recent posts.
Oct
7
comment Query by one meta_key and sort by another (possibly NULL value)
This is almost there! Awesome! For some reason I can't get the posts with a dealer_number key to come first no matter how I set the orderby parameter. Could it be something in the fields parameter? I don't really understand what is going on there.
Oct
7
comment Query by one meta_key and sort by another (possibly NULL value)
Yes, I just realized that _dealer_number existing and not existing at the same time is impossible. :) But I still want _customer_user to be required at all times. Is there a way to filter posts_orderby, etc so that the custom orderby clause only effects this get_posts() query?
Oct
7
comment Query by one meta_key and sort by another (possibly NULL value)
According to the codex for get_posts()(which of course can be out of date) numberposts and posts_per_page can be used interchangeably. But that isn't the real problem. I have determined that the EXISTS and NOT EXISTS at the same time (at least with the AND relation returns nothing, at least with the AND relation. But I don't know how to have it AND for the _customer_user. You're answer is overlooking how I would like to sort by the _dealer_number key which is not guaranteed to be in existence and then by post date.