| rev |
line source |
|
bsw@989
|
1 --trace.disable()
|
|
bsw@989
|
2
|
|
bsw@989
|
3 local email = param.get("email")
|
|
bsw@989
|
4
|
|
bsw@989
|
5 local members = Member:new_selector()
|
|
bsw@990
|
6 :add_where{ "split_part(notify_email, '@', 1) = split_part(?, '@', 1)", email }
|
|
bsw@990
|
7 :add_where{ "lower(split_part(notify_email, '@', 2)) = lower(split_part(?, '@', 2))", email }
|
|
bsw@989
|
8 :add_where("login_recovery_expiry ISNULL OR login_recovery_expiry < now()")
|
|
bsw@989
|
9 :exec()
|
|
bsw@989
|
10
|
|
bsw@989
|
11 if #members < 1 then
|
|
bsw@989
|
12 return
|
|
bsw@989
|
13 end
|
|
bsw@989
|
14
|
|
bsw@989
|
15 local logins = {}
|
|
bsw@989
|
16
|
|
bsw@989
|
17 for i, member in ipairs(members) do
|
|
bsw@989
|
18 local expiry = db:query("SELECT now() + '7 days'::interval as expiry", "object").expiry
|
|
bsw@989
|
19 member.login_recovery_expiry = expiry
|
|
bsw@989
|
20 member:save()
|
|
bsw@989
|
21 logins[#logins+1] = member.login
|
|
bsw@989
|
22 end
|
|
bsw@989
|
23
|
|
bsw@989
|
24 local content = slot.use_temporary(function()
|
|
bsw@989
|
25 slot.put(_"Hello,\n\n")
|
|
bsw@989
|
26 slot.put(_"the following login is connected to this email address:\n\n")
|
|
bsw@989
|
27 for i, login in ipairs(logins) do
|
|
bsw@989
|
28 slot.put(_"Login-Name: " .. login .. "\n")
|
|
bsw@989
|
29 end
|
|
bsw@989
|
30 end)
|
|
bsw@989
|
31
|
|
bsw@989
|
32 local success = net.send_mail{
|
|
bsw@989
|
33 envelope_from = config.mail_envelope_from,
|
|
bsw@989
|
34 from = config.mail_from,
|
|
bsw@989
|
35 reply_to = config.mail_reply_to,
|
|
bsw@989
|
36 to = email,
|
|
bsw@989
|
37 subject = config.mail_subject_prefix .. _"Login name request",
|
|
bsw@989
|
38 content_type = "text/plain; charset=UTF-8",
|
|
bsw@989
|
39 content = content
|
|
bsw@989
|
40 }
|
|
bsw@990
|
41
|
|
bsw@990
|
42 slot.put_into("notice", _"Your request has been processed.")
|