$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>'; }