public function fetchAll()
{
$this->buildStart();
$this->build();
$this->buildStat();
$results = array();
while ($data = $this->stat->fetch()) {
$uwgm = new UserWatchesGroupModel();
$uwgm->setFromDataBaseRow($data);
$results[] = $uwgm;
}
return $results;
}
public function markPromptEmailSent(UserWatchesGroupModel $userWatchesGroup, $emailTime)
{
global $DB;
$stat = $DB->prepare("UPDATE user_watches_group_information SET last_prompt_email_sent=:sent WHERE user_account_id =:user_account_id AND group_id=:group_id");
$stat->execute(array('user_account_id' => $userWatchesGroup->getUserAccountId(), 'group_id' => $userWatchesGroup->getGroupId(), 'sent' => $emailTime->format("Y-m-d H:i:s")));
}