WP-DBManager Plugin Can’t Find Mysql Path

I solved this with help from the main StackOverflow site. One of the commenters suggested that the open_basedir directive might be set in php.ini – and that was the issue. Here is the open_basedir setting: open_basedir = “/var/www/vhosts/lifering.org/:/tmp/” I created a hard link mysql (could have been a symlink) to /usr/bin/mysql in the /tmp directory … Read more

Filter/Sort Post Form On Taxonomy page

That happens because wp_dropdown_categories, by default, defines the name of the dropdowns as ‘cat’. You are showing 2 dropdowns in the form, and both are named ‘cat’, because you didn’t define a name for them. So when you submit the form, you get two query vars named cat. For example, if you want the second … Read more

Show one post per author and order by custom field

You use a AND statement after a GROUP BY statement. That wont work. Try altering the WHERE statement (posts_where_paged filter) to add the AND pm.meta_key = ‘KEY’ line. Additionally you can use the posts_orderby filter to alter the ORDER BY. EDIT You can find some additional information here.

How to change post template

The way I see it you have two options here: Pass the id to a custom template and then create a custom wp_query loop and use $_GET[‘id’] as the id of the loop. For Example: <?php /* Template Name: Pop Up View */ //get id from your url $id=$_GET[‘id’]; //start custom loop $query = new … Read more

How do I find users by password?

The user password (stored as an MD5 hash) can be retrieved like so: $users = get_users(); foreach ( $users as $user ) { $password = $user->user_pass; } Assuming you have some known value for passkey, you can hash it and compare it to each user’s password: $passkey = ‘somestring’; $hashed_passkey = md5( $passkey ); $users … Read more

Keeping Objects in Memory

This is a perfect use case for Transients. In WordPress, transients are short-lived data objects. By default, they’re persisted to the database using WordPress’ built-in WP_Object_Cache object. However, you can use a variety of caching plugins (Batcache is an outstanding one that works with Memcached) to store Transients in memory. To set a transient, call … Read more