
WordPress数据库初学者指南
_wp_delete_orphaned_draft_menu_items ( No parameters )
_wp_delete_orphaned_draft_menu_items: 这个函数用来删除WordPress中无主的草稿菜单项。菜单项是用来在WordPress网站上创建导航菜单的。被遗弃的菜单项是已经创建但从未保存或发布的菜单项。
删除无主菜单项目
function _wp_delete_orphaned_draft_menu_items() { global $wpdb; $delete_timestamp = time() - ( DAY_IN_SECONDS * EMPTY_TRASH_DAYS ); // Delete orphaned draft menu items. $menu_items_to_delete = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM $wpdb->posts AS p LEFT JOIN $wpdb->postmeta AS m ON p.ID = m.post_id WHERE post_type = 'nav_menu_item' AND post_status = 'draft' AND meta_key = '_menu_item_orphaned' AND meta_value < %d", $delete_timestamp ) ); foreach ( (array) $menu_items_to_delete as $menu_item_id ) { wp_delete_post( $menu_item_id, true ); } }