missing table prefix in cvs_get_contributed_projects

In the cvs_get_contributed_projects() function of cvs.module, there is the following line:

$result = db_query("SELECT DISTINCT(f.nid), n.title, COUNT(f.nid) AS commits FROM {cvs_files} f INNER JOIN node n ON n.status = 1 AND n.nid = f.nid WHERE f.uid = %d GROUP BY f.nid ORDER BY commits DESC", $uid);

that is missing curly braces around the node table.

The corrected line should be:

$result = db_query("SELECT DISTINCT(f.nid), n.title, COUNT(f.nid) AS commits FROM {cvs_files} f INNER JOIN {node} n ON n.status = 1 AND n.nid = f.nid WHERE f.uid = %d GROUP BY f.nid ORDER BY commits DESC", $uid);

AC