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