private function statspro::get_data_comment in Statistics Pro 6

Same name and namespace in other branches

1. 6.2 statspro.inc \StatsPro::get_data_comment()

Returns the number of new comments created per day since the last run.

File

./statspro.inc, line 574

statspro class for statistics pro module.

Class

statspro

Manages the data saving and retrieval according to the user defined parameters.

Code

private function get_data_comment() {
  $result = db_query('SELECT COUNT(*) AS num, DATE(FROM_UNIXTIME(timestamp)) AS dategroup
        FROM {comments}
        WHERE timestamp >= %d
        GROUP BY dategroup', $this->last_run);
  while ($row = db_fetch_array($result)) {
    $this
      ->add_day_data($row['dategroup'], $row['num']);
  }
}