[Tickets #4466] NEW: shared address book

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=4466
-----------------------------------------------------------------------
 Ticket             | 4466
 Created By         | bruno at merjasec.com
 Summary            | shared address book
 Queue              | Turba
 Version            | 2.1.2
 Type               | Bug
 State              | Unconfirmed
 Priority           | 2. Medium
 Owners             | 
-----------------------------------------------------------------------


bruno at merjasec.com (2006-09-26 14:12) wrote:

Hello there

I have a problem with Turba shared address book.

I tried to make some public address book (read-only) for all users, but I
failed. How can I make some read-only/public/not exportable address book
for all users?

I looked into horde_datatree and horde_datatree_attributes. 

#table datatree
+-------------+------------------------+----------------+----------------+------------------+----------------+---------------+---------------------+
| datatree_id | group_uid              | user_uid       | datatree_name  |
datatree_parents | datatree_order | datatree_data | datatree_serialized |
+-------------+------------------------+----------------+----------------+------------------+----------------+---------------+---------------------+
|          16 | horde.shares.turba     | gasper at domain  | localsql       |
                 |           NULL |               |                   0 |
|          15 | horde.shares.turba     | gasper at domain  | gasper at domain  |
:16              |           NULL | NULL          |                   0 |
|          19 | horde.shares.turba     | usr4250 at domain | usr4250 at domain |
:16              |           NULL | NULL          |                   0 |
+-------------+------------------------+----------------+----------------+------------------+----------------+---------------+---------------------+

#table datatree_attiributes
+-------------+----------------+----------------+---------------------------------+
| datatree_id | attribute_name | attribute_key  | attribute_value         
       |
+-------------+----------------+----------------+---------------------------------+
|          15 | uid            |                | gasper at domain           
       |
|          15 | name           |                | Gasper's Knjiga naslovov
       |
|          15 | owner          |                | gasper at domain           
       |
|          15 | perm_users     | gasper at domain  | 30                      
       |
|          19 | uid            |                | rkc4250 at domain          
       |
|          19 | name           |                | Spela's Knjiga naslovov 
       |
|          19 | owner          |                | usr4250 at domain          
       |
|          19 | perm_users     | usr4250 at domain | 30                      
       |
+-------------+----------------+----------------+---------------------------------+



When I added this line user usr4250 can read AND write my Address book

|          18 | perm_users     | usr4250 at rkc.si | 30                      
       |


#sources.php
$cfgSources['localsql'] = array(
    'title' => _("My Address Book"),
    'type' => 'sql',
    'params' => array_merge($conf['sql'], array('table' =>
'turba_objects')),
    'map' => array(
        '__key' => 'object_id',
        '__owner' => 'owner_id',
        '__type' => 'object_type',
        '__members' => 'object_members',
        '__uid' => 'object_uid',
        'name' => 'object_name',
        'email' => 'object_email',
        'alias' => 'object_alias',
        'homeAddress' => 'object_homeaddress',
        'workAddress' => 'object_workaddress',
        'homePhone' => 'object_homephone',
        'workPhone' => 'object_workphone',
        'cellPhone' => 'object_cellphone',
        'fax' => 'object_fax',
        'title' => 'object_title',
        'company' => 'object_company',
        'notes' => 'object_notes',
        'pgpPublicKey' => 'object_pgppublickey',
        'smimePublicKey' => 'object_smimepublickey',
        'freebusyUrl' => 'object_freebusyurl'
    ),
    'search' => array(
        'name',
        'email'
    ),
    'strict' => array(
        'object_id',
        'owner_id',
        'object_type',
    ),
    'export' => true,
    'browse' => true,
    'use_shares' => true,
);