+
+date_default_timezone_set(@date_default_timezone_get());
+$endtime = time();
+$starttime = $endtime - 86400 ;
+
+$shortopts = "v"; // enable verbose mode
+$longopts = array(
+ "all", // consider all commits from registration date saved in db up to now
+ "allepoch", // consider all commits from start of the epoch (1970-01-01) up to now
+ "startdate:", // consider only commits later than given startdate (YYYY-MM-DD), overwritten by all/allsvn
+ "enddate:", // consider only commits before given enddate (YYYY-MM-DD), overwritten by all/allsvn
+ "group_id:", // update data only for group with given id
+ "unix_group_name:" // update data only for group with given unix name
+);
+$options = getopt($shortopts, $longopts);
+$EXTRA_WHERE = "";
+$verbose = false;
+
+$qpa = db_construct_qpa(false, 'SELECT group_id, group_name, register_time FROM groups WHERE status=$1 AND use_scm=$2', array ('A', 1));
+
+if ( isset($options['v']) ) {
+ $verbose = true;
+}
+if ( isset($options['startdate']) ) {
+ $starttime = strtotime($options['startdate']) ;
+ ($verbose) && print "Startdate: ".date("Y-m-d", $starttime)."\n";
+}
+if ( isset($options['enddate']) ) {
+ $endtime = strtotime($options['enddate']) ;
+ ($verbose) && print "Enddate: ".date("Y-m-d", $endtime)."\n";
+}
+if ( isset($options['group_id']) ) {
+ ($verbose) && print "group_id: ".$options['group_id']."\n";
+ $qpa = db_construct_qpa($qpa, ' AND group_id=$1', array($options['group_id']));
+}
+if ( isset($options['unix_group_name']) ) {
+ ($verbose) && print "unix_group_name: ".$options['unix_group_name']."\n";
+ $qpa = db_construct_qpa($qpa, ' AND unix_group_name=$1', array($options['unix_group_name']));
+}
+
+$qpa = db_construct_qpa($qpa, ' ORDER BY group_id DESC');
+
+$res = db_query_qpa($qpa);
+