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