amtgard / ORK3

Version 3 of the Online Record Keeper
Other
23 stars 12 forks source link

Event date_start not honoured #211

Closed kenwalker closed 5 years ago

kenwalker commented 5 years ago

If you run the following query the result should not include any events prior to 2018 but it does. I believe the date string needs to be encased in quotes in the SQL query. Will submit a pull request.

https://amtgard.com/ork/orkservice/Json/index.php?&call=SearchService%2FEvent&kingdom_id=31&date_order=true&date_start=2018-01-01

If you enclose the $when in single quotes ('$when')then the query honours the date.

https://github.com/amtgard/ORK3/blob/master/system/lib/ork3/class.SearchService.php#L164