diff options
author | Dominique Martinet <asmadeus@codewreck.org> | 2012-10-28 08:50:57 +0100 |
---|---|---|
committer | Dominique Martinet <asmadeus@codewreck.org> | 2015-11-08 14:27:58 +0100 |
commit | 75b704b4e8e5faa82d2650c2ff7a9795b6319b4d (patch) | |
tree | e5cc2f2d5c8c072fbec919d72a94817cbb001eb8 | |
parent | 22f380ffe6432f576e9349d6eb36f204bb57a9ce (diff) |
Fixed mistake in modified viewmember - query for attendance per event was wrong
-rw-r--r-- | viewmember.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/viewmember.php b/viewmember.php index 592c202..4ce6eee 100644 --- a/viewmember.php +++ b/viewmember.php @@ -198,8 +198,8 @@ if ( (isset($_GET[URI_NAME])) && (strval($_GET[URI_NAME] != '')) ) // Find the count for each for for this member
$sql = 'SELECT e.event_id, r.raid_name, count(ra.raid_id) AS raid_count
FROM ' . RAID_ATTENDEES_TABLE . ' ra
- LEFT JOIN ' . RAIDS_TABLE . ' r ON (e.event_name = r.raid_name)
- LEFT JOIN ' . EVENTS_TABLE . " e ON (r.raid_id = ra.raid_id)
+ LEFT JOIN ' . RAIDS_TABLE . ' r ON (ra.raid_id = r.raid_id)
+ LEFT JOIN ' . EVENTS_TABLE . " e ON (r.raid_name = e.event_name)
WHERE (ra.member_name = '" . $member['member_name'] . "')
AND (r.raid_date >= " . $member['member_firstraid'] . ")
GROUP BY ra.member_name, r.raid_name";
|