X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FMembers.pm;h=2ab6f2759baf2e66e53ffe7e6cf58968f9833d13;hb=fcd1ee7b280d01a082b3a868a56145f970251f5d;hp=f69e82d19b986fa901aa3ac371d867d115db20f7;hpb=83195c3c8034fff520fa90d1d0fb8b7995f925d3;p=ndwebbie.git diff --git a/lib/NDWeb/Controller/Members.pm b/lib/NDWeb/Controller/Members.pm index f69e82d..2ab6f27 100644 --- a/lib/NDWeb/Controller/Members.pm +++ b/lib/NDWeb/Controller/Members.pm @@ -527,7 +527,7 @@ sub defenders : Local { my $defenders = $dbh->prepare(q{ SELECT uid,u.planet,username, to_char(NOW() AT TIME ZONE timezone,'HH24:MI') AS time - ,sms_note, call_if_needed, race + ,sms_note, call_if_needed, race, timezone FROM users u JOIN current_planet_stats p ON p.id = u.planet WHERE uid IN (SELECT uid FROM groupmembers WHERE gid = 2)