~lss-team/lilsoftstats/trunk

<?php

        require_once("DBManager.class.php");

        

        function get_location($ip) {

                $content = @file_get_contents('http://api.hostip.info/?ip='.$ip);

                if ($content != FALSE) {

                        $xml = new SimpleXmlElement($content);

                        $coordinates = $xml->children('gml', TRUE)->featureMember->children('', TRUE)->Hostip->ipLocation->children('gml', TRUE)->pointProperty->Point->coordinates;

                        $longlat = explode(',', $coordinates);

                        $location['longitude'] = $longlat[0];

                        $location['latitude'] = $longlat[1];            

                        $location['citystate'] = '==>'.$xml->children('gml', TRUE)->featureMember->children('', TRUE)->Hostip->children('gml', TRUE)->name;

                        $location['country'] =  '==>'.$xml->children('gml', TRUE)->featureMember->children('', TRUE)->Hostip->countryName;

                        return $location;

                }

                else return false;

        }

        

        $dbManager = new DBManager();

        

        // Get product id

        if (array_key_exists('prodID', $_REQUEST))

                $prodID = mysql_real_escape_string($_REQUEST['prodID']); // prevent SQL injection

        else 

                $prodID = "Unknown";

        

        // Get version

        if (array_key_exists('version', $_REQUEST))

                $ver = mysql_real_escape_string($_REQUEST['version']); // prevent SQL injection

        else 

                $ver = "Unknown";

 

        // Get the ip address

        $ip = $_SERVER['REMOTE_ADDR'];

 

        // Get tbe country

        $location = get_location($ip);

        

        $country = (($location != false)?($location['country']):('Unknown'));

        $long = $location['longitude'];

        $lat = $location['latitude'];

        

        // If ip is private -> die

        if ($country == '(Private Address)')

                die();

                

        // If product ID doesnt exist -> die

        $dbManager->executeQuery("SELECT * FROM stats_products WHERE prodID = '$prodID'");

        if ($dbManager->getSelectedRows() == 0)

                die();

                

        // Add country to list (if not already listed)

        $dbManager->executeQuery("INSERT INTO stats_countries (country) VALUES('$country')");

                

        // Add version to list (if not already listed)

        $dbManager->executeQuery("INSERT INTO stats_versions (prodID, version) VALUES('$prodID', '$version')");

                

        // Update table

        $dbManager->executeQuery("INSERT INTO stats_log (datetime, version, country, ip, longitude, latitude) VALUES (NOW(), '$ver', '$country', '$ip', '$long', '$lat')");

?>