[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