Exemple #1
0
 function getIp()
 {
     if (isset($this->details['location_ip'])) {
         return Piwik_IP::N2P($this->details['location_ip']);
     }
     return false;
 }
 /**
  * Logs the IntranetSubNetwork in the log_visit table
  */
 public function logIntranetSubNetworkInfo($notification)
 {
     $visitorInfo =& $notification->getNotificationObject();
     $ip = Piwik_IP::N2P($visitorInfo['location_ip']);
     // by default, we want the network name to be the IP address:
     $networkName = $ip;
     /**
      *********************************************************************************************
      ****************** adopt the following lines according to your subnets **********************
      **/
     // Some default subnets:
     if (Piwik_IP::isIpInRange($visitorInfo['location_ip'], array('0.0.0.0/0'))) {
         $networkName = 'Global IPv4';
     }
     // all IPv4 addresses
     if (Piwik_IP::isIpInRange($visitorInfo['location_ip'], array('::/0'))) {
         $networkName = 'Global IPv6';
     }
     // IPv6 addresses
     if (Piwik_IP::isIpInRange($visitorInfo['location_ip'], array('::ffff:0:0/96'))) {
         $networkName = 'Global IPv4';
     }
     // IPv4 mapped IPv6 addresses
     // You may include your custom subnets:
     //if (Piwik_IP::isIpInRange($visitorInfo['location_ip'], array('141.2.0.0/16')))	     { $networkName = 'University Frankfurt'; }
     //if (Piwik_IP::isIpInRange($visitorInfo['location_ip'], array('192.0.2.0/24')))	     { $networkName = 'TEST-NET'; }
     //if (Piwik_IP::isIpInRange($visitorInfo['location_ip'], array('198.51.100.0/24')))	  { $networkName = 'TEST-NET-2'; }
     //if (Piwik_IP::isIpInRange($visitorInfo['location_ip'], array('2001:db8::/33',
     //	                                                           '2001:db8:8000::/33'))) { $networkName = 'Doc-IPv6'; }
     /**
      ******************* end adopt here to your subnets	*****************************************
      *********************************************************************************************
      **/
     // add the IntranetSubNetwork value in the table log_visit
     $visitorInfo['location_IntranetSubNetwork'] = substr($networkName, 0, 100);
 }
Exemple #3
0
 /**
  * Logs the provider in the log_visit table
  */
 public function logProviderInfo($notification)
 {
     $visitorInfo =& $notification->getNotificationObject();
     $ip = Piwik_IP::N2P($visitorInfo['location_ip']);
     // In case the IP was anonymized, we should not continue since the DNS reverse lookup will fail and this will slow down tracking
     if (substr($ip, -2, 2) == '.0') {
         printDebug("IP Was anonymized so we skip the Provider DNS reverse lookup...");
         return;
     }
     $hostname = $this->getHost($ip);
     $hostnameExtension = $this->getCleanHostname($hostname);
     // add the provider value in the table log_visit
     $visitorInfo['location_provider'] = $hostnameExtension;
     $visitorInfo['location_provider'] = substr($visitorInfo['location_provider'], 0, 100);
     // improve the country using the provider extension if valid
     $hostnameDomain = substr($hostnameExtension, 1 + strrpos($hostnameExtension, '.'));
     if ($hostnameDomain == 'uk') {
         $hostnameDomain = 'gb';
     }
     if (array_key_exists($hostnameDomain, Piwik_Common::getCountriesList())) {
         $visitorInfo['location_country'] = $hostnameDomain;
     }
 }
	/**
	 * Returns the hostname given the internal representation of the
	 * IP address
	 *
	 * @param string $ip Internal representation of IP address in binary-safe string
	 * @return string hostname (or human-readable IP address)
	 */
	private function getHost($ip)
	{
		return trim(strtolower(@Piwik_IP::getHostByAddr(Piwik_IP::N2P($ip))));
	}
Exemple #5
0
	/**
	 * Get the start and end IP addresses for an IP address range
	 *
	 * @param string $ipRange IP address range in presentation format
	 * @return array|false Array( low, high ) IP addresses in presentation format; or false if error
	 */
	public function getIpsForRange($ipRange)
	{
		$range = Piwik_IP::getIpsForRange($ipRange);
		if($range === false)
		{
			return false;
		}

		return array( Piwik_IP::N2P($range[0]), Piwik_IP::N2P($range[1]) );
	}
Exemple #6
0
 /**
  * @group Core
  * @group IP
  * @dataProvider getIpsInRangeData
  */
 public function testIsIpInRange($range, $test)
 {
     foreach ($test as $ip => $expected) {
         // range as a string
         $this->assertEquals($expected, Piwik_IP::isIpInRange(Piwik_IP::P2N($ip), array($range)), "{$ip} in {$range}");
         // range as an array(low, high)
         $aRange = Piwik_IP::getIpsForRange($range);
         $aRange[0] = Piwik_IP::N2P($aRange[0]);
         $aRange[1] = Piwik_IP::N2P($aRange[1]);
         $this->assertEquals($expected, Piwik_IP::isIpInRange(Piwik_IP::P2N($ip), array($aRange)), "{$ip} in {$range}");
     }
 }
Exemple #7
0
 function test_isIpInRange()
 {
     $tests = array('192.168.1.10' => array('192.168.1.9' => false, '192.168.1.10' => true, '192.168.1.11' => false, '::ffff:192.168.1.10' => false), '::ffff:192.168.1.10' => array('::ffff:192.168.1.9' => false, '::ffff:192.168.1.10' => true, '::ffff:c0a8:010a' => true, '0000:0000:0000:0000:0000:ffff:c0a8:010a' => true, '::ffff:192.168.1.11' => false, '192.168.1.10' => false), '192.168.1.10/32' => array('192.168.1.9' => false, '192.168.1.10' => true, '192.168.1.11' => false), '192.168.1.10/31' => array('192.168.1.9' => false, '192.168.1.10' => true, '192.168.1.11' => true, '192.168.1.12' => false), '192.168.1.128/25' => array('192.168.1.127' => false, '192.168.1.128' => true, '192.168.1.255' => true, '192.168.2.0' => false), '192.168.1.10/24' => array('192.168.0.255' => false, '192.168.1.0' => true, '192.168.1.1' => true, '192.168.1.2' => true, '192.168.1.3' => true, '192.168.1.4' => true, '192.168.1.7' => true, '192.168.1.8' => true, '192.168.1.15' => true, '192.168.1.16' => true, '192.168.1.31' => true, '192.168.1.32' => true, '192.168.1.63' => true, '192.168.1.64' => true, '192.168.1.127' => true, '192.168.1.128' => true, '192.168.1.255' => true, '192.168.2.0' => false), '192.168.1.*' => array('192.168.0.255' => false, '192.168.1.0' => true, '192.168.1.1' => true, '192.168.1.2' => true, '192.168.1.3' => true, '192.168.1.4' => true, '192.168.1.7' => true, '192.168.1.8' => true, '192.168.1.15' => true, '192.168.1.16' => true, '192.168.1.31' => true, '192.168.1.32' => true, '192.168.1.63' => true, '192.168.1.64' => true, '192.168.1.127' => true, '192.168.1.128' => true, '192.168.1.255' => true, '192.168.2.0' => false));
     // testing with a single range
     foreach ($tests as $range => $test) {
         foreach ($test as $ip => $expected) {
             // range as a string
             $this->assertEqual(Piwik_IP::isIpInRange(Piwik_IP::P2N($ip), array($range)), $expected, "{$ip} in {$range}");
             // range as an array(low, high)
             $aRange = Piwik_IP::getIpsForRange($range);
             $aRange[0] = Piwik_IP::N2P($aRange[0]);
             $aRange[1] = Piwik_IP::N2P($aRange[1]);
             $this->assertEqual(Piwik_IP::isIpInRange(Piwik_IP::P2N($ip), array($aRange)), $expected, "{$ip} in {$range}");
         }
     }
 }
 $rows = Piwik_FetchAll("SELECT idvisit, location_ip, " . implode(',', array_keys($logVisitFieldsToUpdate)) . "\n\t\t\t\t\t\tFROM " . Piwik_Common::prefixTable('log_visit') . " \n\t\t\t\t\t\tLIMIT {$start}, {$limit}");
 if (!count($rows)) {
     continue;
 }
 foreach ($rows as $i => $row) {
     $fieldsToSet = array();
     foreach ($logVisitFieldsToUpdate as $field => $ignore) {
         if (empty($fieldsToSet[$field])) {
             $fieldsToSet[] = $field;
         }
     }
     // skip if it already has a location
     if (empty($fieldsToSet)) {
         continue;
     }
     $ip = Piwik_IP::N2P($row['location_ip']);
     $location = $provider->getLocation(array('ip' => $ip));
     if (!empty($location[Piwik_UserCountry_LocationProvider::COUNTRY_CODE_KEY])) {
         $location[Piwik_UserCountry_LocationProvider::COUNTRY_CODE_KEY] = strtolower($location[Piwik_UserCountry_LocationProvider::COUNTRY_CODE_KEY]);
     }
     $row['location_country'] = strtolower($row['location_country']);
     $columnsToSet = array();
     $bind = array();
     foreach ($logVisitFieldsToUpdate as $column => $locationKey) {
         if (!empty($location[$locationKey]) && $location[$locationKey] != $row[$column]) {
             $columnsToSet[] = $column . ' = ?';
             $bind[] = $location[$locationKey];
         }
     }
     if (empty($columnsToSet)) {
         continue;
Exemple #9
0
 /**
  * Checks if the visitor ip is in the excluded list
  *
  * @param string $ip Long IP
  * @return bool
  */
 protected function isVisitorIpExcluded($ip)
 {
     $websiteAttributes = Piwik_Common::getCacheWebsiteAttributes($this->idsite);
     if (!empty($websiteAttributes['excluded_ips'])) {
         if (Piwik_IP::isIpInRange($ip, $websiteAttributes['excluded_ips'])) {
             printDebug('Visitor IP ' . Piwik_IP::N2P($ip) . ' is excluded from being tracked');
             return true;
         }
     }
     return false;
 }