--- phpMyEdit.class.php	2004-04-16 20:29:24.797955200 +0200
+++ phpMyEdit.class.notices.php	2004-04-17 11:38:23.084467200 +0200
@@ -199,10 +199,10 @@
 	function view_enabled()   { return stristr($this->options, 'V'); }
 	function copy_enabled()   { return stristr($this->options, 'P') && $this->add_enabled(); }
 	function tabs_enabled()   { return $this->display['tabs'] && count($this->tabs) > 0; }
-	function hidden($k)       { return stristr($this->fdd[$k]['input'],'H'); }
-	function password($k)     { return stristr($this->fdd[$k]['input'],'W'); }
-	function readonly($k)     { return stristr($this->fdd[$k]['input'],'R') || $this->virtual($k);     }
-	function virtual($k)      { return stristr($this->fdd[$k]['input'],'V') && $this->col_has_sql($k); }
+	function hidden($k)       { return isset($this->fdd[$k]['input']) && stristr($this->fdd[$k]['input'],'H'); }
+	function password($k)     { return isset($this->fdd[$k]['input']) && stristr($this->fdd[$k]['input'],'W'); }
+	function readonly($k)     { return isset($this->fdd[$k]['input']) && stristr($this->fdd[$k]['input'],'R') || $this->virtual($k);     }
+	function virtual($k)      { return isset($this->fdd[$k]['input']) && stristr($this->fdd[$k]['input'],'V') && $this->col_has_sql($k); }
 
 	function add_operation()    { return $this->operation == $this->labels['Add']    && $this->add_enabled();    }
 	function change_operation() { return $this->operation == $this->labels['Change'] && $this->change_enabled(); }
@@ -339,7 +339,8 @@
 
 	function set_values($field_num, $prepend = null, $append = null, $strict = false) /* {{{ */
 	{
-		return (array) $prepend + (array) $this->fdd[$field_num]['values2']
+		return (array) $prepend
+			+ (array) (isset($this->fdd[$field_num]['values2']) ? $this->fdd[$field_num]['values2'] : Array())
 			+ (isset($this->fdd[$field_num]['values']['table']) || $strict
 					? $this->set_values_from_table($field_num, $strict)
 					: array())
@@ -385,8 +386,8 @@
 			}
 			//$qparts['from'] = "$db.$table.$sel;
 			$qparts['from'] = "$db.$table";
-			$qparts['where'] = $this->fdd[$field_num]['values']['filters'];
-			if ($this->fdd[$field_num]['values']['orderby']) {
+			$qparts['where'] = isset($this->fdd[$field_num]['values']['filters']) ? $this->fdd[$field_num]['values']['filters'] : '';
+			if (isset($this->fdd[$field_num]['values']['orderby']) && $this->fdd[$field_num]['values']['orderby']) {
 				$qparts['orderby'] = $this->fdd[$field_num]['values']['orderby'];
 			}
 		} else { /* simple value extraction */
@@ -416,7 +417,7 @@
 				|| $this->change_operation()) {
 				$ret = 'PMEtable0.'.$this->fds[$field];
 		} else {
-			if ($this->fdd[$this->fds[$field]]['values']['description'] && ! $dont_desc) {
+			if (isset($this->fdd[$this->fds[$field]]['values']['description']) && ! $dont_desc) {
 				$desc = &$this->fdd[$this->fds[$field]]['values']['description'];
 				if (is_array($desc) && is_array($desc['columns'])) {
 					$ret      = 'CONCAT('; // )
@@ -445,9 +446,6 @@
 			} else {
 				$ret = 'PMEtable0.'.$this->fds[$field];
 			}
-			// TODO: not neccessary, remove me!
-			if (is_array($this->fdd[$this->fds[$field]]['values2'])) {
-			}
 		}
 		return $ret;
 	} /* }}} */
@@ -478,27 +476,27 @@
 		switch ($parts['type']) {
 			case 'select':
 				$ret  = 'SELECT ';
-				if ($parts['DISTINCT'])
+				if (isset($parts['DISTINCT']) && $parts['DISTINCT'])
 					$ret .= 'DISTINCT ';
 				$ret .= $parts['select'];
 				$ret .= ' FROM '.$parts['from'];
-				if ($parts['where'] != '')
+				if (isset($parts['where']) && $parts['where'] != '')
 					$ret .= ' WHERE '.$parts['where'];
-				if ($parts['groupby'] != '')
+				if (isset($parts['groupby']) && $parts['groupby'] != '')
 					$ret .= ' GROUP BY '.$parts['groupby'];
-				if ($parts['having'] != '')
+				if (isset($parts['having']) && $parts['having'] != '')
 					$ret .= ' HAVING '.$parts['having'];
-				if ($parts['orderby'] != '')
+				if (isset($parts['orderby']) && $parts['orderby'] != '')
 					$ret .= ' ORDER BY '.$parts['orderby'];
-				if ($parts['limit'] != '')
+				if (isset($parts['limit']) && $parts['limit'] != '')
 					$ret .= ' LIMIT '.$parts['limit'];
-				if ($parts['procedure'] != '')
+				if (isset($parts['procedure']) && $parts['procedure'] != '')
 					$ret .= ' PROCEDURE '.$parts['procedure'];
 				break;
 			case 'update':
 				$ret  = 'UPDATE '.$parts['table'];
 				$ret .= ' SET '.$parts['fields'];
-				if ($parts['where'] != '')
+				if (isset($parts['where']) && $parts['where'] != '')
 					$ret .= ' WHERE '.$parts['where'];
 				break;
 			case 'insert':
@@ -507,7 +505,7 @@
 				break;
 			case 'delete':
 				$ret  = 'DELETE FROM '.$parts['table'];
-				if ($parts['where'] != '')
+				if (isset($parts['where']) && $parts['where'] != '')
 					$ret .= ' WHERE '.$parts['where'];
 				break;
 			default:
@@ -524,7 +522,7 @@
 		$join_clause = $this->tb." AS $main_table";
 		for ($k = 0, $numfds = sizeof($this->fds); $k < $numfds; $k++) {
 			$main_column = $this->fds[$k];
-			if($this->fdd[$main_column]['values']['db']) {
+			if(isset($this->fdd[$main_column]['values']['db'])) {
 				$db = $this->fdd[$main_column]['values']['db'];
 			} else {
 				$db = $this->db;
@@ -673,7 +671,7 @@
 					$ids  = array();
 					$ar   = array();
 					$ar[$this->fqn($k)] = array('oper' => 'LIKE', 'value' => "'$afilter'");
-					if (is_array($this->fdd[$k]['values2'])) {
+					if (isset($this->fdd[$k]['values2']) && is_array($this->fdd[$k]['values2'])) {
 						foreach ($this->fdd[$k]['values2'] as $key => $val) {
 							if (strlen($m) > 0 && stristr($val, $m)) {
 								$ids[] = '"'.addslashes($key).'"';
@@ -756,8 +754,8 @@
 		if ($this->add_operation() || $this->change_operation() || $this->copy_operation()) {
 			$first_required = true;
 			for ($k = 0; $k < $this->num_fds; $k++) {
-				if ($this->displayed[$k] && ! $this->readonly($k) && ! $this->hidden($k)
-						&& ($this->fdd[$k]['js']['required'] || isset($this->fdd[$k]['js']['regexp']))) {
+				if ($this->displayed[$k] && ! $this->readonly($k) && ! $this->hidden($k) && isset($this->fdd[$k]['js'])
+						&& ((isset($this->fdd[$k]['js']['required']) && $this->fdd[$k]['js']['required']) || isset($this->fdd[$k]['js']['regexp']))) {
 					if ($first_required) {
 				 		$first_required = false;
 						echo '<script type="text/javascript"><!--',"\n";
@@ -947,7 +945,7 @@
 				} else {
 					echo ' wrap="virtual"';
 				}
-				echo '>',htmlspecialchars($this->fdd[$k]['default']),'</textarea>',"\n";
+				echo '>',isset($this->fdd[$k]['default']) ? htmlspecialchars($this->fdd[$k]['default']) : '','</textarea>',"\n";
 			} else {
 				// Simple edit box required
 				$size_ml_props = '';
@@ -1268,7 +1266,7 @@
 		if (@$this->fdd[$k]['strip_tags']) {
 			$value = strip_tags($value);
 		}
-		if (intval($this->fdd[$k]['trimlen']) > 0 && strlen($value) > $this->fdd[$k]['trimlen']) {
+		if (isset($this->fdd[$k]['trimlen']) && intval($this->fdd[$k]['trimlen']) > 0 && strlen($value) > $this->fdd[$k]['trimlen']) {
 			$value = ereg_replace("[\r\n\t ]+",' ',$value);
 			$value = substr($value, 0, $this->fdd[$k]['trimlen'] - 3).'...';
 		}
@@ -2040,6 +2038,12 @@
 			$qpcopyStr   = htmlspecialchars($this->page_name.'?'.join('&',$qpcopy).$this->qfn);
 			$qpchangeStr = htmlspecialchars($this->page_name.'?'.join('&',$qpchange).$this->qfn);
 			$qpdeleteStr = htmlspecialchars($this->page_name.'?'.join('&',$qpdelete).$this->qfn);
+		} else {
+			$qpviewStr      = '';
+			$qpcopyStr      = '';
+			$qpchangeStr    = '';
+			$qpdeleteStr    = '';
+		
 		}
 
 		$fetched  = true;
@@ -2162,7 +2166,7 @@
 		 * XXX this feature does not work yet!!!
 		 */
 		// aggregates listing (if any)
-		if ($$var_to_total) {
+		if (isset($var_to_total) && $$var_to_total) {
 			// do the aggregate query if necessary
 			//if ($vars_to_total) {
 				$qp = array();
@@ -2592,19 +2596,21 @@
 		$this->filter_operation() && $this->page_type = 'F';
 		$this->view_operation()   && $this->page_type = 'V';
 		if ($this->add_operation()
-				|| $this->saveadd == $this->labels['Save']
-				|| $this->moreadd == $this->labels['More']) {
+				|| (isset($this->saveadd) && $this->saveadd == $this->labels['Save'])
+				|| (isset($this->moreadd) &&$this->moreadd == $this->labels['More'])) {
 			$this->page_type = 'A';
 		}
 		if ($this->change_operation()
-				|| $this->savechange == $this->labels['Save']
-				|| $this->morechange == $this->labels['Apply']) {
+				|| (isset($this->savechange) && $this->savechange == $this->labels['Save'])
+				|| (isset($this->morechange) && $this->morechange == $this->labels['Apply'])) {
 			$this->page_type = 'C';
 		}
-		if ($this->copy_operation() || $this->savecopy == $this->labels['Save']) {
+		if ($this->copy_operation()
+				|| (isset($this->savecopy) && $this->savecopy == $this->labels['Save'])) {
 			$this->page_type = 'P';
 		}
-		if ($this->delete_operation() || $this->savedelete == $this->labels['Delete']) {
+		if ($this->delete_operation()
+				|| (isset($this->savedelete) && $this->savedelete == $this->labels['Delete'])) {
 			$this->page_type = 'D';
 		}
 		// Restore backups (if exists)
@@ -2628,7 +2634,7 @@
 					continue;
 				}
 				// Make field backups
-				$this->fdd[$column][$col_ar[0] .'~'] = $this->fdd[$column][$col_ar[0]];
+				isset($this->fdd[$column][$col_ar[0]]) && $this->fdd[$column][$col_ar[0] .'~'] = $this->fdd[$column][$col_ar[0]];
 				$this->fdd[$column][$col_option.'~'] = $this->fdd[$column][$col_option];
 				// Set particular field
 				$this->fdd[$column][$col_ar[0]] = $this->fdd[$column][$col_option];
@@ -2719,6 +2725,7 @@
 			}
 			// move 'HWR' flags from ['options'] into ['input']
 			if (isset($this->fdd[$column]['options'])) {
+				!isset($this->fdd[$column]['input']) && $this->fdd[$column]['input'] = '';
 				stristr($this->fdd[$column]['options'], 'H') && $this->fdd[$column]['input'] .= 'H';
 				stristr($this->fdd[$column]['options'], 'W') && $this->fdd[$column]['input'] .= 'W';
 				stristr($this->fdd[$column]['options'], 'R') && $this->fdd[$column]['input'] .= 'R';