@@ 1298-1317 (lines=20) @@ | ||
1295 | } |
|
1296 | ||
1297 | // Post Meta |
|
1298 | if ( ! empty( PodsMeta::$post_types ) ) { |
|
1299 | $sql = " |
|
1300 | DELETE `rel` |
|
1301 | FROM `@wp_postmeta` AS `rel` |
|
1302 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
1303 | ON |
|
1304 | `p`.`post_type` = '_pods_field' |
|
1305 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
1306 | ON |
|
1307 | `pm`.`post_id` = `p`.`ID` |
|
1308 | AND `pm`.`meta_key` = 'type' |
|
1309 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
1310 | WHERE |
|
1311 | `p`.`ID` IS NOT NULL |
|
1312 | AND `pm`.`meta_id` IS NOT NULL |
|
1313 | AND `rel`.`meta_key` = `p`.`post_name` |
|
1314 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
1315 | ||
1316 | pods_query( $sql, false ); |
|
1317 | } |
|
1318 | ||
1319 | // User Meta |
|
1320 | if ( ! empty( PodsMeta::$user ) ) { |
|
@@ 1320-1339 (lines=20) @@ | ||
1317 | } |
|
1318 | ||
1319 | // User Meta |
|
1320 | if ( ! empty( PodsMeta::$user ) ) { |
|
1321 | $sql = " |
|
1322 | DELETE `rel` |
|
1323 | FROM `@wp_usermeta` AS `rel` |
|
1324 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
1325 | ON |
|
1326 | `p`.`post_type` = '_pods_field' |
|
1327 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
1328 | ON |
|
1329 | `pm`.`post_id` = `p`.`ID` |
|
1330 | AND `pm`.`meta_key` = 'type' |
|
1331 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
1332 | WHERE |
|
1333 | `p`.`ID` IS NOT NULL |
|
1334 | AND `pm`.`meta_id` IS NOT NULL |
|
1335 | AND `rel`.`meta_key` = `p`.`post_name` |
|
1336 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
1337 | ||
1338 | pods_query( $sql, false ); |
|
1339 | } |
|
1340 | ||
1341 | // Comment Meta |
|
1342 | if ( ! empty( PodsMeta::$comment ) ) { |
|
@@ 1342-1361 (lines=20) @@ | ||
1339 | } |
|
1340 | ||
1341 | // Comment Meta |
|
1342 | if ( ! empty( PodsMeta::$comment ) ) { |
|
1343 | $sql = " |
|
1344 | DELETE `rel` |
|
1345 | FROM `@wp_commentmeta` AS `rel` |
|
1346 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
1347 | ON |
|
1348 | `p`.`post_type` = '_pods_field' |
|
1349 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
1350 | ON |
|
1351 | `pm`.`post_id` = `p`.`ID` |
|
1352 | AND `pm`.`meta_key` = 'type' |
|
1353 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
1354 | WHERE |
|
1355 | `p`.`ID` IS NOT NULL |
|
1356 | AND `pm`.`meta_id` IS NOT NULL |
|
1357 | AND `rel`.`meta_key` = `p`.`post_name` |
|
1358 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
1359 | ||
1360 | pods_query( $sql, false ); |
|
1361 | } |
|
1362 | } |
|
1363 | ||
1364 | /** |