[Web-cyradm] First/Last Name and Search patch

[Leon Kolchinsky]

Hello All,

Thanks to our PHP Coder - Eugeny Myunster we now can use some additional
features from the web-cyradm web interface (in version 0.5.5 -
http://www.web-cyradm.org/web-cyradm-svn-0.5.5.tar.gz):

1) Create (in "Add new account") account with First/Last Name in the DB.
2) Edit First Name/Last Name (in " Edit account")
3) While Browsing Domain Accounts we can now see users "First Name/Last
Name"
4) Additional button "Show all" to show all accounts in specified (browsed)
domain
5) Search function is also searching in the "First Name/Last Name" and
showing "First Name/Last Name" in search results.

Please use it for your own benefit :)

Do not forget to create 2 new columns with something like this (and index
them): alter table accountuser add name varchar(255), shurename varchar(255)

So your accountuser table would look like this:
-----------------------------------------------
CREATE TABLE `accountuser` (
  `username` varchar(255) character set utf8 collate utf8_bin NOT NULL
default '',
  `password` varchar(30) character set utf8 collate utf8_bin NOT NULL
default '',
  `prefix` varchar(50) NOT NULL default '',
  `domain_name` varchar(255) NOT NULL default '',
  `imap` int(10) NOT NULL default '1',
  `pop` int(10) NOT NULL default '1',
  `sieve` int(10) NOT NULL default '1',
  `smtpauth` int(10) NOT NULL default '1',
  `name` varchar(80) NOT NULL default '',
  `shurename` varchar(80) NOT NULL default '',
  UNIQUE KEY `username` (`username`),
  KEY `name` (`name`,`shurename`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8


I also have a kind request to Luc De Low and Michael Muenz:

Please check this patch (if you need some improvements in it tell me) and
incorporate it in web-cyradm so we won't need to patch every new version for
these nice features.


Best Regards,
Leon Kolchinsky



-------------- next part --------------
A non-text attachment was scrubbed...
Name: f_l_name_search.patch
Type: application/octet-stream
Size: 10226 bytes
Desc: not available
Url : http://foxi.bitheads.ch/pipermail/web-cyradm/attachments/20071224/969955b8/f_l_name_search.obj