| @@ 1398-1417 (lines=20) @@ | ||
| 1395 | } |
|
| 1396 | ||
| 1397 | // Post Meta |
|
| 1398 | if ( ! empty( PodsMeta::$post_types ) ) { |
|
| 1399 | $sql = " |
|
| 1400 | DELETE `rel` |
|
| 1401 | FROM `@wp_postmeta` AS `rel` |
|
| 1402 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1403 | ON |
|
| 1404 | `p`.`post_type` = '_pods_field' |
|
| 1405 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1406 | ON |
|
| 1407 | `pm`.`post_id` = `p`.`ID` |
|
| 1408 | AND `pm`.`meta_key` = 'type' |
|
| 1409 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1410 | WHERE |
|
| 1411 | `p`.`ID` IS NOT NULL |
|
| 1412 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1413 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1414 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1415 | ||
| 1416 | pods_query( $sql, false ); |
|
| 1417 | } |
|
| 1418 | ||
| 1419 | // User Meta |
|
| 1420 | if ( ! empty( PodsMeta::$user ) ) { |
|
| @@ 1420-1439 (lines=20) @@ | ||
| 1417 | } |
|
| 1418 | ||
| 1419 | // User Meta |
|
| 1420 | if ( ! empty( PodsMeta::$user ) ) { |
|
| 1421 | $sql = " |
|
| 1422 | DELETE `rel` |
|
| 1423 | FROM `@wp_usermeta` AS `rel` |
|
| 1424 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1425 | ON |
|
| 1426 | `p`.`post_type` = '_pods_field' |
|
| 1427 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1428 | ON |
|
| 1429 | `pm`.`post_id` = `p`.`ID` |
|
| 1430 | AND `pm`.`meta_key` = 'type' |
|
| 1431 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1432 | WHERE |
|
| 1433 | `p`.`ID` IS NOT NULL |
|
| 1434 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1435 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1436 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1437 | ||
| 1438 | pods_query( $sql, false ); |
|
| 1439 | } |
|
| 1440 | ||
| 1441 | // Comment Meta |
|
| 1442 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| @@ 1442-1461 (lines=20) @@ | ||
| 1439 | } |
|
| 1440 | ||
| 1441 | // Comment Meta |
|
| 1442 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| 1443 | $sql = " |
|
| 1444 | DELETE `rel` |
|
| 1445 | FROM `@wp_commentmeta` AS `rel` |
|
| 1446 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1447 | ON |
|
| 1448 | `p`.`post_type` = '_pods_field' |
|
| 1449 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1450 | ON |
|
| 1451 | `pm`.`post_id` = `p`.`ID` |
|
| 1452 | AND `pm`.`meta_key` = 'type' |
|
| 1453 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1454 | WHERE |
|
| 1455 | `p`.`ID` IS NOT NULL |
|
| 1456 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1457 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1458 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1459 | ||
| 1460 | pods_query( $sql, false ); |
|
| 1461 | } |
|
| 1462 | } |
|
| 1463 | ||
| 1464 | /** |
|