<?php
  ini_set('max_execution_time', 300);

  $path  = $_SERVER['DOCUMENT_ROOT'];
  
  include_once $path.'/connect_db.php';

    
// Execute query
$sql = "SELECT * FROM `ads` where `junk` = 0 order by `adid` LIMIT 100";
// $sql = "SELECT * FROM `ads` LIMIT 50";
$result = $connect->query($sql);

if ($result->num_rows > 0) {
    // Process the results
    while ($row = $result->fetch_assoc()) {

        $adid = $row['adid'];

        $cat1 = $row["cat1"];
        $cat2 = $row["cat2"];
        $cat3 = $row["cat3"];

        $cat1 = addslashes(trim($cat1));
        $cat2 = addslashes(trim($cat2));
        $cat3 = addslashes(trim($cat3));
    
        $res = $connect->query("SELECT * FROM `google_suggest` WHERE `keyword_plurals`='$cat1'");
        if ($res->num_rows < 1){
            $cat1 = '';
        }

        $res = $connect->query("SELECT * FROM `google_suggest` WHERE `keyword_plurals`='$cat2'");
        if ($res->num_rows < 1){
            $cat2 = '';
        }

        $res = $connect->query("SELECT * FROM `google_suggest` WHERE `keyword_plurals`='$cat3'");
        if ($res->num_rows < 1){
            $cat3 = '';
        }

        echo "<pre>";
        echo "adid : " . $adid . "<br/>";
        echo "cat1: ".$row["cat1"]." -> ".$cat1."<br>";
        echo "cat2: ".$row["cat2"]." -> ".$cat2."<br>";
        echo "cat3: ".$row["cat3"]." -> ".$cat3."<br>";
        echo "</pre>";

        
    
        $sql = "UPDATE `ads` SET `cat1`='$cat1',`cat2`='$cat2',`cat3`='$cat3', junk = 1  WHERE adid='$adid'";
        $connect->query($sql) || die("Error: ".$connect->error);
    }
    
    echo '<meta http-equiv="refresh" content="0">';
}else{
    echo "completed";
}

// Close the connection
$connect->close();
?>