It is not a good practice to add/remove columns to/from the core tables in WordPress. There is no guarantee that the very next update doesn’t change this table’s behavior, or even overwrite your column. Your best approach is to use metadata as you mentioned. But, if you need to do this for some reason, you … Read more
You can use the filters the_author_$meta and get_the_author_$meta (where $meta is in this case ‘description’): add_filter(‘the_author_decription’, ‘custom_about_member’, 10, 2); add_filter(‘get_the_author_decription’, ‘custom_about_member’, 10, 2); function custom_about_member($description, $userid) { $about = get_user_meta($userid, ‘user_about’, true); if ($about) {return $about;} return $description; } This of course relies on the place where the author bio is being displayed using the … Read more
This Should Work? ALTER TABLE wp_usermeta ADD COLUMN old_user_id bigint(20) unsigned; INSERT INTO wp_usermeta (old_user_id) SELECT u.id FROM wp_users AS u; INSERT INTO wp_usermeta (user_id, meta_key, meta_value) SELECT u.id, ‘wp_2_capabilities’, meta_value JOIN wp_users AS u ON u.user_id = u.old_user_id; ALTER TABLE wp_users DROP COLUMN old_user_id;
There is none. You have to implement your own custom function to trim any content you wish. For example, this function will trim your content based on words: function my_custom_excerpt ( $content, $limit = 20, $more=”…” ){ return $data = wp_trim_words( strip_tags( $content ), $limit, $more ); } Or this one will trim it based … Read more
What you are doing is not a valid way of retrieving and checking serialize data from the WP. You may insert array as a user meta but this array behind the scenes is transformed to serialize string something the MySql can handle. There are options for searching with the LIKE operator but I don’t endorse … Read more
Try this: function thebroker_agents() { global $current_user; $bmail = $current_user->user_email; $user_query = new WP_User_Query( array( ‘meta_key’ => ‘broker_email’, ‘meta_value’ => $bmail, ‘fields’ => ‘all’ ) ); $users = $user_query->get_results(); if (!empty($users)) { $results=”<ul>”; foreach ($users as $user){ $results=”<li>” . $user->display_name . ‘</li>’; } $results=”</ul>”; } else { $results=”No users found”; } wp_reset_postdata(); return $results; } … Read more
Here’s a solution that I came up with that will add the user query argument and the current user’s ID to PDF links, e.g.: http://mysite/wp-content/uploads/2018/12/My_PDF_File.pdf?user=54 This code works by inspecting the post’s content using the the_content filter, then parsing the content using DOMDocument. I’ve run into various gotchas using DOMDocument and much of this code … Read more
You’re very close. First, make sure you’re using unique variable names. I have set $current_seeking_id for the meta key seeking_first and $current_team_id for the meta key team_manager. Next, you have to use these in your query to match. I’ve placed these variables at the value for your meta_query. This assumes that the seeking_first value matches … Read more
I see 2 possible ways: 1) Using your WP_User_Query in a WC_Order_Query with the customer_id argument this way: // Users query $user_ids = (array) get_users([ ‘role’ => ‘customer’, ‘number’ => – 1, ‘fields’ => ‘ID’, ‘meta_query’ => [ ‘relation’ => ‘OR’, [ ‘key’ => ‘unsubscribed’, ‘compare’ => ‘!=’, ‘value’ => 1 ], [ ‘key’ => … Read more
If you want to use that function everywhere, you need to be sure that: $current_user is always defined as a WP_User object, $current_user->ID is different from 0 (zero) – only for logged in users, jQuery select2() function (plugin) exist, avoiding JS errors on some other pages (where Select 2 is not enabled). See: How can … Read more