blob: 22d2fce23a7a2d390ed75aaade2cca2087d7ef0d (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
|
<?php
/* Foursquare Community Site
*
* Copyright (C) 2011 Foursquare Church.
*
* Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
*
*/
require_once "base.inc.php";
class Post {
private $info;
public function __construct($info=null) {
$this->info = $info;
}
public static function getById($id) {
$where = "id='$id'";
return Post::getPost($where);
}
public static function getBySecretId($secretid) {
$where = "secretid='$secretid'";
return Post::getPost($where);
}
private static function getPost($where) {
$query = "SELECT *, UNIX_TIMESTAMP(created) AS createdts FROM post WHERE $where";
$db = getDatabase();
$row = $db->fetchAssocRow($query);
if ($row) {
$user = new Post();
$user->info = $row;
return $user;
} else {
return false;
}
}
public function save() {
$db = getDatabase();
// TODO: Implement Save
}
public function getId() {
return $this->info['id'];
}
public function getName() {
return htmlspecialchars($this->info['name']);
}
public function getDescription() {
return htmlspecialchars($this->info['description']);
}
public function getStage() {
return $this->info['stage'];
}
public function approve() {
$this->info['stage'] = 'approved';
}
public function verify() {
$this->info['stage'] = 'verify';
}
public function getCreated() {
return $this->info['created'];
}
public function getAge() {
$diff = time() - $this->info['createdts'];
if ($diff < 60) {
return floor($diff) ." seconds ago";
} else if ($diff < 3600) {
return floor($diff / 60) ." minutes ago";
} else if ($diff < 86400) {
return floor($diff / 3600) ." hours ago";
} else if ($diff < 604800) {
return floor($diff / 86400) ." days ago";
} else {
return floor($diff / 604800) . " weeks ago";
}
}
public function getLocation() {
return $this->info['location'];
}
}
?>
|
