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; case 'actions':
<th>Actions</th> </tr> </thead> <tbody> <?php $conn = sql_domain(); $stmt = $conn->prepare('select t.user_id,role_id,rank_solo from teams_roles as t left join users_statistics as u on t.user_id = u.user_id where t.team_id = :t'); $stmt->bindParam(':t', $team_id); $stmt->execute(); $teams = $stmt->fetchAll(); foreach ($teams as $t) { echo "<tr>"; echo "<td>"; echo UserGetInfoByColumn('username', 'id', $t['user_id']) . "</td>"; echo "<td>" . GlobalGetRole($t['role_id']) . "</td>"; echo "<td>" . GlobalGetRank('value', 'id', $t['rank_solo']) . "</td>"; echo "<td><button class='btn btn-primary btn-sm'><i class='fa fa-refresh'></i></button>"; echo "</td>"; echo "</tr>"; } ?> </tbody> </table> </div> </div> </div> <div class="col-md-12"> dsfds </div> </div> <div class="col-md-6">
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>'; }