<div> <!-- widget edit box --> <div class="jarviswidget-editbox"> <!-- This area used as dropdown edit box --> <input class="form-control" type="text"> </div> <!-- end widget edit box --> <!-- widget content --> <div class="widget-body" style="text-align: center;"> <div class="row"> <?php $sql = "SELECT * from players WHERE archived!=1"; $result = $database->sqlQuery($sql); ?> <?php while ($row = $result->fetch_assoc()) { ?> <?php $player_id = $row["id"]; $getWins = "SELECT games.id,games.winning_team,players.slack_user_name FROM pumpfoos.games JOIN pumpfoos.games_players ON pumpfoos.games.id=pumpfoos.games_players.game_id JOIN pumpfoos.players ON pumpfoos.players.id=pumpfoos.games_players.player_id WHERE games.winning_team=games_players.team AND players.id={$player_id}"; $getLosses = "SELECT games.id,games.winning_team,players.slack_user_name FROM pumpfoos.games JOIN pumpfoos.games_players ON pumpfoos.games.id=pumpfoos.games_players.game_id JOIN pumpfoos.players ON pumpfoos.players.id=pumpfoos.games_players.player_id WHERE games.losing_team=games_players.team AND players.id={$player_id}"; $result3 = $database->sqlQuery($getWins); $result4 = $database->sqlQuery($getLosses); $numWins = $result3->num_rows; $numLosses = $result4->num_rows; ?> <div class="col-sm-6 col-md-4 col-lg-3" style="padding: 10px;"> <div class="row">
<!-- widget div--> <div> <!-- widget edit box --> <div class="jarviswidget-editbox"> <!-- This area used as dropdown edit box --> <input class="form-control" type="text"> </div> <!-- end widget edit box --> <!-- widget content --> <div class="widget-body"> <?php $sql = "SELECT * FROM games;"; $result = $database->sqlQuery($sql); $num_games = $result->num_rows; $total_time = 0; $yellowWins = 0; $blackWins = 0; while ($row = $result->fetch_assoc()) { $total_time += intval($row['duration']); if ($row['winning_team'] == 1) { $yellowWins++; } else { $blackWins++; } } $sql1 = "SELECT * FROM goals;"; $result1 = $database->sqlQuery($sql1); $num_goals = $result1->num_rows;
<?php require_once realpath(__DIR__ . '/../') . '/httpdocs/database.php'; $database = new Database(); if (isset($_GET['game_id'])) { $gameID = $_GET['game_id']; $sql = "SELECT * FROM goals JOIN players on goals.scoring_player_id=players.id WHERE goals.game_id={$gameID}"; $result = $database->sqlQuery($sql); $myArray = array(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $myArray[] = $row; } echo json_encode($myArray); } else { echo 0; } } else { $sql = "SELECT * FROM games WHERE start IS NOT NULL AND end IS NULL"; $result = $database->sqlQuery($sql); $myArray = array(); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $myArray[] = $row; } echo json_encode($myArray); } else { echo 0; } }
public function truncate() { $this->db->sqlQuery("TRUNCATE " . Config::get("DB_PREFIX") . $this->dbTable); }