Separate first-, middle- and lastname columns in fe_users table (thanks to Ismaël...
authorSteffen Kamper <info@sk-typo3.de>
Wed, 27 Jan 2010 11:16:44 +0000 (11:16 +0000)
committerSteffen Kamper <info@sk-typo3.de>
Wed, 27 Jan 2010 11:16:44 +0000 (11:16 +0000)
git-svn-id: https://svn.typo3.org/TYPO3v4/Core/trunk@6823 709f56b5-9817-0410-a4d7-c38de5d9e867

ChangeLog
typo3/sysext/cms/ext_tables.sql
typo3/sysext/cms/tbl_cms.php
typo3/sysext/lang/locallang_general.xml

index 24d830a..7417b10 100755 (executable)
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,7 @@
+2010-01-27  Steffen Kamper  <info@sk-typo3.de>
+
+       * Added feature #11221 : Separate first-, middle- and lastname columns in fe_users table (thanks to Ismaël Bidau)
+
 2010-01-25  Steffen Kamper  <info@sk-typo3.de>
 
        * Added feature #13313: ExtDirect API (thanks to Stefan Galinski and the T3UXW09 team)
index ba9463b..1a8e991 100755 (executable)
@@ -203,6 +203,9 @@ CREATE TABLE fe_users (
   starttime int(11) unsigned DEFAULT '0' NOT NULL,
   endtime int(11) unsigned DEFAULT '0' NOT NULL,
   name varchar(80) DEFAULT '' NOT NULL,
+  first_name varchar(50) DEFAULT '' NOT NULL,
+  middle_name varchar(50) DEFAULT '' NOT NULL,
+  last_name varchar(50) DEFAULT '' NOT NULL,
   address varchar(255) DEFAULT '' NOT NULL,
   telephone varchar(20) DEFAULT '' NOT NULL,
   fax varchar(20) DEFAULT '' NOT NULL,
index c53d0cf..6640a9d 100755 (executable)
@@ -99,6 +99,36 @@ $TCA['fe_users'] = array(
                                'max' => '80'
                        )
                ),
+               'first_name' => array(
+                       'exclude' => 1,
+                       'label' => 'LLL:EXT:lang/locallang_general.php:LGL.first_name',
+                       'config' => array(
+                               'type' => 'input',
+                               'size' => '25',
+                               'eval' => 'trim',
+                               'max' => '50'
+                       )
+               ),
+               'middle_name' => array(
+                       'exclude' => 1,
+                       'label' => 'LLL:EXT:lang/locallang_general.php:LGL.middle_name',
+                       'config' => array(
+                               'type' => 'input',
+                               'size' => '25',
+                               'eval' => 'trim',
+                               'max' => '50'
+                       )
+               ),
+               'last_name' => array(
+                       'exclude' => 1,
+                       'label' => 'LLL:EXT:lang/locallang_general.php:LGL.last_name',
+                       'config' => array(
+                               'type' => 'input',
+                               'size' => '25',
+                               'eval' => 'trim',
+                               'max' => '50'
+                       )
+               ),
                'address' => array(
                        'exclude' => 1,
                        'label' => 'LLL:EXT:lang/locallang_general.php:LGL.address',
@@ -283,7 +313,7 @@ $TCA['fe_users'] = array(
        'types' => array(
                '0' => array('showitem' => '
                        disable,username;;;;1-1-1, password, usergroup, lastlogin;;;;1-1-1,
-                       --div--;LLL:EXT:cms/locallang_tca.xml:fe_users.tabs.personelData, name;;1;;1-1-1, address, zip, city, country, telephone, fax, email, www, image;;;;2-2-2,
+                       --div--;LLL:EXT:cms/locallang_tca.xml:fe_users.tabs.personelData, company;;1;;1-1-1, name;;2;;2-2-2, address, zip, city, country, telephone, fax, email, www, image;;;;2-2-2,
                        --div--;LLL:EXT:cms/locallang_tca.xml:fe_users.tabs.options, lockToDomain;;;;1-1-1, TSconfig;;;;2-2-2,
                        --div--;LLL:EXT:cms/locallang_tca.xml:fe_users.tabs.access, starttime, endtime,
                        --div--;LLL:EXT:cms/locallang_tca.xml:fe_users.tabs.extended
@@ -291,7 +321,8 @@ $TCA['fe_users'] = array(
                ')
        ),
        'palettes' => array(
-               '1' => array('showitem' => 'title,company')
+               '1' => array('showitem' => 'title'),
+               '2' => array('showitem' => 'first_name,--linebreak--,middle_name,--linebreak--,last_name')
        )
 );
 
index 0ca0c20..2e95f0e 100755 (executable)
@@ -29,6 +29,9 @@
                        <label index="LGL.subheader">Subheader:</label>
                        <label index="LGL.text">Text:</label>
                        <label index="LGL.name">Name:</label>
+                       <label index="LGL.first_name">First name:</label>
+                       <label index="LGL.middle_name">Middle name:</label>
+                       <label index="LGL.last_name">Last name:</label>
                        <label index="LGL.title">Title:</label>
                        <label index="LGL.title_person">Title:</label>
                        <label index="LGL.address">Address:</label>