var cookies = {};
var sl = [["mysql","MySQL 5"],["oracle","Oracle"],["sqlserver","Microsoft SQL Server"],["postgres","PostgreSQL"],["ingres","Ingres"],["db2","DB2"]];

var defaultServer = sl[0][2];

var cookie="B Adolescent";
var page = '';
page = page.substr(page.lastIndexOf('/')+1);
page = page.substr(0,page.indexOf('.'));

function nn(tagName,atts,content){
  var n = document.createElement(tagName);
  if (atts)
    for (var a in atts)
      if (a=='style'){
        var s=atts[a].split(/;/);
        for (var i=0;i<s.length;i++){
          var kv = s[i].split(/:/);
          if (kv[0] && kv[1]){
            var wrds = kv[0].split('-');
            if (wrds.length>1){
              kv[0]=wrds[0];
              for (var j=1;j<wrds.length;j++){
                kv[0] += wrds[j].substr(0,1).toUpperCase()+wrds[j].substring(1);
              }
            }
            n.style[kv[0]]=kv[1];
          }
        }
      }else
        n.setAttribute(a,atts[a]);
  if (content)
    for (var i=0;i<content.length;i++)
      if (typeof content[i] == 'string')
        n.appendChild(document.createTextNode(content[i]));
      else
        n.appendChild(content[i]);
  return n;
}

function logClick(){
  var li = this.firstChild;
  this.removeChild(li);
  var bt = nn('input',{type:'button',value:'login',id:'login'});
  var ne = nn('span',{},
    ["User:",nn("input",{name:'usr',size:8,type:'text',value:"",id:'usr'}),
     " Passwd:",nn("input",{name:'passwd',size:8,type:'password',id:'passwd'}),
     bt
    ]);
  this.parentNode.parentNode.appendChild(ne);
  bt.onclick = logn;
}

function logn(){
  var req = mkNewHttpRequest();
  req.onreadystatechange = function(){
    if(req.readyState==4 && req.status==200){
      var r=eval("("+req.responseText+")");
      if (r[0]){
        setCookie('oliver',r[0]);
        setCookie('hash',r[2]);
        window.location.reload();        
      }
      else alert('Sorry.');
    }
  }
  req.open("POST","/cmn/login.pl",true);
  req.setRequestHeader('Content-Type',
                         'application/x-www-form-urlencoded');
  var user = document.getElementById('usr').value;
  var pass = document.getElementById('passwd').value;
  req.send('user='+user+'&pass='+pass);
}

function mkNewHttpRequest(){
  var httpRequest;
  if (window.XMLHttpRequest) { // Mozilla, Safari, ...
    httpRequest = new XMLHttpRequest();
      if (httpRequest.overrideMimeType)
          httpRequest.overrideMimeType('text/xml');
  } else if (window.ActiveXObject) { // IE
    try {
      httpRequest = new ActiveXObject("Msxml2.XMLHTTP");
    } catch (e) {
      try {
        httpRequest = new ActiveXObject("Microsoft.XMLHTTP");
      } catch (e) {}
    }
  }
  return httpRequest;
}

function onL(){
  var konq = navigator.userAgent.match(/Konqueror/);
  var pairs=document.cookie.split(";");
  for(var i=0;i<pairs.length;i++){
    var pairSplit=pairs[i].split("=");
    cookies[trim(pairSplit[0])]=unescape(pairSplit[1]);
  }

  var li = document.getElementById('login');
  if (li){
    var sp = (cookies['hash'])
           ?nn("span",{style:'color:blue;cursor:pointer;'},["Welcome: "+cookies['oliver']])
           :nn("span",{style:'color:blue;cursor:pointer;'},['']);
    li.appendChild(sp);
    sp.onclick = logClick;
  }
  var lo = nn('span',{},[' [',
                nn('span',{title:'Logout and clear text areas.',
                           'style':'color:blue;cursor:pointer;'},
                   ['Forget me']),']']);
  lo.onclick = clearCookies;
  //li.appendChild(lo);
  if (cookies['engine'] && document.forms[0] && document.forms[0].pickServer){
    document.forms[0].pickServer.selectedIndex = 
         Math.min(cookies['engine'],document.forms[0].pickServer.length-1);
  }
  setFormActions();
  if (window.location.search && window.location.search.match('answer')){
    for (var i=0;i<document.forms.length;i++){
      var n = document.forms[i].name.substr(4);
      //alert(document.getElementById("frmans"+n));
      if (document.getElementById && document.getElementById("frmans"+n) &&
          document.forms[i].sql){
        document.forms[i].sql.value =
          er(document.getElementById("frmans"+n).innerHTML);
      }
    }
  }else {
  }
    
}

function setDisplay(e,d){
  if (e.getAttribute("id"))
    e=document.getElementById(e.getAttribute("id"));
  if(e.getAttribute('style').display)
    e.getAttribute('style').display =d;
  else
    e.setAttribute('style','display:'+d);
}

function setFormActions(){
  if (!document.forms[0]) return;
  var t=document.forms[0].pickServer;
  if (t)
    for (var i=0;i<document.forms.length;i++){
      if (document.forms[i].server)
        document.forms[i].server.value = sl[t.selectedIndex][0];
      if (document.forms[i].cookie)
        document.forms[i].cookie.value = cookie;
    }
  var l=document.getElementsByTagName('p');
  for (var i=0;i<l.length;i++){
    if (l[i].getAttribute('warning')){
      if (l[i].getAttribute('id')==sl[t.selectedIndex][1].toLowerCase())
        setDisplay(l[i],'block');
      else
        setDisplay(l[i],'none');
    }
  }
}

function userSetServer(){
  setFormActions();
  setCookie('engine',document.forms[0].pickServer.selectedIndex);
  //alert(document.forms[0].pickServer.selectedIndex);
}

function setCookie(k,v) {
  //setEngine();
  document.cookie = k+"="+escape(v)+"; expires="+new Date('20 May 2062').toGMTString();
  cookies[k]=v;
}

function clearCookies ()
{
  var tas=document.getElementsByTagName('form');
  for (var i=0;i<tas.length;i++)
    tas[i].reset();
  delete_cookie('oliver');
  delete_cookie('engine');
  window.location.reload();
}

function delete_cookie(cookie_name){
  var cookie_date = new Date ( );  // current date & time
  cookie_date.setTime ( cookie_date.getTime() - 1 );
  document.cookie = cookie_name += "=; expires=" + cookie_date.toGMTString();
}

function warning(engine,text){
//Used (at least) in nested select page regarding MySQL
  if (document.ss && document.ss.pickServer)
    if (sl[document.ss.pickServer.selectedIndex][1].toLowerCase()==engine){
      document.write("<p style='background-color: yellow'>",text,"</p>");
    }
}

function trim(s){
  return (s.substr(0,1)==" ")?s.substr(1):s;
}

function fileName(s){
  var i=s.lastIndexOf("/");
  if (i) i++;
  return s.substr(i);
}

function unencode(s){
  var t=(s.replace("&gt;",">"));
  return(t);
}

function populateList(pl){
  var i;
  for (i=0; i< sl.length; i++){
    pl.options[i] = new Option(sl[i][1]
                              ,sl[i][0]);
  }
}

function er(s){
  return s.replace(/&lt;/g,"<").replace(/&gt;/g,">");
}