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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
|
<?php defined("SYSPATH") or die("No direct script access.");
/**
* Gallery - a web based photo album viewer and editor
* Copyright (C) 2000-2008 Bharat Mediratta
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or (at
* your option) any later version.
*
* This program is distributed in the hope that it will be useful, but
* WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* General Public License for more details.
*
* You should have received a copy of the GNU General Public License
* along with this program; if not, write to the Free Software
* Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA 02110-1301, USA.
*/
class Admin_Comments_Controller extends Admin_Controller {
public function index() {
$this->queue("all");
}
public function queue($state) {
$view = new Admin_View("admin.html");
$view->content = new View("admin_comments.html");
$view->content->all = $this->_query(array("published", "unpublished"));
$view->content->published = $this->_query(array("published"));
$view->content->unpublished = $this->_query(array("unpublished"));
$view->content->spam = $this->_query(array("spam"));
$view->content->menu = Menu::factory("root")
->append(Menu::factory("link")
->id("all")
->label(sprintf(_("All Comments (%d)"),
$view->content->all->count()))
->url(url::site("admin/comments/queue/all")))
->append(Menu::factory("link")
->id("unpublished")
->label(sprintf(_("Awaiting Moderation (%d)"),
$view->content->unpublished->count()))
->url(url::site("admin/comments/queue/unpublished")))
->append(Menu::factory("link")
->id("published")
->label(sprintf(_("Approved (%d)"),
$view->content->published->count()))
->url(url::site("admin/comments/queue/published")))
->append(Menu::factory("link")
->id("spam")
->label(sprintf(_("Spam (%d)"), $view->content->spam->count()))
->url(url::site("admin/comments/queue/spam")));
switch ($state) {
case "all":
$view->content->comments = $view->content->all;
$view->content->title = _("All Comments");
break;
case "published":
$view->content->comments = $view->content->published;
$view->content->title = _("Approved Comments");
break;
case "unpublished":
$view->content->comments = $view->content->unpublished;
$view->content->title = _("Comments Awaiting Moderation");
break;
case "spam":
$view->content->title = _("Spam Comments");
$view->content->comments = $view->content->spam;
$view->content->spam_caught = module::get_var("comment", "spam_caught");
break;
}
$view->content->queue = $state;
$view->content->pager = new Pagination();
$view->content->pager->initialize(
array('query_string' => 'page',
'total_items' => $view->content->comments->count(),
'items_per_page' => 20,
'style' => 'classic'));
print $view;
}
private function _query($states) {
$query = ORM::factory("comment")
->orderby("created", "DESC");
if ($states) {
$query->in("state", $states);
}
return $query->find_all();
}
public function set_state($id, $state) {
access::verify_csrf();
$comment = ORM::factory("comment", $id);
$orig = clone $comment;
if ($comment->loaded) {
$comment->state = $state;
$comment->save();
module::event("comment_changed", $orig, $comment);
}
}
public function delete($id) {
access::verify_csrf();
$comment = ORM::factory("comment", $id);
if ($comment->loaded) {
module::event("comment_before_delete", $comment);
$comment->delete();
}
}
public function delete_all_spam() {
access::verify_csrf();
ORM::factory("comment")
->where("state", "spam")
->delete_all();
url::redirect("admin/comments/queue/spam");
}
}
|
