def modcontrol_spam_remove_post_(request):
"""
Submits content to the spam filtering backend, and hides it from view.
Either `submitid` or `journalid` must be present in the request's parameters.
:param request: The Pyramid request.
:subparam request.params['submitid']: If present, the submission's ID number.
:subparam request.params['journalid']: If present, the journal's ID number.
:return/raises: HTTPSeeOther to /modcontrol/suspenduser.
"""
submitid = request.params.get('submitid')
journalid = request.params.get('journalid')
# Only one parameter should ever be set
if sum(item is not None for item in [submitid, journalid]) != 1:
raise WeasylError("Unexpected")
submitid = int(submitid) if submitid is not None else None
journalid = int(journalid) if journalid is not None else None
# Only pkey_value is untrusted input to this statement.
statement = """
SELECT userid, content, submitter_user_agent_id, submitter_ip_address
FROM {table_name}
WHERE {pkey_name} = %(pkey_value)s
"""
if submitid:
# The content_type parameter which will be used to signal to the filtering backend what kind of content this is.
content_type = "submission"
statement = statement.format(table_name="submission",
pkey_name="submitid")
record_identifier = submitid
welcome.submission_remove(submitid=submitid)
moderation.hidesubmission(submitid=submitid)
elif journalid:
content_type = "journal"
statement = statement.format(table_name="journal",
pkey_name="journalid")
record_identifier = journalid
welcome.journal_remove(journalid=journalid)
moderation.hidejournal(journalid=journalid)
userid, content, user_agent_id, ip_addr = define.engine.execute(
statement, pkey_value=record_identifier).first()
spam_filtering.submit(
is_spam=True,
user_ip=ip_addr,
user_agent_id=user_agent_id,
user_id=userid,
comment_type=content_type,
comment_content=content,
)
index.recent_submissions.invalidate()
raise HTTPSeeOther("/modcontrol/suspenduser")
def modcontrol_hide_(request):
form = request.web_input(name="", submission="", character="")
if form.submission:
moderation.hidesubmission(int(form.submission))
elif form.character:
moderation.hidecharacter(int(form.character))
raise HTTPSeeOther(location="/modcontrol")
def modcontrol_hide_(request):
form = request.web_input(name="", submission="", character="")
if form.submission:
moderation.hidesubmission(int(form.submission))
elif form.character:
moderation.hidecharacter(int(form.character))
raise HTTPSeeOther(location="/modcontrol")
def POST(self):
form = web.input(name="", submission="", character="")
if form.submission:
moderation.hidesubmission(int(form.submission))
elif form.character:
moderation.hidecharacter(int(form.character))
raise web.seeother("/modcontrol")
def POST(self):
form = web.input(name="", submission="", character="")
if form.submission:
moderation.hidesubmission(int(form.submission))
elif form.character:
moderation.hidecharacter(int(form.character))
raise web.seeother("/modcontrol")
def modcontrol_spamqueue_submission_post_(request):
"""
A Pyramid route controller for approving for display or items which the spam filter has tagged as being spam.
:param request: The Pyramid request.
:return/raises: HTTPSeeOther for the journal spam queue.
"""
action = request.params.get("directive")
submitid = int(request.params.get("submitid"))
if action == "approve":
# Approve and insert the journal into the notifications table.
submitid, userid, rating, settings, content, ua_id, ip_addr = define.engine.execute(
"""
UPDATE submission
SET is_spam = FALSE
WHERE submitid = %(id)s
RETURNING submitid, userid, rating, settings, content, submitter_user_agent_id, submitter_ip_address
""",
id=submitid).first()
# Update the spam filtering backend to indicate that this was not spam
spam_filtering.submit(
is_ham=True,
user_ip=ip_addr,
user_agent_id=ua_id,
user_id=userid,
comment_type="submission",
comment_content=content,
)
welcome.submission_insert(userid=userid,
submitid=submitid,
rating=rating,
settings=settings)
elif action == "reject":
moderation.hidesubmission(submitid=submitid)
else:
raise HTTPSeeOther("/modcontrol/spamqueue/submission")
raise HTTPSeeOther("/modcontrol/spamqueue/submission")