| @@ 1281-1300 (lines=20) @@ | ||
| 1278 | } |
|
| 1279 | ||
| 1280 | // Post Meta |
|
| 1281 | if ( ! empty( PodsMeta::$post_types ) ) { |
|
| 1282 | $sql = " |
|
| 1283 | DELETE `rel` |
|
| 1284 | FROM `@wp_postmeta` AS `rel` |
|
| 1285 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1286 | ON |
|
| 1287 | `p`.`post_type` = '_pods_field' |
|
| 1288 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1289 | ON |
|
| 1290 | `pm`.`post_id` = `p`.`ID` |
|
| 1291 | AND `pm`.`meta_key` = 'type' |
|
| 1292 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1293 | WHERE |
|
| 1294 | `p`.`ID` IS NOT NULL |
|
| 1295 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1296 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1297 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1298 | ||
| 1299 | pods_query( $sql, false ); |
|
| 1300 | } |
|
| 1301 | ||
| 1302 | // User Meta |
|
| 1303 | if ( ! empty( PodsMeta::$user ) ) { |
|
| @@ 1303-1322 (lines=20) @@ | ||
| 1300 | } |
|
| 1301 | ||
| 1302 | // User Meta |
|
| 1303 | if ( ! empty( PodsMeta::$user ) ) { |
|
| 1304 | $sql = " |
|
| 1305 | DELETE `rel` |
|
| 1306 | FROM `@wp_usermeta` AS `rel` |
|
| 1307 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1308 | ON |
|
| 1309 | `p`.`post_type` = '_pods_field' |
|
| 1310 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1311 | ON |
|
| 1312 | `pm`.`post_id` = `p`.`ID` |
|
| 1313 | AND `pm`.`meta_key` = 'type' |
|
| 1314 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1315 | WHERE |
|
| 1316 | `p`.`ID` IS NOT NULL |
|
| 1317 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1318 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1319 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1320 | ||
| 1321 | pods_query( $sql, false ); |
|
| 1322 | } |
|
| 1323 | ||
| 1324 | // Comment Meta |
|
| 1325 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| @@ 1325-1344 (lines=20) @@ | ||
| 1322 | } |
|
| 1323 | ||
| 1324 | // Comment Meta |
|
| 1325 | if ( ! empty( PodsMeta::$comment ) ) { |
|
| 1326 | $sql = " |
|
| 1327 | DELETE `rel` |
|
| 1328 | FROM `@wp_commentmeta` AS `rel` |
|
| 1329 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1330 | ON |
|
| 1331 | `p`.`post_type` = '_pods_field' |
|
| 1332 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1333 | ON |
|
| 1334 | `pm`.`post_id` = `p`.`ID` |
|
| 1335 | AND `pm`.`meta_key` = 'type' |
|
| 1336 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1337 | WHERE |
|
| 1338 | `p`.`ID` IS NOT NULL |
|
| 1339 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1340 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1341 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1342 | ||
| 1343 | pods_query( $sql, false ); |
|
| 1344 | } |
|
| 1345 | } |
|
| 1346 | ||
| 1347 | /** |
|