Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $json = file_get_contents('https://servers-live.fivem.net/api/servers/');
- $data = json_decode($json, true);
- for ($i = 0; $i < sizeof($data); $i++)
- {
- $ip = $data[$i]['EndPoint'];
- $resources = $data[$i]['Data']['resources'];
- }
- $stmt = $dbh->prepare("INSERT INTO resources (ip, resource) VALUES ('". $ip . "','" . $resources ."')");
- if ($stmt->execute())
- {
- echo 'done';
- }
- //################SDSAADDD
- $values = [];
- $values1 = [];
- $values2 = [];
- for ($i = 0; $i < sizeof($data); $i++)
- {
- $resources = $data[$i]['Data']['resources'];
- $ip = $data[$i]['EndPoint'];
- for ($j = 0; $j < sizeof($resources); $j++)
- {
- $resource = $resources[$j];
- $add = "('" . $ip . "','" . $resource ."')";
- if ( sizeof($values) < 20000 )
- {
- array_push($values, $add);
- }
- else
- {
- if ( sizeof($values1) < 40000)
- {
- array_push($values1, $add);
- }
- else
- {
- array_push($values2, $add);
- }
- }
- }
- }
- $stmt = $dbh->prepare("INSERT INTO resources (ip, resource) VALUES ". implode(", ", $values) ."");
- if ($stmt->execute())
- {
- $values = null;
- $stmt = $dbh->prepare("INSERT INTO resources (ip, resource) VALUES ". implode(", ", $values1) ."");
- if ($stmt->execute())
- {
- $values1 = null;
- $stmt = $dbh->prepare("INSERT INTO resources (ip, resource) VALUES ". implode(", ", $values2) ."");
- if ($stmt->execute())
- {
- $values2 = null;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement