/**
* @return CL_MySQLi
*/
public static function get_instance()
{
if (self::$instance === null) {
$config = CL_Config::get_instance();
$host = $config->get_value('database', 'host');
$user = $config->get_value('database', 'user');
$password = $config->get_value('database', 'password');
$database = $config->get_value('database', 'database');
self::$instance = new CL_MySQLi($host, $user, $password, $database);
}
return self::$instance;
}
/**
* @param int $userId
* @param int $nearId
* @param int $countryId
* @param string $name
* @param string $label
* @param string $cat
* @param string $sub
* @param LatLng $latLng
* @param Polygon $border
* @param string[] $attrs
* @return int
*/
public static function addNew($url, $nearId, $countryId, $userId, $name, $label, $cat, $sub, $latLng, $border, $attrs)
{
$mysql = CL_MySQLi::get_instance();
$query = insert($mysql)->into('poi_new')->value('url', $url)->value('userId', $userId)->value('countryId', $countryId)->value('nearId', $nearId)->value('name', $name)->value('label', $label)->value('cat', $cat)->value('sub', $sub)->value('lat', $latLng->lat())->value('lng', $latLng->lng())->value('border', $border === NULL ? 'NULL' : $border->toWKT())->op(GEOM_FROM_TEXT)->value('attrs', json_encode($attrs));
$mysql->query($query);
return $mysql->insertId();
}
