$o_fld_val) { ?> $o_fld_val) { ?> " /> ' . PMA_showMySQLDocu('Reference', 'Column_types') . ''; $header_cells[] = $strLengthSet; if (PMA_MYSQL_INT_VERSION >= 40100) { $header_cells[] = $strCharset; } $header_cells[] = $strAttr; $header_cells[] = $strNull; $header_cells[] = $strDefault . '**'; $header_cells[] = $strExtra; require_once('./libraries/relation.lib.php'); require_once('./libraries/transformations.lib.php'); $cfgRelation = PMA_getRelationsParam(); $comments_map = array(); $mime_map = array(); $available_mime = array(); if ($cfgRelation['commwork']) { $comments_map = PMA_getComments($db, $table); $header_cells[] = $strComments; if ($cfgRelation['mimework'] && $cfg['BrowseMIME']) { $mime_map = PMA_getMIME($db, $table); $available_mime = PMA_getAvailableMIMEtypes(); $header_cells[] = $strMIME_MIMEtype; $header_cells[] = $strMIME_transformation; $header_cells[] = $strMIME_transformation_options . '***'; } } // lem9: We could remove this 'if' and let the key information be shown and // editable. However, for this to work, tbl_alter must be modified to use the // key fields, as tbl_addfield does. if (!$is_backup) { $header_cells[] = $strPrimary; $header_cells[] = $strIndex; $header_cells[] = $strUnique; $header_cells[] = '---'; $header_cells[] = $strIdxFulltext; } // garvin: workaround for field_fulltext, because its submitted indizes contain // the index as a value, not a key. Inserted here for easier maintaineance // and less code to change in existing files. if (isset($field_fulltext) && is_array($field_fulltext)) { foreach($field_fulltext AS $fulltext_nr => $fulltext_indexkey) { $submit_fulltext[$fulltext_indexkey] = $fulltext_indexkey; } } for ($i = 0 ; $i < $num_fields; $i++) { $submit_null = FALSE; if (isset($regenerate) && $regenerate == TRUE) { // An error happened with previous inputs, so we will restore the data // to embed it once again in this form. $row['Field'] = (isset($field_name) && isset($field_name[$i]) ? $field_name[$i] : FALSE); $row['Type'] = (isset($field_type) && isset($field_type[$i]) ? $field_type[$i] : FALSE); $row['Null'] = (isset($field_null) && isset($field_null[$i]) ? $field_null[$i] : ''); if ($row['Null'] == '') { $submit_null = TRUE; } if (isset(${'field_key_' . $i}) && ${'field_key_' . $i} == 'primary_' . $i) { $row['Key'] = 'PRI'; } elseif (isset(${'field_key_' . $i}) && ${'field_key_' . $i} == 'index_' . $i) { $row['Key'] = 'MUL'; } elseif (isset(${'field_key_' . $i}) && ${'field_key_' . $i} == 'unique_' . $i) { $row['Key'] = 'UNI'; } else { $row['Key'] = ''; } $row['Default'] = (isset($field_default) && isset($field_default[$i]) ? $field_default[$i] : FALSE); $row['Extra'] = (isset($field_extra) && isset($field_extra[$i]) ? $field_extra[$i] : FALSE); $row['Comment'] = (isset($submit_fulltext) && isset($submit_fulltext[$i]) && ($submit_fulltext[$i] == $i) ? 'FULLTEXT' : FALSE); $submit_length = (isset($field_length) && isset($field_length[$i]) ? $field_length[$i] : FALSE); $submit_attribute = (isset($field_attribute) && isset($field_attribute[$i]) ? $field_attribute[$i] : FALSE); if (isset($field_comments) && isset($field_comments[$i])) { $comments_map[$row['Field']] = $field_comments[$i]; } if (isset($field_mimetype) && isset($field_mimetype[$i])) { $mime_map[$row['Field']]['mimetype'] = $field_mimetype[$i]; } if (isset($field_transformation) && isset($field_transformation[$i])) { $mime_map[$row['Field']]['transformation'] = $field_transformation[$i]; } if (isset($field_transformation_options) && isset($field_transformation_options[$i])) { $mime_map[$row['Field']]['transformation_options'] = $field_transformation_options[$i]; } } elseif (isset($fields_meta)) { $row = $fields_meta[$i]; } $bgcolor = ($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; // Cell index: If certain fields get left out, the counter shouldn't chage. $ci = 0; // Everytime a cell shall be left out the STRG-jumping feature, $ci_offset // has to be incremented ($ci_offset++) $ci_offset = -1; if ($is_backup) { $backup_field = (isset($true_selected) && $true_selected[$i] ? $true_selected[$i] : (isset($row) && isset($row['Field']) ? urlencode($row['Field']) : '')); $content_cells[$i][$ci] = "\n" . '' . "\n"; } else { $content_cells[$i][$ci] = ''; } $content_cells[$i][$ci] .= "\n" . ''; $ci++; $content_cells[$i][$ci] = ''; $ci++; if ($is_backup) { $content_cells[$i][$ci] = "\n" . ''; } else { $content_cells[$i][$ci] = ''; } $content_cells[$i][$ci] .= "\n" . '' . "\n"; $ci++; if (preg_match('@^(set|enum)$@i', $type)) { $binary = 0; $unsigned = 0; $zerofill = 0; } else { $binary = stristr($row['Type'], 'binary'); $unsigned = stristr($row['Type'], 'unsigned'); $zerofill = stristr($row['Type'], 'zerofill'); } if (PMA_MYSQL_INT_VERSION >= 40100) { $content_cells[$i][$ci] = '' . "\n"; $ci++; } $content_cells[$i][$ci] = ''; $ci++; $content_cells[$i][$ci] = ''; $ci++; if (isset($row) && !isset($row['Default']) && !empty($row['Null'])) { $row['Default'] = 'NULL'; } if ($is_backup) { $content_cells[$i][$ci] = "\n" . ''; } else { $content_cells[$i][$ci] = "\n"; } $content_cells[$i][$ci] .= ''; $ci++; $content_cells[$i][$ci] = ''; $ci++; // garvin: comments if ($cfgRelation['commwork']) { $content_cells[$i][$ci] = ''; $ci++; } // garvin: MIME-types if ($cfgRelation['mimework'] && $cfg['BrowseMIME'] && $cfgRelation['commwork']) { $content_cells[$i][$ci] = ''; $ci++; $content_cells[$i][$ci] = ''; $ci++; $content_cells[$i][$ci] = ''; $ci++; } // lem9: See my other comment about removing this 'if'. if (!$is_backup) { if (isset($row) && isset($row['Key']) && $row['Key'] == 'PRI') { $checked_primary = ' checked="checked"'; } else { $checked_primary = ''; } if (isset($row) && isset($row['Key']) && $row['Key'] == 'MUL') { $checked_index = ' checked="checked"'; } else { $checked_index = ''; } if (isset($row) && isset($row['Key']) && $row['Key'] == 'UNI') { $checked_unique = ' checked="checked"'; } else { $checked_unique = ''; } if (empty($checked_primary) && empty($checked_index) && empty($checked_unique)) { $checked_none = ' checked="checked"'; } else { $checked_none = ''; } if ((isset($row) && isset($row['Comment']) && $row['Comment'] == 'FULLTEXT')) { $checked_fulltext = ' checked="checked"'; } else { $checked_fulltext = ''; } $content_cells[$i][$ci] = "\n" . ''; $ci++; $content_cells[$i][$ci] = "\n" . ''; $ci++; $content_cells[$i][$ci] = "\n" . ''; $ci++; $content_cells[$i][$ci] = "\n" . ''; $ci++; $content_cells[$i][$ci] = ''; } // end if ($action ==...) } // end for if ($cfg['DefaultPropDisplay'] == 'horizontal') { ?> $header_val) { ?> $content_row) { $i++; echo "\n" . '' . "\n"; $bgcolor = ($i % 2) ? $cfg['BgcolorOne'] : $cfg['BgcolorTwo']; if (is_array($content_row)) { foreach($content_row AS $content_row_nr => $content_row_val) { ?> ' . "\n"; } } ?>

$header_val) { echo "\n" . '' . "\n"; ?> ' . "\n"; $i++; } } ?>

= 40100) { echo ' ' . "\n" . ' ' . "\n"; } } echo "\n"; ?> 0) { while ($tmp = PMA_mysql_fetch_array($result)) { if (isset($tmp['Variable_name'])) { switch ($tmp['Variable_name']) { case 'have_bdb': if (isset($tmp['Variable_name']) && $tmp['Value'] == 'YES') { $tbl_bdb = TRUE; } break; case 'have_gemini': if (isset($tmp['Variable_name']) && $tmp['Value'] == 'YES') { $tbl_gemini = TRUE; } break; case 'have_innodb': if (isset($tmp['Variable_name']) && $tmp['Value'] == 'YES') { $tbl_innodb = TRUE; } break; case 'have_isam': if (isset($tmp['Variable_name']) && $tmp['Value'] == 'YES') { $tbl_isam = TRUE; } break; } // end switch } // end if } // end while } // end if mysql_free_result($result); echo "\n"; ?> = 40100) { echo ' ' . "\n" . ' ' . "\n"; } } echo "\n"; ?>

:		:		' . $strCharset . ' :
				' . "\n" . ' ' . "\n" . '

*
**
***
***	', '') . "\n"; ?>