function getBattleGrounds($day, $month, $year, $level_cond, $type_cond, $limit) { global $db, $date_format, $time_format, $ALLIANCE, $HORDE, $alliance_color, $horde_color, $none_color; if ($year != "") { $year_cond = sprintf("YEAR(date) = '%s'", $year); } else { die("Function getBattleGrounds() called passing year = null"); } if ($month != "" && $month != 0) { $month_cond = sprintf("AND MONTH(date) = '%s'", $month); } else { $month_cond = ""; } if ($day != "") { $day_cond = sprintf("AND DAY(date) = '%s'", $day); } else { $day_cond = ""; } if ($level_cond != "") { $level_cond = "AND " . $level_cond; } else { $level_cond = ""; } if ($type_cond != "") { $type_cond = "AND " . $type_cond; } else { $type_cond = ""; } $query = sprintf("SELECT * FROM pvpstats_battlegrounds WHERE %s %s %s %s %s ORDER BY date DESC LIMIT 0, %d;", $year_cond, $month_cond, $day_cond, $level_cond, $type_cond, $limit); $result = $db->query($query); if (!$result) { die("Error querying: " . $query); } while (($row = $result->fetch_array()) != null) { $datetime = new DateTime($row['date']); $date = $datetime->format($date_format); $time = $datetime->format($time_format); if ($row['winner_faction'] == $ALLIANCE) { $color = $alliance_color; } else { if ($row['winner_faction'] == $HORDE) { $color = $horde_color; } else { $color = $none_color; } } printf("<tr style=\"color: %s; font-weight: bold;\" class=\"hover-pointer\" onClick=\"location.href='battleground.php?id=%s'\"><td>%s</td><td>%s</td><td>%s</td><td>%s</td><td>%s</td></tr></a>", $color, $row['id'], $row['id'], getBattleGroundTypeName($row['type']), getLevelRangeByBracketId($row['bracket_id']), $date, $time); } }
require_once "factionScores.php"; if (isset($_GET['id']) && is_numeric($_GET['id'])) { $id = $_GET['id']; $query = sprintf("SELECT * FROM pvpstats_battlegrounds WHERE id = %d", $id); $result = $db->query($query); if (!$result) { die("Error querying: " . $query); } else { if ($result->num_rows > 0) { $row = $result->fetch_array(); $type = $row['type']; $winner_faction = $row['winner_faction']; $bracket_id = $row['bracket_id']; $datetime = new DateTime($row['date']); $bracket_level_range = getLevelRangeByBracketId($bracket_id); $type_name = getBattleGroundTypeName($type); $date = $datetime->format($date_format); $time = $datetime->format($time_format); $month = $datetime->format('M'); $year = $datetime->format('Y'); $month_and_year = $month . " " . $year; $this_day_condition = "DATE(date) = DATE('" . $row['date'] . "')"; $this_month_condition = "MONTH(date) = MONTH('" . $row['date'] . "') AND YEAR(date) = YEAR('" . $row['date'] . "')"; $this_level_condition = "bracket_id = " . $bracket_id; $score_this_day = getFactionScores($this_day_condition, $this_level_condition, ""); $score_this_month = getFactionScores($this_month_condition, $this_level_condition, ""); $alliance_today = $score_today[0]; $horde_today = $score_today[1]; $alliance_this_day = $score_this_day[0]; $horde_this_day = $score_this_day[1]; $alliance_this_month = $score_this_month[0];