/**
* Delete the transcript.
*/
public function delete($date, $shortName)
{
// transcript users are not needed anymore
$this->db->delete('transcript_users', array('transcript' => $this->details['key']));
// files
$files = $this->db->selectRow('files', 'group_concat(code) as codes', array('transcript' => $this->details['key']));
$this->db->delete('files', array('transcript' => $this->details['key']));
// thumbnails aka silly quoting
$codes = explode(',', $files['codes']);
foreach ($codes as &$code) {
$code = "'{$code}'";
}
$codes = implode(', ', $codes);
$this->db->delete('thumbs', "code IN ({$codes})");
// finaly ourselves
$this->db->delete('room_transcripts', array('key' => $this->details['key']));
// reset the last activity for the room so a new transcript can be created
$this->db->update('rooms', array('activity' => 0), array('id' => $this->details['room']));
// delete all messages for the day
$this->db->delete('messages', array('room' => $this->details['room'], 'date' => $this->details['date']));
// has this happened today?
if ($date == SystemTime::timestampToDate()) {
$message = new MessageSpeak($this->details['room'], mktime());
$message->transcript($this->details['room'], $shortName, $date);
}
}
