[Chris M]

You'll need to make a file with the following Query:
[sql]UPDATE user SET downloadcount = 0[/sql]
You should change the php code to the following:

PHP Code:

 $downloadlimit = 10;
if ($vbulletin->userinfo['downloadcount'] > $downloadlimit) {
eval(standard_error(fetch_error('dlquotareached')));
exit;
} else {
$db->query_write("UPDATE user SET downloadcount = downloadcount + 1 WHERE userid = ' . $vbulletin->userinfo['userid'] . '");
} 


I'll do the usergroup thing when I get more time

Chris