| @@ 1607-1626 (lines=20) @@ | ||
| 1604 | } |
|
| 1605 | ||
| 1606 | // Post Meta |
|
| 1607 | if ( ! empty( PodsMeta::$post_types ) ) { |
|
| 1608 | $sql = " |
|
| 1609 | DELETE `rel` |
|
| 1610 | FROM `@wp_postmeta` AS `rel` |
|
| 1611 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1612 | ON |
|
| 1613 | `p`.`post_type` = '_pods_field' |
|
| 1614 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1615 | ON |
|
| 1616 | `pm`.`post_id` = `p`.`ID` |
|
| 1617 | AND `pm`.`meta_key` = 'type' |
|
| 1618 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1619 | WHERE |
|
| 1620 | `p`.`ID` IS NOT NULL |
|
| 1621 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1622 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1623 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1624 | ||
| 1625 | pods_query( $sql, false ); |
|
| 1626 | } |
|
| 1627 | ||
| 1628 | // User Meta |
|
| 1629 | if ( ! empty( PodsMeta::$user ) ) { |
|
| @@ 1629-1648 (lines=20) @@ | ||
| 1626 | } |
|
| 1627 | ||
| 1628 | // User Meta |
|
| 1629 | if ( ! empty( PodsMeta::$user ) ) { |
|
| 1630 | $sql = " |
|
| 1631 | DELETE `rel` |
|
| 1632 | FROM `@wp_usermeta` AS `rel` |
|
| 1633 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1634 | ON |
|
| 1635 | `p`.`post_type` = '_pods_field' |
|
| 1636 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1637 | ON |
|
| 1638 | `pm`.`post_id` = `p`.`ID` |
|
| 1639 | AND `pm`.`meta_key` = 'type' |
|
| 1640 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1641 | WHERE |
|
| 1642 | `p`.`ID` IS NOT NULL |
|
| 1643 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1644 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1645 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1646 | ||
| 1647 | pods_query( $sql, false ); |
|
| 1648 | } |
|
| 1649 | ||
| 1650 | // Comment Meta |
|
| 1651 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| @@ 1651-1670 (lines=20) @@ | ||
| 1648 | } |
|
| 1649 | ||
| 1650 | // Comment Meta |
|
| 1651 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| 1652 | $sql = " |
|
| 1653 | DELETE `rel` |
|
| 1654 | FROM `@wp_commentmeta` AS `rel` |
|
| 1655 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1656 | ON |
|
| 1657 | `p`.`post_type` = '_pods_field' |
|
| 1658 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1659 | ON |
|
| 1660 | `pm`.`post_id` = `p`.`ID` |
|
| 1661 | AND `pm`.`meta_key` = 'type' |
|
| 1662 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1663 | WHERE |
|
| 1664 | `p`.`ID` IS NOT NULL |
|
| 1665 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1666 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1667 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1668 | ||
| 1669 | pods_query( $sql, false ); |
|
| 1670 | } |
|
| 1671 | } |
|
| 1672 | ||
| 1673 | /** |
|