"Link to Business" ajax query does not match substrings

This topic contains 3 replies, has 2 voices, and was last updated by  Alex Rollin 5 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #447424

    Brandon Quig
    Expired Member
    Post count: 7

    The query behind the “Link to Business” search currently requires that you know exactly how the name of the business’ title begins in order to return it as a result.

    For example, suppose you had a business listing named “WP Geodirectory”, it would match on “WP Geo” but not “Geodirectory”

    This is not intuitive.
    Within geodir_event_get_my_listings() function, suggest changing this line:

    $condition .= $search != '' ? $wpdb->prepare( " AND post_title LIKE %s", array( $search . '%%' ) ) : "";

    to this:

    $condition .= $search != '' ? $wpdb->prepare( " AND post_title LIKE %s", array('%%' . $search . '%%' ) ) : "";
    #447496

    Alex Rollin
    Moderator
    Post count: 27815

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    #448294

    Brandon Quig
    Expired Member
    Post count: 7

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

    #448315

    Alex Rollin
    Moderator
    Post count: 27815

    A valid license is required to view this reply.

    You may need to login

    OR

    Buy either a Membership or valid license for this product.

    Thanks, Team GeoDirectory!

Viewing 4 posts - 1 through 4 (of 4 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket