var httpObject = null;
		var base_url="http://localhost/housingnepal.com/";
//			var base_url="http://www.housingnepal.com/";
		
		function getHTTPObject(){
    	  if (window.ActiveXObject) return new ActiveXObject("Microsoft.XMLHTTP");
	      else if (window.XMLHttpRequest) return new XMLHttpRequest();
   		  else {
		      alert("Your browser does not support AJAX.");
		      return null;
	      }
      	}
			  	
    function generalajax(id,url,params)
	{
	
		var httpObjects = null;
		  httpObjects = getHTTPObject();
    	  if (httpObjects != null) 
		  {
			  httpObjects.open('POST',url,true);
			  httpObjects.setRequestHeader("Content-type", "application/x-www-form-urlencoded");
			  httpObjects.setRequestHeader("Content-length", params.length);
			  httpObjects.setRequestHeader("Connection", "close");
		      httpObjects.onreadystatechange = function()
			  {
					if(httpObjects.readyState == 4)
					{
						var str=httpObjects.responseText;
					//	alert(str);
						document.getElementById(id).innerHTML="";
						document.getElementById(id).innerHTML=str;
					}  
			  }
			  httpObjects.send(params);
		  }
	}
	
	function generalgetajax(id,url)
	{
		var httpObjects = null;
		  httpObjects = getHTTPObject();
    	  if (httpObjects != null) 
		  {
			  httpObjects.open('GET',url,true);
		      httpObjects.onreadystatechange = function()
			  {
					if(httpObjects.readyState == 4)
					{
						var str=httpObjects.responseText;
						document.getElementById(id).innerHTML="";
					//alert(str);
						document.getElementById(id).innerHTML=str;
					}  
			  }
			  httpObjects.send(null);
		  }
	}
	var timeout         = 500;
	var closetimer		= 0;
	var ddmenuitem      = 0;
	var childid=0;
	function mopen(id)
	{	
		// cancel close timer
		mcancelclosetime();
		
		
		// close old layer
		
		if(ddmenuitem) 
		{
			var temp=ddmenuitem.id.split('_');
			if(isArray(temp))
			{
				i=1;
				while(true)
				{
					if(document.getElementById(temp[0]+"_child"+i))
					{
						document.getElementById(temp[0]+"_child"+i).style.visibility="hidden";
						i++;
					}
					else break;
				}
				document.getElementById(temp[0]).style.visibility="hidden";
			}
			else
			{
				ddmenuitem.style.visibility = 'hidden';
			}
		}
		
		// get new layer and show it
		ddmenuitem = document.getElementById(id);
		ddmenuitem.style.visibility = 'visible';
	}
	function isArray(obj) {
	return (obj.constructor.toString().indexOf("Array") != -1);
	}
	function mopen2(id)
	{	
		// cancel close timer
		mcancelclosetime();
		
		
		// get new layer and show it
		ddmenuitem = document.getElementById(id);
		childid=id;
		var temp=id.split('_');
		i=1;
		while(true)
		{
			if(document.getElementById(temp[0]+"_child"+i))
			{
				document.getElementById(temp[0]+"_child"+i).style.visibility="hidden";
				i++;
			}
			else break;
		}
		var top=(parseInt(temp[1].substr(5,1))-1)*21;
		ddmenuitem.style.left=(document.getElementById(temp[0]).offsetWidth-2)+"px";
		ddmenuitem.style.top=top+"px";
		ddmenuitem.style.visibility = 'visible';
	}
	
	// close showed layer
	function mclose()
	{
		if(ddmenuitem)
		{
			ddmenuitem.style.visibility = 'hidden';
		}
	}
	
	function mclose3()
	{
		var temp=ddmenuitem.id.split('_');
		ddmenuitem.style.visibility = 'hidden';
		var temp=ddmenuitem.id.split('_');
		ddmenuitem=document.getElementById(temp[0]);
		closetimer = window.setTimeout(mclose, timeout);	
	}
	// go close timer
	function mclosetime()
	{
		closetimer = window.setTimeout(mclose, timeout);
	}
	
	function mclosetime3()
	{
		closetimer = window.setTimeout(mclose3, timeout);
		
	}
	// cancel close timer
	function mcancelclosetime()
	{
		if(closetimer)
		{
			window.clearTimeout(closetimer);
			closetimer = null;
		}
	}
	
	// close layer when click-out
	document.onclick = mclose; 
	
	function loadAdmin()
	{
		//alert("Hello");
		document.getElementById('second-bottom').innerHTML="";
		generalgetajax('second-top2',base_url+'welcome/loadmenu');
	}
	  
	function loadUser()
	{
		document.getElementById('second-bottom').style.border='1px solid #666633 ';
		generalgetajax('second-bottom','adminconfig/change_uname.php');
	}
	function loadpassword()
	{
		document.getElementById('second-bottom').style.border='1px solid #666633 ';
		generalgetajax('second-bottom','adminconfig/change_pword.php');
	}
	function loademail()
	{
		document.getElementById('second-bottom').style.border='1px solid #666633 ';
		generalgetajax('second-bottom','adminconfig/change_email.php');
	}
	
	function loadsystem()
	{
		document.getElementById('second-bottom').innerHTML="";
		generalgetajax('second-top2','systemconfig/sysmenus.php');	
	}
	function loadcreate_table()
	{
		document.getElementById('second-bottom').style.border='none ';
		generalgetajax('second-bottom','systemconfig/create_table.php');
	}
	function loadalter_table()
	{
		document.getElementById('second-bottom').style.border='none';
		generalgetajax('second-bottom','systemconfig/alter_table.php');		
	}
	function loadPrimary_keyonclick()
	{
		document.getElementById('downleft').style.border='none';
		generalgetajax('downleft','systemconfig/primary_keyonclick.php');		
	}
	function loadforeign_keyonclick()
	{
		document.getElementById('downleft').style.border='none';
		document.getElementById('downleft').innerHTML='';
		generalgetajax('downleft','systemconfig/foreign_keyonclick.php');	
	}
	function loaddrop_table()
	{
		document.getElementById('second-bottom').style.border='none';
		generalgetajax('second-bottom','systemconfig/drop_table.php');		
	}
	
	function validate_username()
	{
		var old_username,new_username,confirm_username;
		old_username=document.getElementById('o_uname').value;
		new_username=document.getElementById('n_uname').value;
		confirm_username=document.getElementById('c_uname').value;
		
		if(old_username=='' || new_username=='' || confirm_username=='')
		{
			alert('Please fill up the required fields');
			return false;
		}
		else if(new_username!=confirm_username)
		{
			alert('Please enter same new username and confirm username');
			return false;
		}
		else
		{
			alert('Congratulations');
		}
		
	}
	function validate_password()
	{
		var oldpassword, newpassword, confirmpassword;
		oldpassword=document.getElementById('old_pass').value;
		newpassword=document.getElementById('new_pass').value;
		confirmpassword=document.getElementById('confirm_pass').value;
		
		if(oldpassword=='' || newpassword=='' || confirmpassword=='')
		{
			alert('Please enter requried fields');
			return false;
		}
		else if(newpassword!=confirmpassword)
		{
			alert('enter valid password');
			return false;
		}
		else
		{
			alert('Congratulations');
			return true;
		}
	}
	function emailvalidation(id)
	{
		var oldemail,newemail,confirmemail;
		oldemail=document.getElementById(id).value;
		
		
		if(oldemail=="")
		{
			alert("Please enter the required fields");
			document.getElementById(id).focus();
		}
		else if(emailCheck(oldemail)==false)
		{
			alert('Please Enter Valid Email Address');
			document.getElementById(id).focus();
		}
	}
	function emailCheck(str) {
		var at="@";
		var dot=".";
		var lat=str.indexOf(at);
		
		var lstr=str.length;
		
//		alert(lstr);
		var ldot=str.indexOf(dot);
		if (str.indexOf(at)==-1){
		   return false;
		}

		if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){
		   return false;
		}

		if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr){
		    return false;
		}

		 if (str.indexOf(at,(lat+1))!=-1){
		    return false;
		 }

		 if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot){
		    return false;
		 }

		 if (str.indexOf(dot,(lat+2))==-1){
		    return false;
		 }
		
		 if (str.indexOf(" ")!=-1){
		    return false;
		 }

 		 return true;					
	}
	function validate_createtable()
	{
		var create_table,parameter;
		create_table=document.getElementById('tablename').value;
		if(create_table=='')
		{
			alert('please enter required fields');
			return false;
		}
		else
		{
	//		alert('add Table');
			return true;
		}
	}
	function validate_addfeilds()
	{
		var select_table,field_name,field_type;
		select_table=document.getElementById('selecttable').value;
		field_name=document.getElementById('fieldname').value;
		field_type=document.getElementById('fieldtype').value;
		if(select_table=='0' )
		{
			alert('Please Select Table');
			return false;
		}
		else if(field_name=='')
		{
			alert('Please Enter the Field Name');
			return false;
		}
		else if(field_type=='0' )
		{
			alert('Please Select Field Type');	
			return false;
		}
		else
		{
		//	alert('FIELDS ADDED');
			return true;
		}
	}
	function validate_primarykeyonclick()
	{
		var select_table,select_field;
		select_table=document.getElementById('selecttable').value;
		select_field=document.getElementById('selectfield').value;
		if(select_table=='Null' || select_field=='Null')
		{
			alert('Please select the Fields');
			return false;
		}
		else if(select_table=='Null')
		{
			alert('Please select Table');
			return false;
		}
		else if(select_field=='Null')
		{
			alert('Please select Field');
			return false;
		}
		else
		{
			return true;
		}
		
	}
	function validate_droptable()
	{
		var select_table;
		select_table=document.getElementById('selecttable').value;
		if(select_table=='Null')
		{
			alert('Please select the Feilds');
			return false;
		}
		else
		{
			return true;
		}
	}
	
	function display_fields()
	{
		var table_name,params;
		table_name=document.getElementById('selecttable').value;
		params="TName="+table_name;
		generalajax('downright',base_url+'database_manager/load_fields',params);		
		
	}
	function display_values()
	{
		var tablename,parameter;
		tablename=document.getElementById('selecttable').value;
		parameter="Tname="+tablename+"&DivID=selectfield";;
//		alert(parameter);
		generalajax('primary_table_fields',base_url+'database_manager/load_table_fields',parameter);
		generalajax('downright1',base_url+'database_manager/display_primary_key',parameter);
	}
	function validate_foreignkeyonclick()
	{
			var select_table,select_field,select_sourcetable;
			select_table=document.getElementById('select_table').value;
			select_field=document.getElementById('select_field').value;
			
			select_sourcetable=document.getElementById('selectsource').value;
			if(select_table=='Null' && select_field=='Null' && select_sourcttable=='Null')
			{
				alert('Please select the required fields');
				return false;
			}
			else if(select_table=='Null')
			{
				alert('Please select the table');
				return false;
			}
			else if(select_field=='Null')
			{
				alert('Please select the field:'+select_field);
				return false;
			}
			else
			{
			//	alert('Foreign Key has been added');
				return true;
			}
			
	}
	
	
	
	
	
	
	function display_Fvalues()
	{
		var tablename,parameter,source_table,para;
		tablename=document.getElementById('select_table').value;
		parameter="Tname="+tablename+"&DivID=select_field";
		para="uptable="+tablename;
//		alert(parameter);
//alert(para);
		generalajax('table_fields',base_url+'database_manager/load_table_fields',parameter);
		generalajax('sourcetable',base_url+'database_manager/display_source_tables',para);
		generalajax('downright',base_url+'database_manager/display_foreign_key',parameter);
	}
	function load_records()
	{
		var tablename;
		tablename=document.getElementById('selecttable').value;
		if(tablename=="")
		{
			
		}
		else
		{
			parameter="Tname="+tablename;
			generalajax('down2',base_url+'database_manager/get_records',parameter);
		}
	}
	
	
	
	





var timeout         = 500;
var closetimer		= 0;
var ddmenuitem      = 0;

// open hidden layer
function mopen(id)
{	
	// cancel close timer
	mcancelclosetime();
	
	
	// close old layer
	if(ddmenuitem) ddmenuitem.style.visibility = 'hidden';
	
	// get new layer and show it
	ddmenuitem = document.getElementById(id);
	ddmenuitem.style.visibility = 'visible';
	

}
// close showed layer
function mclose()
{
	if(ddmenuitem) ddmenuitem.style.visibility = 'hidden';
}

// go close timer
function mclosetime()
{
	closetimer = window.setTimeout(mclose, timeout);
}

// cancel close timer
function mcancelclosetime()
{
	if(closetimer)
	{
		window.clearTimeout(closetimer);
		closetimer = null;
	}
}

// close layer when click-out
document.onclick = mclose; 
	
	
	
	function resettext(id)
	{
		document.getElementById(id).value="";
	}