Rick James and I have created the (free, GPL) Index WP MySQL for Speed plugin. It addresses some of the performance problems with wp_postmeta by adding database indexes suitable for that table’s use cases. I use it myself on a Woo site with several thousand products. (It works on users, terms, options, and comments too.) … Read more
There are lots of examples to store the data in usermeta. But should this amount of data be stored in the usermeta table? I don’t see any reason why you should not use the default user meta data table, after-all that is what it is for, regardless of the amount of users/fields. The user meta … Read more
A different way of doing this (not better, but easier to follow) would be: DELETE * FROM wp_postmeta WHERE post_id NOT IN (SELECT ID FROM wp_posts) Obviously changing the prefixes from ‘wp_’ to whatever your setup uses
Personally, I’d generate the date in php using the PHP Date class and then $date->sub(). With a few more lines of code the query will read: … WHERE post_date >= “.$date.” …
Probably just add a counter, show ad on multiples of 6. Something like $count = 0; $adEvery = 6; if (have_posts()) : while (have_posts()) : the_post(); // Individual Post $count++; if ($count%$adEvery == 0) { // your ad } endwhile; else : // No Posts Found endif;
Here’s an updated version of pf_rb_install(). In the table creation SQL, $table_name should not be in quotes. The quotes should have triggered an error which would appear in PHP’s error.log file. Also, there should be two spaces after the PRIMARY KEY (id) portion of the SQL statement. register_activation_hook( __FILE__, ‘pf_rb_install’ ); function pf_rb_install() { global … Read more
You are looking for the wp_localize_script() function. This function allows you to add data from server to your javascript. However, this will not change the content of jsfile.js. Instead, it will add some global variable in your theme’s footer.Changing the content of a JS file before outputting it to the browser is an advanced technique, … Read more
// function to show a banner using query of banner post type function show_banner( $att ) { // Set default $att values if none is provided // $att is an array so access the shortcode value via $att[‘thumbnail_id’] // in the [banner thumbnail_id=”12″] shortcode $atts = shortcode_atts( array( ‘thumbnail_id’ => ”, ), $atts, ‘banner’ ); … Read more
Give WPCLI’s search-replace command a try: https://developer.wordpress.org/cli/commands/search-replace/ WPCLI is cross-platform and the search-replace command handles serialized data.
dbDelta is squirrelly. Some things it will alter, others it will not. For example, and if I remember correctly, you can add indexes to tables but not change those indexes or delete them. I honestly don’t know if it will remove table columns. (My guess it that it won’t but I may test that later.) … Read more