| 1 |
<?php |
| 2 |
|
| 3 |
namespace BitCode\BitForm\Core\Fallback; |
| 4 |
|
| 5 |
class EntryMetaFallback |
| 6 |
{ |
| 7 |
public function removeAllDuplicateMetaKeysExceptLast() |
| 8 |
{ |
| 9 |
global $wpdb; |
| 10 |
$tablename = $wpdb->prefix . 'bitforms_form_entrymeta'; |
| 11 |
$sql = $wpdb->query("DELETE a FROM $tablename AS a |
| 12 |
JOIN ( |
| 13 |
SELECT bitforms_form_entry_id, meta_key, MAX(meta_id) AS max_id |
| 14 |
FROM $tablename |
| 15 |
GROUP BY bitforms_form_entry_id, meta_key |
| 16 |
) AS b |
| 17 |
ON a.bitforms_form_entry_id = b.bitforms_form_entry_id AND a.meta_key = b.meta_key |
| 18 |
WHERE a.meta_id != b.max_id; |
| 19 |
"); |
| 20 |
} |
| 21 |
} |
| 22 |
|
