Alex Moreno

A Drupal Developer in London

Changing Short project name in a project

Typical problem, you have just gained your full project permissions role in, 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. 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:

Fortunately git can help. You will simply have to:

Drupal form api select elements returning integers instead of string

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.



Customize a webform with

Situation: you have a webform, with a select option in which you want to push your own information, like a list from a database.Very easy, first, you need webform 3.x.Second, build a module:  [gist:5782455]    Related links: 

Convert dates from UNIXTIME in mysql

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 )

For example:

SELECT * , FROM_UNIXTIME( created ) FROM `node` ORDER BY `node`.`created` DESC LIMIT 0 , 30