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;
}
<div class='item'>
<div class='title roboto'><a href='index.php?view=image&id=<?php
echo $image->id;
?>
'><?php
echo $image->title;
?>
</a></div>
<img class="img-responsive" src='<?php
echo $url;
?>
'><br>
<div class='subtitle roboto'>por <span class='channel'><?php
echo $image->getChannel()->title;
?>
</span></div>
</div>
<?php
}
?>
</div>
<?php
}
?>
</div>
</div><!-- /container -->
<?php
IpLogger::addImageViewIP($_GET['id']);
