Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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());
- }
- }
- ?>
Add Comment
Please, Sign In to add comment