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