<?php
$server = "";
$username = "";
$password = "";
$database = "";
mysql_connect($server,$username,$password) or die("Failed");
mysql_select_db($database) or die("Database Failed");

$url = "";
$string = file_get_contents($url);
var_dump($string);
$arr = json_decode($string, true);
var_dump($arr);

foreach($arr as $data){
  echo("Foreach Loop\n");
  var_dump($data);
  $clusterkey = isset($data['ClusterKey']) ? $data['ClusterKey'] : '';
  $steamid = isset($data['SteamId']) ? $data['SteamId'] : '';
  $charactername = isset($data['CharacterName']) ? $data['CharacterName'] : '';
  $gender = isset($data['Gender']) ? $data['Gender'] : '';
  $tribename = isset($data['TribeName']) ? $data['TribeName'] : '';
  $tribeid = isset($data['TribeId']) ? $data['TribeId'] : '';
  $level = isset($data['Level']) ? $data['Level'] : '';
  $engrampoints = isset($data['EngramPoints']) ? $data['EngramPoints'] : '';
  $latitude = isset($data['Longitude']) ? $data['Latitude'] : '';
  $longitude = isset($data['Longitude']) ? $data['Longitude'] : '';
  $topomapx = isset($data['TopoMapX']) ? $data['TopoMapX'] : '';
  $topomapy = isset($data['TopoMapY']) ? $data['TopoMapY'] : '';
  $savedat = isset($data['SavedAt']) ? $data['SavedAt'] : '';

  $sql = "INSERT INTO players(clusterkey, steamid, charactername, gender, tribename, tribeid, level, engrampoints, latitude, longitude, topomapx, topomapy, savedat)
VALUES('$clusterkey', '$steamid', '$charactername', '$gender', '$tribename', '$tribeid', '$level', '$engrampoints', '$latitude', '$longitude', '$topomapx', '$topomapy', '$savedat');";

  echo("SQL String\n");
  echo($sql."\n");

  if(!mysql_query($sql)){
    die('Error : ' . mysql_error());
  }
}
?>