| @@ 1324-1343 (lines=20) @@ | ||
| 1321 | } |
|
| 1322 | ||
| 1323 | // Post Meta |
|
| 1324 | if ( ! empty( PodsMeta::$post_types ) ) { |
|
| 1325 | $sql = " |
|
| 1326 | DELETE `rel` |
|
| 1327 | FROM `@wp_postmeta` AS `rel` |
|
| 1328 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1329 | ON |
|
| 1330 | `p`.`post_type` = '_pods_field' |
|
| 1331 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1332 | ON |
|
| 1333 | `pm`.`post_id` = `p`.`ID` |
|
| 1334 | AND `pm`.`meta_key` = 'type' |
|
| 1335 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1336 | WHERE |
|
| 1337 | `p`.`ID` IS NOT NULL |
|
| 1338 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1339 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1340 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1341 | ||
| 1342 | pods_query( $sql, false ); |
|
| 1343 | } |
|
| 1344 | ||
| 1345 | // User Meta |
|
| 1346 | if ( ! empty( PodsMeta::$user ) ) { |
|
| @@ 1346-1365 (lines=20) @@ | ||
| 1343 | } |
|
| 1344 | ||
| 1345 | // User Meta |
|
| 1346 | if ( ! empty( PodsMeta::$user ) ) { |
|
| 1347 | $sql = " |
|
| 1348 | DELETE `rel` |
|
| 1349 | FROM `@wp_usermeta` AS `rel` |
|
| 1350 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1351 | ON |
|
| 1352 | `p`.`post_type` = '_pods_field' |
|
| 1353 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1354 | ON |
|
| 1355 | `pm`.`post_id` = `p`.`ID` |
|
| 1356 | AND `pm`.`meta_key` = 'type' |
|
| 1357 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1358 | WHERE |
|
| 1359 | `p`.`ID` IS NOT NULL |
|
| 1360 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1361 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1362 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1363 | ||
| 1364 | pods_query( $sql, false ); |
|
| 1365 | } |
|
| 1366 | ||
| 1367 | // Comment Meta |
|
| 1368 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| @@ 1368-1387 (lines=20) @@ | ||
| 1365 | } |
|
| 1366 | ||
| 1367 | // Comment Meta |
|
| 1368 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| 1369 | $sql = " |
|
| 1370 | DELETE `rel` |
|
| 1371 | FROM `@wp_commentmeta` AS `rel` |
|
| 1372 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1373 | ON |
|
| 1374 | `p`.`post_type` = '_pods_field' |
|
| 1375 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1376 | ON |
|
| 1377 | `pm`.`post_id` = `p`.`ID` |
|
| 1378 | AND `pm`.`meta_key` = 'type' |
|
| 1379 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1380 | WHERE |
|
| 1381 | `p`.`ID` IS NOT NULL |
|
| 1382 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1383 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1384 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1385 | ||
| 1386 | pods_query( $sql, false ); |
|
| 1387 | } |
|
| 1388 | } |
|
| 1389 | ||
| 1390 | /** |
|