//replace glyphicon icon with v6 font awesome icons for default main menu items
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-house' where menu_item_icon = 'glyphicon-home' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-user' where menu_item_icon = 'glyphicon-user' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-right-left' where menu_item_icon = 'glyphicon-transfer' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-paper-plane' where menu_item_icon = 'glyphicon-send' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-chart-column' where menu_item_icon = 'glyphicon-equalizer' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-gear' where menu_item_icon = 'glyphicon-cog' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-right-from-bracket' where menu_item_icon = 'glyphicon-log-out' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-right-to-bracket' where menu_item_icon = 'glyphicon-log-in' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-up-right-from-square' where menu_item_icon = 'glyphicon-new-window' ";
//replace v5.x font awesome icons with v6.x icons for default main menu items
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-house' where menu_item_icon = 'fa-home' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-user' where menu_item_icon = 'fa-user' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-right-left' where menu_item_icon = 'fa-exchange-alt' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-paper-plane' where menu_item_icon = 'fa-paper-plane' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-chart-column' where menu_item_icon = 'fa-chart-bar' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-gear' where menu_item_icon = 'fa-cog' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-right-from-bracket' where menu_item_icon = 'fa-sign-out-alt' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-right-to-bracket' where menu_item_icon = 'fa-sign-in-alt' ";
$queries[]="update v_menu_items set menu_item_icon = 'fa-solid fa-up-right-from-square' where menu_item_icon = 'fa-external-link-alt' ";
//convert button and other icons in default/domain/user settings to use v6.x font awesome style class prefixes (e.g. 'fa-solid ' instead of 'fas ')
foreach(['default','domain','user']as$type){
$queries[]="update v_".$type."_settings set ".$type."_setting_value = replace(".$type."_setting_value, 'fas ', 'fa-solid ') where ".$type."_setting_category = 'theme' and ".$type."_setting_subcategory like 'button_icon_%' ";
$queries[]="update v_".$type."_settings set ".$type."_setting_value = concat('fa-solid fa-', ".$type."_setting_value) where ".$type."_setting_category = 'theme' and ".$type."_setting_subcategory like 'body_header_icon_%' and ".$type."_setting_value not like 'fa-solid fa-%' and ".$type."_setting_value not like 'fa-regular fa-%' and ".$type."_setting_value not like 'fa-brands fa-%' ";
$queries[]="update v_".$type."_settings set ".$type."_setting_value = concat('fa-solid fa-', ".$type."_setting_value) where ".$type."_setting_category = 'theme' and ".$type."_setting_subcategory like 'menu_side_item_main_sub_icon_%' and ".$type."_setting_name = 'text' and ".$type."_setting_value not like 'fa-solid fa-%' and ".$type."_setting_value not like 'fa-regular fa-%' and ".$type."_setting_value not like 'fa-brands fa-%' ";