public function getAgo() { if (!empty($this->updated)) { return FoodleUtils::date_diff(time() - $this->updated); } if (!empty($this->created)) { return FoodleUtils::date_diff(time() - $this->created); } return NULL; }
public function getExpireText() { if (empty($this->expire)) { return 'This foodle will not expire'; } if ($this->isExpired()) { return 'This foodle is expired'; } return date("Y-m-d H:i", (int) $this->expire) . ' (expires in ' . FoodleUtils::date_diff((int) $this->expire - time()) . ')'; }
public function readDiscussion(Data_Foodle $foodle, $maxago = null) { $maxclause = ''; if ($maxago !== null) { $maxclause = ' AND UNIX_TIMESTAMP(NOW()) - UNIX_TIMESTAMP(created) < ' . mysql_real_escape_string($maxago); } $sql = "\n\t\t\tSELECT *, UNIX_TIMESTAMP(created) AS createdu\n\t\t\tFROM discussion \n\t\t\tWHERE foodleid = '" . $foodle->identifier . "' " . $maxclause . "\n\t\t\tORDER BY discussion.created DESC \n\t\t\t"; $result = $this->q($sql); $discussion = array(); if (!empty($result)) { foreach ($result as $row) { try { if (!empty($row['userid'])) { $ruser = $this->readUser($row['userid']); if ($ruser !== false) { $row['user'] = $ruser; } } } catch (Exception $e) { } $row['agotext'] = FoodleUtils::date_diff(time() - $row['createdu']); $discussion[] = $row; } } return $discussion; }