<?php error_reporting(E_ALL); ini_set('display_errors', '1'); set_time_limit(0); //include "../includes/functions.php"; include "includes/db.php"; require_once "Objects/FunctionClass.php"; $username = isset($_GET['username']) ? $_GET['username'] : ""; $password = isset($_GET['password']) ? $_GET['password'] : ""; $ads_id = isset($_GET['ads_id']) ? $_GET['ads_id'] : ""; try { $functionObject = new FunctionClass('./'); $member_id = $functionObject->getIdMembre($username, $password); $url = $functionObject->getPubUrl($ads_id); $date = date('Y-m-d', time()); $STH = $DBH->prepare("\n\tSELECT id, clicked \n\tFROM ads_clicked \n\tWHERE ads_id = :ads_id \n\tAND date = :date \n\tLIMIT 1"); $STH->bindParam(":ads_id", $ads_id); $STH->bindParam(":date", $date); $STH->execute(); $STH->setFetchMode(PDO::FETCH_ASSOC); $row = $STH->fetch(); if (empty($row)) { $STH = $DBH->prepare("\n\t\tINSERT INTO `ads_clicked` (`ads_id`, `date`) \n\t\tVALUES (:ads_id, :date) \n\t\t"); $STH->bindParam(":ads_id", $ads_id); $STH->bindParam(":date", $date); $STH->execute(); $tacking_id = $DBH->lastInsertId(); $clicked = 0; } else { $tacking_id = $row['id'];