Age | Commit message (Collapse) | Author | |
---|---|---|---|
2010-02-04 | Add 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-04 | Ticket 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-26 | and a typo in column name fixed | Brenda Wallace | |
2009-11-26 | added missing space after new group by fields | Brenda Wallace | |
2009-11-26 | added more fields to the group by. | Brenda Wallace | |
2009-08-26 | define LACONICA and accept LACONICA for backwards compatibility | Evan Prodromou | |
2009-08-25 | change LACONICA to STATUSNET | Evan Prodromou | |
2009-08-25 | change controlyourself.ca to status.net | Evan Prodromou | |
2009-08-25 | change laconi.ca to status.net | Evan Prodromou | |
2009-08-25 | change Laconica and Control Yourself to StatusNet in PHP files | Evan Prodromou | |
2009-07-15 | used SQL standard LIMIT/OFFSET, because every database can understand that | Brenda Wallace | |
2009-06-24 | add missing group by item, to make database that aren't mysql happy | Brenda Wallace | |
2009-05-17 | Refactored new sections code to proper classes and added notice link to ↵ | Robin Millette | |
links in notice sections. | |||
2009-04-14 | trac#1223 Show most popular notices per tag in the tag page sidebar. | Robin Millette | |
2009-03-05 | The 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-05 | Undo my previous change that breaks the Popular Notices section on the ↵ | CiaranG | |
public timeline under MySQL | |||
2009-03-04 | PostgreSQL - 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-20 | NOTICES_PER_SECTION already defined in lib/noticesection.php, causing a warning | Leslie Michael Orchard | |
2009-02-14 | Fix the More... link for popular notices section | Evan Prodromou | |
2009-02-02 | Ticket 1044 -- Removed border-top, reduced padding, changed notice | Sarven Capadisli | |
count from 6 to 5, removed nickname. | |||
2009-01-22 | Add a section for popular notices sitewide | Evan Prodromou | |