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