public static function checkView($servid, $field, $table)
{
// vamos a verficar que no se haya visto el servicio en un lapso de tiempo
$con = Database::getCon();
// $sql = "select serviceview.id as svid, iplog.id as ilid serviceview inner join iplog on (serviceview.iplog_id=iplog.id) where $field=$servid and order by created_at desc limit 1";
$sql = "select * from {$table} where realip='" . IpLogger::getRealIP() . "' and {$field}='{$servid}' order by created_at desc limit 1";
$query = $con->query($sql);
$found = false;
$ca = 0;
while ($r = $query->fetch_array()) {
$found = true;
$ca = $r['created_at'];
}
if ($found == true) {
$ca2 = $ca + 24 * 3600;
if (time() >= $ca2) {
$found = false;
}
}
if ($found == false) {
return true;
} else {
return false;
}
}
public function verify()
{
$con = Database::getCon();
$sql = "select * from " . self::$tablename . " where realip=\"" . IpLogger::getRealIP() . "\" and viewer_id=" . Session::getUID();
$query = $con->query($sql);
$found = false;
$ca = "";
while ($r = $query->fetch_array()) {
$found = true;
$ca = $r['created_at'];
}
if ($found == true) {
$ca2 = $ca + 24 * 3600;
if (time() >= $ca2) {
$found = false;
}
}
return $found;
}
