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; }