1 local tmp = db:query({ "SELECT text_entries_left FROM member_contingent_left WHERE member_id = ?", app.session.member.id }, "opt_object")

2 if tmp and tmp.text_entries_left and tmp.text_entries_left < 1 then

3 slot.put_into("error", _"Sorry, you have reached your personal flood limit. Please be slower...")

4 return false

5 end

6

7 local initiative = Initiative:by_id(param.get("initiative_id", atom.integer))

8

9 -- TODO important m1 selectors returning result _SET_!

10 local issue = initiative:get_reference_selector("issue"):for_share():single_object_mode():exec()

11

12 if issue.closed then

13 slot.put_into("error", _"This issue is already closed.")

14 return false

15 elseif issue.half_frozen then

16 slot.put_into("error", _"This issue is already frozen.")

17 return false

18 end

19

20 local initiator = Initiator:by_pk(initiative.id, app.session.member.id)

21 if not initiator or not initiator.accepted then

22 error("access denied")

23 end

24

25 local formatting_engine = param.get("formatting_engine")

26

27 local formatting_engine_valid = false

28 for fe, dummy in pairs(config.formatting_engine_executeables) do

29 if formatting_engine == fe then

30 formatting_engine_valid = true

31 end

32 end

33 if not formatting_engine_valid then

34 error("invalid formatting engine!")

35 end

36

37 if param.get("preview") then

38 return false

39 end

40

41 local draft = Draft:new()

42 draft.author_id = app.session.member.id

43 draft.initiative_id = initiative.id

44 draft.formatting_engine = formatting_engine

45 draft.content = param.get("content")

46 draft:save()

47

48 local supporter = Supporter:by_pk(initiative.id, app.session.member.id)

49

50 if supporter then

51 supporter.draft_id = draft.id

52 supporter:save()

53 end

54

55 draft:render_content()

56

57 slot.put_into("notice", _"New draft has been added to initiative")

58