Typical problem, you have just gained your full project permissions role in Drupal.org, and you make your first mess... you have promoted your so loved first project without changing the Short project name.
Well, you have a problem, but not too big. Drupal.org will not allow you to rename your Short project name, so you will have to create a new one if you don't want to have an ugly url like that: https://drupal.org/project/2062343
Fortunately git can help. You will simply have to:
I always have the same problem when using select forms, and I always forget the solution.
Instead of returning an array, like: return $competitions; you have to return a drupal_map_assoc, like this: return drupal_map_assoc($competitions);
Otherwise, when selecting the form in hook_submit you will get a number, instead of a human readable string.
Reading a date in mysql can be frustrating, unless your brain is able to convert Dates from UNIXTIME formats. Let's see for example this scenario in Drupal:
SELECT * FROM `node` ORDER BY `node`.`created` DESC LIMIT 0 , 30
If you need to fetch, for example, when it was the last time that a node was created, this format doesn't help too much.
The solution is quite simple, FROM_UNIXTIME( field_with_date )
SELECT * , FROM_UNIXTIME( created ) FROM `node` ORDER BY `node`.`created` DESC LIMIT 0 , 30