http://bugs.winehq.org/show_bug.cgi?id=13750 --- Comment #10 from Jeff Zaroyko <jeffz(a)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 -- Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email Do not reply to this email, post in Bugzilla using the above URL to reply. ------- You are receiving this mail because: ------- You are watching all bug changes.