Directly editing WP database issues

The data is serialized. You can try an online editor like this one (just use JSON), otherwise you can do it with a little PHP: $data = unserialize( $your_serialized_data ); $data[‘this’] = ‘that’; echo serialize( $data );

Automatically generate pages from SQL

Use a shell script and WP-CLI in your SSH console. Your shell script has to fetch each element of your table and launch the function of WP-CLI that creates a post in WordPress. You can even provide a sort of template in the call of the function. WP-CLI is a useful tool, but you can … Read more

WordPress security [closed]

No, and what you want is DRM and not security. The base of any measure of security is that only you have “root” level access to the server as the root user will be able in the end to overcome any DRM measure you try to implement. If a contract will not stop him from … Read more

Buddypress avatar image in database [closed]

BuddyPress does not store the avatar path in the database. It loads avatars using the directory path – usually …/wp-content/uploads/avatars/. For example, the full sized avatar for a member might be …/wp-content/uploads/avatars/1/ef1e70a512662ea4fdca5b2efb6f76ab-bpfull.jpg where 1 is the user_id. Check your BP installation to find the exact path to the avatars.

WPDB – Read and write value from / to database

This is still a valid question even if there is an easier way. That easier way is get_user_meta($user_id,’vatnumber’,true); NOT $wpdb->get_user_meta($user_id, vatnumber,”); by the way. Setting the $single flag to true is because although you can store multiple values in a single keyname but this is usually best avoided to avoid confusion. Since you are getting … Read more

Unkown meta_value in ACF

For every meta value saved there is a second row prefixed with _ that stores what field definition this value refers to. Do not delete it. Your example additionally is a repeater which makes it more complex but the docs has a nice explanation: $ParentName_$RowNumber_$ChildName So you have a repeater field called carousel which has … Read more