== Short answer == If you use the found $1 you should use LIKE and not = as you match against the title’s LIKE. So replace ((abc18meta.meta_key = ‘plz’) AND (abc18meta.meta_value = $1)) into ((abc18meta.meta_key = ‘plz’) AND (abc18meta.meta_value LIKE $1)) You could change your preg_replace search by ignore the wrapping (see below) of **ABC* … Read more
What I understand is you want to update records/table to another database from wordpress…. well you can achieve this in wordpress 3.1> using $newwpdb = new wpdb(“mysqluser”,”mysqlpassword”,”mysqldbname”,”mysqlhost”); Then using $newwpdb you can access table from new database and perform all operation on it like edit/delete update/insert… same as $wpdb do wordpress…. Hope that helps or … Read more
I’d point you to the much-cited Justin Tadlock “Using custom taxonomies to create a movie database” as a good place to start. His example is Popcritic. The saving favorites would probably require a different plugin, but such is the nature of WordPress.
I have a wordpress site with some serious wp_options table bloating. This is causing slow page loads and memory bloat. After investigation, there appears to be thousands of orphaned entries. If you know for a fact these options are for plugins that are no longer in use, then yes it’s safe to delete them. If … Read more
I find the export tools very slow and not so reliable. If imporitng fails you probably have a timeout with your server or your dump file is too big. Here’s the way I do it, and it’s much faster: extract a fresh copy of wordpress code in production replace the wp-content folder with the one … Read more
This is more a git question than a WordPress one IMHO, but what you need to do is write a bash script and associate with a git hook that does what you want.
You might be able to solve this if you have a text editor with good encoding support. That way, you could switch between the Latin 1 and the UTF-8 encoding until you have the right combination. I use SubEthaEdit which can convert but also reinterpret a file when you change the encoding. The ç should … Read more
Here is an example code that will get the data and then display it: global $wpdb; // this adds the prefix which is set by the user upon instillation of wordpress $table_name = $wpdb->prefix . “your_table_name”; // this will get the data from your table $retrieve_data = $wpdb->get_results( “SELECT * FROM $table_name” ); ?> <ul> … Read more
Try this code Refresh page after update_user_meta add_action( ‘user_meta_after_user_update’, ‘refreshPage’ ); function refreshPage() { echo ‘<script>location.reload();</script>’; }
After executing these: [root@shop ~]# mysqlcheck -p -c wordpress hihgv_options wordpress.hihgv_options OK [root@shop ~]# mysqlcheck -p -o wordpress hihgv_options wordpress.hihgv_options note : Table does not support optimize, doing recreate + analyze instead status : OK [root@shop ~]# mysqlcheck -p -a wordpress hihgv_options wordpress.hihgv_options OK Size is down to 1.6MB, not sure if it was optimize … Read more