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
136
137
138
|
<?php
/**
* Postfix Admin
*
* LICENSE
* This source file is subject to the GPL license that is bundled with
* this package in the file LICENSE.TXT.
*
* Further details on the project are available at https://github.com/postfixadmin/postfixadmin
*
* @version $Id$
* @license GNU GPL v2 or later.
*
* File: app-passwords.php
* Used by users to view and change their app passwords.
* Template File: app-passwords.tpl
*
*
* Form POST \ GET Variables:
*
* fPassword_current
* fAppDesc
* fAppPass
* fAppId
*
*/
require_once('../common.php');
$smarty = PFASmarty::getInstance();
$smarty->configureTheme($smarty->getRelPath());
$username = authentication_get_username();
$pPassword_text = "";
$pUser_text = '';
$pUser = '';
if (authentication_has_role('global-admin')) {
$login = new Login('admin');
$admin = 2;
$passwords = getAllAppPasswords();
} elseif (authentication_has_role('admin')) {
$login = new Login('admin');
$admin = 1;
$passwords = getAppPasswordsFor($username);
} else {
$login = new Login('mailbox');
$admin = 0;
$passwords = getAppPasswordsFor($username);
}
if ($_SERVER['REQUEST_METHOD'] == "POST") {
if (safepost('token') != $_SESSION['PFA_token']) {
die('Invalid token!');
}
if (isset($_POST['fCancel'])) {
header("Location: main.php");
exit(0);
}
if (isset($_POST['fAppPass'])) {
$fPass = $_POST['fPassword_current'];
$fAppDesc = $_POST['fAppDesc'];
$fAppPass = $_POST['fAppPass'];
try {
if ($login->addAppPassword($username, $fPass, $fAppDesc, $fAppPass)) {
flash_info($PALANG['pAppPassAdd_result_success']);
header("Location: app-passwords.php");
exit(0);
} else {
flash_error(Config::Lang_f('pAppPassAdd_result_error', $username));
}
} catch (\Exception $e) {
flash_error($e->getMessage());
}
}
if (isset($_POST['fAppId']) && is_numeric($_POST['fAppId'])) {
$fAppId = (int)$_POST['fAppId'];
// $username should be from $_SESSION and not modifiable by the end user
// we don't want someone to be able to delete someone else's app password by guessing an id...
$row = db_query_one('SELECT id FROM ' . table_by_key('mailbox_app_password') . ' WHERE id = :id AND username = :username', ['username' => $username, 'id' => $fAppId]);
if (!empty($row)) {
$result = db_delete('mailbox_app_password', 'id', $row['id']);
if ($result == 1) {
flash_info($PALANG['pTotp_exceptions_revoked']);
header("Location: app-passwords.php");
exit(0);
}
}
flash_error($PALANG['pPassword_result_error']);
}
}
foreach ($passwords as $n => $pass) {
if ($pass['username'] == $username) {
$passwords[$n]['edit'] = 1;
}
if ($admin == 2) {
$passwords[$n]['edit'] = 1;
}
}
$smarty->assign('SESSID_USERNAME', $username);
$smarty->assign('pPassword_text', $pPassword_text, false);
$smarty->assign('pUser_text', $pUser_text, false);
$smarty->assign('pUser', $pUser, false);
$smarty->assign('pPasswords', $passwords, false);
$smarty->assign('smarty_template', 'app-passwords');
$smarty->display('index.tpl');
/**
* @return array
*/
function getAllAppPasswords()
{
return db_query_all("SELECT * FROM " . table_by_key('mailbox_app_password'));
}
/**
* @param string $username
* @return array
* @todo if $username is a domain admin, we should return all app passwords for that domain.
*/
function getAppPasswordsFor(string $username): array
{
return db_query_all("SELECT * FROM " . table_by_key('mailbox_app_password') . " WHERE username = :username", ['username' => $username]);
}
/* vim: set expandtab softtabstop=4 tabstop=4 shiftwidth=4: */
|
