function getSentMailByUser($user)
{
global $mysql;
$sql = "select * from mail where `isDeleted` = 'false' and mailSender like '%?%' ORDER BY `mailTime` DESC ";
$arr = $mysql->DBGetAsMap($sql, $user);
for ($i = 0; $i < count($arr); $i++) {
$receiver = $arr[$i]["mailReceiver"];
$receiverList = explode(',', $receiver);
for ($j = 0; $j < count($receiverList); $j++) {
$realName = getUserRealName($receiverList[$j]);
$realName = $realName["realname"];
if ($realName != "" && $realName != null) {
$receiverList[$j] = $realName;
}
}
$receiver = implode(",", $receiverList);
$arr[$i]["mailReceiver"] = $receiver;
$sender = getUserRealName($arr[$i]["mailSender"]);
$arr[$i]["mailSender"] = $sender["realname"];
}
return $arr;
}
<?php
include_once "conn.php";
include_once "mailDB.php";
$action = strtolower($_REQUEST["action"]);
$res = "";
switch ($action) {
case "send":
$mailSender = $_SESSION['name'];
if (isset($_REQUEST['mailSender'])) {
$realname = getUserRealName($_REQUEST['mailSender']);
$mailSender = $realname["realname"];
}
$senderAddress = $_SESSION['mail'];
$receiverAddress = $_REQUEST["recipient"];
$mailSubject = $_REQUEST["subject"];
$mailContent = $_REQUEST["body"];
sendEmail($receiverAddress, null, $mailSender, $mailSubject, $mailContent, null);
global $mysql;
$mailReceivers = $mysql->DBGetAsOneArray("select name from user where `mail` = '{$receiverAddress}' and `isDeleted` = 'false' ");
//如果多个用户用同一个邮箱，则此处会出问题，收件人不一定对。
$mailReceiver = count($mailReceivers) == 0 ? $receiverAddress : $mailReceivers[0];
$res = insert($mailSender, $senderAddress, $mailReceiver, $receiverAddress, $mailSubject, $mailContent);
break;
case "insert":
$res = insert($_POST["mailSender"], $_POST["senderAddress"], $_POST["mailReceiver"], $_POST["receiverAddress"], $_POST["mailSubject"], $_POST["mailContent"]);
break;
case "sendmail":
$mailSender = $_REQUEST['mailSender'];
$senderAddress = $_REQUEST['senderAddress'];
$mailReceiver = $_REQUEST['mailReceiver'];
$res = logout();
break;
case "edit":
$res = edit();
break;
case "modify":
$res = modify();
break;
case "delete":
$res = delete($_POST['name']);
break;
case "view":
$res = getList();
break;
case "getrealname":
$res = getUserRealName($_REQUEST['name']);
break;
case "getuserbylevel":
$res = getUserByLevel($_REQUEST['level']);
break;
case "reset":
$res = resetAccount();
break;
case "checkUserOnlineUniqueness":
$res = checkUserOnlineUniqueness();
break;
case "modifyPhoneNumber":
$res = modifyPhoneNumber();
break;
case "modifyEmail":
$res = modifyEmail();
<div id = "submitDiv">
<?php
if (isActiveUser()) {
echo ' <button type="submit" id = "submitButton" class="btn btn-lg btn-primary btn-block" onclick = "changePassword(); return false;">Изменить пароль</button>';
}
?>
</div>
</form>
<div class="titleName">Изменение информации</div>
<form class="form-signin" role="form" method="POST">
<input class="form-control" id = "newSurname" value="<?php
echo getUserSurname(isAdmin() && isset($_GET['id']) ? $_GET['id'] : "");
?>
" type="text" placeholder="Фамилия">
<input class="form-control" id = "newName" value="<?php
echo getUserRealName(isAdmin() && isset($_GET['id']) ? $_GET['id'] : "");
?>
" type="text" placeholder="Имя">
<input class="form-control" id = "newPatronymic" value="<?php
echo getUserPatronymic(isAdmin() && isset($_GET['id']) ? $_GET['id'] : "");
?>
" type="text" placeholder="Отчество">
<?php
if (isAdmin() && $id != getActiveUserID()) {
?>
<br />
Роль: <select id="group" class="form-control">
<option value="user" <?php
if (isUserInGroup('user', $id)) {
echo "selected";
}
<?php
$result = getUsersRoundScores($roundId);
foreach ($result as $row) {
?>
<tr align = center>
<td><?php
echo '<b>';
if (isAdmin()) {
echo '<a href="userProfile.php?id=' . $row['id'] . '">';
}
echo $row['name'];
if (isAdmin()) {
echo '</a>';
}
echo '</b> (';
echo getUserSurname($row['id']), ' ', getUserRealName($row['id']), ' ', getUserPatronymic($row['id']);
echo ')';
?>
</td>
<td><?php
echo $row['score'];
?>
</td>
</tr>
<?php
}
?>
</table>
<br>
<h3>Турнирная таблица</h3>
<a href="javascript:loadRoundTable(<?php
