Reviews Update 2

[Crothian]

when I posted my review it subscribed it as a thread, except it linked to the main page of the reviews and listed Joe Kusner as the starter of the thread and 4 replies to it (which I guess to be the other three reviews and the single comment)

 

[Michael Morris]

That's next weekend's product. Here's a full list of things to do / fix.

• Fix the navbar breadcrumbs so that they can be used to navigate back up the line.
• Open product, productline, and publisher posting as well as the associated editting features
• Set the 500 min word lock on reviews.
• Paginate large publisher entries
• Paginate large product line entries
• Automate notices of reviews postings in main news body (though that goes hand in hand with a revision of the news pages)
• Alter user profiles to list recent and all reviews of a poster - not just the staff posters.
• Display user review counts in addition to post counts.
• Write an admin tool to associate old reviews with a new account.
• Write an admin tool to recalculate all review scores (actually, I have one - but it needs to be more fully integrated).
• Write an admin tool to locate and delete orphan posts in the reviews system - mostly comments without reviews, reviews without products (unlikely since products are threads and vbulletin will prevent that problem on its own), products without publishers and productlines without publishers.
• Allow publisher access to their interface panels.
• Integrate product links with the links system so that links associated with products are displayed under both setups.
• Allow publishers to upload company logos, product logos, product line logos, and up to 10 product images.
• Configure reviews system to display product images within the body of any review to break up the large blocks of text.
• Display ENnies award medals beside their winners within the product postbit as appropriate.

Longer term plans. (Subject to change)

• Custom Ad System
  • Publishers would access their ads from the same interface used for their reviews profile.
  • Publishers would purchase ad exposures from the same interface and could assign those exposures to specific products or reassign them.
  • Publishers would be able to set limits to how often an ad is exposed to a user overall, or per session. Such limits wouldn't apply to staff, but exposures to ENWorld staff would not be counted towards the purchased exposures.
  • Community supporters would be able to weight the ads they see towards their interests. This wouldn't stop them from seeing ads irrelevant to their interests, but it would help it along.
• Reviews would link over to preview downloads available in the upload section.
• Publishers would be able to upload preview items and, if desired, limit them to community supporters.
• The noticing of new reviews would be automated on the news page.
• I want (don't know if Russ will let me) make some significant changes to the news page to make it more fluid and centralized.

Oh, and Gamers seeking Gamers will get a major upgrade.

 

[Michael Morris]

when I posted my review it subscribed it as a thread, except it linked to the main page of the reviews and listed Joe Kusner as the starter of the thread and 4 replies to it (which I guess to be the other three reviews and the single comment)

Yes, that's normal. The subscription system *sees* the product as a thread, and the reviews and comments are all replies to the product which starts the post. I may streamline it out later. As it stands though, you can subscribe to products and get updates whenever they are reviewed or commented to, but you can't subscribe to just one review.

Better than what we had though (no subscription system at all)

 

[Mark]

Not sure if this has been addressed but it appears that products that haven't been reviewed are treated as having no stars and thus bring down the rating of a publisher.

 

[Michael Morris]

Rats.. Hmm.. Well... I uh.. As soon as I figure out a correction to the query I'll recalculate it.

 

[Crothian]

Yes, that's normal. The subscription system *sees* the product as a thread, and the reviews and comments are all replies to the product which starts the post. I may streamline it out later. As it stands though, you can subscribe to products and get updates whenever they are reviewed or commented to, but you can't subscribe to just one review.

Better than what we had though (no subscription system at all)

Gotcha, I'm getting used to the review site so these features obviously new to me and I'm not sure what to expect from that all. Thanks.

 

[jmucchiello]

Rats.. Hmm.. Well... I uh.. As soon as I figure out a correction to the query I'll recalculate it.

Shouldn't you just average the existing reviews without regard for how many products there are?

Select Sum(stars) as total_starts, Count(*) as total_reviews, publisher_id from reviews; (or join the reviews and pubs table if the pub_id is not available on the review table)

if (count > 0) stars = total_stars/total_reviews else stars = 0;

The number of products shouldn't enter into it.

 

[Michael Morris]

Shouldn't you just average the existing reviews without regard for how many products there are?

Select Sum(stars) as total_starts, Count(*) as total_reviews, publisher_id from reviews; (or join the reviews and pubs table if the pub_id is not available on the review table)

if (count > 0) stars = total_stars/total_reviews else stars = 0;

The number of products shouldn't enter into it.

The correct query, I believe, will be

SELECT AVG(score) AS score FROM product WHERE publisherid = $publisherid AND score > 0

Haven't had time to test it yet - been taking a break.

 

[jmucchiello]

The correct query, I believe, will be

SELECT AVG(score) AS score FROM product WHERE publisherid = $publisherid AND score > 0

Haven't had time to test it yet - been taking a break.

But that averages the product scores which are already an average. So if a publisher have two products: one with 100 reviews and an average of 3 and one with 1 review of 5, the publisher will have a score of 4 by that querry. That's why my querry was off of the (assumed) review table instead of the product table.

 

[MonsterMash]

Are we able to edit our existing reviews as I couldn't find a link to do it.