mahara-contributors team mailing list archive

[Aaron Wells <1127802@xxxxxxxxxxxxxxxxxx>]

Note that this turns out to be a difficult thing to implement without
getting rid of the LIMIT function on the query that selects the forum
entries for the page. You'd need to group together adjacent deleted
records by the same author, something which is probably only possible
with a window function: http://www.postgresql.org/docs/9.1/static
/tutorial-window.html

So, one might implement this as a postgres-only bit of functionality.

Alternately, just drop the LIMIT function from the query that gets the
forum records, and in PHP process through them all to find the 10 unique
non-deleted records for the page. If you use adodb recordsets for this
instead of dumping the recordset into an array, you won't have to worry
about running out of memory. There just might be some processing time
involved, if you're dealing with a giant thread.

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
Matching subscriptions: Subscription for all Mahara Contrib members
https://bugs.launchpad.net/bugs/1127802

Title:
  Forum post deletion notices should not count towards pagination

Status in Mahara ePortfolio:
  Confirmed

Bug description:
  In addition to bug #1127801, post removal notices should be ignored by
  the pagination.

  Even if bug #1127801 is implemented, several spammers flooding a topic
  might take turns and hence stop the consecutive grouping from being
  successful in reducing the noise.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1127802/+subscriptions