5 * Modify from controls when the "NULL" checkbox is selected
7 * @param string the MySQL field type
8 * @param string the urlencoded field name
9 * @param string the md5 hashed field name
11 * @return boolean always true
13 function nullify(theType, urlField, md5Field)
15 var rowForm = document.forms['insertForm'];
17 if (typeof(rowForm.elements['funcs[' + urlField + ']']) != 'undefined') {
18 rowForm.elements['funcs[' + urlField + ']'].selectedIndex = -1;
21 // "SET" field , "ENUM" field with more than 20 characters
22 // or foreign key field
23 if (theType == 1 || theType == 3 || theType == 4) {
24 rowForm.elements['field_' + md5Field + '[]'].selectedIndex = -1;
27 else if (theType == 2) {
28 var elts = rowForm.elements['field_' + md5Field + '[]'];
29 var elts_cnt = elts.length;
30 for (var i = 0; i < elts_cnt; i++ ) {
31 elts[i].checked = false;
35 else /*if (theType == 5)*/ {
36 rowForm.elements['fields[' + urlField + ']'].value = '';
37 } // end if... else if... else
40 } // end of the 'nullify()' function
44 * Unchecks the "NULL" control when a function has been selected or a value
47 * @param string the urlencoded field name
49 * @return boolean always true
51 function unNullify(urlField)
53 var rowForm = document.forms['insertForm'];
55 if (typeof(rowForm.elements['fields_null[' + urlField + ']']) != 'undefined') {
56 rowForm.elements['fields_null[' + urlField + ']'].checked = false
60 } // end of the 'unNullify()' function
63 * Allows moving around inputs/select by Ctrl+arrows
65 * @param object event data
67 function onKeyDownArrowsHandler(e) {
69 var o = (e.srcElement||e.target);
71 if (o.tagName != "TEXTAREA" && o.tagName != "INPUT" && o.tagName != "SELECT") return;
72 if (!e.ctrlKey) return;
75 var pos = o.id.split("_");
76 if (pos[0] != "field" || typeof pos[2] == "undefined") return;
78 var x = pos[2], y=pos[1];
80 // skip non existent fields
84 case 38: y--; break; // up
85 case 40: y++; break; // down
86 case 37: x--; break; // left
87 case 39: x++; break; // right
91 var id = "field_" + y + "_" + x;
92 var nO = document.getElementById(id);
94 var id = "field_" + y + "_" + x + "_0";
95 var nO = document.getElementById(id);
102 if (nO.tagName != 'SELECT') {
105 e.returnValue = false;