Review counts are needed in 3.2's redesign, and I don't want to have to do an extra query on the reviews table to get this info. For the same reason we have flattened out average rating, weekly and total downloads, etc. So I'd like an additional field added to addons named 'reviews' that's an unsigned int(11) and also we will need another action in maintenance.php to update these counts (read from slave, update master).
Created attachment 297373 [details] [diff] [review] v1, adding column to addons and case to maintenance script This depends on fligtar's patch for maintenance.php. Need to add reviews to addon model... will reupload after meeting.
Created attachment 299951 [details] [diff] [review] v1.5, fixes maint script col name and adds column to addon model When we push this, we will need to have this run on prod: alter table addons add column `totalreviews` int(11) unsigned NOT NULL default '0'
Comment on attachment 299951 [details] [diff] [review] v1.5, fixes maint script col name and adds column to addon model Yes, this looks good. You want to use it in the stars element too, I assume.
This is live.