You are hereModules

Modules

Database syncing over drush

This has been a long wish for me. Sync databases online and on localhost.

There is an add on for drush that does that
https://drupal.org/project/drush_sql_sync_pipe

Of course this didn't run smoothly and needed some extra config. First SSH didn't work correctly on connecting to remote server, and then MySql also had a problem with the same solution, they were both just needed to be added to windows enviroment, eniroment variables to be exact.

So

New Age sliders and carousel (Responsive)

After using views slideshow and jCarousel (and not so happy the way they work, mostly in theming department) there are new players in town and they are even responsive. Also easy to theme and easy to setup.

https://drupal.org/project/flexslider
https://drupal.org/project/owl-carousel

Flexslider is great for slideshows, they can even pull carousels but for great responsive carousels use the owl carousel. Just a note, owl for drupal is pretty beta, so you will need to use dev version and also use jquery update 1.8 version, otherwise you may end up with empty space in place of carousel.

No file found - get the file object in file upload validate function

I had a form without this "name" parametar, and without that parametar there is just no file object in validate function for file upload

$form['image']['file']= array(
'#name' => 'files[advert]',
'#type' => 'file',
'#title' => '

'.t('Add New Image').'

',
'#description' => t('Upload a file, allowed extensions: jpg, jpeg, png, gif'),
);

and then you can get it in validate function like below with 'advert'

function item_validate($form, &$form_state)
{

Tableselect Form API - How to delete/edit selected rows from tableselect

To delete/edit selected rows from tableselect and have something to work in in form_state you should add keys to your array in your form like:

$rows = array();
foreach($fullList as $line)
{
$rows[$line->category] = array(
'tid' => $line->category,
);
}

This way you will be able to easily retrieve values on your submit/delete handler on $form_state

foreach ($form_state['values']['table'] as $rows) {
$delete = db_delete('htb_if_categories')
->condition('category', $rows, '=')

Setting Sessions and Cookies

Setting a session in Drupal is easy, everything is set from the Drupal boostrap, all you need to do is to set it and get it. Like

$_SESSION['zip'] = $form_state['values']['zip_code'];
and latter you just get value on some page like
$view_filters['field_zip_range']['value'] = $_SESSION['zip'];

and it works. Just be careful of caching and varnish and similar things as they sometimes do not cooparate.

Session is set on server side.

For client side, you use cookies and set it like this

user_cookie_save(array('key'=>'value'));
print $_COOKIE['Drupal_visitor_key'];

View 3, alter filters programmatically

function custom_views_pre_view(&$view) {
if ($view->name === 'pricing') {
$view_filters = $view->display_handler->get_option('filters');
$view_filters['field_zip_range']['value'] = $_SESSION['zip_code'];

$overrides = array();
$overrides['filters'] = $view_filters;
foreach ($overrides as $option => $definition) {
$view->display_handler->override_option($option, $definition);
}
}
}

Views 3 query altering with hook_views_query_alter

You can alter views, alter queries and much more. Problem with documentation online is that is lacking some crucial information.

First, you should put your alter function in separate file, your_module.views.inc
as it is said here
https://api.drupal.org/api/views/views.api.php/function/hook_views_query...

What you also need to do is implement hook_views_api, it is said above that you don't have to but with lates views 3.0 it won't work if you don't do it, so you add this little line

function your_module_views_api() {
return array('api' => 3.0);
}

Modal form, CTools automodal and redirect

Currently I am using a https://drupal.org/project/ctools_automodal for my modal forms, that use CTools and its form dialogs for nice overlay forms (well not so nice, they look ugly as hell, but you can theme things :) ).

So there are some good tutorials how to setup modal forms and make you forms in overlay
http://deeson-online.co.uk/labs/insert-form-pop-modal-ctools-and-drupal-7
http://drupion.com/blog/10-steps-creating-ctools-modal-window-drupal-7

WSOD or white screen of death and error reporting

Sometimes you will have a WSOD and nothing to show for. One simple solution to get what is a problem is to insert the following lines into the Drupal's index.php, that should set PHP to report all errors.

<?php
error_reporting(E_ALL);
ini_set('display_errors', TRUE);
ini_set('display_startup_errors', TRUE);
?>

and you will probably see that some module is making a problem, so you can fix it or disable it.

Converting Form API date field to timestamp

If you are not using a date module and just want to use date field from form api, you will want to insert it into DB, probably as timestamp. So to convert that value to timestamp you need to use some precoding for that. In this example we also use a simple textfield to enter time value and add it to timestamp. Also take a note we are using timezone value.

$timezone = $user->timezone;
$dateFrom = $form_state['values']['schedule_container']['date_container']['from']['date'];