<?php

error_reporting(E_ALL);
ini_set("display_errors",true);


include dirname(__FILE__).'/../../diversescripts/Database.class.php';

$refreshTimeStamp = time();
//sleep(15);
$Database = Database::getConnection();
$query = $Database->prepare(" SELECT  count(*) FROM posts join circles on circles.user_id = :user_id where post_time >:refreshTimeStamp AND posts.user_id in(circles.in_circle) ");
$query->bindParam("user_id",$_COOKIE['id']);
$query->bindParam("refreshTimeStamp",$refreshTimeStamp);

$query->execute();
$result = $query->fetch();

echo $result[0];