Example #1
0
				<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">
Example #2
0
				<!-- 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;
    }
}
Example #4
0
 public function truncate()
 {
     $this->db->sqlQuery("TRUNCATE " . Config::get("DB_PREFIX") . $this->dbTable);
 }