require_once "head.php";
if (isset($_POST['accion'])) {
//Crear nuevo link
if (strtolower($_POST['accion']) == 'crear') {
$enlace = filter_var($_POST['enlace'], FILTER_SANITIZE_URL);
$descripcion = filter_var($_POST['descripcion'], FILTER_SANITIZE_STRING);
if (!empty($enlace) && !empty($descripcion)) {
$link = new Link();
$link->crear($enlace, $descripcion);
//debug($link);
$id_new_link = $link->dbsave();
if (!empty($id_new_link)) {
$insert = "INSERT INTO user_link VALUES(0, " . $_SESSION['idusuario'] . ", " . $id_new_link . ")";
$db = new ConexionBd();
$db->execute($insert);
header("Location: index.php");
} else {
echo "Error al crear el enlace";
}
}
}
//Guardar link despues de editar
if (strtolower($_POST['accion']) == 'doedit') {
$id_link = filter_var($_POST['id_link'], FILTER_SANITIZE_URL);
$enlace = filter_var($_POST['enlace'], FILTER_SANITIZE_URL);
$descripcion = filter_var($_POST['descripcion'], FILTER_SANITIZE_STRING);
$link = new Link($_GET['id_link']);
$link->setDescription($descripcion);
$link->setUrl($enlace);
$link->dbsave();
public function countClick()
{
$client_ip = $_SERVER['REMOTE_ADDR'];
$client_user_agent = $_SERVER['HTTP_USER_AGENT'];
if (isset($_SERVER['HTTP_REFERER'])) {
$referer_page = $_SERVER['HTTP_REFERER'];
} else {
$referer_page = "";
}
$ua = getBrowser($client_user_agent);
$geoloc = json_decode(peticion("freegeoip.net/json/" . $client_ip));
$insert = "INSERT INTO clicks VALUES(\n 0,\n " . $this->id . ",\n '" . date("Y-m-d H:i:s") . "',\n '" . $referer_page . "',\n '" . $client_user_agent . "',\n '" . $client_ip . "',\n '" . $ua['name'] . " v" . $ua['version'] . "',\n '" . $ua['platform'] . "',\n '" . $geoloc->country_name . ", " . $geoloc->country_code . "',\n '" . $geoloc->region_name . ", " . $geoloc->region_code . "',\n '" . $geoloc->city . "',\n '" . $geoloc->zip_code . "',\n '" . $geoloc->latitude . "/" . $geoloc->longitude . "'\n )";
$db = new ConexionBd();
$db->execute($insert);
}
