<?php
$path  = $_SERVER['DOCUMENT_ROOT'];
include $path.'/connect_db.php';

// $res_ads = $connect->query("SELECT adid, image, url FROM ads WHERE active = 1 AND logo_scrapped = 0 ORDER BY adid ASC LIMIT 1000");
$res_ads = $connect->query("SELECT adid, image, url FROM ads WHERE active = 1 AND logo_scrapped = 0 ORDER BY RAND() ASC LIMIT 5000");
if ($connect->connect_error) {
    die("Connection failed: " . $connect->connect_error);
}
if ($res_ads->num_rows > 0) {
    $businesses = array();
    while($row = $res_ads->fetch_assoc()) {
        $logo = $path.'/members/uploads/logo/'.$row['image'];
        $url = $row['url'];
        $adid = $row['adid'];
        if (!empty($url)) {
            if (!empty($logo)) {
                if(!file_exists($logo)){
                    array_push($businesses, array('adid' => $adid, 'website_url' => $url));
                }else{
                    $connect->query("UPDATE ads SET logo_scrapped = 2 WHERE adid = $adid") || die("Update error: ".$connect->error);
                }
            }else{
                array_push($businesses, array('adid' => $adid, 'website_url' => $url));
            }
        }else{
            $connect->query("UPDATE ads SET active = 0 AND approval = 0 WHERE adid = $adid") || die("Update error: ".$connect->error);
        }
    }
    // echo "<pre>";
    // print_r($businesses);
    // die();
    echo json_encode($businesses);
}else{
    echo "No active businesses";
}
?>