#1992 closed defect (bug) (fixed)
Need function to delete usermeta key/value pairs
| Reported by: | skippy | Owned by: | |
|---|---|---|---|
| Priority: | high | Milestone: | |
| Component: | Administration | Version: | 2.0 |
| Severity: | normal | Keywords: | usermeta bg|needs-patch |
| Cc: | Focuses: |
Description
There exists no function to delete a usermeta key/value pair.
Change History (3)
Note:
See TracTickets
for help on using tickets.
![(please configure the [header_logo] section in trac.ini)](/chrome/site/your_project_logo.png)
Something like this?
function remove_usermeta_pair ( $user_id, $meta_key, $meta_value ) { global $wpdb; if ( !is_numeric( $user_id ) ) return false; $meta_key = preg_replace('|[^a-z0-9_]|i', '', $meta_key); if ( is_array($meta_value) || is_object($meta_value) ) $meta_value = serialize($meta_value); $meta_value = trim( $meta_value ); if ( '' == $meta_value ) return false; $wpdb->query("DELETE FROM $wpdb->usermeta WHERE user_id = '$user_id' AND meta_key = '$meta_key' AND meta_value = '$meta_value'"); }