<?php
//October 13, 2006

//Variables for connections
global $milionic_connection;
global $ss_connection;


//Function to establish a connection to the Milonic menu database
function connectToMilonic()
{
   global $milionic_connection;
   //Connect to the milonic server
   $milionic_connection = mysql_connect ("servername", "username", "password") or die ('I cannot connect to the database because: ' . mysql_error());

   //select the milionic database
   mysql_select_db ("milonic_database");

}

//Function to terminate the connection to the milonic database
function closeMilonic()
{
   //Close the MySQL connection
   global $milionic_connection;
   mysql_close($milionic_connection);
}

//Function to establish a connection to the shop script database
function connectToShopScript()
{
   global $ss_connection;
   //connect to the shop script server
   $ss_connection=mysql_connect ("servername", "username", "password") or die ('I cannot connect to the database because: ' . mysql_error());

   //select the shop script database
   mysql_select_db("database");
}

//Function to terminate the connection to the shop script database
function closeShopScript()
{
   //Close the MySQL connection
   global $ss_connection;
   mysql_close($ss_connection);
}

//Function to build the menu tree for the passed in category ID
//Note: when this function is called, connection is to milonic DB
function buildMenuTree($ssMenuRowsResult, $name, $menuID, $categoryID)
{
   while ($array = mysql_fetch_array($ssMenuRowsResult))
   {
      $SSCategoryID = $array['categoryID'];
      $SSName   = $array['name'];
      
      closeMilonic();
      connectToShopScript();
      
      $query = "SELECT * FROM SS_categories WHERE parent = '$SSCategoryID'";
      $result = mysql_query($query);
      
      closeShopScript();
      connectToMilonic();
      
      //If there are no subcategories of the current category
      if (mysql_num_rows($result) == 0)
      {
         //Formulate the URL for the menu_item
         $url = "index.php?categoryID=";
         $url .= $SSCategoryID;
         
         //Insert the current category into the milonic database as an item
         $query = "INSERT INTO mm_items SET menuid = '$menuID',text = '$SSName', url='$url'";
         $insertResult = mysql_query($query);
      }
      else   //There are subitems, so need a menu and a menuitem
      {
         //Insert the current category into the milonic database as a menu
         $insert = "INSERT INTO mm_menus SET projectid='1', styleid='1', name='$SSName'";
         $insertResult = mysql_query($insert);
         
         $newMenuID = mysql_insert_id();
         
         //Formulate the URL
         $url = "index.php?categoryID=";
         $url .= $SSCategoryID;
         
         //Insert the current category into the milonic database as an item
         $query = "INSERT INTO mm_items SET menuid = '$menuID',text = '$SSName', url='$url', showmenu='$SSName'";
         $insertResult = mysql_query($query);
         

                        //For each subitem, build a menu tree for it (recursive call)
         while ($line = mysql_fetch_array($result))
         {
            $newName = $line['name'];
            $newCategoryID = $line['categoryID'];
         
            buildMenuTree($result, $newName, $newMenuID, $newCategoryID);
         }
      }
   }
}

//Connect to the Milonic DB
connectToMilonic();

//empty the mm_menus table
$query = "TRUNCATE mm_menus";
$result = mysql_query($query);

//empty the mm_items table
$query = "TRUNCATE mm_items";
$result = mysql_query($query);

//always insert this first into the mm_menus table (1,1,Main Menu,1,0,NULL)
//This is because you ALWAYS need a "Main Menu" entry for it to work
$query = "INSERT INTO mm_menus SET projectid='1', styleid='1', name='Main Menu', alwaysvisible='1',orientation='0', position='relative', menuwidth='100%'";
$result = mysql_query($query);

//insert  into mm_menus table(1,1,Home,NULL,NULL,NULL)
//This is for the top link
$query = "INSERT INTO mm_menus SET projectid='1', styleid='1', name='Home'";
$result = mysql_query($query);
$query = "INSERT INTO mm_items SET menuid='1', text='Home', url='index.php'";
$result = mysql_query($query);


//insert into mm_menus table (1,1,News,NULL,NULL,NULL)
//This is for the News link that is unique to SS
$query = "INSERT INTO mm_menus SET projectid='1', styleid='1', name='News'";
$result = mysql_query($query);
$query = "INSERT INTO mm_items SET menuid='1', text='News', url='index.php?news=yes'";
$result = mysql_query($query);

//close the milionic connection
closeMilonic();

//Connect to SS
connectToShopScript();

//get out of the shop script database that have a parent of 1, this will be the root menu
$query = "SELECT categoryID,name FROM SS_categories WHERE parent = '1'";
$result = mysql_query($query);

//close the shop script connection
closeShopScript();

//connect to the milonic database
connectToMilonic();

//insert what you got out of the shop script database into mm_menus table
while($array = mysql_fetch_array($result))
{
   $categoryID = $array['categoryID'];
   $name = $array['name'];
   $url = "index.php?categoryID=";
   $url .= $categoryID;
   //insert into mm_menus table (1,1,$name,NULL,NULL,NULL)
   $query = "INSERT INTO mm_menus SET projectid='1', styleid='1', name='$name'";   
   $myResult = mysql_query($query);
   
   $menuID = mysql_insert_id();
   
   closeMilonic();
   connectToShopScript();
   
        //Check to see if there are any submenus for the current category
   $query = "SELECT * FROM SS_categories WHERE parent = '$categoryID'";
   $ssResult = mysql_query($query);
   
   closeShopScript();
   connectToMilonic();
   
        //If no subcategories, then just insert a menu item
   if (mysql_num_rows($ssResult) == 0)
   {
      $query = "INSERT INTO mm_items SET menuid='1', text='$name',url='$url'";
      $itemsResult = mysql_query($query);
   }
   else  //Else, insert a menu and menu item and do the recursive call
   {
      $query = "INSERT INTO mm_items SET menuid='1', text='$name',showmenu='$name',url='$url'";
      $itemsResult = mysql_query($query);
      
      //Now, call a function to build the menu items for this category ID
      //Pass in $ssResult, $name, $menuid and $categoryID
      buildMenuTree($ssResult, $name, $menuID, $categoryID);
   }
}

/**********************************************************
  The last 3 inserts are 3 unique links added to the bottom of main menu
***********************************************************/

//insert into mm_menus (1,1,Site Credits,NULL,NULL,NULL)
$query = "INSERT INTO mm_menus SET projectid='1', styleid='1', name='Site Credits'";
$result = mysql_query($query);
$query = "INSERT INTO mm_items SET menuid='1', text='Site Credits', url='index.php?show_aux_page=14'";
$result = mysql_query($query);


//insert into mm_menus (1,1,M/A Com Parts,NULL,NULL,NULL)
$query = "INSERT INTO mm_menus SET projectid='1', styleid='1', name='M/A Com Parts'";
$result = mysql_query($query);
$query = "INSERT INTO mm_items SET menuid='1', text='M/A Com Parts', url='index.php?show_aux_page=10'";
$result = mysql_query($query);

//insert into mm_menus (1,1,NLT Repair Depot,NULL,NULL,NULL)
$query = "INSERT INTO mm_menus SET projectid='1', styleid='1', name='NLT Repair Depot'";
$result = mysql_query($query);
$query = "INSERT INTO mm_items SET menuid='1', text='NLT Repair Depot',url='index.php?show_aux_page=11'";
$result = mysql_query($query);

//close the milionic connection
closeMilonic();

//This confirmation is displayed because this script was setup as a "backend" function where the user clicks a button and a new window opens to run this PHP script
echo "Menus Updated Successfully! You may now <a href='javascript:window.close()'>close</a> this window.";

?>