Woher weiß Google meinen Standort? Geotargeting macht's möglich!

<?php

##########################################################
$Data['input_name'] 		= "dbip-city-2016-10.csv.gz";
$Data['name_ipv4'] 			= "location_ipv4";
$Data['name_ipv6'] 			= "location_ipv6";
$Data['insert_lines_max']	= 10000;
##########################################################

create_SQL_files($Data);

// Creates two SQL files (IPv4, IPv6) out of the CSV file
function create_SQL_files($Data) {

	// Open files
	$file_gz 	= gzopen(__DIR__."/".$Data['input_name'], "r");
	$file_ipv4 	= fopen(__DIR__."/".$Data['name_ipv4'].".sql", "wb");
	$file_ipv6 	= fopen(__DIR__."/".$Data['name_ipv6'].".sql", "wb");

	$ipv4 = header_info('ipv4', $Data['name_ipv4']);
	$ipv6 = header_info('ipv6', $Data['name_ipv6']);

	$number_ipv4 	= 0;
	$number_ipv6 	= 0;
	$prev_line 		= "";
	$gz_blocks		= 1024*1024;								// Process file in 1 MB blocks (uncompressed)

	// For the whole file
	while(!gzeof($file_gz)) {
	
		$string 			= gzread($file_gz, $gz_blocks);		// Read the file in blocks
		$lines 				= explode("\n", $string);			// Extract the lines
		$number_of_lines 	= count($lines)-1;					// Determine number of lines
		$lines[0] 			= $prev_line.$lines[0];				// Add the last line of the previous iteration in front of the first line

		// For all lines
		for($i = 0; $i < $number_of_lines; $i++) {

			$values 		= explode("\"", $lines[$i]);		// Extract the values from the line
			$ip_bin 		= inet_pton($values[3]);			// Convert IP into binary value
			$ip_hex_string 	= unpack('H*', $ip_bin);			// Convert binary IP into hex string
			$ip_hex_string 	= "0x".$ip_hex_string[1];

			// If this is a IPv4 address
			if(strlen($ip_bin) == 4) {
				
				// If we need a new INSERT
				if($number_ipv4 % $Data['insert_lines_max'] == 0) $ipv4 .= ";\nINSERT INTO `".$Data['name_ipv4']."` VALUES ";
				// If we don't need a new INSERT
				else $ipv4 .= ",";
				
				$ipv4 .= "(".$ip_hex_string.",\"".htmlspecialchars($values[5])."\",\"".htmlspecialchars($values[7])."\",\"".htmlspecialchars($values[9])."\")";
				$number_ipv4++;			
				
			}
			
			// If this is a IPv6 address
			else {
				
				// If we need a new INSERT
				if($number_ipv6 % $Data['insert_lines_max'] == 0) $ipv6 .= ";\nINSERT INTO `".$Data['name_ipv6']."` VALUES ";
				// If we don't need a new INSERT
				else $ipv6 .= ",";
				
				$ipv6 .= "(".$ip_hex_string.",\"".htmlspecialchars($values[5])."\",\"".htmlspecialchars($values[7])."\",\"".htmlspecialchars($values[9])."\")";
				$number_ipv6++;

			}		
		
		}
		$prev_line = $lines[$i];
		
		// Write data into file
		fwrite($file_ipv4, $ipv4, strlen($ipv4));
		fwrite($file_ipv6, $ipv6, strlen($ipv6));
		$ipv4 = "";
		$ipv6 = "";

	}

	$ipv4 = footer_info($Data['name_ipv4']);
	$ipv6 = footer_info($Data['name_ipv6']);

	// Write data into files
	fwrite($file_ipv4, $ipv4, strlen($ipv4));
	fwrite($file_ipv6, $ipv6, strlen($ipv6));

	// Close files
	fclose($file_gz);
	gzclose($file_ipv4);
	gzclose($file_ipv6);

	print("Done!");
	print("<br>Number of entries: ".($number_ipv4+$number_ipv6));
	print("<br>Number of IPv4 entries: ".$number_ipv4);
	print("<br>Number of IPv6 entries: ". $number_ipv6);

}

// Print the header information of the SQL file
function header_info($type, $name) {
	
	$type = $type == "ipv4";
	
	return 
"/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

DROP TABLE IF EXISTS `".$name."`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `".$name."` (
  `ip_end` binary(".($type ? 4 : 16).") NOT NULL,
  `country` char(2) COLLATE utf8_unicode_ci NOT NULL,
  `stateprov` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  `city` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`ip_end`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
LOCK TABLES `".$name."` WRITE;
/*!40000 ALTER TABLE `".$name."` DISABLE KEYS */";
	
}

// Print the footer information of the SQL file
function footer_info($name) {
	
	return ";
/*!40000 ALTER TABLE `".$name."` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;";
	
}

?>