<?php
//$message_text = mysqli_real_escape_string($con,$message_text);
include('db.php');
session_start();
$status = $_GET['status'];

//////////////////////////////////////////////////////////

$user_ip = getenv('REMOTE_ADDR');
$geo = unserialize(file_get_contents("http://www.geoplugin.net/php.gp?ip=$user_ip"));
$city = $geo["geoplugin_city"];
$country = $geo["geoplugin_countryName"];
//echo" mmm $user_ip";

///////////////////////////////////////////////////////////////////////////////////////

if($status =='insert_app_download_count')
{
	$app_id = $_GET['app_id'];
	$insert_app_download_count ="insert into app_down_count(app_id,user_id,user_ip,country,city,date,time)
	values ('$app_id','101','$user_ip','$country','$city',CURDATE(),CURTIME() )";
	$run_insert_comment = mysqli_query($con,$insert_app_download_count);
}


/////////////////////////////////////////////////////////////////////////////////////

if($status =='insert_user_count')
{
	$insert_user_count ="insert into user_counttb(user_ip,user_id,country,city,date,time)
	values ('$user_ip','102','$country','$city',CURDATE(),CURTIME() )";
	$run_insert_user_count = mysqli_query($con,$insert_user_count);
}


?>