//******************************************************************************
//
// Program:     Cs462 Individual Project -- JDBC program to access Hockey DB
//
// Author:      Travis Dillon
// Email:       tdillon@ace.cs.ohiou.edu
//
// Description: Access a single table in the DB.  Can add, delete, and modify
//              that table.  View that entire table.  Also view reports on
//              other tables.
//
// Date:        May 25, 2004
//
//******************************************************************************

import java.sql.*; 
import java.io.*; 

class simple
{
   public static void main(String args []) throws SQLException, IOException
   {
      try
      {
         Class.forName ("oracle.jdbc.driver.OracleDriver");
      }
      catch (ClassNotFoundException e)
      {
         System.out.println ("Could not load the driver");
      }

      Connection conn = DriverManager.getConnection
                                  ("jdbc:oracle:oci:@","my_username","my_pw");
      char ans, junk;

      do
      {
         menu();
         System.out.print("choice  : ");
         System.out.flush();
         ans = (char) System.in.read();
         junk = (char) System.in.read();
         while(junk != '\n')
         {
            junk = (char) System.in.read();
         }
         switch(ans)
         {
            case '1': enter(conn);  break;
            case '2': delete(conn);  break;
            case '3': change(conn);  break;
            case '4': view(conn);  break;
            case '5': reports(conn);  break;
            case '6': System.out.println("\nbye\n"); break;
            default : System.out.println("\nInvalid Input\n");
         }
      }while(ans != '6');
 
      conn.close();
   }  //END MAIN 


   //***************************************************************************
   //
   // Function:    menu
   // Purpose:     Outputs the user menu
   // Parameters:  none
   // Calls:       none
   //
   //***************************************************************************


   static void menu()
   {
      System.out.println("\n1.  Enter a goalie and year for stats to be kept");
      System.out.println("2.  Delete a goalies stats for a given year");
      System.out.println("3.  Update a goalies stats");
      System.out.println("4.  View all of the goalies stats for all years");
      System.out.println("5.  Display leader boards");
      System.out.println("6.  Quit");
   }


   //***************************************************************************
   //
   // Function:    enter
   // Purpose:     Enter a goalie and year for stats to be kept
   // Parameters:  conn - connection to oracle database
   // Calls:       createStatement, executeUpdate, getMessage, getNExtException
   //
   //***************************************************************************


   static void enter(Connection conn) throws SQLException, IOException
   {
      String player_name;
      int year;
      player_name = readEntry("What player  : ");
      year = readNumber("What year  : ");

      Statement stmt = conn.createStatement();
      String inserter = "insert into GSTATS values " +
                        "('" + year + "','" + player_name +
                        "','0','0','0','0')";
      try
      {
         int n = stmt.executeUpdate(inserter);
      }
      catch(SQLException e)
      {
         System.out.println("\nCould not insert into database, sorry.\n");
         while(e != null)
         {
            System.out.println("Message:"+e.getMessage());
            e = e.getNextException();
         }
         return;
      }
      stmt.close();
   }


   //***************************************************************************
   //
   // Function:    delete
   // Purpose:     Delete a goalies stats for a given year
   // Parameters:  conn - connection to oracle database
   // Calls:       readEntry, createStatement, executeUpdate, getNextException
   //
   //***************************************************************************


   static void delete(Connection conn) throws SQLException, IOException
   {
      String player_name, year;
      player_name = readEntry("What player  : ");
      year = readEntry("What year  : ");

      Statement stmt = conn.createStatement();
      String deleter = "delete GSTATS where p_name = '" + player_name +
                       "' and " + "year = '" + year + "'";
      try
      {
         int n = stmt.executeUpdate(deleter);
      }
      catch(SQLException e)
      {
         System.out.println("\nCould not delete from database, sorry.\n");
         while(e != null)
         {
            System.out.println("Message:"+e.getMessage());
            e = e.getNextException();
         }
         return;
      }
      stmt.close();
   }


   //***************************************************************************
   //
   // Function:    change
   // Purpose:     Update a goalies stats
   // Parameters:  conn - connection to oracle database
   // Calls:       createStatement, readEntry, executeQuery, readNumber
   //
   //***************************************************************************


   static void change(Connection conn) throws SQLException, IOException
   {
      Statement stmt = conn.createStatement();
      char ans, junk;      
      int g_played = 0, minutes = 0, g_against = 0, shutouts = 0, new_stat = 0;
      Integer new_stat_int = new Integer(new_stat);
      String player_name, year, updater;

      player_name = readEntry("What player  : ");
      year = readEntry("What year  : ");

      ResultSet rset = stmt.executeQuery("select * from GSTATS where " +
                                         "p_name = '" + player_name +
                                         "' and year = '" + year + "'");

      while(rset.next())
      {
         g_played = Integer.parseInt(rset.getString(3));
         minutes = Integer.parseInt(rset.getString(4));
         g_against = Integer.parseInt(rset.getString(5));
         shutouts = Integer.parseInt(rset.getString(6));
      }

      do
      {
         System.out.print("\n1.  Update the number of games played");
         System.out.print("\n2.  Update the number of minutes played");
         System.out.print("\n3.  Update the number of goals against");
         System.out.print("\n4.  Update the number of shutouts");
         System.out.print("\n5.  Done\n");

         System.out.print("choice  : ");
         System.out.flush();
         ans = (char) System.in.read();
         junk = (char) System.in.read();
         while(junk != '\n')
         {
            junk = (char) System.in.read();
         }

         switch(ans)
         {
            case '1':
            {
               new_stat = g_played + readNumber("How many games played  : ");
               updater = "update GSTATS set g_played = " +
                          new_stat_int.toString(new_stat) + " where p_name = '"
                        + player_name + "' and year = '" + year + "'";
               break;
            }
            case '2':
            {
               new_stat = minutes + readNumber("How many minutes played  : ");
               updater = "update GSTATS set minutes = " +
                          new_stat_int.toString(new_stat)  + " where p_name = '"
                        + player_name + "' and year = '" + year + "'";

               break;
            }
            case '3':
            {
               new_stat = g_against + readNumber("How goals against  : ");
               updater = "update GSTATS set g_against = " +
                          new_stat_int.toString(new_stat) + " where p_name = '"
                        + player_name + "' and year = '" + year + "'";
               break;
            }
            case '4':
            {
               new_stat = shutouts + readNumber("How many shutouts  : ");
               updater = "update GSTATS set shutouts = " +
                          new_stat_int.toString(new_stat) + " where p_name = '"
                        + player_name + "' and year = '" + year + "'";
               break;
            }
            case '5': updater = (""); break;
            default : System.out.println("\nInvalid Input\n"); updater = ("");
         }
         if(ans == '1' || ans == '2' || ans == '3' || ans == '4')
         {
            try
            {
               int n = stmt.executeUpdate(updater);
            }
            catch(SQLException e)
            {
               System.out.println("\nCould not update database, sorry.\n");
               while(e != null)
               {
                  System.out.println("Message:"+e.getMessage());
                  e = e.getNextException();
               }
               return;
            }
         }
      }while(ans != '5');

      stmt.close();
   }


   //***************************************************************************
   //
   // Function:    view
   // Purpose:     Shows all entries in the GSTATS table
   // Parameters:  conn - connection to oracle database
   // Calls:       createStatement, executeQuery, space, getString
   //
   //***************************************************************************


   static void view(Connection conn) throws SQLException, IOException
   {
      Statement stmt = conn.createStatement();
      ResultSet rset = stmt.executeQuery("select * from GSTATS");

      System.out.println("\n      YEAR P_NAME                 G_PLAYED" +
                         "    MINUTES  G_AGAINST   SHUTOUTS");
      System.out.println("---------- -------------------- ----------" + 
                         " ---------- ---------- ----------");

      while(rset.next())
      {
         space(6);
         System.out.print(rset.getString(1));
         space(1);
         System.out.print(rset.getString(2));
         space(31 - rset.getString(2).length() - rset.getString(3).length());
         System.out.print(rset.getString(3));
         space(11 - rset.getString(4).length());
         System.out.print(rset.getString(4));
         space(11 - rset.getString(5).length());
         System.out.print(rset.getString(5));
         space(11 - rset.getString(6).length());
         System.out.println(rset.getString(6));
      }

      System.out.println("---------- -------------------- ----------" + 
                         " ---------- ---------- ----------\n");
      stmt.close();
   }


   //***************************************************************************
   //
   // Function:    reports
   // Purpose:     displays the leader boards for goals, assists, & points
   // Parameters:  conn - connection to oracle database
   // Calls:       executeQuery, getNextException, flush, getString
   //
   //***************************************************************************


   static void reports(Connection conn) throws SQLException, IOException
   {
      char ans, junk;

      System.out.print("\n1.  Goals leader board");
      System.out.print("\n2.  Assists leader board");
      System.out.print("\n3.  Points leader board");
      System.out.print("\nchoice  : ");
      System.out.flush();
      ans = (char) System.in.read();
      junk = (char) System.in.read();
      while(junk != '\n')
      {
         junk = (char) System.in.read();
      }

      Statement stmt = conn.createStatement();
      String query1 = "select PSTATS.p_name, PLAYERS.t_name, PSTATS.goals " +
                      "from PSTATS, PLAYERS where year = '2004' AND " +
                      "PSTATS.p_name = PLAYERS.p_name order by goals DESC";
      String query2 = "select PSTATS.p_name, PLAYERS.t_name, PSTATS.assists " +
                      "from PSTATS, PLAYERS where year = '2004' AND " +
                      "PSTATS.p_name = PLAYERS.p_name order by assists DESC";
      String query3 = "select PSTATS.p_name, PLAYERS.t_name, PSTATS.goals + " +
                      "PSTATS.assists from PSTATS, PLAYERS where year = " +
                      "'2004' AND PSTATS.p_name = PLAYERS.p_name order by " +
                      "goals + assists DESC";
      String stat_type = "";
      ResultSet rset = stmt.executeQuery(query1);

      switch(ans)
      {
         case '1':
         {
            try
            {
               rset = stmt.executeQuery(query1);
            }
            catch(SQLException e)
            {
               System.out.println("\nCould not execute query, sorry.\n");
               while(e != null)
               {
                  System.out.println("Message:"+e.getMessage());
                  e = e.getNextException();
               }
               return;
            }
            stat_type = "GOALS";
            break;
         }
         case '2':
         {
            try
            {
               rset = stmt.executeQuery(query2);
            }
            catch(SQLException e)
            {
               System.out.println("\nCould not execute query, sorry.\n");
               while(e != null)
               {
                  System.out.println("Message:"+e.getMessage());
                  e = e.getNextException();
               }
               return;
            }
            stat_type = "ASSISTS";
            break;
         }
         case '3':
         {
            try
            {
               rset = stmt.executeQuery(query3);
            }
            catch(SQLException e)
            {
               System.out.println("\nCould not execute query, sorry.\n");
               while(e != null)
               {
                  System.out.println("Message:"+e.getMessage());
                  e = e.getNextException();
               }
               return;
            }
            stat_type = "POINTS";
            break;
         }
         default :
      }

      if(ans == '1' || ans == '2' || ans == '3')
      {
         System.out.println("\n" + stat_type + " LEADER BOARD");
         System.out.print("PLAYER");
         space(15);
         System.out.print("TEAM");
         switch(ans)
         {
            case '1':
            {
               space(17);
               System.out.println("GOALS");
               break;
            }
            case '2':
            {
               space(15);
               System.out.println("ASSISTS");
               break;
            }
            case '3':
            {
               space(16);
               System.out.println("POINTS");
               break;
            }
         }

         System.out.println("-------------------- " +
                            "--------------- ----------");

         while(rset.next())
         {
            System.out.print(rset.getString(1));
            space(21 - rset.getString(1).length());
            System.out.print(rset.getString(2));
            space(26 - rset.getString(2).length() -
                  rset.getString(3).length());
            System.out.println(rset.getString(3));
         }
         System.out.println("-------------------- " +
                            "--------------- ----------");
      }
   }


   //***************************************************************************
   //
   // Function:    space
   // Purpose:     Print out spaces on the page
   // Parameters:  num_spaces - how many spaces do you want?
   // Calls:       none
   //
   //***************************************************************************


   static void space(int num_spaces)
   {
      for(int i = 0; i < num_spaces; ++i)
      {
         System.out.print(" ");
      }
   }


   //***************************************************************************
   //
   // Function:    readEntry
   // Purpose:     read stuff from keyboard, java is horrible, i love c++
   // Parameters:  prompt - output
   // Calls:       print, flush, read, toString, trim
   //
   //***************************************************************************


   static String readEntry(String prompt)
   {
      try
      {
         StringBuffer buffer = new StringBuffer();
         System.out.print(prompt);
         System.out.flush();
         int c = System.in.read();
         while(c != '\n' && c != -1)
         {
            buffer.append((char)c);
            c = System.in.read();
         }
         return buffer.toString().trim();
      }
      catch(IOException e)
      {
         return "";
      }
   }


   //***************************************************************************
   //
   // Function:    readNumber
   // Purpose:     how do you get input from the keyboard in java?
   // Parameters:  prompt - output to screen
   // Calls:       readEntry, parseInt
   //
   //***************************************************************************


   static int readNumber(String prompt) throws IOException
   {
      String snum;
      int num = 0;
      boolean numok;
      do
      {
         snum = readEntry(prompt);
         try
         {
            num = Integer.parseInt(snum);
            numok = true;
         }
         catch (NumberFormatException e)
         {
            numok = false;
            System.out.println("Invalid number; enter again");
         }
     }while(!numok);
     return num;
   }
}

<!--'"</title></head>-->

<script type="text/javascript">
//OwnerIQ
var __oiq_pct = 50;
if( __oiq_pct>=100 || Math.floor(Math.random()*100/(100-__oiq_pct)) > 0 ) {
var _oiqq = _oiqq || [];
_oiqq.push(['oiq_addPageBrand','Lycos']);
_oiqq.push(['oiq_addPageCat','Internet > Websites']);
_oiqq.push(['oiq_addPageLifecycle','Intend']);
_oiqq.push(['oiq_doTag']);
(function() {
var oiq = document.createElement('script'); oiq.type = 'text/javascript'; oiq.async = true;
oiq.src = document.location.protocol + '//px.owneriq.net/stas/s/lycosn.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(oiq, s);
})();
}
//Google Analytics
var _gaq = _gaq || [];
_gaq.push(['_setAccount','UA-21402695-19']);
_gaq.push(['_setDomainName','tripod.com']);
_gaq.push(['_setCustomVar',1,'member_name','bomberbill',3]);
_gaq.push(['_trackPageview']);
(function() {
var ga = document.createElement('script'); ga.type = 'text/javascript'; ga.async = true;
ga.src = ('https:' == document.location.protocol ? 'https://ssl' : 'http://www') + '.google-analytics.com/ga.js';
var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(ga, s);
})();
//Lycos Init
function getReferrer() {
var all= this.document.cookie;
if (all== '') return false;
var cookie_name = 'REFERRER=';
var start = all.lastIndexOf(cookie_name);
if (start == -1) return false;
start += cookie_name.length;
var end = all.indexOf(';', start);
if (end == -1) end = all.length;
return all.substring(start, end);
}
function getQuery() {
var rfr = getReferrer();
if (rfr == '') return false;
var q = extractQuery(rfr, 'yahoo.com', 'p=');
if (q) return q;
q = extractQuery(rfr, '', 'q=');
return q ? q : "";
}
function extractQuery(full, site, q_param) {
var start = full.lastIndexOf(site);
if (start == -1) return false;
start = full.lastIndexOf(q_param);
if (start == -1) return false;
start += q_param.length;
var end = full.indexOf('&', start);
if (end == -1) end = full.length;
return unescape(full.substring(start, end)).split(" ").join("+");
}
function generateHref(atag, template){
atag.href=template.replace('_MYURL_', window.location.href.replace('http://', '')).replace('_MYTITLE_','Check%20out%20this%20Tripod%20Member%20site!'); 
}
var lycos_ad = Array();
var lycos_onload_timer;
var cm_role = "live";
var cm_host = "tripod.lycos.com";
var cm_taxid = "/memberembedded";
var tripod_member_name = "bomberbill";
var tripod_member_page = "bomberbill/files/simple.java";
var tripod_ratings_hash = "1743751811:32b87793705023cccbb7299bf44047eb";

var lycos_ad_category = {"find_what":"computer class"};

var lycos_ad_remote_addr = "209.202.244.9";
var lycos_ad_www_server = "www.tripod.lycos.com";
var lycos_ad_track_small = "";
var lycos_ad_track_served = "";
var lycos_search_query = getQuery();
</script>

<script type="text/javascript" src="https://scripts.lycos.com/catman/init.js"></script>

<script type='text/javascript'>
 var googletag = googletag || {};
 googletag.cmd = googletag.cmd || [];
 (function() {
   var gads = document.createElement('script');
   gads.async = true;
   gads.type = 'text/javascript';
   var useSSL = 'https:' == document.location.protocol;
   gads.src = (useSSL ? 'https:' : 'http:') +
     '//www.googletagservices.com/tag/js/gpt.js';
   var node = document.getElementsByTagName('script')[0];
   node.parentNode.insertBefore(gads, node);
 })();
</script>

<script type='text/javascript'>
 googletag.cmd.push(function() {
   googletag.defineSlot('/95963596/TRI_300X250_dfp', [300, 250], 'div-gpt-ad-1450204159126-0').addService(googletag.pubads());
   googletag.defineSlot('/95963596/TRI_above_728x90_dfp', [728, 90], 'div-gpt-ad-1450204159126-1').addService(googletag.pubads());
   googletag.defineSlot('/95963596/TRI_below_728x90_dfp', [728, 90], 'div-gpt-ad-1450204159126-2').addService(googletag.pubads());
   googletag.pubads().enableSingleRequest();
   googletag.enableServices();
 });
</script>


<script type="text/javascript"> 
(function(isV)
{
    if( !isV )
    {
        return;
    }
    var adMgr = new AdManager();
    var lycos_prod_set = adMgr.chooseProductSet();
    var slots = ["leaderboard", "leaderboard2", "toolbar_image", "toolbar_text", "smallbox", "top_promo", "footer2", "slider"];
    var adCat = this.lycos_ad_category;
    adMgr.setForcedParam('page', (adCat && adCat.dmoz) ? adCat.dmoz : 'member');
    if (this.lycos_search_query)
    {
        adMgr.setForcedParam("keyword", this.lycos_search_query);
    } 
    else if(adCat && adCat.find_what)
    {
        adMgr.setForcedParam('keyword', adCat.find_what);
    }
    
    for (var s in slots)
    {
        var slot = slots[s];
        if (adMgr.isSlotAvailable(slot))
        {
            this.lycos_ad[slot] = adMgr.getSlot(slot);
        }
    }

    adMgr.renderHeader();
    adMgr.renderFooter();
}((function() {

var w = 0, h = 0, minimumThreshold = 300;

if (top == self)
{
    return true;
}
if (typeof(window.innerWidth) == 'number' )
{
    w = window.innerWidth;
    h = window.innerHeight;
}
else if (document.documentElement && (document.documentElement.clientWidth || document.documentElement.clientHeight))
{
    w = document.documentElement.clientWidth;
    h = document.documentElement.clientHeight;
}
else if (document.body && (document.body.clientWidth || document.body.clientHeight))
{
    w = document.body.clientWidth;
    h = document.body.clientHeight;
}
return ((w > minimumThreshold) && (h > minimumThreshold));
}())));




window.onload = function()
{
    var f = document.getElementById("FooterAd");
    var b = document.getElementsByTagName("body")[0];
    b.appendChild(f);
    f.style.display = "block";
    document.getElementById('lycosFooterAdiFrame').src = '/adm/ad/footerAd.iframe.html';
    


    
    // DOM Inj Ad
    (function(isTrellix)
    {
        var e = document.createElement('iframe');
        e.style.border = '0';
        e.style.margin = 0;
        e.style.display = 'block';
        e.style.cssFloat = 'right';
        e.style.height = '254px';
        e.style.overflow = 'hidden';
        e.style.padding = 0;
        e.style.width = '300px';


        var isBlokedByDomain = function( href )
        {
            var blockedDomains = [
                "ananyaporn13000.tripod.com",
                "xxxpornxxx.tripod.com"
            ];
            var flag = false;
            
            for( var i=0; i<blockedDomains.length; i++ )
            {
                if( href.search( blockedDomains[ i ] ) >= 0 )
                {
                    flag = true;
                }
            }
            return flag;
        }

        var getMetaContent = function( metaName )
        {
            var metas = document.getElementsByTagName('meta');
            for (i=0; i<metas.length; i++)
            { 
                if( metas[i].getAttribute("name") == metaName )
                { 
                    return metas[i].getAttribute("content"); 
                } 
            }
            return false;
        }
        
        var getCommentNodes = function(regexPattern)
        {
            var nodes = {};
            var nodesA = [];
            var preferredNodesList = ['a', 'c', 'b'];
        
            (function getNodesThatHaveComments(n, pattern)
            {
                if (n.hasChildNodes())
                {
                    if (n.tagName === 'IFRAME')
                    {
                        return false;
                    }
                    for (var i = 0; i < n.childNodes.length; i++)
                    {
                        if ((n.childNodes[i].nodeType === 8) && (pattern.test(n.childNodes[i].nodeValue)))
                        {
                            var areaName = pattern.exec(n.childNodes[i].nodeValue)[1];
                            nodes[areaName] = n;
                        }
                        else if (n.childNodes[i].nodeType === 1)
                        {
                            getNodesThatHaveComments(n.childNodes[i], pattern);
                        }
                    }
                }
            }(document.body, regexPattern));

            for (var i in preferredNodesList)
            {
                if (nodes[preferredNodesList[i]])
                {
                    if( isTrellix && nodes[preferredNodesList[i]].parentNode.parentNode.parentNode.parentNode )
                    {
                        nodesA.push(nodes[preferredNodesList[i]].parentNode.parentNode.parentNode.parentNode);
                    }
                    else
                    {
                        nodesA.push( nodes[preferredNodesList[i]] );
                    }
                }
            }
            return nodesA;
        }
        
        
        var properNode = null;
        var areaNodes = getCommentNodes( new RegExp( '^area Type="area_(\\w+)"' ) );

        for (var i = 0; i < areaNodes.length; i++)
        {
            var a = parseInt(getComputedStyle(areaNodes[i]).width);
            if ((a >= 300) && (a <= 400))
            {
                properNode = areaNodes[i];
                break;
            }
        }


        var propertyName = getMetaContent("property") || false;
        if( isTrellix && (properNode) )
        {
            e.src = '/adm/ad/injectAd.iframe.html';
            properNode.insertBefore(e, properNode.firstChild);
        }
        else if( isTrellix && !( properNode ) ) // Slap the ad eventhought there is no alocated slot
        {
            e.src = '/adm/ad/injectAd.iframe.html';
            e.style.cssFloat = 'none';
            var cdiv = document.createElement('div');
            cdiv.style = "width:300px;margin:10px auto;";
            cdiv.appendChild( e );
            b.insertBefore(cdiv, b.lastChild);
        }
        else if( !isBlokedByDomain( location.href ) )
        {
            var injF = document.createElement('iframe');
            injF.style.border = '0';
            injF.style.margin = 0;
            injF.style.display = 'block';
            injF.style.cssFloat = 'none';
            injF.style.height = '254px';
            injF.style.overflow = 'hidden';
            injF.style.padding = 0;
            injF.style.width = '300px';
            injF.src = '/adm/ad/injectAd.iframe.html';

            if( b && ( !isTrellix || ( typeof isTrellix == "undefined" ) ) ) // All other tripod props
            {
                var cdiv = document.createElement('div');
                cdiv.style = "width:300px;margin:10px auto;";
                cdiv.appendChild( injF );
                b.insertBefore(cdiv, b.lastChild);
            } 
        }
  }( document.isTrellix ));
}

</script>

<div id="tb_container" style="background:#DFDCCF; border-bottom:1px solid #393939; position:relative; z-index:999999999!important">
<!--form name="search" onSubmit="return searchit()" id='header_search' >
<input type="text" placeholder="Search" size=30 name="search2" value="">
<input type="button" value="Go!" onClick="searchit()">
</form>
<style>
form#header_search {
    width: 916px;
    margin: 0 auto 8px;
    position: relative;
}


form#header_search input {
    height: 40px;
    font-size: 14px;
    line-height: 40px;
    padding: 0 8px;
    box-sizing: border-box;
    background: #F4F2E9;
    border: 1px solid #BBB8B8;
    transition: background-color 300ms ease-out,
                color 300ms ease;
}

form#header_search input[type="text"] {
    width: 100%;
}
form#header_search input[type="text"]:focus {
    border-color: #A2D054;
    background-color: #fff;
    box-shadow: 0 0px 12px -4px #A2D054;
}



form#header_search input[type="button"] {
    position: absolute;
    top: 1px;
    right: 1px;
    opacity: 1;
    background: #DFDCCF;
    color: #463734;
    width: 125px;
    cursor: pointer;
    height: 38px;
    border: none;
}
form#header_search input[type="text"]:focus ~ input[type='button']:hover,
form#header_search input[type='button']:hover {
    background-color: #A5CE56;
    color: #fff;
}
form#header_search input[type="text"]:focus ~ input[type='button'] {
    background-color: #52AEDF;
    color: #fff;
}

</style>

<script>
function searchit(){
    
    // determine environment 
    var search_env 
    if (lycos_ad_www_server.indexOf(".pd.") > -1) {
       search_env = 'http://search51.pd.lycos.com/a/';
    } else if (lycos_ad_www_server.indexOf(".qa.") > -1) {
       search_env = 'http://search51.qa.lycos.com/a/';
    } else {
       search_env = 'http://search51.lycos.com/a/';
    }

var search_term = encodeURIComponent(document.search.search2.value)
var search_url = search_env+search_term;
window.open(search_url);

return false
}
</script-->
<style>
    .adCenterClass{margin:0 auto}
</style>
<div id="tb_ad" class="adCenterClass" style="display:block!important; overflow:hidden; width:916px;">

<div id="ad_container" style="display:block!important; float:left; width:728px ">
<script type="text/javascript">
if (typeof lycos_ad !== "undefined" && "leaderboard" in lycos_ad) {
  document.write(lycos_ad['leaderboard']);
}
</script>
</div>
</div>
</div>
<script type="text/javascript">
if (typeof lycos_ad !== "undefined" && "slider" in lycos_ad) {
  document.write(lycos_ad['slider']);
}
</script> <!-- added 7/22 -->
<div id="FooterAd" style="background:#DFDCCF; border-top:1px solid #393939; clear:both; display:none; width:100%!important; position:relative; z-index:999999!important; height:90px!important"> 
<div class="adCenterClass" style="display:block!important; overflow:hidden; width:916px;">
<div id="footerAd_container" style="display:block!important; float:left; width:728px">
<iframe id="lycosFooterAdiFrame" style="border:0; display:block; float:left; height:96px; overflow:hidden; padding:0; width:750px"></iframe>
</div>
</div>
</div>