Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.65 KB | None | 0 0
  1. $json = file_get_contents('https://servers-live.fivem.net/api/servers/');
  2. $data = json_decode($json, true);
  3.  
  4. for ($i = 0; $i < sizeof($data); $i++)
  5. {
  6.     $ip        = $data[$i]['EndPoint'];
  7.     $resources = $data[$i]['Data']['resources'];
  8. }
  9.  
  10. $stmt = $dbh->prepare("INSERT INTO resources (ip, resource) VALUES ('". $ip . "','" . $resources ."')");
  11.  
  12. if ($stmt->execute())
  13. {
  14.    echo 'done';
  15. }
  16.  
  17. //################SDSAADDD
  18.  
  19. $values = [];
  20. $values1 = [];
  21. $values2 = [];
  22.  
  23. for ($i = 0; $i < sizeof($data); $i++)
  24. {
  25.     $resources = $data[$i]['Data']['resources'];
  26.     $ip        = $data[$i]['EndPoint'];
  27.    
  28.     for ($j = 0; $j < sizeof($resources); $j++)
  29.     {
  30.         $resource = $resources[$j];
  31.        
  32.         $add = "('" . $ip  . "','" . $resource ."')";
  33.        
  34.         if ( sizeof($values) < 20000 )
  35.         {
  36.             array_push($values, $add);
  37.         }
  38.         else
  39.         {
  40.             if ( sizeof($values1) < 40000)
  41.             {
  42.                 array_push($values1, $add);
  43.             }
  44.             else
  45.             {
  46.                 array_push($values2, $add);
  47.             }
  48.         }
  49.     }
  50. }
  51.  
  52. $stmt = $dbh->prepare("INSERT INTO resources (ip, resource) VALUES ". implode(", ", $values) ."");
  53.  
  54. if ($stmt->execute())
  55. {
  56.     $values = null;
  57.     $stmt = $dbh->prepare("INSERT INTO resources (ip, resource) VALUES ". implode(", ", $values1) ."");
  58.    
  59.     if ($stmt->execute())
  60.     {
  61.         $values1 = null;
  62.         $stmt = $dbh->prepare("INSERT INTO resources (ip, resource) VALUES ". implode(", ", $values2) ."");
  63.    
  64.         if ($stmt->execute())
  65.         {
  66.             $values2 = null;
  67.         }
  68.     }
  69. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement