1 --trace.disable()

2

3 local email = param.get("email")

4

5 local members = Member:new_selector()

6 :add_where{ "notify_email = ? OR notify_email_unconfirmed = ?", email, email }

7 :add_where("login_recovery_expiry ISNULL OR login_recovery_expiry < now()")

8 :exec()

9

10 if #members < 1 then

11 return

12 end

13

14 local logins = {}

15

16 for i, member in ipairs(members) do

17 local expiry = db:query("SELECT now() + '7 days'::interval as expiry", "object").expiry

18 member.login_recovery_expiry = expiry

19 member:save()

20 logins[#logins+1] = member.login

21 end

22

23 local content = slot.use_temporary(function()

24 slot.put(_"Hello,\n\n")

25 slot.put(_"the following login is connected to this email address:\n\n")

26 for i, login in ipairs(logins) do

27 slot.put(_"Login-Name: " .. login .. "\n")

28 end

29 end)

30

31 trace.debug(content)

32 if true then return end

33

34 local success = net.send_mail{

35 envelope_from = config.mail_envelope_from,

36 from = config.mail_from,

37 reply_to = config.mail_reply_to,

38 to = email,

39 subject = config.mail_subject_prefix .. _"Login name request",

40 content_type = "text/plain; charset=UTF-8",

41 content = content

42 }