How to verify password outside WordPress?

While the answer to your question could be long and complex, but since you are developing another website using ASP, I assume you know how to integrate with database too. I’m going to add some useful information for your case. WordPress Salts WordPress uses different salts for different purposes, as asked here. These salts are … Read more

Slow Mysql Queries

WP options (which is one of the most basic and used storage APIs) can be stored with or without “autoload” setting. Usually this is reasonable, since many options will be checked on each and every page load, so loading them in bulk during core load is much more efficient than individually. Problems usually start when … Read more

Using table lock with wp_insert_post?

Firstly, your question indicates that your plugin sometimes runs over 5 min, don’t you get script timeouts? 5 min is a very long runtime… How many posts are you adding and what’s your server environment? Back to the problem… May I suggest another solution? Simply set an option that you’re doing something, and deactivate it … Read more

How to add and SQL query of posts only published

You should be able to get away with just adding AND $wpdb->posts.post_status=”publish” at the end. $prepare_string = ” SELECT DISTINCT ID FROM $wpdb->posts LEFT JOIN $wpdb->postmeta ON ( $wpdb->posts.ID = $wpdb->postmeta.post_id ) LEFT JOIN $wpdb->postmeta AS mt1 ON ( $wpdb->posts.ID = mt1.post_id ) WHERE ( ( $wpdb->postmeta.meta_key = ‘event_date’ AND $wpdb->postmeta.meta_value >= %d ) OR … Read more

What is stored in the webserver? (Separated Database)

The WP database contains everything that is related to content: posts, pages, theme settings, plugin settings, media of all kinds. So if you were to replace the WP database with a brand-new WP database, all of your content – and many of your settings – will be gone. The WP ‘code’ (PHP, CSS, JS source … Read more

Using same database for main and subdomain

Can I use the same database that I use at mysite.com also to my subdomain Yes, as long as the table names don’t clash you’re fine, some people have multiple WP instances using the same database, but with different table prefixes. However, keep in mind that there is a security risk as now 2 sites … Read more