http://bugs.winehq.org/show_bug.cgi?id=13750
--- Comment #10 from Jeff Zaroyko jeffz@jeffz.name 2008-12-06 20:26:16 --- (In reply to comment #9)
Heh, don't really have enough knowledge about databases to interpret that file correctly :P
Not to complain, but the app from comment 7 still doesn't have the bogus votes removed.
it looks like they were there from before, using the same copy of the db I took last time I looked at this, the votes appear to be there.
and there's nothing to know really:
install mysql. download the backup, uncompress it, mysql -uroot create database apidb; use apidb; source backup071208.sql; # the url in comment shows 8735 is the verisonId select userId, count(userId) from appVotes where versionId = 8735 group by userId;
+--------+---------------+ | userId | count(userId) | +--------+---------------+ <snip> | 113799 | 3 | | 113800 | 3 | | 113801 | 3 | | 113802 | 3 | | 114064 | 3 | | 114065 | 3 | | 114073 | 3 | | 114074 | 3 | | 114075 | 3 | | 114076 | 3 | <snip>
This pretty much shows that the userIds who voted for this app were created sequentially, probably by the same person.
So, take a copy of the suspect UserIds:
select userId into outfile '/tmp/eh.txt' from appVotes where versionId = 8735 group by userId; quit
Turn them into html links so that an AppDB admin can look at the user prefs page for each of them and delete them if necessary:
ghci # glasgow haskell compiler lamers <- readFile "/tmp/eh.txt" writeFile "/tmp/lamers.html" $ (concatMap (\id -> "<a href="http://appdb.winehq.org/contact.php?iRecipientId=" ++ id ++ "">" ++ id ++ "</a><br/>")) (lines lamers) ^D
firefox /tmp/lamers.html