4 * Copyright 1999-2001 (c) VA Linux Systems
6 * This file is part of FusionForge. FusionForge is free software;
7 * you can redistribute it and/or modify it under the terms of the
8 * GNU General Public License as published by the Free Software
9 * Foundation; either version 2 of the Licence, or (at your option)
12 * FusionForge is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
17 * You should have received a copy of the GNU General Public License along
18 * with FusionForge; if not, write to the Free Software Foundation, Inc.,
19 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
22 require (dirname(__FILE__).'/../www/env.inc.php');
23 require_once $gfcommon.'include/pre.php';
24 require $gfcommon.'include/cron_utils.php';
29 # aggregate the ratings
34 $rel = db_query_params ('DELETE FROM survey_rating_aggregate;',
39 $rel = db_query_params ('INSERT INTO survey_rating_aggregate SELECT type,id,avg(response),count(*) FROM survey_rating_response GROUP BY type,id',
45 $err .= "Error: ".db_error();