$file_contents = file_get_contents($file); $data = array("stats" => array("defenses" => json_decode($file_contents, 1))); $team_stats = array(); foreach ($data["stats"] as $stat => $teams) { if (is_string($teams)) { $teams = json_decode($teams, 1); } foreach ($teams as $team_number => $stats) { if (!isset($team_stats[$team_number])) { $team_stats[$team_number] = array(); } $team_stats[$team_number][$stat] = $stats; } } $json_fields = array("questions", "stats"); foreach ($team_stats as $team_number => $stats) { $existing = $sdb->getItem("team", array("team_number" => $team_number), array("id", "stats_json")); if ($existing["id"] > 0) { $sdb->updateTeam($team_number, array_merge($existing, array("stats" => $stats))); } else { $tba_team = $tba->get("team/frc{$team_number}"); $data = array_merge($default_fields, $tba_team, array("team_number" => $team_number, "team_name" => $tba_team["nickname"], "stats" => $stats)); foreach ($json_fields as $field) { if (isset($data[$field])) { $data["{$field}_json"] = json_encode($data[$field]); } } $sdb->addTeam($data); } } die(print_r($team_stats));
if (isset($post[$field])) { if (strlen(trim($post[$field]))) { $team_data[$field] = trim($post[$field]); } else { $errors[] = array("field" => $field, "msg" => "{$label} can't be blank"); $success = false; } } } foreach ($other_fields as $field) { if (isset($post[$field])) { $team_data[$field] = trim($post[$field]); } } if ($success) { $existing = $sdb->getItem("team", array("team_number" => $data["teamID"])); if (!count($existing)) { $success = false; $errors[] = array("field" => "team_number", "msg" => "Team #{$data["teamID"]} doesn't exist!"); } } if ($success) { $data = $sdb->updateTeam($data["teamID"], $team_data); if (!isset($data["id"]) || !$data["id"] && !$data["error"]) { $success = false; $data = array(); $errors[] = "Database error"; } } } $output = array("data" => $data, "error" => $errors, "success" => $success);