summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorDominique Martinet <asmadeus@codewreck.org>2012-10-28 08:50:57 +0100
committerDominique Martinet <asmadeus@codewreck.org>2015-11-08 14:27:58 +0100
commit75b704b4e8e5faa82d2650c2ff7a9795b6319b4d (patch)
treee5cc2f2d5c8c072fbec919d72a94817cbb001eb8
parent22f380ffe6432f576e9349d6eb36f204bb57a9ce (diff)
Fixed mistake in modified viewmember - query for attendance per event was wrong
-rw-r--r--viewmember.php4
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";