notify the channel of new tickets

function bot_nowpublic_irc_bot_cron() {
  $pdo = new PDO('sqlite:/home/trac/nowpublic/db/trac.db');
  $statement = $pdo->prepare('SELECT id, reporter, summary, priority, owner FROM ticket WHERE time > :time');
  $statement->execute(array(':time' => time() - 300));
  foreach ($statement as $ticket) {
    extract($ticket);
    $message = "New $priority ticket from $reporter for $owner: $summary https://TRACURL/ticket/$id";
    bot_message('#nowpublic', $message);
  }
}

edit: I removed the tracurl from the post. Opsie.
interested in this feature? then take the above code and make it nice and configurable. It requires PHP 5.2 but it does work for me.