<?php
 
	// This class adds referer and google searchword to session (for using in powermail later)
	class user_googlesession {
 
		var $allow = array(1,1,1); // enable or disable the infos (1. Searchword, 2. Referer, 3. IP Address)
		var $sesprefix = 'wt_googlesession'; // prefix for session
		var $finalarray = array(); // empty array for session
		var $test = 0; // testmode (show google searchword)
 
 
		// Main function for additional google information
		function user_main($content='', $conf=array()) {
			$this->makeSession();
			if ($this->test === 1) return $this->user_test();
		}
 
 
		// Function to generate the session
		function makeSession() {
			$foo = $this->infoArray(); // Array with information about user
			if (count($foo) > 0 && $foo) { // if array is not empty
				$GLOBALS['TSFE']->fe_user->setKey("ses", $this->sesprefix, $this->infoArray()); // Generate Session with array
				$GLOBALS['TSFE']->storeSessionData(); // Save session
			}
		}
 
 
		// Function infoArray() generates array with needed stuff for session
		function infoArray() {
			$url = parse_url(htmlentities($_SERVER['HTTP_REFERER'])); // every part of the referer in an own array
			if(isset($url['query'])) { // if GET params is set
				preg_match("/q=(.*?)(&amp;|^)/", $url['query'], $output); // give me only the &q="searchword" part
 
				if ($output[1]) { // only if GET param &q= was set
					if ($this->allow[0]) $this->finalarray['searchword'] = urldecode($output[1]); // 1. searchword
					if ($this->allow[1]) $this->finalarray['referer'] = $_SERVER['HTTP_REFERER']; // 2. referer
				}
				if ($this->allow[2]) $this->finalarray['ip'] = $_SERVER['REMOTE_ADDR']; // 3. IP address
			} 
 
			// return whole array
			if (!empty($this->finalarray)) return $this->finalarray; // return info array
		}
 
		function user_test($content='', $conf=array()) {
			$content = 'Sessionentry: ';
			$content .= print_r($GLOBALS['TSFE']->fe_user->sesData[$this->sesprefix]['searchword'], 1);
			if (!empty($content)) return $content;
		}
 
	}
 
?>

includeLibs.user_googlesession = fileadmin/user_googlesession.php
 
page.100 = USER
page.100.userFunc = user_googlesession->user_main

plugin.tx_powermail_pi1 {
	prefill {
		uid26 = TEXT
		uid26.data = TSFE:fe_user|sesData|wt_googlesession|searchword
		uid27 = TEXT
		uid27.data = TSFE:fe_user|sesData|wt_googlesession|referer
		uid28 = TEXT
		uid28.data = TSFE:fe_user|sesData|wt_googlesession|ip
	}
}

plugin.tx_powermail_pi1.dynamicTyposcript {
    ai = COA
    ai.wrap = <hr />|
    ai {
    	# Current page
        10 = COA
        10.wrap = <b>conject page:</b>&nbsp;|
        10.10 = TEXT
        10.10.typolink.parameter.data = TSFE:id
        10.10.typolink.returnLast = url
        10.10.wrap = <a href="http://www.conject.com/|">
        10.20 = TEXT
        10.20.data = page:title
        10.20.wrap = |</a>
 
    	# Current language
        20 = COA       
        20.wrap = <b>Preferred language:</b>&nbsp;|
        20.10 = CASE
        20.10.key.data = GPvar:L 
        20.10.default = TEXT
        20.10.default.value = EN
        20.10.1 = TEXT
        20.10.1.value = DE
        20.10.4 = TEXT
        20.10.4.value = RU
        20.10.5 = TEXT
        20.10.5.value = ME
 
    	# Geoinfo City
        30 = COA
        30.10 = USER
        30.10.userFunc = user_pmgeoinfo->city
        30.wrap = <b>City:</b>&nbsp;|
 
        # Geoinfo Country
        40 = COA
        40.10 = USER
        40.10.userFunc = user_pmgeoinfo->country
        40.wrap = <b>Country:</b>&nbsp;|
 
    	# Google Searchword if any
        50 = TEXT
        50.data = TSFE:fe_user|sesData|wt_googlesession|searchword
        50.wrap = <b>Google searchword:</b>&nbsp;|
 
    	# Referer if any
        60 = TEXT
        60.data = TSFE:fe_user|sesData|wt_referersession
        60.wrap = <b>Referer:</b>&nbsp;|
 
    	# Googleaddwords code
        70 = TEXT
        70.data = TSFE:fe_user|sesData|wt_googleaddscode
        70.wrap = <b>Google adwords code:</b>&nbsp;|
 
        # IP address
        100 = TEXT
        100.data = getIndpEnv:REMOTE_ADDR
        100.wrap = <b>IP Address:</b>&nbsp;|
    }
}

<?php
 
	class user_pmgeoinfo {
 
		var $geoDBpath = 'fileadmin/conject/administration/scripts/GeoLiteCity.dat'; // path to geoip database
		var $ip = ''; // test some ip addresses (e.g. DEU: 83.236.183.130, UAE: 195.229.237.36, UAE: 87.200.131.139, RUS: 89.113.208.15)
 
		// Get country
		function country($content='', $conf=array()) {
			$this->geoInfo(); // init geoip
			if (!empty($this->GEOinfos['countryName'])) return $this->GEOinfos['countryName'];
		}
 
		// Get country ISO code
		function countryISO($content='', $conf=array()) {
			$this->geoInfo(); // init geoip
			$this->GEOinfos['countryCode'] = $this->changeISO_3_2($this->GEOinfos['countryCode']); // changes ISO code from 3 to 2
 
			if (!empty($this->GEOinfos['countryCode'])) return $this->GEOinfos['countryCode'];
		}
 
		// Get city
		function city($content='', $conf=array()) {
			$this->geoInfo(); // init geoip
			if (!empty($this->GEOinfos['city'])) return $this->GEOinfos['city'];
		}
 
		// Get zipFromCity (Extension zip_distance neeeded)
		function zipFromCity($content='', $conf=array()) {
			// config
			global $TSFE;
    		$this->cObj = $TSFE->cObj; // cObject
			$city = $this->cObj->cObjGetSingle($conf['userFunc.']['city'], $conf['userFunc.']['city.']); // get city from typoscript
			if (empty($city)) { // no city defined in typoscript
				$this->geoInfo(); // init geoip
				$city = $this->GEOinfos['city']; // Get city from geoinfo
			}
 
			// Let's go
			if (!empty($city)) { // only if city was given
				if (t3lib_extMgm::isLoaded('zip_distance')) { // if zip_distance is loaded
 
					$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery (
						'zip',
						'tx_zipdistance',
						'city = "'.$city.'"',
						'',
						'',
						'1'
					);
					$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
					if (!empty($row['zip'])) {
						$zip = ($conf['userFunc.']['cutAfter'] > 0 ? substr($row['zip'], 0, $conf['userFunc.']['cutAfter']).$conf['userFunc.']['fillWith'].$conf['userFunc.']['fillWith'].$conf['userFunc.']['fillWith'] : $row['zip']);
						return $zip;
					}
 
				} else die ('zip_distance not loaded!');
			} else return false; // no city given
		}
 
		// Debut output with all available information
		function giveMeAll($content='', $conf=array()) {
			if (!empty($conf['userFunc.']['ip'])) $this->ip = $conf['userFunc.']['ip']; // set ip from typoscript
			$this->geoInfo(); // init geoip
 
			t3lib_div::debug($this->GEOinfos);
		}
 
		#######
 
		// use geo ip if loaded
		function geoInfo() {
			if (t3lib_extMgm::isLoaded('geoip')) {
				require_once(t3lib_extMgm::extPath('geoip').'/pi1/class.tx_geoip_pi1.php');
				$this->media = t3lib_div::makeInstance('tx_geoip_pi1');
				$this->media->init($this->geoDBpath); // Initialize the Geoip Ext
				$this->GEOinfos = $this->media->getGeoIP(($this->ip ? $this->ip : t3lib_div::getIndpEnv('REMOTE_ADDR'))); // get all the infos
			} else die('geoip not loaded!');
		}
 
		// function changeISO_3_2 changes country with ISO code 3 to ISO code 2 (DEU => DE, AUT => AT)
		function changeISO_3_2($country) {
			if (t3lib_extMgm::isLoaded('static_info_tables', 0)) { // if ext static_info_tables is loaded
 
				$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery (
					'cn_iso_2',
					'static_countries',
					'cn_iso_3 = "'.$country.'"',
					'',
					'',
					'1'
				);
				$row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res);
 
				if (!empty($row['cn_iso_2'])) return $row['cn_iso_2'];
			} else die ('static_info_tables not loaded!');
		}
 
	}
 
?>