| @@ 1362-1381 (lines=20) @@ | ||
| 1359 | } |
|
| 1360 | ||
| 1361 | // Post Meta |
|
| 1362 | if ( ! empty( PodsMeta::$post_types ) ) { |
|
| 1363 | $sql = " |
|
| 1364 | DELETE `rel` |
|
| 1365 | FROM `@wp_postmeta` AS `rel` |
|
| 1366 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1367 | ON |
|
| 1368 | `p`.`post_type` = '_pods_field' |
|
| 1369 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1370 | ON |
|
| 1371 | `pm`.`post_id` = `p`.`ID` |
|
| 1372 | AND `pm`.`meta_key` = 'type' |
|
| 1373 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1374 | WHERE |
|
| 1375 | `p`.`ID` IS NOT NULL |
|
| 1376 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1377 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1378 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1379 | ||
| 1380 | pods_query( $sql, false ); |
|
| 1381 | } |
|
| 1382 | ||
| 1383 | // User Meta |
|
| 1384 | if ( ! empty( PodsMeta::$user ) ) { |
|
| @@ 1384-1403 (lines=20) @@ | ||
| 1381 | } |
|
| 1382 | ||
| 1383 | // User Meta |
|
| 1384 | if ( ! empty( PodsMeta::$user ) ) { |
|
| 1385 | $sql = " |
|
| 1386 | DELETE `rel` |
|
| 1387 | FROM `@wp_usermeta` AS `rel` |
|
| 1388 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1389 | ON |
|
| 1390 | `p`.`post_type` = '_pods_field' |
|
| 1391 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1392 | ON |
|
| 1393 | `pm`.`post_id` = `p`.`ID` |
|
| 1394 | AND `pm`.`meta_key` = 'type' |
|
| 1395 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1396 | WHERE |
|
| 1397 | `p`.`ID` IS NOT NULL |
|
| 1398 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1399 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1400 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1401 | ||
| 1402 | pods_query( $sql, false ); |
|
| 1403 | } |
|
| 1404 | ||
| 1405 | // Comment Meta |
|
| 1406 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| @@ 1406-1425 (lines=20) @@ | ||
| 1403 | } |
|
| 1404 | ||
| 1405 | // Comment Meta |
|
| 1406 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| 1407 | $sql = " |
|
| 1408 | DELETE `rel` |
|
| 1409 | FROM `@wp_commentmeta` AS `rel` |
|
| 1410 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1411 | ON |
|
| 1412 | `p`.`post_type` = '_pods_field' |
|
| 1413 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1414 | ON |
|
| 1415 | `pm`.`post_id` = `p`.`ID` |
|
| 1416 | AND `pm`.`meta_key` = 'type' |
|
| 1417 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1418 | WHERE |
|
| 1419 | `p`.`ID` IS NOT NULL |
|
| 1420 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1421 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1422 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1423 | ||
| 1424 | pods_query( $sql, false ); |
|
| 1425 | } |
|
| 1426 | } |
|
| 1427 | ||
| 1428 | /** |
|