function addcell(param, zeile) {
	if(document.getElementById) {
		if (!zeile) {
			var zeile = 1;
		}
		zeile += 1;
		var tr = document.getElementById(param).insertRow(zeile);

		var td1 = document.createElement("td");
		var td1input = document.createElement("input");
                td1input.size = "4";
                td1input.name = "jahr_"+zeile;
		td1.appendChild(td1input);

		var td2 = document.createElement("td");
		var td2input = document.createElement("input");
                td2input.size = "20";
                td2input.name = "award_"+zeile;
		td2.appendChild(td2input);

		var td3 = document.createElement("td");
		var td3input = document.createElement("input");
                td3input.size = "50";
                td3input.name = "preis_"+zeile;
		td3.appendChild(td3input);

		tr.appendChild(td1);
		tr.appendChild(td2);
		tr.appendChild(td3);

	} else if(document.all) {

		var tr = document.all[param].insertRow(zeile);

		var td1 = document.createElement("td");
		var td1input = document.createElement("input");
                td1input.size = "4";
                td1input.name = "jahr_"+zeile;
		td1.appendChild(td1input);

		var td2 = document.createElement("td");
		var td2input = document.createElement("input");
                td2input.size = "20";
                td2input.name = "award_"+zeile;
		td2.appendChild(td2input);

		var td3 = document.createElement("td");
		var td3input = document.createElement("input");
                td3input.size = "50";
                td3input.name = "preis_"+zeile;
		td3.appendChild(td3input);

		tr.appendChild(td1);
		tr.appendChild(td2);
		tr.appendChild(td3);

		zeile += 1;

	} else {
		alert('Ihr Browser ist zu alt oder mit dieser Funktion inkompatible!\nBitte benutzen sie einen anderen Browser wenn sie diese Funktion nutzen wollen,\nwir empfehlen ihnen Opera einen link finden sie Links auf der Seite.');
	}
}

function display(param) {
	if(document.getElementById) {
		params = document.getElementById(param);
		if (params.style.display == "block") {
			params.style.display = "none";
			document.getElementById(param + "pic").src = "images/plus.gif";
		} else {
			params.style.display = "block";
			document.getElementById(param + "pic").src = "images/minus.gif";
		}
	} else if(document.all) {
		params = document.all[param];
		if (params.style.getAttribute("display","false") == "block") {
			params.style.setAttribute("display","none","false");
			document.all[param + "pic"].src = "images/plus.gif";
		} else {
			params.style.setAttribute("display","block","false");
			document.all[param + "pic"].src = "images/minus.gif";
		}
	} else {
		alert('Ihr Browser ist zu alt oder mit dieser Funktion inkompatible!\nBitte benutzen sie einen anderen Browser wenn sie diese Funktion nutzen wollen,\nwir empfehlen ihnen Opera einen link finden sie Links auf der Seite.');
	}
}

function player(sURL,sWidth,sHeight) {
	w=window.open(sURL,'music','height='+sHeight+',left='+(screen.width-sWidth)/2+',location=no,menubar=no,resizable=no,scrollbars=no,status=no,toolbar=no,top='+(screen.height-sHeight)/2+',width='+sWidth);if(w)w.focus();
}

function openAddress(form) {
	if(document.getElementById) {
		s_plz = document.getElementById("plz").value;
		s_ort = document.getElementById("ort").value;
	} else if(document.all) {
		s_plz = document.all["plz"].value;
		s_ort = document.all["ort"].value;
	} else {
		alert('Ihr Browser ist zu alt oder mit dieser Funktion inkompatible!\nBitte benutzen sie einen anderen Browser wenn sie diese Funktion nutzen wollen,\nwir empfehlen ihnen Opera einen link finden sie Links auf der Seite.');
	}
	window.open("search_address&plz="+s_plz+"&ort="+s_ort+".html", "Address", "width=370,height=200,status=yes");
	dateField1 = eval("document." + form + ".plz");
	dateField2 = eval("document." + form + ".ort");
}



/**
 * Modify from controls when the "NULL" checkbox is selected
 *
 * @param   string   the MySQL field type
 * @param   string   the urlencoded field name
 * @param   string   the md5 hashed field name
 *
 * @return  boolean  always true
 */
function nullify(theType, urlField, md5Field, multi_edit)
{
    var rowForm = document.forms['insertForm'];

    if (typeof(rowForm.elements['funcs' + multi_edit + '[' + urlField + ']']) != 'undefined') {
        rowForm.elements['funcs' + multi_edit + '[' + urlField + ']'].selectedIndex = -1;
    }

    // "SET" field , "ENUM" field with more than 20 characters
    // or foreign key field
    if (theType == 1 || theType == 3 || theType == 4) {
        rowForm.elements['field_' + md5Field + multi_edit + '[]'].selectedIndex = -1;
    }
    // Other "ENUM" field
    else if (theType == 2) {
        var elts     = rowForm.elements['field_' + md5Field + multi_edit + '[]'];
        // when there is just one option in ENUM:
        if (elts.checked) {
            elts.checked = false;
        } else {
            var elts_cnt = elts.length;
            for (var i = 0; i < elts_cnt; i++ ) {
                elts[i].checked = false;
            } // end for

        } // end if
    }
    // Other field types
    else /*if (theType == 5)*/ {
        rowForm.elements['fields' + multi_edit + '[' + urlField + ']'].value = '';
    } // end if... else if... else

    return true;
} // end of the 'nullify()' function


/**
 * Unchecks the "NULL" control when a function has been selected or a value
 * entered
 *
 * @param   string   the urlencoded field name
 *
 * @return  boolean  always true
 */
function unNullify(urlField, multi_edit)
{
    var rowForm = document.forms['insertForm'];

    if (typeof(rowForm.elements['fields_null[multi_edit][' + multi_edit + '][' + urlField + ']']) != 'undefined') {
        rowForm.elements['fields_null[multi_edit][' + multi_edit + '][' + urlField + ']'].checked = false
    } // end if
    
    if (typeof(rowForm.elements['insert_ignore_' + multi_edit]) != 'undefined') {
        rowForm.elements['insert_ignore_' + multi_edit].checked = false
    } // end if

    return true;
} // end of the 'unNullify()' function

/**
  * Allows moving around inputs/select by Ctrl+arrows
  *
  * @param   object   event data
  */
function onKeyDownArrowsHandler(e) {
    e = e||window.event;
    var o = (e.srcElement||e.target);
    if (!o) return;
    if (o.tagName != "TEXTAREA" && o.tagName != "INPUT" && o.tagName != "SELECT") return;
    if (!e.ctrlKey) return;
    if (!o.id) return;

    var pos = o.id.split("_");
    if (pos[0] != "field" || typeof pos[2] == "undefined") return;

    var x = pos[2], y=pos[1];

    // skip non existent fields
    for (i=0; i<10; i++)
    {
        switch(e.keyCode) {
            case 38: y--; break; // up
            case 40: y++; break; // down
            case 37: x--; break; // left
            case 39: x++; break; // right
            default: return;
        }

        var id = "field_" + y + "_" + x;
        var nO = document.getElementById(id);
        if (!nO) {
            var id = "field_" + y + "_" + x + "_0";
            var nO = document.getElementById(id);
        }
        if (nO) break;
    }

    if (!nO) return;
    nO.focus();
    if (nO.tagName != 'SELECT') {
        nO.select();
    }
    e.returnValue = false;
}
var day;
var month;
var year;
var hour;
var minute;
var second;
var clock_set = 0;

/**
 * Opens calendar window.
 *
 * @param   string      calendar.php parameters
 * @param   string      form name
 * @param   string      field name
 * @param   string      edit type - date/timestamp
 */
function openCalendar(params, form, field, type) {
    window.open(params, "calendar", "width=400,height=200,status=yes");
    dateField = eval("document." + form + "." + field);
    dateType = type;
}
/**
 * Formats number to two digits.
 *
 * @param   int number to format.
 */
function formatNum2(i, valtype) {
    f = (i < 10 ? '0' : '') + i;
    if (valtype && valtype != '') {
        switch(valtype) {
            case 'month':
                f = (f > 12 ? 12 : f);
                break;

            case 'day':
                f = (f > 31 ? 31 : f);
                break;

            case 'hour':
                f = (f > 24 ? 24 : f);
                break;

            default:
            case 'second':
            case 'minute':
                f = (f > 59 ? 59 : f);
                break;
        }
    }

    return f;
}

/**
 * Formats number to four digits.
 *
 * @param   int number to format.
 */
function formatNum4(i) {
    return (i < 1000 ? i < 100 ? i < 10 ? '000' : '00' : '0' : '') + i;
}
/**
 * Initializes calendar window.
 */
function initCalendar() {
    if (!year && !month && !day) {
        /* Called for first time */
        if (window.opener.dateField.value) {
            value = window.opener.dateField.value;
            if (window.opener.dateType == 'datetime' || window.opener.dateType == 'date') {
                if (window.opener.dateType == 'datetime') {
                    parts   = value.split(' ');
                    value   = parts[0];

                    if (parts[1]) {
                        time    = parts[1].split(':');
                        hour    = parseInt(time[0],10);
                        minute  = parseInt(time[1],10);
                        second  = parseInt(time[2],10);
                    }
                }
                date        = value.split("-");
                day         = parseInt(date[2],10);
                month       = parseInt(date[1],10) - 1;
                year        = parseInt(date[0],10);
            } else {
                year        = parseInt(value.substr(0,4),10);
                month       = parseInt(value.substr(4,2),10) - 1;
                day         = parseInt(value.substr(6,2),10);
                hour        = parseInt(value.substr(8,2),10);
                minute      = parseInt(value.substr(10,2),10);
                second      = parseInt(value.substr(12,2),10);
            }
        }
        if (isNaN(year) || isNaN(month) || isNaN(day) || day == 0) {
            dt      = new Date();
            year    = dt.getFullYear();
            month   = dt.getMonth();
            day     = dt.getDate();
        }
        if (isNaN(hour) || isNaN(minute) || isNaN(second)) {
            dt      = new Date();
            hour    = dt.getHours();
            minute  = dt.getMinutes();
            second  = dt.getSeconds();
        }
    } else {
        /* Moving in calendar */
        if (month > 11) {
            month = 0;
            year++;
        }
        if (month < 0) {
            month = 11;
            year--;
        }
    }

    if (document.getElementById) {
        cnt = document.getElementById("calendar_data");
    } else if (document.all) {
        cnt = document.all["calendar_data"];
    }

    cnt.innerHTML = "";

    str = ""

    //heading table
    str += '<table width="100%"><tr><th width="50%" class="abc">';
    str += '<a href="javascript:month--; initCalendar();">&laquo;</a> &nbsp;&nbsp;';
    str += month_names[month];
    str += ' &nbsp;&nbsp;<a href="javascript:month++; initCalendar();">&raquo;</a>';
    str += '</th><th width="50%" class="abc">';
    str += '<a href="javascript:year--; initCalendar();">&laquo;</a> &nbsp;&nbsp;';
    str += year;
    str += ' &nbsp;&nbsp;<a href="javascript:year++; initCalendar();">&raquo;</a>';
    str += '</th></tr></table>';

    str += '<table width="100%"><tr>';
    for (i = 0; i < 7; i++) {
        str += "<th>" + day_names[i] + "</th>";
    }
    str += "</tr>";

    var firstDay = new Date(year, month, 1).getDay();
    var lastDay = new Date(year, month + 1, 0).getDate();

    str += "<tr>";

    dayInWeek = 0;
    for (i = 0; i < firstDay; i++) {
        str += "<td>&nbsp;</td>";
        dayInWeek++;
    }
    for (i = 1; i <= lastDay; i++) {
        if (dayInWeek == 7) {
            str += "</tr><tr>";
            dayInWeek = 0;
        }

        dispmonth = 1 + month;

        if (window.opener.dateType == 'datetime' || window.opener.dateType == 'date') {
            actVal = formatNum4(year) + "-" + formatNum2(dispmonth, 'month') + "-" + formatNum2(i, 'day');
        } else {
            actVal = "" + formatNum4(year) + formatNum2(dispmonth, 'month') + formatNum2(i, 'day');
        }
        if (i == day) {
            style = ' style="text-align:center;border:red 1px solid;"';
        } else {
            style = ' style="text-align:center;"';
        }
        str += "<td" + style + "><a href=\"javascript:returnDate('" + actVal + "');\">" + i + "</a></td>"
        dayInWeek++;
    }
    for (i = dayInWeek; i < 7; i++) {
        str += "<td>&nbsp;</td>";
    }

    str += "</tr></table>";

    cnt.innerHTML = str;

    // Should we handle time also?
    if (window.opener.dateType != 'date' && !clock_set) {

        if (document.getElementById) {
            cnt = document.getElementById("clock_data");
        } else if (document.all) {
            cnt = document.all["clock_data"];
        }

        str = '';
        str += '<form class="clock">';
        str += '<input id="hour"    type="text" size="2" maxlength="2" onblur="this.value=formatNum2(this.value, \'hour\')" value="' + formatNum2(hour, 'hour') + '" />:';
        str += '<input id="minute"  type="text" size="2" maxlength="2" onblur="this.value=formatNum2(this.value, \'minute\')" value="' + formatNum2(minute, 'minute') + '" />:';
        str += '<input id="second"  type="text" size="2" maxlength="2" onblur="this.value=formatNum2(this.value, \'second\')" value="' + formatNum2(second, 'second') + '" />';
        str += '</form>';

        cnt.innerHTML = str;
        clock_set = 1;
    }

}
/**
 * Returns date from calendar.
 *
 * @param   string     date text
 */
function returnDate(d) {
    txt = d;
    if (window.opener.dateType != 'date') {
        // need to get time
        h = parseInt(document.getElementById('hour').value,10);
        m = parseInt(document.getElementById('minute').value,10);
        s = parseInt(document.getElementById('second').value,10);
        if (window.opener.dateType == 'datetime') {
            txt += ' ' + formatNum2(h, 'hour') + ':' + formatNum2(m, 'minute') + ':' + formatNum2(s, 'second');
        } else {
            // timestamp
            txt += formatNum2(h, 'hour') + formatNum2(m, 'minute') + formatNum2(s, 'second');
        }
    }

    window.opener.dateField.value = txt;
    window.close();
}