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
126
127
128
129
130
131
132
133
134
135
|
<?php
/**
* score.php - Stud.IP Highscore List
*
* 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., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
*
* @author Stefan Suchi <suchi@gmx.de>
* @author Michael Riehemann <michael.riehemann@uni-oldenburg.de>
* @author Jan-Hendrik Willms <tleilax+studip@gmail.com>
* @license http://www.gnu.org/licenses/gpl-2.0.html GPL version 2 or later
* @category Stud.IP
* @since 2.4
*/
class ScoreController extends AuthenticatedController
{
/**
* Set up this controller.
*
* @param String $action Name of the action to be invoked
* @param Array $args Arguments to be passed to the action method
*/
public function before_filter(&$action, &$args)
{
// Interpret every action other than 'index', 'publish' or 'unpublish'
// as page number
if (!in_array($action, words('index publish unpublish'))) {
array_unshift($args, (int)$action);
$action = 'index';
}
parent::before_filter($action, $args);
if (!Config::Get()->SCORE_ENABLE) {
throw new AccessDeniedException(_('Die Rangliste und die Score-Funktion sind nicht aktiviert.'));
}
PageLayout::setHelpKeyword('Basis.VerschiedenesScore'); // external help keyword
PageLayout::setTitle(_('Rangliste'));
Navigation::activateItem('/community/score');
}
/**
* Displays the global ranking list.
*
* @param int $page Page of the ranking list to be displayed.
*/
public function index_action($page = 1)
{
$vis_query = get_vis_query('b');
// Calculate offsets
$max_per_page = Config::get()->ENTRIES_PER_PAGE;
if ($page < 1) {
$page = 1;
}
$offset = max(0, ($page - 1) * $max_per_page);
// Liste aller die mutig (oder eitel?) genug sind
$query = "SELECT SQL_CALC_FOUND_ROWS a.user_id,username,score,geschlecht, {$GLOBALS['_fullname_sql']['full']} AS fullname
FROM user_info AS a
LEFT JOIN auth_user_md5 AS b USING (user_id)
WHERE score > 0 AND locked = 0 AND {$vis_query}
ORDER BY score DESC
LIMIT " . (int)$offset . "," . (int)$max_per_page;
$result = DBManager::get()->fetchAll($query);
$count = DBManager::get()->fetchColumn("SELECT FOUND_ROWS()");
$persons = [];
foreach ($result as $row) {
$row['is_king'] = StudipKing::is_king($row['user_id'], true);
$persons[$row['user_id']] = $row;
}
$persons = Score::getScoreContent($persons);
$this->persons = array_values($persons);
$this->numberOfPersons = $count;
$this->page = $page;
$this->offset = $offset;
$this->max_per_page = $max_per_page;
$this->current_user = User::findCurrent();
$this->current_user_score = Score::getMyScore($this->current_user);
// Set up sidebar and helpbar
$sidebar = Sidebar::get();
$actions = new OptionsWidget();
$actions->addCheckbox(
_('Ihren Wert veröffentlichen'),
$this->current_user->score,
$this->url_for('score/publish'),
$this->url_for('score/unpublish')
);
$sidebar->addWidget($actions);
}
/**
* Publish user's score / add user's score to the ranking list.
*/
public function publish_action()
{
$user = User::findCurrent();
$user->score = Score::getMyScore($user);
$user->store();
PageLayout::postSuccess(_('Ihr Wert wurde auf der Rangliste veröffentlicht.'));
$this->redirect('score');
}
/**
* Removes the user's score from the ranking list.
*/
public function unpublish_action()
{
$user = User::findCurrent();
$user->score = 0;
$user->store();
PageLayout::postSuccess(_('Ihr Wert wurde von der Rangliste gelöscht.'));
$this->redirect('score');
}
}
|
