GeoDirectory / geodirectory

 * @global object $wpdb     WordPress Database object.

 * @return bool|null|string Returns default sort results, when the post type is valid. Otherwise returns false.

 */

function geodir_get_posts_default_sort( $post_type ) {

	global $wpdb;

	if ( $post_type != '' ) {

		$all_postypes = geodir_get_posttypes();

		if ( ! in_array( $post_type, $all_postypes ) ) {

			return false;

		}

		$sort_field_info = $wpdb->get_var( $wpdb->prepare( "select default_order from " . GEODIR_CUSTOM_SORT_FIELDS_TABLE . " where	post_type= %s and is_active=%d and is_default=%d", array(

			$post_type,

			1,

			1

		) ) );

		if ( ! empty( $sort_field_info ) ) {

			return $sort_field_info;

		}

	}

 * @global object $wpdb     WordPress Database object.

 * @return bool|mixed|void Returns sort results, when the post type is valid. Otherwise returns false.

 */

function geodir_get_sort_options( $post_type ) {

	global $wpdb;

	if ( $post_type != '' ) {

		$all_postypes = geodir_get_posttypes();

		if ( ! in_array( $post_type, $all_postypes ) ) {

			return false;

		}

		$sort_field_info = $wpdb->get_results( $wpdb->prepare( "SELECT * FROM " . GEODIR_CUSTOM_SORT_FIELDS_TABLE . " WHERE post_type=%s AND is_active=%d AND (sort_asc=1 || sort_desc=1 || field_type='random') AND field_type != 'address' ORDER BY sort_order ASC", array(

			$post_type,

			1

		) ) );

		/**

		 * Filter post sort options.

		 *

		 * @since 1.0.0

		 *

		 * @param array $sort_field_info Unfiltered sort field array.

		 * @param string $post_type      Post type.

		 */

		return apply_filters( 'geodir_get_sort_options', $sort_field_info, $post_type );

	}

}