function jquerymenu_update_1 in JQuery menu 7

Same name and namespace in other branches

1. 7.4 jquerymenu.install \jquerymenu_update_1()
2. 7.2 jquerymenu.install \jquerymenu_update_1()
3. 7.3 jquerymenu.install \jquerymenu_update_1()

File

./jquerymenu.install, line 28

Code

function jquerymenu_update_1() {

  // This is a one time cleanup to remove blocks and menus that have gotten out of sync.
  // This update will reset blocks that were created directly by jquery menu
  // you will need to visit the blocks page after running this to re-enable those blocks.
  $result = db_query("SELECT mid, menu_name FROM {jquerymenus}");
  $enabledmenus = array();
  while ($enabled = db_fetch_object($result)) {
    $title = '';
    $title = db_result(db_query("SELECT title FROM {menu_custom} WHERE menu_name = '%s'", $enabled->menu_name));
    if (empty($title)) {
      db_query("DELETE FROM {jquerymenus} WHERE menu_name = '%s'", $enabled->menu_name);
      db_query("DELETE FROM {blocks} WHERE module = 'jquerymenu'");
    }
  }
}