protected function StatsPro::get_data_comment in Statistics Pro 6.2

Same name and namespace in other branches

1. 6 statspro.inc \statspro::get_data_comment()

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

File

./statspro.inc, line 726

statspro class for Statistics Pro module.

Class

StatsPro

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

Code

protected 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']);
  }
}