What about something like this ? $custom_row = array(array(‘race_id’ => ‘1’, ‘race_name’ => ‘2’, ‘race_date’ => ‘3’)); $races = $wpdb->get_results(” select r.race_name ,r.race_id ,date_format(r.race_date,’%c.%d.%Y’) race_date from race_calendar r order by r.race_date; “, ARRAY_N); $merged_arr = array_merge($custom_row, $races); foreach ( $merged_arr as $race ) { echo $race[‘race_id’] . ‘,’ . $race[‘race_name’] . ‘,’ . $race[‘race_date’]; } … Read more
Your concern regarding updating every relevant user row every 20 seconds or so is totally valid. One solution, then, is to store this data in a single row rather than using the metadata APIs or custom SQL to associate the data with each individual user. The Options API as well as the Transients API are … Read more
spambot registering without providing email or password, bypassing registration process
How to change link in all posts?
I wasn’t thorough enough initially. Old wp-config.php files were found in my downloads folder. It looked like these files came from the zip file Duplicator created when copying my live site. These files contained config information to my live site database. After deleting them, the problem has gone away.
Sorry, I’m not familiar with gravity form plugin, but overall it should work as following: Build a custom plugin which retrieves vendor database values. Create a shortcode for plugin and integrate it into gravity form to retrieve values on the form. Once required information is on the form, you should be able to forward it … Read more
I can’t simulate this on a clean install of WordPress. So probably there is some extra filtering of XSS/Injection prevention happening on the server side. You should probably check that out first.
How can we speed up wp_get_nav_menu_items()?
It would be bad practice to have two sites running off the same database. This is especially true if you were to perform plugin / core updates on one or the other. You would be much better off using something like migrate-db (https://wordpress.org/plugins/wp-migrate-db/) to perform a migration. The maintainers of migrate db are also working … Read more
Add following in WHERE condition of your SQL query. WHERE t1.meta_key = “<?php echo $wpdb->prefix; ?>capabilities” AND ( t1.meta_value LIKE ‘%ROLE_YOU_WANT_TO_FILTER%’) Let me know if it works for you or not.