[AppDB] Fix up showing too many votes in votestats

Paul van Schayck polleke at gmail.com
Mon Jan 3 04:49:48 CST 2005


The query used in votestats was wrong. Sometimes it would show way too
many votes for an application.  Look at
http://appdb.winehq.org/votestats.php?categoryId=82
Compare with
http://appdb.winehq.org/votestats.php

This was caused by a wrongly build query.
The query was wrongly linking the appCategory table with the appFamily table.

The new query was quite a pain to make. I've documented into
votestats.php as comment.

Changelog:
- Fix the per category query. It was showing too many votes in some cases.
- Use query_appdb
-------------- next part --------------
A non-text attachment was scrubbed...
Name: votes.diff
Type: text/x-patch
Size: 1933 bytes
Desc: not available
Url : http://www.winehq.org/pipermail/wine-patches/attachments/20050103/db3da2ea/votes.bin


More information about the wine-patches mailing list