| @@ 1203-1222 (lines=20) @@ | ||
| 1200 | } |
|
| 1201 | ||
| 1202 | // Post Meta |
|
| 1203 | if ( !empty( PodsMeta::$post_types ) ) { |
|
| 1204 | $sql = " |
|
| 1205 | DELETE `rel` |
|
| 1206 | FROM `@wp_postmeta` AS `rel` |
|
| 1207 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1208 | ON |
|
| 1209 | `p`.`post_type` = '_pods_field' |
|
| 1210 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1211 | ON |
|
| 1212 | `pm`.`post_id` = `p`.`ID` |
|
| 1213 | AND `pm`.`meta_key` = 'type' |
|
| 1214 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1215 | WHERE |
|
| 1216 | `p`.`ID` IS NOT NULL |
|
| 1217 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1218 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1219 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1220 | ||
| 1221 | pods_query( $sql, false ); |
|
| 1222 | } |
|
| 1223 | ||
| 1224 | // User Meta |
|
| 1225 | if ( !empty( PodsMeta::$user ) ) { |
|
| @@ 1225-1244 (lines=20) @@ | ||
| 1222 | } |
|
| 1223 | ||
| 1224 | // User Meta |
|
| 1225 | if ( !empty( PodsMeta::$user ) ) { |
|
| 1226 | $sql = " |
|
| 1227 | DELETE `rel` |
|
| 1228 | FROM `@wp_usermeta` AS `rel` |
|
| 1229 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1230 | ON |
|
| 1231 | `p`.`post_type` = '_pods_field' |
|
| 1232 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1233 | ON |
|
| 1234 | `pm`.`post_id` = `p`.`ID` |
|
| 1235 | AND `pm`.`meta_key` = 'type' |
|
| 1236 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1237 | WHERE |
|
| 1238 | `p`.`ID` IS NOT NULL |
|
| 1239 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1240 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1241 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1242 | ||
| 1243 | pods_query( $sql, false ); |
|
| 1244 | } |
|
| 1245 | ||
| 1246 | // Comment Meta |
|
| 1247 | if ( !empty( PodsMeta::$comment ) ) { |
|
| @@ 1247-1266 (lines=20) @@ | ||
| 1244 | } |
|
| 1245 | ||
| 1246 | // Comment Meta |
|
| 1247 | if ( !empty( PodsMeta::$comment ) ) { |
|
| 1248 | $sql = " |
|
| 1249 | DELETE `rel` |
|
| 1250 | FROM `@wp_commentmeta` AS `rel` |
|
| 1251 | LEFT JOIN `{$wpdb->posts}` AS `p` |
|
| 1252 | ON |
|
| 1253 | `p`.`post_type` = '_pods_field' |
|
| 1254 | LEFT JOIN `{$wpdb->postmeta}` AS `pm` |
|
| 1255 | ON |
|
| 1256 | `pm`.`post_id` = `p`.`ID` |
|
| 1257 | AND `pm`.`meta_key` = 'type' |
|
| 1258 | AND `pm`.`meta_value` IN ( {$file_types} ) |
|
| 1259 | WHERE |
|
| 1260 | `p`.`ID` IS NOT NULL |
|
| 1261 | AND `pm`.`meta_id` IS NOT NULL |
|
| 1262 | AND `rel`.`meta_key` = `p`.`post_name` |
|
| 1263 | AND `rel`.`meta_value` = '{$_ID}'"; |
|
| 1264 | ||
| 1265 | pods_query( $sql, false ); |
|
| 1266 | } |
|
| 1267 | } |
|
| 1268 | ||
| 1269 | /** |
|