Norm Lang - 2021-04-30

The program default, is to allow a Contact to only be linked to a single project The Contact includes a taskid field in the database. I found a way to allow for multiple taskid numbers by modifying a bit of code. YMMV>>>

Re: contact_menubox.php beginning at about line 51.

Changed:

//get task contacts
$q = db_prepare('SELECT id, firstname, lastname, company FROM '.PRE.'contacts
WHERE taskid=? OR taskid=? ORDER BY company, lastname' );
db_execute($q, array($taskid, $TASKID_ROW['projectid'] ) );
$add = '&taskid='.$taskid;

To:

//get task contacts // modified Apr30-2021 to allow a contact name be linked to multiple projects.
$q = db_prepare('SELECT id, firstname, lastname, company FROM '.PRE.'contacts
WHERE taskid LIKE ? OR taskid LIKE ? ORDER BY company, lastname' );
db_execute($q, array("%$taskid%", $TASKID_ROW['projectid'] ) );
$add = '&taskid='.$taskid;