$output = array("iTotalRecords" => $iTotal, "iTotalDisplayRecords" => $iFilteredTotal, "aaData" => array());
while ($aRow = mysqli_fetch_array($rResult)) {
$row = array();
foreach ($columns as $key => $value) {
switch ($key) {
case "username":
$row[] = "<a href='index?module=user_profile&id=" . $aRow['id'] . "' target='_blank'>" . $aRow["username"] . "</a>";
break;
case "email":
$row[] = $aRow["email"];
break;
case "type":
$row[] = GlobalGetAccountType($aRow['type']);
break;
case "rank":
$rank = UserGetStatistics($aRow['id']);
$row[] = GlobalGetRank('value', 'id', $rank[0]['rank_solo']);
break;
case "team":
$row[] = TeamGetInfoByColumn('name', 'id', GetTeamOfUser($aRow['id']));
break;
case "role":
$row[] = GlobalGetRole(GetCurrentRoleOfUser($aRow['id']));
break;
case "last_login":
if (date('d-m-Y H:i:s', strtotime($aRow['last_login'])) == '01-01-1970 01:00:00') {
$row[] = "No data";
} else {
$row[] = date('d-m-Y H:i:s', strtotime($aRow['last_login']));
}
break;
<?php
error_reporting(0);
include $_SERVER['DOCUMENT_ROOT'] . '/functions.php';
// for edit user
$user_id = $_POST['user_id'];
$conn = sql_domain();
$stmt = $conn->prepare('select * from users where id = :uid');
$stmt->bindparam(':uid', $user_id);
$stmt->execute();
$result = $stmt->fetchAll();
$result = $result[0];
$user_name = $result['username'];
$user_email = $result['email'];
$user_type = $result['type'];
$current_rank = UserGetStatistics($user_id);
$current_rank = $current_rank[0]['rank_solo'];
$role_pref = $result['role_pref'];
?>
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="myModalLabel"><?php
if ($user_id) {
echo "Edit user : "******"New user";
}
?>
</h4>
function GetCurrentRosterForTeam($team_id)
{
echo "<table class='table table-hover table-light'>";
echo '<thead>';
echo '<tr class="uppercase">';
echo '<th colspan="2">';
echo "Member";
echo '<th>Role</th>';
echo '<th>Rank</th>';
echo '</tr>';
echo '</thead>';
$conn = sql_domain();
$stmt = $conn->prepare('select * from teams_roles where team_id = :tid');
$stmt->bindParam(':tid', $team_id);
$stmt->execute();
$members = $stmt->fetchAll();
foreach ($members as $member) {
echo "<tr data-toggle='context' data-target='#context-menu'>";
echo "<td class='fit'>";
echo "<img class='user-pic' src='" . GetUserBanner($member['user_id']) . "'>";
echo "</td>";
echo "<td>";
echo "<a target='_blank' href='index?module=user_profile&id=" . $member['user_id'] . "' class='primary-link'>" . UserGetInfoByColumn('username', 'id', $member['user_id']) . "</a>";
echo "</td>";
echo "<td>";
echo GlobalGetRole(GetCurrentRoleOfUser($member['user_id']));
echo "</td>";
echo "<td>";
$rank = UserGetStatistics($member['user_id']);
echo GlobalGetRank('value', 'id', $rank[0]['rank_solo']);
echo "</td>";
echo "</tr>";
echo '<div id="context-menu">
<ul class="dropdown-menu" role="menu">
<li>
<a href="javascript:;">
<i class="fa fa-refresh"></i> Update rank
</a>
</li>
</ul>
</div>';
}
echo '</table>';
echo '<script src="../../assets/global/plugins/bootstrap-contextmenu/bootstrap-contextmenu.js"></script>';
}
