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']);