Menu
▾
▴
[eGroupWare-svn] r42739 - in /trunk/etemplate: inc/class.db_tools.inc.php setup/etemplates.inc.php templates/default/db-tools.edit.xet
|
From: <ral...@us...> - 2013-06-11 14:48:35
|
Author: ralfbecker Date: Tue Jun 11 16:48:25 2013 New Revision: 42739 URL: http://svn.stylite.de/viewvc/egroupware?rev=42739&view=rev Log: allow db-tools to edit meta information about schema, currently what is stored in integer columns, eg: "timestamp", "account", "account-commasep" or "category" Modified: trunk/etemplate/inc/class.db_tools.inc.php trunk/etemplate/setup/etemplates.inc.php trunk/etemplate/templates/default/db-tools.edit.xet Modified: trunk/etemplate/inc/class.db_tools.inc.php URL: http://svn.stylite.de/viewvc/egroupware/trunk/etemplate/inc/class.db_tools.inc.php?rev=42739&r1=42738&r2=42739&view=diff ============================================================================== --- trunk/etemplate/inc/class.db_tools.inc.php (original) +++ trunk/etemplate/inc/class.db_tools.inc.php Tue Jun 11 16:48:25 2013 @@ -4,7 +4,7 @@ * * @link http://www.egroupware.org * @author Ralf Becker <Ral...@ou...> - * @copyright 2002-9 by Ral...@ou... + * @copyright 2002-13 by Ral...@ou... * @license http://opensource.org/licenses/gpl-license.php GPL - GNU General Public License * @package etemplate * @subpackage tools @@ -71,6 +71,26 @@ 'bool' => 'boolean', // 'abstime' => 'abstime (mysql:timestamp)', ); + /** + * Available meta-types + * + * @var array + */ + protected static $meta_types = array( + '' => '', + 'account' => 'user or group', + 'account-commasep' => 'multiple comma-separated users or groups', + 'account-abs' => 'user or group (with positiv id)', + 'user' => 'a single user', + 'user-commasep' => 'multiple comma-separated users', + 'user-serialized' => 'multiple serialized users or groups (do NOT use!)', + 'group' => 'a single group', + 'group-commasep' => 'multiple comma-separated groups', + 'group-abs' => 'single group (with positive id)', + 'timestamp' => 'unix timestamp', + 'category' => 'category id', + 'percent' => '0 - 100', + ); /** * constructor of class @@ -223,8 +243,32 @@ } $sel_options = array( 'table_name' => $table_names, - 'type' => $this->types + 'type' => $this->types, ); + foreach(self::$meta_types as $value => $title) + { + $sel_options['meta'][$value] = $value ? array( + 'label' => $value, + 'title' => $title, + ) : $title; + } + foreach($this->data[$this->table]['fd'] as $col => $data) + { + $meta = $title = $data['meta']; + if (empty($meta)) continue; + if (is_array($meta)) + { + $this->data[$this->table]['fd'][$col]['meta'] = $meta = serialize($meta); + $title = $this->write_array($data['meta'], 0); + } + if (!isset($sel_options['meta'][$meta])) + { + $sel_options['meta'][$meta] = array( + 'label' => lang('Custom'), + 'title' => $title, + ); + } + } if ($this->table != '' && isset($this->data[$this->table])) { $content += $this->table2content($this->data[$this->table],$sel_options['Index'],$add_index); @@ -492,6 +536,7 @@ { case 'default': case 'type': // selectbox ensures type is not empty + case 'meta': case 'precision': case 'scale': case 'comment': @@ -625,7 +670,20 @@ { if (!is_int($key)) { - $def .= "'$key' => "; + if (strpos($key, "'") !== false && strpos($key, '"') === false) + { + $def .= '"'.$key.'"'; + } + else + { + $def .= "'".addslashes($key)."'"; + } + $def .= ' => '; + } + // unserialize custom meta values + if ($key === 'meta' && is_string($val) && (($v = @unserialize($val)) !== false || $val === serialize(false))) + { + $val = $v; } if (is_array($val)) { @@ -637,9 +695,13 @@ { $def .= $val ? 'True' : 'False'; } + elseif (strpos($val, "'") !== false && strpos($val, '"') === false) + { + $def .= '"'.$val.'"'; + } else { - $def .= "'$val'"; + $def .= "'".addslashes($val)."'"; } } if ($n < count($arr)-1) @@ -1044,6 +1106,7 @@ 'nullable' => !isset($props['nullable']) || !!$props['nullable'], 'default' => (string)$props['default'], 'comment' => (string)$props['comment'], + 'meta' => is_array($props['meta']) ? serialize($props['meta']) : $props['meta'], ); } return array( Modified: trunk/etemplate/setup/etemplates.inc.php URL: http://svn.stylite.de/viewvc/egroupware/trunk/etemplate/setup/etemplates.inc.php?rev=42739&r1=42738&r2=42739&view=diff ============================================================================== --- trunk/etemplate/setup/etemplates.inc.php (original) +++ trunk/etemplate/setup/etemplates.inc.php Tue Jun 11 16:48:25 2013 @@ -2,7 +2,7 @@ /** * EGroupware - eTemplates for Application etemplate * http://www.egroupware.org - * generated by soetemplate::dump4setup() 2013-04-23 11:56 + * generated by soetemplate::dump4setup() 2013-06-11 16:46 * * @license http://opensource.org/licenses/gpl-license.php GPL - GNU General Public License * @package etemplate @@ -59,7 +59,7 @@ $templ_data[] = array('name' => 'etemplate.db-tools.ask_save','template' => '','lang' => '','group' => '0','version' => '1.0.0.001','data' => 'a:1:{i:0;a:5:{s:4:"type";s:4:"grid";s:4:"data";a:8:{i:0;a:1:{s:2:"h1";s:6:",!@msg";}i:1;a:2:{s:1:"A";a:4:{s:4:"type";s:5:"label";s:4:"span";s:13:"all,redItalic";s:4:"name";s:3:"msg";s:7:"no_lang";s:1:"1";}s:1:"B";a:1:{s:4:"type";s:5:"label";}}i:2;a:2:{s:1:"A";a:2:{s:4:"type";s:5:"label";s:4:"span";s:3:"all";}s:1:"B";a:1:{s:4:"type";s:5:"label";}}i:3;a:2:{s:1:"A";a:6:{s:7:"no_lang";s:1:"1";s:5:"align";s:5:"right";s:4:"name";s:7:"version";s:4:"size";s:2:"bi";s:4:"type";s:5:"label";s:5:"label";s:27:"Update from Version \'%s\' to";}s:1:"B";a:3:{s:4:"name";s:11:"new_version";s:4:"type";s:4:"text";s:4:"help";s:75:"enter the new version number here (> old_version), empty for no update-file";}}i:4;a:2:{s:1:"A";a:2:{s:4:"span";s:3:"all";s:4:"type";s:5:"label";}s:1:"B";a:1:{s:4:"type";s:5:"label";}}i:5;a:2:{s:1:"A";a:7:{s:4:"span";s:3:"all";s:7 :"no_lang";s:1:"1";s:5:"align";s:6:"center";s:4:"name";s:5:"table";s:4:"size";s:1:"b";s:4:"type";s:5:"label";s:5:"label";s:53:"Do you want to save the changes you made in table %s?";}s:1:"B";a:1:{s:4:"type";s:5:"label";}}i:6;a:2:{s:1:"A";a:2:{s:4:"span";s:3:"all";s:4:"type";s:5:"label";}s:1:"B";a:1:{s:4:"type";s:5:"label";}}i:7;a:2:{s:1:"A";a:5:{s:5:"label";s:3:"Yes";s:5:"align";s:5:"right";s:4:"name";s:3:"yes";s:4:"type";s:6:"button";s:4:"help";s:39:"saves changes to tables_current.inc.php";}s:1:"B";a:4:{s:5:"label";s:2:"No";s:4:"name";s:2:"no";s:4:"type";s:6:"button";s:4:"help";s:15:"discard changes";}}}s:4:"cols";i:2;s:4:"rows";i:7;s:4:"size";s:4:"100%";}}','size' => '100%','style' => '','modified' => '1112602648',); -$templ_data[] = array('name' => 'etemplate.db-tools.cols','template' => '','lang' => '','group' => '0','version' => '1.7.001','data' => 'a:1:{i:0;a:4:{s:4:"type";s:4:"grid";s:4:"data";a:3:{i:0;a:2:{s:2:"c1";s:3:"nmh";s:2:"c2";s:3:"nmr";}i:1;a:14:{s:1:"A";a:4:{s:4:"type";s:5:"label";s:5:"label";s:1:"#";s:7:"no_lang";s:1:"1";s:5:"align";s:6:"center";}s:1:"B";a:2:{s:4:"type";s:5:"label";s:5:"label";s:10:"ColumnName";}s:1:"C";a:2:{s:4:"type";s:5:"label";s:5:"label";s:4:"Type";}s:1:"D";a:2:{s:4:"type";s:5:"label";s:5:"label";s:9:"Precision";}s:1:"E";a:2:{s:4:"type";s:5:"label";s:5:"label";s:5:"Scale";}s:1:"F";a:2:{s:4:"type";s:5:"label";s:5:"label";s:8:"NOT NULL";}s:1:"G";a:2:{s:4:"type";s:5:"label";s:5:"label";s:11:"Primary Key";}s:1:"H";a:2:{s:4:"type";s:5:"label";s:5:"label";s:6:"Unique";}s:1:"I";a:2:{s:4:"type";s:5:"label";s:5:"label";s:7:"Indexed";}s:1:"J";a:2:{s:4:"type";s:5:"label";s:5:"label";s:7:"Default";}s:1:"K";a:2:{s:4:"type";s:5:"label";s:5:"label";s:7:"Comment";}s: 1:"L";a:2:{s:4:"type";s:5:"label";s:5:"label";s:12:"Indexoptions";}s:1:"M";a:2:{s:4:"type";s:5:"label";s:5:"label";s:11:"Foreign Key";}s:1:"N";a:5:{s:4:"type";s:6:"button";s:5:"label";s:10:"Add Column";s:5:"align";s:6:"center";s:4:"name";s:10:"add_column";s:4:"help";s:42:"Add a new column (after the existing ones)";}}i:2;a:14:{s:1:"A";a:4:{s:4:"type";s:5:"label";s:7:"no_lang";s:1:"1";s:5:"align";s:6:"center";s:4:"name";s:12:"Row${row}[n]";}s:1:"B";a:5:{s:4:"type";s:4:"text";s:4:"size";s:2:"15";s:7:"no_lang";s:1:"1";s:4:"name";s:15:"Row${row}[name]";s:4:"help";s:127:"need to be unique in the table and no reseved word from SQL, best prefix all with a common 2-digit short for the app, eg. \'et_\'";}s:1:"C";a:4:{s:4:"type";s:6:"select";s:7:"no_lang";s:1:"1";s:4:"name";s:15:"Row${row}[type]";s:4:"help";s:18:"type of the column";}s:1:"D";a:4:{s:4:"type";s:3:"int";s:5:"align";s:6:"center";s:4:"name";s:20:"Row${row}[precision]";s:4:"help";s:64:"length for char+varchar, precisions in t: 2, 4, 8 and float: 4, 8";}s:1:"E";a:3:{s:4:"type";s:3:"int";s:4:"name";s:16:"Row${row}[scale]";s:4:"help";s:15:"scale for float";}s:1:"F";a:4:{s:4:"type";s:8:"checkbox";s:5:"align";s:6:"center";s:4:"name";s:18:"Row${row}[notnull]";s:4:"help";s:35:"can not have special SQL-value NULL";}s:1:"G";a:4:{s:4:"type";s:8:"checkbox";s:5:"align";s:6:"center";s:4:"name";s:13:"Row${row}[pk]";s:4:"help";s:52:"Primary key for the table, gets automaticaly indexed";}s:1:"H";a:4:{s:4:"type";s:8:"checkbox";s:5:"align";s:6:"center";s:4:"name";s:13:"Row${row}[uc]";s:4:"help";s:59:"DB ensures that every row has a unique value in that column";}s:1:"I";a:4:{s:4:"type";s:8:"checkbox";s:5:"align";s:6:"center";s:4:"name";s:13:"Row${row}[ix]";s:4:"help";s:81:"an indexed column speeds up querys using that column (cost space on the disk !!!)";}s:1:"J";a:4:{s:4:"type";s:4:"text";s:4:"size";s:1:"8";s:4:"name";s:18:"Row${row}[default]";s:4:"help";s:54:"enter \'\' for an empty default, nothing mean no def ault";}s:1:"K";a:3:{s:4:"type";s:4:"text";s:4:"size";s:2:"20";s:4:"name";s:18:"Row${row}[comment]";}s:1:"L";a:4:{s:4:"type";s:4:"text";s:4:"size";s:1:"8";s:4:"name";s:18:"Row${row}[options]";s:4:"help";s:105:"DB-specific index options (comma-sep.), eg. mysql(FULLTEXT) or mysql(100) for the indexed length of a col";}s:1:"M";a:5:{s:4:"type";s:4:"text";s:4:"size";s:1:"8";s:5:"align";s:6:"center";s:4:"name";s:13:"Row${row}[fk]";s:4:"help";s:46:"name of other table where column is a key from";}s:1:"N";a:5:{s:4:"type";s:6:"button";s:5:"label";s:13:"Delete Column";s:5:"align";s:6:"center";s:4:"name";s:12:"delete[$row]";s:4:"help";s:19:"Deletes this column";}}}s:4:"rows";i:2;s:4:"cols";i:14;}}','size' => '','style' => '','modified' => '1067163210',); +$templ_data[] = array('name' => 'etemplate.db-tools.cols','template' => '','lang' => '','group' => '0','version' => '1.9.001','data' => 'a:1:{i:0;a:4:{s:4:"type";s:4:"grid";s:4:"data";a:3:{i:0;a:2:{s:2:"c1";s:3:"nmh";s:2:"c2";s:3:"nmr";}i:1;a:15:{s:1:"A";a:4:{s:4:"type";s:5:"label";s:5:"label";s:1:"#";s:7:"no_lang";s:1:"1";s:5:"align";s:6:"center";}s:1:"B";a:2:{s:4:"type";s:5:"label";s:5:"label";s:10:"ColumnName";}s:1:"C";a:2:{s:4:"type";s:5:"label";s:5:"label";s:4:"Type";}s:1:"D";a:2:{s:4:"type";s:5:"label";s:5:"label";s:9:"Meta-type";}s:1:"E";a:2:{s:4:"type";s:5:"label";s:5:"label";s:9:"Precision";}s:1:"F";a:2:{s:4:"type";s:5:"label";s:5:"label";s:5:"Scale";}s:1:"G";a:2:{s:4:"type";s:5:"label";s:5:"label";s:8:"NOT NULL";}s:1:"H";a:2:{s:4:"type";s:5:"label";s:5:"label";s:11:"Primary Key";}s:1:"I";a:2:{s:4:"type";s:5:"label";s:5:"label";s:6:"Unique";}s:1:"J";a:2:{s:4:"type";s:5:"label";s:5:"label";s:7:"Indexed";}s:1:"K";a:2:{s:4:"type";s:5:"label";s:5:"label";s:7:"Default";} s:1:"L";a:2:{s:4:"type";s:5:"label";s:5:"label";s:7:"Comment";}s:1:"M";a:2:{s:4:"type";s:5:"label";s:5:"label";s:12:"Indexoptions";}s:1:"N";a:2:{s:4:"type";s:5:"label";s:5:"label";s:11:"Foreign Key";}s:1:"O";a:5:{s:4:"type";s:6:"button";s:5:"label";s:10:"Add Column";s:5:"align";s:6:"center";s:4:"name";s:10:"add_column";s:4:"help";s:42:"Add a new column (after the existing ones)";}}i:2;a:15:{s:1:"A";a:4:{s:4:"type";s:5:"label";s:7:"no_lang";s:1:"1";s:5:"align";s:6:"center";s:4:"name";s:12:"Row${row}[n]";}s:1:"B";a:5:{s:4:"type";s:4:"text";s:4:"size";s:2:"15";s:7:"no_lang";s:1:"1";s:4:"name";s:15:"Row${row}[name]";s:4:"help";s:127:"need to be unique in the table and no reseved word from SQL, best prefix all with a common 2-digit short for the app, eg. \'et_\'";}s:1:"C";a:4:{s:4:"type";s:6:"select";s:7:"no_lang";s:1:"1";s:4:"name";s:15:"Row${row}[type]";s:4:"help";s:18:"type of the column";}s:1:"D";a:6:{s:4:"type";s:6:"select";s:7:"no_lang";s:1:"1";s:4:"name";s:15:"Row${row}[me ta]";s:4:"help";s:23:"meta-type of the column";s:4:"span";s:19:",selectboxFullWidth";s:4:"size";s:8:",,,,,,,0";}s:1:"E";a:4:{s:4:"type";s:3:"int";s:5:"align";s:6:"center";s:4:"name";s:20:"Row${row}[precision]";s:4:"help";s:64:"length for char+varchar, precisions int: 2, 4, 8 and float: 4, 8";}s:1:"F";a:3:{s:4:"type";s:3:"int";s:4:"name";s:16:"Row${row}[scale]";s:4:"help";s:15:"scale for float";}s:1:"G";a:4:{s:4:"type";s:8:"checkbox";s:5:"align";s:6:"center";s:4:"name";s:18:"Row${row}[notnull]";s:4:"help";s:35:"can not have special SQL-value NULL";}s:1:"H";a:4:{s:4:"type";s:8:"checkbox";s:5:"align";s:6:"center";s:4:"name";s:13:"Row${row}[pk]";s:4:"help";s:52:"Primary key for the table, gets automaticaly indexed";}s:1:"I";a:4:{s:4:"type";s:8:"checkbox";s:5:"align";s:6:"center";s:4:"name";s:13:"Row${row}[uc]";s:4:"help";s:59:"DB ensures that every row has a unique value in that column";}s:1:"J";a:4:{s:4:"type";s:8:"checkbox";s:5:"align";s:6:"center";s:4:"name";s:13:"Row${row}[i x]";s:4:"help";s:81:"an indexed column speeds up querys using that column (cost space on the disk !!!)";}s:1:"K";a:4:{s:4:"type";s:4:"text";s:4:"size";s:1:"8";s:4:"name";s:18:"Row${row}[default]";s:4:"help";s:54:"enter \'\' for an empty default, nothing mean no default";}s:1:"L";a:3:{s:4:"type";s:4:"text";s:4:"size";s:2:"20";s:4:"name";s:18:"Row${row}[comment]";}s:1:"M";a:4:{s:4:"type";s:4:"text";s:4:"size";s:1:"8";s:4:"name";s:18:"Row${row}[options]";s:4:"help";s:105:"DB-specific index options (comma-sep.), eg. mysql(FULLTEXT) or mysql(100) for the indexed length of a col";}s:1:"N";a:5:{s:4:"type";s:4:"text";s:4:"size";s:1:"8";s:5:"align";s:6:"center";s:4:"name";s:13:"Row${row}[fk]";s:4:"help";s:46:"name of other table where column is a key from";}s:1:"O";a:5:{s:4:"type";s:6:"button";s:5:"label";s:13:"Delete Column";s:5:"align";s:6:"center";s:4:"name";s:12:"delete[$row]";s:4:"help";s:19:"Deletes this column";}}}s:4:"rows";i:2;s:4:"cols";i:15;}}','size' => '','style' => '',' modified' => '1067163210',); $templ_data[] = array('name' => 'etemplate.db-tools.edit','template' => '','lang' => '','group' => '0','version' => '1.7.001','data' => 'a:1:{i:0;a:5:{s:4:"type";s:4:"grid";s:4:"data";a:5:{i:0;a:2:{s:1:"D";s:2:"1%";s:2:"h1";s:6:",!@msg";}i:1;a:7:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"span";s:13:"all,redItalic";s:4:"name";s:3:"msg";}s:1:"B";a:1:{s:4:"type";s:5:"label";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}s:1:"G";a:1:{s:4:"type";s:5:"label";}}i:2;a:7:{s:1:"A";a:7:{s:4:"type";s:10:"select-app";s:4:"size";s:19:"Select one ...,,all";s:5:"label";s:11:"Application";s:7:"no_lang";s:1:"1";s:4:"name";s:3:"app";s:8:"onchange";s:1:"1";s:4:"help";s:40:"Select an application, (*) = uninstalled";}s:1:"B";a:6:{s:4:"type";s:6:"select";s:5:"label";s:9:"TableName";s:7:"no_lang";s:1:"1";s:4:"name";s:10:"table_name";s:8:"onchange";s:1:"1";s:4:"help";s:34:"Select an table of the appl ication";}s:1:"C";a:5:{s:4:"type";s:4:"text";s:4:"size";s:2:"20";s:5:"align";s:5:"right";s:4:"name";s:14:"new_table_name";s:4:"help";s:20:"Name of table to add";}s:1:"D";a:4:{s:4:"type";s:6:"button";s:5:"label";s:9:"Add Table";s:4:"name";s:9:"add_table";s:4:"help";s:38:"Create a new table for the application";}s:1:"E";a:4:{s:4:"type";s:6:"button";s:5:"label";s:6:"Import";s:4:"name";s:6:"import";s:4:"help";s:47:"Import table-definitions from existing db-table";}s:1:"F";a:5:{s:4:"type";s:6:"button";s:5:"label";s:10:"Drop Table";s:4:"name";s:10:"drop_table";s:8:"disabled";s:1:"1";s:4:"help";s:37:"Drop a table - this can NOT be undone";}s:1:"G";a:4:{s:4:"type";s:6:"button";s:5:"label";s:12:"Write Tables";s:4:"name";s:12:"write_tables";s:4:"help";s:40:"Write <app>/setup/tables_current.inc.php";}}i:3;a:7:{s:1:"A";a:3:{s:4:"type";s:8:"template";s:4:"span";s:3:"all";s:4:"name";s:23:"etemplate.db-tools.cols";}s:1:"B";a:1:{s:4:"type";s:5:"label";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s :1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}s:1:"G";a:1:{s:4:"type";s:5:"label";}}i:4;a:7:{s:1:"A";a:3:{s:4:"type";s:8:"template";s:4:"span";s:3:"all";s:4:"name";s:26:"etemplate.db-tools.indices";}s:1:"B";a:1:{s:4:"type";s:5:"label";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}s:1:"G";a:1:{s:4:"type";s:5:"label";}}}s:4:"rows";i:4;s:4:"cols";i:7;s:4:"size";s:4:"100%";}}','size' => '100%','style' => '','modified' => '1242199350',); @@ -105,7 +105,7 @@ $templ_data[] = array('name' => 'etemplate.editor.widget.contact','template' => '','lang' => '','group' => '0','version' => '1.7.001','data' => 'a:1:{i:0;a:4:{s:4:"type";s:4:"grid";s:4:"data";a:5:{i:0;a:5:{s:2:"c1";s:3:"row";s:2:"c2";s:3:"row";s:2:"c3";s:3:"row";s:2:"c4";s:3:"row";s:2:"h4";s:14:",!@type=button";}i:1;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,type";s:5:"label";s:4:"Type";}s:1:"B";a:4:{s:4:"type";s:6:"select";s:4:"name";s:4:"type";s:8:"onchange";s:1:"1";s:4:"help";s:57:"type of the field (select Label if field should be empty)";}s:1:"C";a:5:{s:4:"type";s:14:"contact-fields";s:4:"name";s:4:"size";s:4:"help";s:21:"Contact field to show";s:4:"span";s:3:"all";s:5:"label";s:5:"Field";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:2;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:8:",,,label";s:5:"label";s:5:"Label";}s:1:"B";a:3:{s:4:"type";s:4:"text";s:4:"name";s:5:"label";s: 4:"help";s:118:"displayed in front of input or input is inserted for a \'%s\' in the label (label of the Submitbutton or Image-filename)";}s:1:"C";a:6:{s:4:"type";s:4:"text";s:4:"size";s:2:"10";s:4:"name";s:4:"span";s:4:"help";s:111:"number of colums the field/cell should span or \'all\' for the remaining columns, CSS-class name (for the TD tag)";s:5:"label";s:11:"Span, Class";s:4:"span";s:1:"2";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:3:{s:4:"type";s:5:"label";s:5:"label";s:5:"Align";s:5:"align";s:6:"center";}s:1:"F";a:3:{s:4:"type";s:6:"select";s:4:"name";s:5:"align";s:4:"help";s:48:"alignment of label and input-field in table-cell";}}i:3;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,name";s:5:"label";s:4:"Name";}s:1:"B";a:3:{s:4:"type";s:4:"text";s:4:"name";s:4:"name";s:4:"help";s:78:"index/name of returned content (name of the Template, Link / Method for Image)";}s:1:"C";a:5:{s:4:"type";s:8:"checkbox";s:5:"label";s:11:"%s disabled";s:4:"name";s:8:"di sabled";s:4:"help";s:96:"if field is disabled an empty table-cell is displayed, for (temporal) removement of a field/cell";s:4:"span";s:3:"all";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:4;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:"onclick";s:5:"label";s:7:"onClick";}s:1:"B";a:5:{s:4:"type";s:4:"hbox";s:4:"size";s:6:"2,,0,0";i:1;a:3:{s:4:"type";s:6:"select";s:4:"name";s:12:"onclick_type";s:4:"help";s:43:"confirmation necesary or custom java-script";}i:2;a:5:{s:4:"type";s:4:"text";s:4:"span";s:27:"all,leftPad5 inputFullWidth";s:4:"name";s:7:"onclick";s:4:"help";s:67:"confirmation message or custom javascript (returning true or false)";s:5:"align";s:5:"right";}s:4:"span";s:3:"all";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}}s:4:"rows";i:4;s:4:"cols";i:6;}}','size' => '','style' => '','mo dified' => '1242559642',); -$templ_data[] = array('name' => 'etemplate.editor.widget.generic','template' => '','lang' => '','group' => '0','version' => '1.7.001','data' => 'a:1:{i:0;a:6:{s:4:"type";s:4:"grid";s:4:"data";a:8:{i:0;a:10:{s:2:"c1";s:3:"row";s:2:"c2";s:3:"row";s:2:"c3";s:3:"row";s:2:"c5";s:3:"row";s:2:"c6";s:3:"row";s:2:"h6";s:12:",@type=label";s:2:"c4";s:3:"row";s:2:"h4";s:12:",@type=label";s:2:"c7";s:3:"row";s:1:"A";s:2:"70";}i:1;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,type";s:5:"label";s:4:"Type";}s:1:"B";a:4:{s:4:"type";s:6:"select";s:4:"name";s:4:"type";s:8:"onchange";s:1:"1";s:4:"help";s:57:"type of the field (select Label if field should be empty)";}s:1:"C";a:4:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,size";s:5:"label";s:7:"Options";s:5:"align";s:6:"center";}s:1:"D";a:4:{s:4:"type";s:4:"text";s:4:"size";s:2:"10";s:4:"name";s:4:"size";s:4:"help";s:187:"Label:[bold][italic] Text:[len][,max] Numbers:[min][,[max][,len]] T.area:[rows][,cols] Radiob.:value H.Rule:[wid th] Templ.:[IndexInContent] Select:[multiselect] Date:[values: eg. \'Y-m-d\']";}s:1:"E";a:4:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,span";s:5:"label";s:11:"Span, Class";s:5:"align";s:6:"center";}s:1:"F";a:4:{s:4:"type";s:4:"text";s:4:"size";s:2:"10";s:4:"name";s:4:"span";s:4:"help";s:111:"number of colums the field/cell should span or \'all\' for the remaining columns, CSS-class name (for the TD tag)";}}i:2;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:8:",,,label";s:5:"label";s:5:"Label";}s:1:"B";a:3:{s:4:"type";s:4:"text";s:4:"name";s:5:"label";s:4:"help";s:118:"displayed in front of input or input is inserted for a \'%s\' in the label (label of the Submitbutton or Image-filename)";}s:1:"C";a:6:{s:4:"type";s:8:"checkbox";s:4:"span";s:1:"2";s:5:"label";s:16:"%s NoTranslation";s:5:"align";s:6:"center";s:4:"name";s:7:"no_lang";s:4:"help";s:82:"select if content of field should not be translated (label gets always translated)";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s :1:"E";a:3:{s:4:"type";s:5:"label";s:5:"label";s:5:"Align";s:5:"align";s:6:"center";}s:1:"F";a:3:{s:4:"type";s:6:"select";s:4:"name";s:5:"align";s:4:"help";s:48:"alignment of label and input-field in table-cell";}}i:3;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,name";s:5:"label";s:4:"Name";}s:1:"B";a:3:{s:4:"type";s:4:"text";s:4:"name";s:4:"name";s:4:"help";s:78:"index/name of returned content (name of the Template, Link / Method for Image)";}s:1:"C";a:6:{s:4:"type";s:4:"hbox";s:4:"size";s:1:"3";s:4:"span";s:1:"4";i:1;a:5:{s:4:"type";s:8:"checkbox";s:5:"label";s:9:"%s needed";s:5:"align";s:6:"center";s:4:"name";s:6:"needed";s:4:"help";s:39:"check if field has to be filled by user";}i:2;a:5:{s:4:"type";s:8:"checkbox";s:5:"label";s:11:"%s readonly";s:5:"align";s:6:"center";s:4:"name";s:8:"readonly";s:4:"help";s:94:"check if content should only be displayed but not altered (the content is not send back then!)";}i:3;a:5:{s:4:"type";s:8:"checkbox";s:5:"label";s:11 :"%s disabled";s:5:"align";s:6:"center";s:4:"name";s:8:"disabled";s:4:"help";s:96:"if field is disabled an empty table-cell is displayed, for (temporal) removement of a field/cell";}}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:4;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,blur";s:5:"label";s:8:"blurText";}s:1:"B";a:3:{s:4:"type";s:4:"text";s:4:"name";s:4:"blur";s:4:"help";s:76:"this text gets displayed if the input-field is empty and has no focus (blur)";}s:1:"C";a:5:{s:4:"type";s:4:"hbox";s:4:"span";s:1:"4";s:4:"size";s:1:"2";i:1;a:5:{s:4:"type";s:3:"int";s:5:"label";s:8:"Tabindex";s:4:"span";s:1:"2";s:4:"name";s:8:"tabindex";s:4:"help";s:47:"Order to navigating by tab key through the form";}i:2;a:5:{s:4:"type";s:4:"text";s:4:"size";s:3:"1,1";s:4:"name";s:9:"accesskey";s:4:"help";s:67:"Accesskeys can also be specified with an & in the label (eg. &Name)";s:5:"label";s:9:"Accesskey";}}s:1:"D ";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:5;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,help";s:5:"label";s:4:"Help";}s:1:"B";a:5:{s:4:"type";s:4:"text";s:4:"size";s:2:"71";s:4:"span";s:18:"all,inputFullWidth";s:4:"name";s:4:"help";s:4:"help";s:60:"displayed in statusline of browser if input-field gets focus";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:6;a:6:{s:1:"A";a:2:{s:4:"type";s:5:"label";s:5:"label";s:8:"onChange";}s:1:"B";a:5:{s:4:"type";s:4:"hbox";s:4:"size";s:6:"2,,0,0";i:1;a:3:{s:4:"type";s:6:"select";s:4:"name";s:13:"onchange_type";s:4:"help";s:65:"Should the form be submitted or any custom javascript be executed";}i:2;a:6:{s:4:"type";s:4:"text";s:4:"size";s:2:"50";s:4:"span";s:27:"all,leftPad5 inputFullWidth";s:4:"name";s:8:"onchange";s:4:"help";s:30:"custom javascript for on Change";s:5:"align";s:5:"right";}s:4:"span";s:3:"all";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:7;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:"onclick";s:5:"label";s:7:"onClick";}s:1:"B";a:5:{s:4:"type";s:4:"hbox";s:4:"size";s:6:"2,,0,0";i:1;a:3:{s:4:"type";s:6:"select";s:4:"name";s:12:"onclick_type";s:4:"help";s:43:"confirmation necesary or custom java-script";}i:2;a:6:{s:4:"type";s:4:"text";s:4:"size";s:2:"53";s:4:"span";s:27:"all,leftPad5 inputFullWidth";s:4:"name";s:7:"onclick";s:4:"help";s:67:"confirmation message or custom javascript (returning true or false)";s:5:"align";s:5:"right";}s:4:"span";s:3:"all";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}}s:4:"rows";i:7;s:4:"cols";i:6;s:4:"size";s:4:"100%";s:7:"options";a:1:{i:0;s:4:"100%";}}}','size' => '100%','style' => '','modified' => '1242559548',); +$templ_data[] = array('name' => 'etemplate.editor.widget.generic','template' => '','lang' => '','group' => '0','version' => '1.7.001','data' => 'a:1:{i:0;a:6:{s:4:"type";s:4:"grid";s:4:"data";a:8:{i:0;a:10:{s:2:"c1";s:3:"row";s:2:"c2";s:3:"row";s:2:"c3";s:3:"row";s:2:"c5";s:3:"row";s:2:"c6";s:3:"row";s:2:"h6";s:12:",@type=label";s:2:"c4";s:3:"row";s:2:"h4";s:12:",@type=label";s:2:"c7";s:3:"row";s:1:"A";s:2:"70";}i:1;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,type";s:5:"label";s:4:"Type";}s:1:"B";a:4:{s:4:"type";s:6:"select";s:4:"name";s:4:"type";s:8:"onchange";i:1;s:4:"help";s:57:"type of the field (select Label if field should be empty)";}s:1:"C";a:4:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,size";s:5:"label";s:7:"Options";s:5:"align";s:6:"center";}s:1:"D";a:4:{s:4:"type";s:4:"text";s:4:"size";s:2:"10";s:4:"name";s:4:"size";s:4:"help";s:187:"Label:[bold][italic] Text:[len][,max] Numbers:[min][,[max][,len]] T.area:[rows][,cols] Radiob.:value H.Rule:[width] Templ.:[IndexInContent] Select:[multiselect] Date:[values: eg. \'Y-m-d\']";}s:1:"E";a:4:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,span";s:5:"label";s:11:"Span, Class";s:5:"align";s:6:"center";}s:1:"F";a:4:{s:4:"type";s:4:"text";s:4:"size";s:2:"10";s:4:"name";s:4:"span";s:4:"help";s:111:"number of colums the field/cell should span or \'all\' for the remaining columns, CSS-class name (for the TD tag)";}}i:2;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:8:",,,label";s:5:"label";s:5:"Label";}s:1:"B";a:3:{s:4:"type";s:4:"text";s:4:"name";s:5:"label";s:4:"help";s:118:"displayed in front of input or input is inserted for a \'%s\' in the label (label of the Submitbutton or Image-filename)";}s:1:"C";a:6:{s:4:"type";s:8:"checkbox";s:4:"span";s:1:"2";s:5:"label";s:16:"%s NoTranslation";s:5:"align";s:6:"center";s:4:"name";s:7:"no_lang";s:4:"help";s:82:"select if content of field should not be translated (label gets always translated)";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:" E";a:3:{s:4:"type";s:5:"label";s:5:"label";s:5:"Align";s:5:"align";s:6:"center";}s:1:"F";a:3:{s:4:"type";s:6:"select";s:4:"name";s:5:"align";s:4:"help";s:48:"alignment of label and input-field in table-cell";}}i:3;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,name";s:5:"label";s:4:"Name";}s:1:"B";a:3:{s:4:"type";s:4:"text";s:4:"name";s:4:"name";s:4:"help";s:78:"index/name of returned content (name of the Template, Link / Method for Image)";}s:1:"C";a:6:{s:4:"type";s:4:"hbox";s:4:"size";s:1:"3";s:4:"span";s:1:"4";i:1;a:5:{s:4:"type";s:8:"checkbox";s:5:"label";s:9:"%s needed";s:5:"align";s:6:"center";s:4:"name";s:6:"needed";s:4:"help";s:39:"check if field has to be filled by user";}i:2;a:5:{s:4:"type";s:8:"checkbox";s:5:"label";s:11:"%s readonly";s:5:"align";s:6:"center";s:4:"name";s:8:"readonly";s:4:"help";s:94:"check if content should only be displayed but not altered (the content is not send back then!)";}i:3;a:5:{s:4:"type";s:8:"checkbox";s:5:"label";s:11:"%s disabled";s:5:"align";s:6:"center";s:4:"name";s:8:"disabled";s:4:"help";s:96:"if field is disabled an empty table-cell is displayed, for (temporal) removement of a field/cell";}}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:4;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,blur";s:5:"label";s:8:"blurText";}s:1:"B";a:3:{s:4:"type";s:4:"text";s:4:"name";s:4:"blur";s:4:"help";s:76:"this text gets displayed if the input-field is empty and has no focus (blur)";}s:1:"C";a:5:{s:4:"type";s:4:"hbox";s:4:"span";s:1:"4";s:4:"size";s:1:"2";i:1;a:5:{s:4:"type";s:3:"int";s:5:"label";s:8:"Tabindex";s:4:"span";s:1:"2";s:4:"name";s:8:"tabindex";s:4:"help";s:47:"Order to navigating by tab key through the form";}i:2;a:5:{s:4:"type";s:4:"text";s:4:"size";s:3:"1,1";s:4:"name";s:9:"accesskey";s:4:"help";s:67:"Accesskeys can also be specified with an & in the label (eg. &Name)";s:5:"label";s:9:"Accesskey";}}s:1:"D";a: 1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:5;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,help";s:5:"label";s:4:"Help";}s:1:"B";a:5:{s:4:"type";s:4:"text";s:4:"size";s:2:"71";s:4:"span";s:18:"all,inputFullWidth";s:4:"name";s:4:"help";s:4:"help";s:60:"displayed in statusline of browser if input-field gets focus";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:6;a:6:{s:1:"A";a:2:{s:4:"type";s:5:"label";s:5:"label";s:8:"onChange";}s:1:"B";a:5:{s:4:"type";s:4:"hbox";s:4:"size";s:6:"2,,0,0";i:1;a:3:{s:4:"type";s:6:"select";s:4:"name";s:13:"onchange_type";s:4:"help";s:65:"Should the form be submitted or any custom javascript be executed";}i:2;a:6:{s:4:"type";s:4:"text";s:4:"size";s:2:"50";s:4:"span";s:27:"all,leftPad5 inputFullWidth";s:4:"name";s:8:"onchange";s:4:"help";s:30:"custom javascript for onChan ge";s:5:"align";s:5:"right";}s:4:"span";s:3:"all";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}i:7;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:"onclick";s:5:"label";s:7:"onClick";}s:1:"B";a:5:{s:4:"type";s:4:"hbox";s:4:"size";s:6:"2,,0,0";i:1;a:3:{s:4:"type";s:6:"select";s:4:"name";s:12:"onclick_type";s:4:"help";s:43:"confirmation necesary or custom java-script";}i:2;a:6:{s:4:"type";s:4:"text";s:4:"size";s:2:"53";s:4:"span";s:27:"all,leftPad5 inputFullWidth";s:4:"name";s:7:"onclick";s:4:"help";s:67:"confirmation message or custom javascript (returning true or false)";s:5:"align";s:5:"right";}s:4:"span";s:3:"all";}s:1:"C";a:1:{s:4:"type";s:5:"label";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:1:{s:4:"type";s:5:"label";}s:1:"F";a:1:{s:4:"type";s:5:"label";}}}s:4:"rows";i:7;s:4:"cols";i:6;s:4:"size";s:4:"100%";s:7:"options";a:1:{i:0;s:4:"100%";}}}','size' => '100%','style' => '','modified' => '1242559548',); $templ_data[] = array('name' => 'etemplate.editor.widget.grid','template' => '','lang' => '','group' => '0','version' => '1.0.1.001','data' => 'a:1:{i:0;a:4:{s:4:"type";s:4:"grid";s:4:"data";a:5:{i:0;a:4:{s:2:"c1";s:3:"row";s:2:"c2";s:3:"row";s:2:"c3";s:3:"row";s:2:"c4";s:3:"row";}i:1;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,type";s:5:"label";s:4:"Type";}s:1:"B";a:4:{s:4:"type";s:6:"select";s:4:"name";s:4:"type";s:8:"onchange";s:1:"1";s:4:"help";s:57:"type of the field (select Label if field should be empty)";}s:1:"C";a:4:{s:4:"type";s:5:"label";s:4:"size";s:8:",,,align";s:5:"label";s:5:"Align";s:5:"align";s:5:"right";}s:1:"D";a:3:{s:4:"type";s:6:"select";s:4:"name";s:5:"align";s:4:"help";s:48:"alignment of label and input-field in table-cell";}s:1:"E";a:4:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,span";s:5:"label";s:4:"Span";s:5:"align";s:5:"right";}s:1:"F";a:4:{s:4:"type";s:4:"text";s:4:"size";s:2:"10";s:4:"name";s:4:"span";s:4:"help";s:111:"number of c olums the field/cell should span or \'all\' for the remaining columns, CSS-class name (for the TD tag)";}}i:2;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:7:",,,name";s:5:"label";s:4:"Name";}s:1:"B";a:3:{s:4:"type";s:4:"text";s:4:"name";s:4:"name";s:4:"help";s:78:"index/name of returned content (name of the Template, Link / Method for Image)";}s:1:"C";a:5:{s:4:"type";s:8:"checkbox";s:5:"label";s:11:"%s disabled";s:4:"name";s:8:"disabled";s:4:"help";s:96:"if field is disabled an empty table-cell is displayed, for (temporal) removement of a field/cell";s:4:"span";s:1:"2";}s:1:"D";a:1:{s:4:"type";s:5:"label";}s:1:"E";a:4:{s:4:"type";s:5:"label";s:4:"size";s:13:",,,options[3]";s:5:"label";s:5:"Class";s:5:"align";s:5:"right";}s:1:"F";a:4:{s:4:"type";s:4:"text";s:4:"size";s:2:"10";s:4:"name";s:10:"options[3]";s:4:"help";s:27:"CSS class for the table-tag";}}i:3;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:13:",,,options[0]";s:5:"label";s:5:"Width";}s:1:"B";a:4:{s: 4:"type";s:4:"text";s:4:"size";s:1:"5";s:4:"name";s:10:"options[0]";s:4:"help";s:71:" Width of the table in % or pixels for the table-tag and (optional) div";}s:1:"C";a:4:{s:4:"type";s:5:"label";s:4:"size";s:13:",,,options[1]";s:5:"label";s:6:"Height";s:5:"align";s:5:"right";}s:1:"D";a:4:{s:4:"type";s:4:"text";s:4:"size";s:1:"5";s:4:"name";s:10:"options[1]";s:4:"help";s:72:" Height of the table in % or pixels for the table-tag and (optional) div";}s:1:"E";a:4:{s:4:"type";s:5:"label";s:4:"size";s:13:",,,options[6]";s:5:"label";s:8:"Overflow";s:5:"align";s:5:"right";}s:1:"F";a:4:{s:4:"type";s:6:"select";s:7:"no_lang";s:1:"1";s:4:"name";s:10:"options[6]";s:4:"help";s:96:"what happens with overflowing content: visible (default), hidden, scroll, auto (browser decides)";}}i:4;a:6:{s:1:"A";a:3:{s:4:"type";s:5:"label";s:4:"size";s:13:",,,options[4]";s:5:"label";s:7:"Spacing";}s:1:"B";a:4:{s:4:"type";s:13:"select-number";s:4:"name";s:10:"options[4]";s:4:"help";s:29:"Cellspacing for t he table-tag";s:4:"size";s:14:"Default,0,10,1";}s:1:"C";a:3:{s:4:"type";s:5:"label";s:4:"size";s:13:",,,options[5]";s:5:"label";s:7:"Padding";}s:1:"D";a:4:{s:4:"type";s:13:"select-number";s:4:"size";s:14:"Default,0,10,1";s:4:"name";s:10:"options[5]";s:4:"help";s:29:"Cellpadding for the table-tag";}s:1:"E";a:4:{s:4:"type";s:5:"label";s:4:"size";s:13:",,,options[2]";s:5:"label";s:6:"Border";s:5:"align";s:5:"right";}s:1:"F";a:4:{s:4:"type";s:13:"select-number";s:4:"size";s:14:"Default,0,10,1";s:4:"name";s:10:"options[2]";s:4:"help";s:39:"Border-line-thickness for the table-tag";}}}s:4:"rows";i:4;s:4:"cols";i:6;}}','size' => '','style' => '','modified' => '1116599469',); Modified: trunk/etemplate/templates/default/db-tools.edit.xet URL: http://svn.stylite.de/viewvc/egroupware/trunk/etemplate/templates/default/db-tools.edit.xet?rev=42739&r1=42738&r2=42739&view=diff ============================================================================== --- trunk/etemplate/templates/default/db-tools.edit.xet (original) +++ trunk/etemplate/templates/default/db-tools.edit.xet Tue Jun 11 16:48:25 2013 @@ -1,9 +1,10 @@ <?xml version="1.0"?> <!-- $Id$ --> <overlay> - <template id="etemplate.db-tools.cols" template="" lang="" group="0" version="1.7.001"> + <template id="etemplate.db-tools.cols" template="" lang="" group="0" version="1.9.001"> <grid> <columns> + <column/> <column/> <column/> <column/> @@ -21,9 +22,10 @@ </columns> <rows> <row class="nmh"> - <description value="#" no_lang="1" align="center"/> + <description align="center" value="#" no_lang="1"/> <description value="ColumnName"/> <description value="Type"/> + <description value="Meta-type"/> <description value="Precision"/> <description value="Scale"/> <description value="NOT NULL"/> @@ -34,25 +36,28 @@ <description value="Comment"/> <description value="Indexoptions"/> <description value="Foreign Key"/> - <button label="Add Column" align="center" id="add_column" statustext="Add a new column (after the existing ones)"/> + <button align="center" statustext="Add a new column (after the existing ones)" label="Add Column" id="add_column"/> </row> <row class="nmr"> - <description no_lang="1" align="center" id="Row${row}[n]"/> - <textbox size="15" no_lang="1" id="Row${row}[name]" statustext="need to be unique in the table and no reseved word from SQL, best prefix all with a common 2-digit short for the app, eg. 'et_'"/> + <description align="center" id="Row${row}[n]" no_lang="1"/> + <textbox statustext="need to be unique in the table and no reseved word from SQL, best prefix all with a common 2-digit short for the app, eg. 'et_'" id="Row${row}[name]" no_lang="1" size="15"/> <menulist> - <menupopup no_lang="1" id="Row${row}[type]" statustext="type of the column"/> + <menupopup statustext="type of the column" id="Row${row}[type]" no_lang="1"/> </menulist> - <int align="center" id="Row${row}[precision]" statustext="length for char+varchar, precisions int: 2, 4, 8 and float: 4, 8"/> - <int id="Row${row}[scale]" statustext="scale for float"/> - <checkbox align="center" id="Row${row}[notnull]" statustext="can not have special SQL-value NULL"/> - <checkbox align="center" id="Row${row}[pk]" statustext="Primary key for the table, gets automaticaly indexed"/> - <checkbox align="center" id="Row${row}[uc]" statustext="DB ensures that every row has a unique value in that column"/> - <checkbox align="center" id="Row${row}[ix]" statustext="an indexed column speeds up querys using that column (cost space on the disk !!!)"/> - <textbox size="8" id="Row${row}[default]" statustext="enter '' for an empty default, nothing mean no default"/> - <textbox size="20" id="Row${row}[comment]"/> - <textbox size="8" id="Row${row}[options]" statustext="DB-specific index options (comma-sep.), eg. mysql(FULLTEXT) or mysql(100) for the indexed length of a col"/> - <textbox size="8" align="center" id="Row${row}[fk]" statustext="name of other table where column is a key from"/> - <button label="Delete Column" align="center" id="delete[$row]" statustext="Deletes this column"/> + <menulist class="selectboxFullWidth"> + <menupopup statustext="meta-type of the column" id="Row${row}[meta]" no_lang="1" options=",,,,,,,0"/> + </menulist> + <textbox type="integer" align="center" statustext="length for char+varchar, precisions int: 2, 4, 8 and float: 4, 8" id="Row${row}[precision]"/> + <textbox type="integer" statustext="scale for float" id="Row${row}[scale]"/> + <checkbox align="center" statustext="can not have special SQL-value NULL" id="Row${row}[notnull]"/> + <checkbox align="center" statustext="Primary key for the table, gets automaticaly indexed" id="Row${row}[pk]"/> + <checkbox align="center" statustext="DB ensures that every row has a unique value in that column" id="Row${row}[uc]"/> + <checkbox align="center" statustext="an indexed column speeds up querys using that column (cost space on the disk !!!)" id="Row${row}[ix]"/> + <textbox statustext="enter '' for an empty default, nothing mean no default" id="Row${row}[default]" size="8"/> + <textbox id="Row${row}[comment]" size="20"/> + <textbox statustext="DB-specific index options (comma-sep.), eg. mysql(FULLTEXT) or mysql(100) for the indexed length of a col" id="Row${row}[options]" size="8"/> + <textbox align="center" statustext="name of other table where column is a key from" id="Row${row}[fk]" size="8"/> + <button align="center" statustext="Deletes this column" label="Delete Column" id="delete[$row]"/> </row> </rows> </grid> @@ -73,10 +78,10 @@ </columns> <rows> <row class="th"> - <description span="all" value="Multicolumn Indices"/> + <description value="Multicolumn Indices" span="all"/> </row> <row class="th"> - <description value="#" no_lang="1" align="center"/> + <description align="center" value="#" no_lang="1"/> <description value="ColumnName"/> <description value="ColumnName"/> <description value="ColumnName"/> @@ -85,33 +90,33 @@ <description value="ColumnName"/> <description value="ColumnName"/> <description value="Unique"/> - <button label="Add Index" align="center" id="add_index" statustext="Add a new multi-column index"/> + <button align="center" statustext="Add a new multi-column index" label="Add Index" id="add_index"/> </row> <row class="row"> - <description no_lang="1" align="center" id="Index[$row][n]"/> + <description align="center" id="Index[$row][n]" no_lang="1"/> <menulist> - <menupopup options="none" no_lang="1" id="Index[$row][0]" statustext="Select the indexed columns in their desired order"/> + <menupopup statustext="Select the indexed columns in their desired order" id="Index[$row][0]" no_lang="1" options="none"/> </menulist> <menulist> - <menupopup options="none" no_lang="1" align="center" id="Index[$row][1]" statustext="Select the indexed columns in their desired order"/> + <menupopup align="center" statustext="Select the indexed columns in their desired order" id="Index[$row][1]" no_lang="1" options="none"/> </menulist> <menulist> - <menupopup options="none" no_lang="1" id="Index[$row][2]" statustext="Select the indexed columns in their desired order"/> + <menupopup statustext="Select the indexed columns in their desired order" id="Index[$row][2]" no_lang="1" options="none"/> </menulist> <menulist> - <menupopup options="none" no_lang="1" align="center" id="Index[$row][3]" statustext="Select the indexed columns in their desired order"/> + <menupopup align="center" statustext="Select the indexed columns in their desired order" id="Index[$row][3]" no_lang="1" options="none"/> </menulist> <menulist> - <menupopup options="none" no_lang="1" id="Index[$row][4]" statustext="Select the indexed columns in their desired order"/> + <menupopup statustext="Select the indexed columns in their desired order" id="Index[$row][4]" no_lang="1" options="none"/> </menulist> <menulist> - <menupopup options="none" no_lang="1" id="Index[$row][5]" statustext="Select the indexed columns in their desired order"/> + <menupopup statustext="Select the indexed columns in their desired order" id="Index[$row][5]" no_lang="1" options="none"/> </menulist> <menulist> - <menupopup options="none" no_lang="1" id="Index[$row][6]" statustext="Select the indexed columns in their desired order"/> + <menupopup statustext="Select the indexed columns in their desired order" id="Index[$row][6]" no_lang="1" options="none"/> </menulist> - <checkbox align="center" id="Index[$row][unique]" statustext="DB ensures that every row has a unique value in that column"/> - <button label="Delete Index" align="center" id="delete_index[$row]" statustext="Deletes this index"/> + <checkbox align="center" statustext="DB ensures that every row has a unique value in that column" id="Index[$row][unique]"/> + <button align="center" statustext="Deletes this index" label="Delete Index" id="delete_index[$row]"/> </row> </rows> </grid> @@ -129,7 +134,7 @@ </columns> <rows> <row disabled="!@msg"> - <description span="all" class="redItalic" id="msg"/> + <description id="msg" span="all" class="redItalic"/> <description/> <description/> <description/> @@ -139,22 +144,22 @@ </row> <row> <menulist> - <menupopup type="select-app" options="Select one ...,,all" label="Application" no_lang="1" id="app" onchange="1" statustext="Select an application, (*) = uninstalled"/> + <menupopup type="select-app" statustext="Select an application, (*) = uninstalled" label="Application" id="app" no_lang="1" onchange="1" options="Select one ...,,all"/> </menulist> <menulist> - <menupopup label="TableName" no_lang="1" id="table_name" onchange="1" statustext="Select an table of the application"/> + <menupopup statustext="Select an table of the application" label="TableName" id="table_name" no_lang="1" onchange="1"/> </menulist> - <textbox size="20" align="right" id="new_table_name" statustext="Name of table to add"/> - <button label="Add Table" id="add_table" statustext="Create a new table for the application"/> - <button label="Import" id="import" statustext="Import table-definitions from existing db-table"/> - <button label="Drop Table" id="drop_table" disabled="true" statustext="Drop a table - this can NOT be undone"/> - <button label="Write Tables" id="write_tables" statustext="Write <app>/setup/tables_current.inc.php"/> + <textbox align="right" statustext="Name of table to add" id="new_table_name" size="20"/> + <button statustext="Create a new table for the application" label="Add Table" id="add_table"/> + <button statustext="Import table-definitions from existing db-table" label="Import" id="import"/> + <button disabled="true" statustext="Drop a table - this can NOT be undone" label="Drop Table" id="drop_table"/> + <button statustext="Write <app>/setup/tables_current.inc.php" label="Write Tables" id="write_tables"/> </row> <row> - <template span="all" id="etemplate.db-tools.cols"/> + <template id="etemplate.db-tools.cols" span="all"/> </row> <row> - <template span="all" id="etemplate.db-tools.indices"/> + <template id="etemplate.db-tools.indices" span="all"/> </row> </rows> </grid> |