From 0569a4118c88ac0370d9070f1067864bc3876817 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Mon, 14 May 2012 12:18:32 +0800 Subject: [PATCH] DataObjects/Events.php --- DataObjects/Events.php | 7 +++++-- 1 file changed, 5 insertions(+), 2 deletions(-) diff --git a/DataObjects/Events.php b/DataObjects/Events.php index d9029fc2..7b71e356 100644 --- a/DataObjects/Events.php +++ b/DataObjects/Events.php @@ -229,11 +229,14 @@ class Pman_Core_DataObjects_Events extends DB_DataObject $cols[$col][] = "WHEN {$tn}.person_table = '$tbl' THEN join_person_table_{$tbl}.{$col}"; } // id's are hard coded... + $cond = "{$tn}.person_table = '{$tbl}'"; + if ($tbl = $ptbl) { + $cond = "( $cond OR {$tn}.person_table == '')"; + } $this->_join .= " LEFT JOIN {$tbl} AS join_person_table_{$tbl} ON {$tn}.person_id = join_person_table_{$tbl}.id - AND {$tn}.person_table = '{$tbl}' - + AND $cond "; } foreach($cols as $col=>$whens) { -- 2.39.2