You probably would have to use a script which would have to be referenced in your crontab. The problem is to calculate the final value of the popularity for each post, but if you apply the funcion the right way in the PHP script, the UPDATE operation on your MySQL database should work nicely.
Here you’ve got a discussion on how to apply that kind of operation (though the final values are easier to get) and there was a good discussion on this subject on StackOverflow sometime ago.
Related Posts:
- How to get all term meta for a taxonomy – getting term_meta for taxonomy
- Short of raw SQL, can I query for multiple attachment metadata that have a given array key?
- Triple meta_key on custom SELECT query
- Get updated post meta on save_post action?
- MySQL Query To Select Post By Postmeta
- Set Condition echo function get_post_meta
- Get a row from a separate table by matching a posts meta_key to a tables ID column
- Compare string with post id in wpdb and do stuff when match is found
- Read post meta values, only if posts are public
- How to test the outcome of a wpdb query?
- wpdb->get_var – count author posts, meta value
- Display current ranking of post as a number in post title
- get specific values from WordPress meta_value
- Get data from custom table and update relative post_meta based on meta_key
- Get table parameter and save in meta value
- Exclude category from DB query
- Fetching array of postmeta with $wpdb and in_array conditional
- Which query method to use? (edit- wpdb syntax problems)
- Cache metadata for set of posts
- How to get all the related ids without array?
- Get posts by meta value
- How get post id from meta value
- Safe to delete blank postmeta?
- advanced custom fields update_field for field type: Taxonomy
- update_post_meta not saving when value is zero
- Restrict post edit/delete based on user ID and custom field
- Remove post meta keys
- delete unused postmeta
- List posts under meta_value heading
- Using Advanced Custom Field (ACF) to insert meta description on each page
- How to add meta tag to wordpress posts filter?
- Correct processing of `$_POST`, following WordPress Coding Standards
- Metabox Data not being saved [closed]
- Options to get my custom post type metadata via the WordPress API
- Generate an Email address from that of the Post Author
- How to get the total number of meta_values based on a custom post type?
- Saving html into postmeta without stripping tags – safe?
- Does “update_post_meta” check if value is the same before updating?
- Add a meta value if admin , editor or any other user have open a post in edit mode
- Finding the page id
- WP_POSTMETA – What do these values mean inside the data structure?
- Update Line Item Meta Data – WooCommerce API
- “update_post_meta” not working in “wp_insert_post_data” hook
- Unset field from an array not working as expected
- Update post_meta with WooCommere variation data
- What type of index should I use for postmeta?
- How to create a meta_query to get all posts with a specific meta data?
- Meta function issue
- get_post_meta is showing file url in url bar
- get_post_meta not extracting title,permalink and posttype
- Save post meta foreach loop
- How to check if a post meta key/value pair already exists for a specific post
- WordPress query posts with multiple post_meta data
- Reset/delete post views meta/custom field after X hours or minutes or seconds
- Difficultly changing date format in post meta value
- Remove last character in get_post_meta
- Have lots of meta for posts, is it better to get at all at once or each individually
- Query posts WITHOUT a custom meta field
- How to obtain a group of post meta and assign each meta to other variables?
- Add box with custom per-page properties
- how to get serialized post meta
- get_post_meta not working when variable used for post ID
- Update post meta dynamically
- update_post_meta in loop changing ALL values
- Is it safe to add a new field to meta_value field?
- Need a SQL query to update meta_key=’_price’ with value in meta_key=’_regular_price’
- Display current user’s custom post meta in sidebar
- add_post_meta doesn’t work
- How to get single value from get_post_meta() array of values?
- How can I use ‘orderby’ => ‘meta_value_num’ to order by the numerical value even if the value starts with a word?
- wordpress update multiple posts post meta
- get_template_part() isn’t loading author information
- get Insert id for meta field
- Add post’s category as a meta tag to the post
- How can I query for posts using a date stored in post-meta?
- Is duplicate `_wp_attachment_image_alt` meta key allowed?
- How can i set media attachments to the author of the post or page for already existed posts with attachments
- How to get posts by meta value as multi-dimensional array?
- How to securely controlling data without keeping it in postmeta?
- Add post meta data date to event
- How to modify default meta link format
- Something adding an excessive meta description
- how to query posts using value in meta post array
- Why doesn’t wp_oembed_get() for the video post format not work?
- Custom Meta Fields that are Echo’d are removed on post update?
- How to add dynamic content in title and meta description in wordpress theme for homepage, post page, category, tag and pages
- How to call get_post()?
- Use $wpdb->get_results with filter based on array
- add_post_meta only adding 1 character
- Update event post meta each day automaticaly
- Advanced Custom Field — grabbing post_meta from previous post
- Posts with no meta field do not appear when sorting by meta field
- How do I delete element from a serialized array upon deletion of a post?
- How to create a link for wordpress meta datas?
- Get meta information from post parent
- Counting number of identical meta keys
- wp_postmeta store multiple values in one key [closed]
- query with custom field
- Using Form to alter PHP variable [closed]
- Chance post id into post name