[Bug 13750] AppDB votes system is being cheated
wine-bugs at winehq.org
wine-bugs at winehq.org
Sat Dec 6 20:26:17 CST 2008
http://bugs.winehq.org/show_bug.cgi?id=13750
--- Comment #10 from Jeff Zaroyko <jeffz at 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.
More information about the wine-bugs
mailing list