One option is setting the site’s URL in the wp-config.php file itself. This effectively overrides the siteurl option that’s otherwise stored in the database, but it also means you can reference the URL without doing a query. From the Codex: It is possible to set the site URL manually in the wp-config.php file. Add these … Read more
The plugin probably (or: hopefully) used the $wpdb object, an instance of the wpdb-class, to add the custom table. If so (and only if so), then its author probably also uses $wpdb->insert() to add rows/ entries to the table. Taking a look at wpdb::insert(), and looking at its source, you will find out that this … Read more
One thing you can do to help reduce the amount of bloat is add a plugin that controls the number of previous revisions kept for Pages, Posts, etc (preferably one that allows for separate values for each type, such as last 5 revisions for pages and last 20 revisions for posts, or whatever.) There are … Read more
I found when attempting similar I needed to clear the user cache to get the relogin to work (after much frustrating testing!): wp_cache_delete($user_id, ‘users’); wp_cache_delete($old_user_login, ‘userlogins’); // maybe unnecessary? $creds = array(‘user_login’ => $user_login, ‘user_password’ => $user_password, ‘remember’ => true); wp_signon($creds); Note for this to work you may also need the user to change their … Read more
Default attributes of WooCommerce variable products are stored as post meta in the database. You can find them in the wp_postmeta table, where the post_id column is the post ID of the parent product (Variable product), and the meta_key column is _default_attributes. You can clear and remove default attributes of all products by replacing all … Read more
So after @Nicolai found that blurb in the WP source confirming that I can’t use multiple parameters in the orderby if I am ordering by relevance I had to go a different route. However, this route only works if I don’t care for pagination. There probably is a way to put it back, but I’m … Read more
It is possible to save ACF data in custom tables by using a separate paid plugin called ACF Custom Database Tables. However, if your goal is just to keep the database as light as possible, meevly.com’s solution of creating your own custom metaboxes would be the lightest-weight option, versus adding two plugins just to track … Read more
Yes, but that is out of quick and easy realm. See HyperDB in Codex and repository for starters.
The disqus plugin synchronizes your WordPress comments with the disqus system — that’s it’s main purpose (own your own comments, etc). You can get around this by ditching the built in WordPress commenting system altogether, modifying your theme templates (probably just comments.php) to use the stand-alone disqus javascript. <script type=”text/javascript”> var disqus_shortname=””; // required: replace … Read more
It is possible but you must manually create a new instance of the wpdb class with right settings for your other database. Quote from the wpdb Codex page: The $wpdb object can talk to any number of tables, but only one database: the WordPress database. In the rare case you need to connect to another … Read more