<?

include 'config.cliente.inc.php';

$sql = "SELECT * FROM events WHERE opening_buyer_accreditation<=NOW() 
				and opening_buyer_accreditation is not NULL 
				and deleted_at is NULL 
				and deadline_buyer_accreditation  >= CURDATE() 
		ORDER BY start DESC";

/*
if(in_array($_SERVER["REMOTE_ADDR"],["81.174.56.205","93.56.121.24","81.29.182.119"])){
	$sql = "SELECT * FROM events WHERE opening_buyer_accreditation<=NOW() 
				and opening_buyer_accreditation is not NULL 
				and YEAR(deadline_buyer_accreditation) >= 2020
				and deleted_at is NULL 
		ORDER BY start DESC";
}*/

$result = $db->query($sql);
$events = array();
$listInteressi = "";
while ($event = $result->fetch_object()) {
	$events[] = $event;
}

$sql = "SELECT * FROM buyers_types ORDER BY `group` ASC, name";
$result = $db->query($sql);

while ($type = $result->fetch_object()) {
	$types[] = $type;
}

$sql = "SELECT country_id,name FROM list_countries ORDER BY name";
$result = $db->query($sql);
while ($nation = $result->fetch_object()) {
  $nations[] = $nation;
}


if ($_GET['l'] == 'en') {
    include("page.en.php");
    exit();
}
include 'page.php';