break; case "header": continue; break; //for HTML_QuickForm versions of standard HTML Form Elements... //for HTML_QuickForm versions of standard HTML Form Elements... default: //continue; // jump straight to validity for debugging if (preg_match("/^Examiner/", $bits[1])) { // Treat examiner specially, since it's a select box but we need // to treat it as a varchar. derive_timepoint_variables will derive // the name from the examiner id $bits[0] = "varchar(255)"; } else { if ($bits[0] == "select") { $bits[0] = enumizeOptions($bits[3], $table, $bits[1]); } else { if ($bits[0] == "textarea") { $bits[0] = "text"; } else { if ($bits[0] == "text") { $bits[0] = "varchar(255)"; } else { if ($bits[0] == "selectmultiple") { $bits[0] = "varchar(255)"; } else { if ($bits[0] == "checkbox") { $bits[0] = "varchar(255)"; } else { if ($bits[0] == "static") { $bits[0] = "varchar(255)";
$bits[0] = "varchar(255)"; } else { if ((array_key_exists(0, $bits) ? $bits[0] : null) == "textarea") { $bits[0] = "text"; } else { if ((array_key_exists(0, $bits) ? $bits[0] : null) == "text") { $bits[0] = "varchar(255)"; } else { if ((array_key_exists(0, $bits) ? $bits[0] : null) == "checkbox") { $bits[0] = "varchar(255)"; } else { if ((array_key_exists(0, $bits) ? $bits[0] : null) == "static") { $bits[0] = "varchar(255)"; } else { if ((array_key_exists(0, $bits) ? $bits[0] : null) == "radio") { $bits[0] = enumizeOptions($bits[3], $table = array(), $bits[1]); } } } } } } } if (array_key_exists(2, $bits)) { $bits[2] = htmlspecialchars($bits[2]); } $output .= "`{$bits['1']}` {$bits['0']} default NULL,\n"; } } $output .= "PRIMARY KEY (`CommentID`)\n\n );\n"; $fp = fopen($filename, "w");