summaryrefslogtreecommitdiff
path: root/lib/popularnoticesection.php
AgeCommit message (Collapse)Author
2010-06-09Revert "added notice.location to group by"Brenda Wallace
This reverts commit 48dc899acb9a0ac87140353092dab1f5e67753d8.
2010-05-17added notice.location to group byBrenda Wallace
2010-05-15added missing field to the group by. this makes postgres happyBrenda Wallace
2010-02-04Add time-based cutoffs for public tag cloud, favorited lists to speed up ↵Brion Vibber
those queries. Defaulting to only looking at last 90 days of activity, can be adjusted up or down. $config['tag']['cutoff'] = 86400 * 90; $config['popular']['cutoff'] = 86400 * 90; Per-user and per-group tag clouds do not use the cutoff (and it doesn't help with indexing on them).
2010-01-04Ticket 2141: bugs with weighted popularity lists across year boundary.Brion Vibber
Consolidated several separate implementations of the same weighting algorithm into common_sql_weight() and fixed some bugs... For MySQL, now using timestampdiff() instead of subtraction for the comparison, so we get sane results when the year doesn't match, and utc_timestamp() rather than now() so we don't get negative ages for recent items with local server timezone. Unknown whether the same problems affect PostgreSQL, but note that it lacks the timestampdiff() SQL function.
2009-11-26and a typo in column name fixedBrenda Wallace
2009-11-26added missing space after new group by fieldsBrenda Wallace
2009-11-26added more fields to the group by.Brenda Wallace
2009-08-26define LACONICA and accept LACONICA for backwards compatibilityEvan Prodromou
2009-08-25change LACONICA to STATUSNETEvan Prodromou
2009-08-25change controlyourself.ca to status.netEvan Prodromou
2009-08-25change laconi.ca to status.netEvan Prodromou
2009-08-25change Laconica and Control Yourself to StatusNet in PHP filesEvan Prodromou
2009-07-15used SQL standard LIMIT/OFFSET, because every database can understand thatBrenda Wallace
2009-06-24add missing group by item, to make database that aren't mysql happyBrenda Wallace
2009-05-17Refactored new sections code to proper classes and added notice link to ↵Robin Millette
links in notice sections.
2009-04-14trac#1223 Show most popular notices per tag in the tag page sidebar.Robin Millette
2009-03-05The correct version of the bad fix I undid in the previous commit. Must ↵CiaranG
explicitly specify all relevant columns in the GROUP BY.
2009-03-05Undo my previous change that breaks the Popular Notices section on the ↵CiaranG
public timeline under MySQL
2009-03-04PostgreSQL - made all 'weight' calculating SQL expressions compatible with ↵CiaranG
both databases, and made some GROUP BY queries more explicit about the fields they are selecting, for the same reason.
2009-02-20NOTICES_PER_SECTION already defined in lib/noticesection.php, causing a warningLeslie Michael Orchard
2009-02-14Fix the More... link for popular notices sectionEvan Prodromou
2009-02-02Ticket 1044 -- Removed border-top, reduced padding, changed noticeSarven Capadisli
count from 6 to 5, removed nickname.
2009-01-22Add a section for popular notices sitewideEvan Prodromou