@@ 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 | /** |