SquirrelMail  
Donations
News
About
Support
Screen shots
Download
Plugins
Documentation
Sponsors
Bounties













Security Notice
Phishing campain
Version 1.4.15
Security Upgrade
Plugins - Address Group Plugin
Category: Addressbook

This simple plugin works on an additional table (addressgroup) containing references to the nicknames from either the personal address book ie. the user will form the address group with entries in his address book.

To configure the plugin:

1. Firstly, you must have your address books stored in a database, one
which PEAR DB can connect to. You must configure the db DSN in the
config.php (in config folder).

$addrbook_dsn = 'connection string';

As to how to configure the DSN (from PEAR DB Manual):

* phptype: Database backend used in PHP (mysql, odbc etc.)
* dbsyntax: Database used with regards to SQL syntax etc.
* protocol: Communication protocol to use (tcp, unix etc.)
* hostspec: Host specification (hostname[:port])
* database: Database to use on the DBMS server
* username: User name for login
* password: Password for login
*
* The format of the supplied DSN is in its fullest form:
*
* phptype(dbsyntax)://username:password@protocol+hostspec/database
*

The Databases currently supported (the phptype DSN part) are:

mysql -> MySQL
pgsql -> PostgreSQL
ibase -> InterBase
msql -> Mini SQL
mssql -> Microsoft SQL Server
oci8 -> Oracle 7/8/8i
odbc -> ODBC (Open Database Connectivity)
sybase -> SyBase
ifx -> Informix
fbsql -> FrontBase

2. To set up an address book for your users, refer to the following
documetnation. You need to have a table like "address"
http://www.squirrelmail.org/wiki/AddressbookDatabase

3. To store the addressgroups, create the following table:

create table addressgroups(
owner varchar(50),
nickname varchar(50),
addressgroup varchar(50),
type varchar(50)
);

The lengths and datatype of the fields are suggested. Modify them to suit
your needs, especially if you use a different database. You could give the
table another name, just remember to change the table name wherever you see:

$myparams = array();
$myparams['dsn'] = $addrbook_dsn;
// change this table name if you named it differently
$myparams['table'] = 'addressgroups';

Thats all folks :)




Version 0.51.1
by Tomas Kuliavas on Jan 28, 2007
[ abook_group-0.51.1-1.4.2.tar.gz tarball (7355 d/l) Help ]
Requires: SquirrelMail 1.4.2 or later

Description:

This plugin version fixes some typos and session handling issues. It also adds three new string translations. Thanks to Phil Driscoll and Florian Daeumling.

Changes:

  • Fixed invalid test in agroup_check_backends() function. Added option to disable use of sqsession_register() in compose (#1599880).
  • Added 'To', 'Cc' and 'Bcc' string translations.
  • Reduced gettext domain switching.
  • Fixed error handling in empty groups.
  • Escaped quotes and slashes in email addresses (#1642857).

Older versions

Version 0.51
by Tomas Kuliavas on Oct 7, 2006
[ abook_group-0.51-1.4.2.tar.gz tarball (2706 d/l) Help ]
Requires: SquirrelMail 1.4.2 or later

Description:

This is intermediate plugin release before making big changes in plugin code. Planned changes are not backwards compatible with current address book data format.

Known issues:

  • remote backends (LDAP) are not enabled.
  • plugin does not work correctly in mixed environments with file based and db based address books.
  • plugin does not work with two flat file address books correctly.

Changes:

  • fixed warnings in flatfile functions
  • added functions that block use of plugin in mixed address book environment. (I don't have plans to fix it until code rewrite in 0.60).
  • $javascript_on variable is used instead of soupNazi().
  • Added Italian translation by Roberto Piola .
  • Converted Russian translation from KOI to UTF-8.
  • Cleaned unused translation directories in po. Removed message.mo files.
  • Added COPYING file and cleaned README.
  • added phpdoc blocks and copyrights.
  • fixed corruption of some variables with recent sqgetGlobalVar() function.
  • disabled use of remote backends.
  • removed some unneeded gettext domain switches.
  • Use function arguments to submit addresses. (sm-bugtracker #1048059, #957157). Fix by Randy Berdan (randum6 at users.sourceforge.net)


Version 0.50
by Jon Nelson on Jul 22, 2004
[ abook_group.0.50-1.4.2.tar.gz tarball (10019 d/l) Help ]
Requires: >=SquirrelMail 1.4.0 (other versions untested), PEAR db.php + Database. Currently no LDAP support!

Description: Jon Nelson ceases to be the maintainer due to work/class load. The plugin is now stored at http://www.sf.net/projects/sm-plugins. This version hasn't been extensively tested. Added Brazilian Portuguese translation with help from Fabio Marcos Pedroso Filho. Applied name patch to reflect Bryan Loniewski comments: "Just a small patch for the text displayed next to the search box, since the search is not performed on 'address' but on 'name'." Modified by Jason Naughton essentially cleaned up a few files junk files left around. Changed the group_database.php file so that based on the $addrbook_dsn variable set by the config.php (ie configure) was set to "" we were then using flat file format. If it was set to anything else then we're back to using databases... Modified by Jason Naughton noticed there wasn't a close button available after you clicked on the groups button and pulled up the groups window so I simply added it. Modified by Jason Naughton added Flat file support.

Version 0.39c
by Jon Nelson on Feb 28, 2004
[ abook_group-0.39c-1.4.2.tar.gz tarball (3994 d/l) Help ]
Requires: >=SquirrelMail 1.4.0 (other versions untested), PEAR db.php + Database

Description: Added Norwegian Nynorsk translation with help from Ola Ketil Siqveland Made some changes in Dutch translation with help from Official SquirrelMail nl_NL translator (M.J. Prinsen ).

Version 0.39b
by Jon Nelson on Feb 1, 2004
[ abook_group-0.39b-1.4.2.tar.gz tarball (2679 d/l) Help ]
Requires: >=SquirrelMail 1.4.0 (other versions untested), PEAR db.php + Database

Description: Removed Ukrainian translation.

Version 0.39
by Jon Nelson on Dec 9, 2003
[ abook_group-0.39-1.4.2.tar.gz tarball (3039 d/l) Help ]
Requires: >=SquirrelMail 1.4.0 (other versions untested), PEAR db.php + Database

Description: Fixed problems listing existing groups. Please see UPGRADING in the README to incorporate this fix. This was done with tremedous help and understanding from Tomas Kuliavas. Lithuanian was also added with help from Tomas. German was added with a lot of help from Thommie . Got rid of window$ carriage returns in some files. Fixed the way "Modify" reponds if you don't change the group name. Added confirmation when deleting a group. Added Dutch translation with help from Ronald.

Version 0.32
by Jon Nelson on Oct 28, 2003
[ abook_group-0.32-1.4.2.tar.gz tarball (2920 d/l) Help ]
Requires: >=SquirrelMail 1.4.0 (other versions untested), PEAR db.php + Database

Description: Added il8n support and the Spanish translation with tremendous help from Rodolfo. French translation added with a lot of help from CÚdric. This should also take of the problem of not being able to see the members of a newly created group. It should also take care of the error: Fatal error: Call to undefined function: fetchrow() in... Fixed typos in .po and version numbering

Version 0.21
by Jon Nelson on Jul 3, 2003
[ abook_group-0.21-1.4.0.tar.gz tarball (3658 d/l) Help ]
Requires: SquirrelMail 1.4.0, PEAR db.php + Database

Description: Added functionality to work with register_globals = Off. Thanks to Chris, Glenn Sieb and PaulD with testing this version.

Version 0.20
by Jon Nelson on Jun 25, 2003
[ abook_group-0.2-1.4.0.tar.gz tarball (2525 d/l) Help ]
Requires: SquirrelMail 1.4.0, PEAR db.php + Database

Description: Made it compatible with SM 1.4. Fixed a misspelling in a button. Fixed SM_PATH. Added a README.

Version 0.1
by Kelvin Ho on Aug 11, 2002
[ abook_groupv0.1.tar.gz tarball (6682 d/l) Help ]
Requires: PEAR db.php + Database

Description:

If you have problems with the download or decompressing...
Internet Explorer
Right-click on the file, then select "Save Target As"
Firefox, Mozilla, Netscape
Right-click on the file, then select "Save Link As"
Opera
Right-click on the file, then select "Save Link Document As"
Lynx and Links
Press "d" on the link to download the file directly.
  • Untarring problems: Your browser might have un-gzipped it for you automatically. Try just "tar xvf" instead of "tar xvfz". Also, the plugins archive isn't gzipped (it is a tarball of .tar.gz files)
  • Macintosh users: Just hold down your mouse button to get the menu instead of right-clicking.
  • If all else fails, seek our help
© 1999-2010 by The SquirrelMail Project Team