search

emka / openstreetbugs

OpenStreetBugs (deprecated)
http://wiki.openstreetmap.org/wiki/OpenStreetBugs
GNU General Public License v3.0
17 stars 5 forks source link

Bug date #16

Open PinkDuck opened 14 years ago

PinkDuck commented 14 years ago

It would be nice to see the date that an OpenStreetBug issue is posted, as I can't tell whether one occured before or after I mapped an area at my first time of checking the OpenStreetBugs website.

emka commented 14 years ago

Bugs contain the posting date after the username (very old bugs dont).

What exactly would you like to change?

PinkDuck commented 14 years ago

In that case, I would like you to update old bugs that don't include the posting date with their posting date. It would be the sensible thing to do now that you've changed to including the post date for new ones.

emka commented 14 years ago

Could you please write the SQL query for that?

PinkDuck commented 14 years ago

This is not something that a single piece of SQL would be the solution for. You'll need to ask the author to write some code to handle the string processing given that existing descriptions can end with "CET]", "GMT]", "CEST]", "MESZ]" etc. and injecting the date has to take account of existing square brackets in the text field.

PinkDuck commented 14 years ago

Ideally the date should be formatted into the display string prior to client-side use from the raw database fields. In that case the existing dates should be stripped out of the text field and code written to format them suitably based on the locale of the browsing user.

emka commented 14 years ago

Sorry, my attention to this issue got lost somehow. I can not work on it right now, but I could commit your changes if you submit a patch.

Otherwise this will be solved by the improved quality assurance tool coming in far future...