Hi All

I've recently converted over to RC and use it alongside a CRM i develop.
My users biggest gripe was the lack of a global address book.
After a quick 5 minute hack got one working by changing a few queries.
For all the files in 'program/steps/addressbook/' i changed the queries like:

  $DB->query("SELECT * FROM ".get_table_name('contacts')."
             WHERE  contact_id=?
             AND    user_id=?
             AND    del<>1",
             $cid,
             $_SESSION['user_id']);

With a slightly different one such as:

  $DB->query("SELECT * FROM ".get_table_name('contacts')."
             WHERE  contact_id=?
             AND    (user_id=? OR user_id='0')
             AND    del<>1",
             $cid,
             $_SESSION['user_id']);

I haven't worked out how to change the UI yet, but i'm sure it isn't hard.
A feature like this would be a nice addition in the next release.

NOTE: Contacts are currently inserted/updated by an automated script that sets 
the user_id field to 0.

Cheers,
  Dan



Reply via email to