Function Reference: geodir_add_new_location_via_adon

Summary

Function for addons to add new location.

Global Values

$wpdb

(object) (required) WordPress Database object.

Default: None

Package

GeoDirectory_Location_Manager

Parameters

$location_info

(array) (required) Location information.

Default: None

Return Values

(mixed)

Change Log

Since: 1.0.0

Source File

geodir_add_new_location_via_adon() is located in geodir_location_manager/geodir_location_functions.php [Line: 2202]

Source Code

function geodir_add_new_location_via_adon($location_info)
{

	global $wpdb;
	if(!empty($location_info)){

		$get_location_info = $wpdb->get_row($wpdb->prepare("SELECT * from ".POST_LOCATION_TABLE." where city like %s AND region like %s AND country like %s",array($location_info['city'],$location_info['region'],$location_info['country'] )), "OBJECT" );

		if(empty($get_location_info)){

			$city_meta = isset($location_info['city_meta']) ? $location_info['city_meta'] : '';
			$city_desc = isset($location_info['city_desc']) ? $location_info['city_desc'] : '';

			$wpdb->query(
				$wpdb->prepare("INSERT INTO ".POST_LOCATION_TABLE." SET
					city = %s,
					region = %s,
					country = %s,
					country_slug = %s,
					region_slug = %s,
					city_slug = %s,
					city_latitude = %s,
					city_longitude = %s,
					is_default	=	%s ,
					city_meta = %s,
					city_desc = %s",

					array($location_info['city'],$location_info['region'],$location_info['country'],$location_info['country_slug'],$location_info['region_slug'],$location_info['city_slug'],$location_info['city_latitude'],$location_info['city_longitude'],$location_info['is_default'],$city_meta,$city_desc)

				)
			);

			$last_location_id = $wpdb->insert_id;

			$location_info = $wpdb->get_row($wpdb->prepare("SELECT * FROM ".POST_LOCATION_TABLE." WHERE location_id=%d",array($last_location_id)), "OBJECT" );

		}else{
			$location_info = $get_location_info;
		}

	}

	return $location_info;
}