[wp-meta] [Making WordPress.org] #5404: Canceled Regional WordCamps are being shown in Dashboard Events widget

[Making WordPress.org]

#5404: Canceled Regional WordCamps are being shown in Dashboard Events widget
------------------------+---------------------------
 Reporter:  RMarks      |       Owner:  coreymckrill
     Type:  defect      |      Status:  closed
 Priority:  normal      |   Milestone:
Component:  Events API  |  Resolution:  fixed
 Keywords:              |
------------------------+---------------------------

Comment (by RMarks):

 @coreymckrill what are your thoughts on automating these three regional
 WordCamps and how the `get_regional_wordcamp_data` function works.

 Suggestion:
 1. Build an array of regional wordcamp names (asia, europe, us).
 2. For each of these, query for the next WordCamp's info (title, url,
 date, end_date, location, country, latitude, longitude) where status is
 `scheduled`, date is in the future, and url contains the wordcamp's name.
 3. Populate the $events array to produce the same data in place today

 For the third where clause condition (url contains the wordcamp's name),
 is there column in the wporg_events table that is indexed to support this?

-- 
Ticket URL: <https://meta.trac.wordpress.org/ticket/5404#comment:4>
Making WordPress.org <https://meta.trac.wordpress.org/>
Making WordPress.org