Adding event -> location search by name and Town – front end

  • Resolved Mirek_PL

    (@mirek_pl)


    10 years, 2 months ago

    Hello.

    I’m struggle with it for quite some time now.

    I want to achieve the following: user need to be able search existing location (in add new event page, egz: [event_form] or url …/mt-events/?action=edit) not only by location_name but also by location_town (location_nameor location_town` or …?)
    Before last update i was able change query in plugins/events-manager/em-actions.php from (~line 215):
    WHERE ('location_name' LIKE %s) AND ....
    to:
    WHERE ('location_name' OR 'location town' LIKE '%s') AND ...
    But now this trick dose not working any more ;(

    And I cant figure it why. If some one help me with this, give a clue, w/e …

    Thank You ??

    edited:
    hmm backticks isnt working?

    https://www.ads-software.com/plugins/events-manager/

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Mirek_PL

    (@mirek_pl)

    Happy New Year.

    ps bump ??

    Plugin Support angelo_nwl

    (@angelo_nwl)

    did you try something like

    WHERE ('location_name' LIKE '%s' OR 'location town' LIKE '%s') AND ...
    Thread Starter Mirek_PL

    (@mirek_pl)

    yes I did, I forgot to insert LIKE after ‘location_name’ in my first post.
    Now this hack is blocking search form in event form (not searching by any thing)

    Plugin Support angelo_nwl

    (@angelo_nwl)

    sorry, try something like

    WHERE (location_name LIKE '%s' OR location town LIKE '%s') AND ...
Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Adding event -> location search by name and Town – front end’ is closed to new replies.