bsw/jbe@5: local tmp = db:query({ "SELECT text_entries_left FROM member_contingent_left WHERE member_id = ?", app.session.member.id }, "opt_object")
bsw/jbe@5: if tmp and tmp.text_entries_left and tmp.text_entries_left < 1 then
bsw/jbe@5:   slot.put_into("error", _"Sorry, you have reached your personal flood limit. Please be slower...")
bsw/jbe@5:   return false
bsw/jbe@5: end
bsw/jbe@5: 
bsw/jbe@0: local initiative = Initiative:by_id(param.get("initiative_id", atom.integer))
bsw/jbe@0: 
bsw/jbe@5: -- TODO important m1 selectors returning result _SET_!
bsw/jbe@5: local issue = initiative:get_reference_selector("issue"):for_share():single_object_mode():exec()
bsw/jbe@5: 
bsw/jbe@5: if issue.closed then
bsw/jbe@5:   slot.put_into("error", _"This issue is already closed.")
bsw/jbe@5:   return false
bsw/jbe@5: elseif issue.half_frozen then 
bsw/jbe@5:   slot.put_into("error", _"This issue is already frozen.")
bsw/jbe@5:   return false
bsw/jbe@5: end
bsw/jbe@5: 
bsw/jbe@0: if Initiator:by_pk(initiative.id, app.session.member.id) then
bsw/jbe@0:   local draft = Draft:new()
bsw/jbe@0:   draft.author_id = app.session.member.id
bsw/jbe@0:   draft.initiative_id = initiative.id
bsw/jbe@4:   local formatting_engine = param.get("formatting_engine")
bsw/jbe@4:   local formatting_engine_valid = false
bsw/jbe@4:   for fe, dummy in pairs(config.formatting_engine_executeables) do
bsw/jbe@4:     if formatting_engine == fe then
bsw/jbe@4:       formatting_engine_valid = true
bsw/jbe@4:     end
bsw/jbe@4:   end
bsw/jbe@4:   if not formatting_engine_valid then
bsw/jbe@4:     error("invalid formatting engine!")
bsw/jbe@4:   end
bsw/jbe@4:   draft.formatting_engine = formatting_engine
bsw/jbe@0:   draft.content = param.get("content")
bsw/jbe@0:   draft:save()
bsw/jbe@0: 
bsw/jbe@0:   slot.put_into("notice", _"New draft has been added to initiative")
bsw/jbe@0: 
bsw/jbe@0: else
bsw/jbe@0:   error('access denied')
bsw/jbe@0: end