This is a serialized array. PHP is able to read them as if they were regular arrays (or objects, in some cases) by using the serialize and unserialize functions (WordPress does this for you). All you need with WordPress to do is use get_option (or comparable WordPress function calls to retrieve data) and use the … Read more
The unit tests transform all CREATE TABLE and DROP TABLE queries to CREATE TEMPORARY TABLE and DROP TEMPORARY TALBE, respectively. So in your tearDown the query will attempt to drop temporary tables with those names, but not the actual tables. To fix this, add this before your DROP queries: remove_filter( ‘query’, array( $this, ‘_drop_temporary_tables’ ) … Read more
…would WordPress be able to render the website in less than one second… WordPress is perfectly scalable to the amount of content and user base you’re describing. You just need the horsepower for httpd (apache/nginx) to be able show one second page loads and have the database server (mysql, maria) respond fast, too. You also … Read more
If you plan to use it just for your own code, and have it running alongside WordPress’ default database driver (wpdb), I see no real problems. It’s only if you plan on fully integrating/overriding WP’s driver that I see it being near-impossible; hard-coded SQL is prolific throughout core, and translating them to ActiveRecord method calls … Read more
Comment type is similar to post type, because it allow to query only a specific type of comments, just like post type allow to query one or more post types. And just like core post types (page, post) there are core comment type as well: ‘comment’, ‘pingback’, ‘trackback’. A difference between the two is that, … Read more
Custom tables can simplify your code, improve performance and help avoiding conflicts with WordPress’ schema changes in the future. Don’t hesitate to use one if you need it. The extra complexity comes from two other factors: maintenance and multisite. Maintenance: manual or automatic backups might omit custom tables, so there is a tiny risk that … Read more
You can do it like this: SQL SELECT * FROM wp_options WHERE option_name=”active_plugins”; But for better approach will be the WordPress way: WordPress if ( ! function_exists( ‘get_plugins’ ) ) { require_once ABSPATH . ‘wp-admin/includes/plugin.php’; } $active_plugins = get_option(‘active_plugins’); $all_plugins = get_plugins(); $activated_plugins = array(); foreach ($active_plugins as $plugin){ if(isset($all_plugins[$plugin])){ array_push($activated_plugins, $all_plugins[$plugin]); } }
I also happened to me once, I only had like 10 real post, so what I did was to go to phpMyAdmin, make sure your that on my wp_posts and wp_posts_meta tables are only information about the 10 real posts IDs, from the mysite/wp-admin/export.php I exported all the posts (10 of them), I run the … Read more
Not from personal experience (I don’t use WP image management much), but I believe Regenerate Thumbnails plugin is usually recommended for rebuilding thumbnails.
SQL query to run via phpmyadmin DELETE a,b,c FROM wp_posts a LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id) LEFT JOIN wp_postmeta c ON (a.ID = c.post_id) WHERE a.post_type=”revision” That query will remove all post revisions from your wp database,, But remember always back up your database before running any direct SQL query.. you can … Read more