function restoreInnerHTMLcel1(){

	if (iEditrow.length > 0) {
		document.all(iEditrow + 'cel1').style.color = "black"
		document.all(iEditrow + 'cel1').style.fontWeight = "normal";
		document.all(iEditrow + 'cel1').innerHTML = innerHTML;
	}
	iEditrow = 0;
}

function replaceInnerHTMLcel1(v,inner){
	document.all(v + 'cel1').innerHTML = "----------------->";
	document.all(v + 'cel1').style.color = "#555555"
	document.all(v + 'cel1').style.fontWeight = "bold";
	iEditrow = v;
	
	innerHTML = inner;
}

function handleCheckbox(svalue){
	if (svalue == "x")
		return true;
	else
		return false;
}

function prepareCheckbox(bValue){
	if (bValue)
		return "1";
	else
		return "0";
}

function replaceAmp(svalue){
	var t = new String(svalue) ;
	while (t.indexOf("&") > -1) {
		t = t.replace("&","&");
	}

	return t;
}


function replacediv(svalue){
	var t = new String(svalue) ;
	while (t.indexOf("&") > -1) {
		t = t.replace("&","&");
	}

	return t;
}
function removeEurosign(svalue){
	var t = new String(svalue) ;
	while (t.indexOf(String.fromCharCode(0x20AC)) > -1) {
		t = t.replace(String.fromCharCode(0x20AC) + " ","");
	}
	return t;
}
function handleRequiredString(value,name){
	if (value == ""){
		var t = new String(name) ;
		while (t.indexOf(" ") > -1) {
			t = t.replace(" ","");
		}
		while (t.indexOf("*") > -1) {
			t = t.replace("*","");
		}
		
		var x = new String(document.location)
		x = Left(x,x.indexOf("spitz-coaching") + 14)
		
		var s = '<IMG src="' + x + '/images/sortdown.gif">';
		t = t.replace(s,"");
		s = '<IMG src="' + x + '/images/sortup.gif">';
		t = t.replace(s,"");
		
		alert("Please supply a " + t + ".");
		return false;
	}
	return true;
}

function trim(str)
{
   return str.replace(/^\s*|\s*$/g,"");
}

function isnumericValue(object_value){
	if (!checkinteger(object_value)){
		alert("Please supply a numeric value.");
		return false;
	}
	return true;
}

function checkinteger(object_value) {
	if (object_value.length == 0)
		return true;
	
	var decimal_format = ".";
	var check_char;
	
	check_char = object_value.indexOf(decimal_format);
	if (check_char < 1)
		return checknumber(object_value);
	else
		return false;
}

function checknumber(object_value) {
	if (object_value.length == 0)
		return true;
	
	var start_format = " .+-0123456789";
	var number_format = " .0123456789";
	var check_char;
	var decimal = false;
	var trailing_blank = false;
	var digits = false;
	
	check_char = start_format.indexOf(object_value.charAt(0));
	if (check_char == 1)
		decimal = true;
	else if (check_char < 1)
		return false;
	 
	for (var i = 1; i < object_value.length; i++)	{
		check_char = number_format.indexOf(object_value.charAt(i))
		if (check_char < 0) {
			return false;
		} else if (check_char == 1)	{
			if (decimal)
				return false;
			else
				decimal = true;
		} else if (check_char == 0) {
			if (decimal || digits)	
			trailing_blank = true;
		}	else if (trailing_blank) { 
			return false;
		} else {
			digits = true;
		}
	}	
	
	return true;
}

function handleTextarea(svalue){

	var t = new String(svalue) ;
	//remove all <br>
	while (t.indexOf("<br>") > -1) {
		t = t.replace("<br>","\n");
	}
	while (t.indexOf("<BR>") > -1) {
		t = t.replace("<BR>","\n");
	}
	//return removeHTMLOverhead(t);
	return t;
}

function removeHTMLOverhead(t){
	//scrolltable.js adds some span tags, we need to remove them
	var pos1 = t.indexOf('px">')
	var pos2 = t.lastIndexOf('</SPAN>')
	if (pos1 != -1)
		return t.substring(pos1 + 4,pos2);
	return t;
}

function checkemail(object_value) {
	if (object_value.length == 0)
		return true;
	
	if (!(object_value.indexOf("@") > -1 && object_value.indexOf(".") > -1))
		return false;    
	
	return true;
}


function checkyear(sYear){
//check for a valid four digit year (only this year or a year in the past)

	if ((sYear.length != 4)||(isNaN( sYear))){
		alert("Please supply a four digit year.");
        return false;
    }
    var now = new Date();
    if (parseInt(sYear) > parseInt(now.getFullYear())){
        alert("Please supply a valid year.");
        return false;
    }
    return true;
}


function Left(str, n){
	if (n <= 0)
	    return "";
	else if (n > String(str).length)
	    return str;
	else
	    return String(str).substring(0,n);
}

function Right(str, n){
    if (n <= 0)
       return "";
    else if (n > String(str).length)
       return str;
    else {
       var iLen = String(str).length;
       return String(str).substring(iLen, iLen - n);
    }
}

function Replace(str,find,replace){
    
	var t = new String(str) ;
	while (t.indexOf(find) > -1) {
		t = t.replace(find,replace);
	}
	return t;
}


function convert2dbdate(sdate) {
	var dateSep = "-";
	var wrongdateSep = "/";
	while (sdate.indexOf("/") > -1) {
		sdate = sdate.replace(wrongdateSep,dateSep);
	}
		
	var isplit = sdate.indexOf(dateSep);
	var day = sdate.substr(0, isplit);
	var imonthsplit = sdate.indexOf(dateSep,isplit + 1);
	var month = sdate.substr(isplit + 1, imonthsplit - isplit - 1);
	var year = sdate.substr(imonthsplit + 1,sdate.length - imonthsplit)
	sdate = year + dateSep + month + dateSep + day
	if (isDate(sdate))
		return sdate  + "  00:00:00";
	else
		return "error";
	
}
function regularexplinked(str){
	 var specials = ['!','@','#','$','%','^','&','*','%','(',')','_','-','+','=','{','}','|',
				'[',']',':','"',';','<','>',',','.','?','`','~', '\\',' ','/'];
		var re = new RegExp('(\\' + specials.join('|\\') + ')', 'g');
	str = str.replace(re, '');
	while (str.indexOf("'") > -1) {
			str = str.replace("'","");
	}
  return str
}

function orderby(orderby,id){
	if (document.all("maintenancehdn"))
		if (!AlreadyEditing())
			return false;

	document.all("endrecordhdn").value = parseFloat(document.all("recperpagehdn").value);
	if (document.all("orderbyhdn").value == orderby){
		if (document.all("orderbydirhdn").value == "ASC")
			document.all("orderbydirhdn").value = "DESC";
		else
			document.all("orderbydirhdn").value = "ASC";
	} else {
		document.all("orderbyhdn").value = orderby
		document.all("orderbyIDhdn").value = id
		document.all("orderbydirhdn").value = "ASC";
	}
	
	submitform();
}
function navrecords(ssign,pages){
	var endrec;
	if (document.all("maintenancehdn"))
		if (!AlreadyEditing())
			return false;
	if (ssign == "-"){
		endrec = parseFloat(document.all("endrecordhdn").value) - parseFloat(document.all("recperpagehdn").value);
		if (endrec < parseFloat(document.all("recperpagehdn").value))
			endrec = parseFloat(document.all("recperpagehdn").value);
		document.all("endrecordhdn").value = endrec;
	}else {
		endrec = parseFloat(document.all("endrecordhdn").value) + parseFloat(document.all("recperpagehdn").value);
		if (endrec > parseFloat(document.all("recperpagehdn").value) * pages)
			endrec = parseFloat(document.all("recperpagehdn").value) * pages;
		document.all("endrecordhdn").value = endrec;
	}
	if (!document.all("maintenancehdn"))
		resetscroll();
	submitform();
}
function resetscroll(){
	if (document.all("xCoordHolder")){
		document.all("xCoordHolder").value = 0;
		document.all("yCoordHolder").value = 0;
	}
}

function submitform(){
	document.forms[0].submit();
}




function opendialog( url,width,height) {

	var left = screenWidth();
	var top = screenHeight();
	if (left < width)
		left = 100;
	else
		left = left/2 - width/2;
	if (top < height)
		top = 100;
	else
		top = top/2 - height/2;
	
	window.open(url,'','left=' + left + ',top=' + top + ',dependent=no,menubar=no,location=no,resizable=no,width=' + width + ',height=' + height + ',toolbar=no,scrollbars=no,status=no');
	return false;
}

function screenWidth() {

	if (window.screen) {
		return(screen.width);
	} else {
		return(0);
	}
}

function screenHeight() {

	if (window.screen) {
		return(screen.height);
	} else {
		return(0);
	}
}

/*fade in/fade out */
function opacity(id, opacStart, opacEnd, millisec) { 
    //speed for each frame 
    var speed = Math.round(millisec / 100); 
    var timer = 0; 

    //determine the direction for the blending, if start and end are the same nothing happens 
    if(opacStart > opacEnd) { 
        for(i = opacStart; i >= opacEnd; i--) { 
            setTimeout("changeOpac(" + i + ",'" + id + "')",(timer * speed)); 
            timer++; 
        } 
    } else if(opacStart < opacEnd) { 
        for(i = opacStart; i <= opacEnd; i++) 
            { 
            setTimeout("changeOpac(" + i + ",'" + id + "')",(timer * speed)); 
            timer++; 
        } 
    } 
} 

//change the opacity for different browsers 
function changeOpac(opacity, id) { 
    var object = document.getElementById(id).style; 
    object.opacity = (opacity / 100); 
    object.MozOpacity = (opacity / 100); 
    object.KhtmlOpacity = (opacity / 100); 
    object.filter = "alpha(opacity=" + opacity + ")"; 
}