| @@ 1454-1473 (lines=20) @@ | ||
| 1451 | } |
|
| 1452 | ||
| 1453 | // Post Meta |
|
| 1454 | if ( ! empty( PodsMeta::$post_types ) ) { |
|
| 1455 | $sql = " |
|
| 1456 | DELETE `rel` |
|
| 1457 | FROM `@wp_postmeta` AS `rel` |
|
| 1458 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1459 | ON |
|
| 1460 | `p`.`post_type` = '_pods_field' |
|
| 1461 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1462 | ON |
|
| 1463 | `pm`.`post_id` = `p`.`ID` |
|
| 1464 | AND `pm`.`meta_key` = 'type' |
|
| 1465 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1466 | WHERE |
|
| 1467 | `p`.`ID` IS NOT NULL |
|
| 1468 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1469 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1470 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1471 | ||
| 1472 | pods_query( $sql, false ); |
|
| 1473 | } |
|
| 1474 | ||
| 1475 | // User Meta |
|
| 1476 | if ( ! empty( PodsMeta::$user ) ) { |
|
| @@ 1476-1495 (lines=20) @@ | ||
| 1473 | } |
|
| 1474 | ||
| 1475 | // User Meta |
|
| 1476 | if ( ! empty( PodsMeta::$user ) ) { |
|
| 1477 | $sql = " |
|
| 1478 | DELETE `rel` |
|
| 1479 | FROM `@wp_usermeta` AS `rel` |
|
| 1480 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1481 | ON |
|
| 1482 | `p`.`post_type` = '_pods_field' |
|
| 1483 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1484 | ON |
|
| 1485 | `pm`.`post_id` = `p`.`ID` |
|
| 1486 | AND `pm`.`meta_key` = 'type' |
|
| 1487 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1488 | WHERE |
|
| 1489 | `p`.`ID` IS NOT NULL |
|
| 1490 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1491 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1492 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1493 | ||
| 1494 | pods_query( $sql, false ); |
|
| 1495 | } |
|
| 1496 | ||
| 1497 | // Comment Meta |
|
| 1498 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| @@ 1498-1517 (lines=20) @@ | ||
| 1495 | } |
|
| 1496 | ||
| 1497 | // Comment Meta |
|
| 1498 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| 1499 | $sql = " |
|
| 1500 | DELETE `rel` |
|
| 1501 | FROM `@wp_commentmeta` AS `rel` |
|
| 1502 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1503 | ON |
|
| 1504 | `p`.`post_type` = '_pods_field' |
|
| 1505 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1506 | ON |
|
| 1507 | `pm`.`post_id` = `p`.`ID` |
|
| 1508 | AND `pm`.`meta_key` = 'type' |
|
| 1509 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1510 | WHERE |
|
| 1511 | `p`.`ID` IS NOT NULL |
|
| 1512 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1513 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1514 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1515 | ||
| 1516 | pods_query( $sql, false ); |
|
| 1517 | } |
|
| 1518 | } |
|
| 1519 | ||
| 1520 | /** |
|