public static function findByIp(xPDO $xpdo, $ip = 'auto'){ if(!$c = self::newQuery($xpdo, $ip)){ return false; } $c->leftJoin('GeoipLocation', 'Location'); $c->leftJoin('GeoipCountry', 'Country'); $c->select(array( "Country.*", "Location.*", "Geoip.*", "ip_end-ip_start as distance", )); $c->sortby('distance'); $c->limit(1); return $xpdo->getObject("Geoip", $c); }