I rewrote the function from the link in your question to SQL. Keep in mind that this script will also clear the page-templates assigned to the pages. Make a backup of the wp_postmeta table first. DELETE pm FROM wp_postmeta pm LEFT JOIN wp_posts p ON pm.post_id = p.id WHERE (p.post_type IN (‘post’, ‘page’) AND pm.meta_key … Read more
wp_insert_post runs whenever a post is updated, not just when it’s first saved. So your payment_meta() function is running every time a post is saved, and since you’re using add_post_meta() in that function, a new meta entry is created every time the post is saved. Instead of using add_post_meta() stick to just using update_post_meta() if … Read more
Check wp-config.php. It’s possible to define these values there, in which case they won’t be available as settings, which means they won’t be saved in the database. It is possible to set the site URL manually in the wp-config.php file. Add these two lines to your wp-config.php, where “example.com” is the correct location of your … Read more
It’s up to you. Normally when you create and query a table you use the $wpdb->prefix property as part of the table name. In a multisite install this prefix includes the current site ID. So if you use dbDelta() to create a table with the name $wpdb->prefix . ‘tablename’, then — assuming the default prefix … Read more
All site content for your WordPress site is stored in the database. The files that query and display the data, store settings, etc, are in the theme and plugin folders. There is the wp-config.php file that stores access credentials for your database. And media files are stored in the wp-content folder, but media files locations … Read more
You’ll want to include the wp-load.php, not the wp-config.php. Depending on how you’re doing it, you may also have to set $_SERVER variables if they aren’t already set to prevent WordPress from trying to redirect you. For example: $_SERVER = array( “HTTP_HOST” => “http://example.com”, “SERVER_NAME” => “http://example.com”, “REQUEST_URI” => “https://wordpress.stackexchange.com/”, “REQUEST_METHOD” => “GET” );
When a user say user A is deleted, you’re not cleaning up all traces of that user. Namely you need to go into each user following A and remove it from their user meta. This is why your function is showing blank users, because its being given stale information that’s out of date, and refers … Read more
Unless you want to retrieve custom data from the database, you will hardly ever need to make use of the WPDB class (or its global object, respectively). Though it is obviously possible to do things that way as well. Just for the sake of completeness, if you had a reason to not use a more … Read more
If it’s information that logically belongs to a post/page – you store it in postmeta (with update_post_meta function). If it’s something that pertains to a user – usermeta table is for you. More still, there’s Settings API in case you have a plugin that needs to persist any settings. From your question it is somewhat … Read more
The obvious advantage of user meta is that you can use the WordPress API to record and retrieve these extra columns, without writing extra PHP classes or SQL queries. The wp_usermeta table is pretty well indexed, in fact, it uses one row per field (rather than one column if you use a custom table), and … Read more