******** VIEW 1

$view = new view;
$view->name = 'coup_de_coeur';
$view->description = '';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['submit_button'] = 'Appliquer';
$handler->display->display_options['exposed_form']['options']['reset_button_label'] = 'Remise à zéro';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['expose']['items_per_page_label'] = 'Éléments par page';
$handler->display->display_options['pager']['options']['expose']['offset_label'] = 'Décalage';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
/* Champ: Noeud : Nid */
$handler->display->display_options['fields']['nid']['id'] = 'nid';
$handler->display->display_options['fields']['nid']['table'] = 'node';
$handler->display->display_options['fields']['nid']['field'] = 'nid';
$handler->display->display_options['fields']['nid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['nid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['nid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['nid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['nid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['nid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['nid']['alter']['html'] = 0;
$handler->display->display_options['fields']['nid']['link_to_node'] = 0;
/* Champ: Content : Affiche (field_show_poster) */
$handler->display->display_options['fields']['field_show_poster_fid']['id'] = 'field_show_poster_fid';
$handler->display->display_options['fields']['field_show_poster_fid']['table'] = 'node_data_field_show_poster';
$handler->display->display_options['fields']['field_show_poster_fid']['field'] = 'field_show_poster_fid';
$handler->display->display_options['fields']['field_show_poster_fid']['label'] = '';
$handler->display->display_options['fields']['field_show_poster_fid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_show_poster_fid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_show_poster_fid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_show_poster_fid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_show_poster_fid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_show_poster_fid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_show_poster_fid']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_show_poster_fid']['link_to_node'] = 0;
/* Critère de tri: Noeud : Titre */
$handler->display->display_options['sorts']['title']['id'] = 'title';
$handler->display->display_options['sorts']['title']['table'] = 'node';
$handler->display->display_options['sorts']['title']['field'] = 'title';
$handler->display->display_options['sorts']['title']['order'] = 'DESC';
/* Filtre: Noeud : Publié */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = '1';
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filtre: Noeud : Node ID PHP handler */
$handler->display->display_options['filters']['nid_php']['id'] = 'nid_php';
$handler->display->display_options['filters']['nid_php']['table'] = 'node';
$handler->display->display_options['filters']['nid_php']['field'] = 'nid_php';
$handler->display->display_options['filters']['nid_php']['value'] = '$sqlShowFavorit = "
SELECT 
content_type_show_showtime.field_showtime_show_nid AS show_nid
FROM content_type_show_showtime  
LEFT JOIN content_field_showtime_price ON content_field_showtime_price.nid = content_type_show_showtime.nid 
LEFT JOIN content_field_showtime_category ON content_field_showtime_category.nid = content_type_show_showtime.nid 
LEFT JOIN content_field_showtime_seats ON content_field_showtime_seats.nid = content_type_show_showtime.nid 
LEFT JOIN content_type_show ON content_type_show.nid = content_type_show_showtime.field_showtime_show_nid 
LEFT JOIN node ON node.nid = content_type_show_showtime.nid 
WHERE 
content_type_show.field_show_favorit_value = 1 && 
(
content_field_showtime_price.delta = content_field_showtime_category.delta && 
content_field_showtime_price.delta = content_field_showtime_seats.delta  && 
content_field_showtime_seats.delta = content_field_showtime_category.delta && 
content_field_showtime_seats.delta = content_field_showtime_price.delta && 
content_field_showtime_category.delta = content_field_showtime_seats.delta && 
content_field_showtime_category.delta = content_field_showtime_price.delta 
)
&& 
content_field_showtime_seats.field_showtime_seats_value > 0 
GROUP BY show_nid 
";
$showsQuery = db_query($sqlShowFavorit);

$showsTotal = array();

while($shows = db_fetch_array($showsQuery)) {
	$showsTotal[] = $shows[\'show_nid\'];
}
return $showsTotal;';
$handler->display->display_options['filters']['nid_php']['expose']['operator'] = FALSE;

******** VIEW 1
******** VIEW 2

$view = new view;
$view->name = 'coup_de_coeur_list';
$view->description = '';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['distinct'] = TRUE;
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'none';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['submit_button'] = 'Appliquer';
$handler->display->display_options['exposed_form']['options']['reset_button_label'] = 'Remise à zéro';
$handler->display->display_options['pager']['type'] = 'some';
$handler->display->display_options['pager']['options']['items_per_page'] = 3;
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
/* Champ: Noeud : Nid */
$handler->display->display_options['fields']['nid']['id'] = 'nid';
$handler->display->display_options['fields']['nid']['table'] = 'node';
$handler->display->display_options['fields']['nid']['field'] = 'nid';
$handler->display->display_options['fields']['nid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['nid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['nid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['nid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['nid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['nid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['nid']['alter']['html'] = 0;
$handler->display->display_options['fields']['nid']['link_to_node'] = 0;
/* Critère de tri: Noeud : Titre */
$handler->display->display_options['sorts']['title']['id'] = 'title';
$handler->display->display_options['sorts']['title']['table'] = 'node';
$handler->display->display_options['sorts']['title']['field'] = 'title';
/* Filtre: Noeud : Publié */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = '1';
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;
/* Filtre: Noeud : Node ID PHP handler */
$handler->display->display_options['filters']['nid_php']['id'] = 'nid_php';
$handler->display->display_options['filters']['nid_php']['table'] = 'node';
$handler->display->display_options['filters']['nid_php']['field'] = 'nid_php';
$handler->display->display_options['filters']['nid_php']['value'] = '$sqlShowFavorit = "
SELECT 
content_type_show_showtime.field_showtime_show_nid AS show_nid
FROM content_type_show_showtime  
LEFT JOIN content_field_showtime_price ON content_field_showtime_price.nid = content_type_show_showtime.nid 
LEFT JOIN content_field_showtime_category ON content_field_showtime_category.nid = content_type_show_showtime.nid 
LEFT JOIN content_field_showtime_seats ON content_field_showtime_seats.nid = content_type_show_showtime.nid 
LEFT JOIN content_type_show ON content_type_show.nid = content_type_show_showtime.field_showtime_show_nid 
LEFT JOIN node ON node.nid = content_type_show_showtime.nid 
WHERE 
content_type_show.field_show_favorit_value = 1 && 
(
content_field_showtime_price.delta = content_field_showtime_category.delta && 
content_field_showtime_price.delta = content_field_showtime_seats.delta  && 
content_field_showtime_seats.delta = content_field_showtime_category.delta && 
content_field_showtime_seats.delta = content_field_showtime_price.delta && 
content_field_showtime_category.delta = content_field_showtime_seats.delta && 
content_field_showtime_category.delta = content_field_showtime_price.delta 
)
&& 
content_field_showtime_seats.field_showtime_seats_value > 0 
GROUP BY show_nid 
";
$showsQuery = db_query($sqlShowFavorit);

$showsTotal = array();

while($shows = db_fetch_array($showsQuery)) {
	$showsTotal[] = $shows[\'show_nid\'];
}
return $showsTotal;
';
$handler->display->display_options['filters']['nid_php']['expose']['operator'] = FALSE;

/* Display: Page */
$handler = $view->new_display('page', 'Page', 'page_1');
$handler->display->display_options['defaults']['items_per_page'] = FALSE;
$handler->display->display_options['defaults']['distinct'] = FALSE;
$handler->display->display_options['defaults']['relationships'] = FALSE;
$handler->display->display_options['defaults']['arguments'] = FALSE;
$handler->display->display_options['path'] = 'test';

******** VIEW 2
******** VIEW 3

$view = new view;
$view->name = 'nos_evenements';
$view->description = '';
$view->tag = '';
$view->view_php = '';
$view->base_table = 'node';
$view->is_cacheable = FALSE;
$view->api_version = 2;
$view->disabled = FALSE; /* Edit this to true to make a default view disabled initially */

/* Display: Defaults */
$handler = $view->new_display('default', 'Defaults', 'default');
$handler->display->display_options['access']['type'] = 'none';
$handler->display->display_options['cache']['type'] = 'time';
$handler->display->display_options['cache']['results_lifespan'] = '3600';
$handler->display->display_options['cache']['output_lifespan'] = '3600';
$handler->display->display_options['exposed_form']['type'] = 'basic';
$handler->display->display_options['exposed_form']['options']['submit_button'] = 'Appliquer';
$handler->display->display_options['exposed_form']['options']['reset_button_label'] = 'Remise à zéro';
$handler->display->display_options['pager']['type'] = 'full';
$handler->display->display_options['pager']['options']['expose']['items_per_page_label'] = 'Éléments par page';
$handler->display->display_options['pager']['options']['expose']['offset_label'] = 'Décalage';
$handler->display->display_options['style_plugin'] = 'default';
$handler->display->display_options['row_plugin'] = 'fields';
/* Champ: Noeud : Titre */
$handler->display->display_options['fields']['title']['id'] = 'title';
$handler->display->display_options['fields']['title']['table'] = 'node';
$handler->display->display_options['fields']['title']['field'] = 'title';
$handler->display->display_options['fields']['title']['label'] = '';
$handler->display->display_options['fields']['title']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['title']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['title']['alter']['trim'] = 0;
$handler->display->display_options['fields']['title']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['title']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['title']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['title']['alter']['html'] = 0;
$handler->display->display_options['fields']['title']['link_to_node'] = 0;
/* Champ: Content : Période (field_event_dates) - Date de début */
$handler->display->display_options['fields']['field_event_dates_value']['id'] = 'field_event_dates_value';
$handler->display->display_options['fields']['field_event_dates_value']['table'] = 'node_data_field_event_dates';
$handler->display->display_options['fields']['field_event_dates_value']['field'] = 'field_event_dates_value';
$handler->display->display_options['fields']['field_event_dates_value']['label'] = '';
$handler->display->display_options['fields']['field_event_dates_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_event_dates_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_event_dates_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_event_dates_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_event_dates_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_event_dates_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_event_dates_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_event_dates_value']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_event_dates_value']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_event_dates_value']['link_to_node'] = 0;
/* Champ: Content : Période (field_event_dates) - Date de fin */
$handler->display->display_options['fields']['field_event_dates_value2']['id'] = 'field_event_dates_value2';
$handler->display->display_options['fields']['field_event_dates_value2']['table'] = 'node_data_field_event_dates';
$handler->display->display_options['fields']['field_event_dates_value2']['field'] = 'field_event_dates_value2';
$handler->display->display_options['fields']['field_event_dates_value2']['label'] = '';
$handler->display->display_options['fields']['field_event_dates_value2']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_event_dates_value2']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_event_dates_value2']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_event_dates_value2']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_event_dates_value2']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_event_dates_value2']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_event_dates_value2']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_event_dates_value2']['hide_empty'] = 0;
$handler->display->display_options['fields']['field_event_dates_value2']['empty_zero'] = 0;
$handler->display->display_options['fields']['field_event_dates_value2']['link_to_node'] = 0;
/* Champ: Content : Spectacle - affiche (field_event_showimage) */
$handler->display->display_options['fields']['field_event_showimage_fid_1']['id'] = 'field_event_showimage_fid_1';
$handler->display->display_options['fields']['field_event_showimage_fid_1']['table'] = 'node_data_field_event_showimage';
$handler->display->display_options['fields']['field_event_showimage_fid_1']['field'] = 'field_event_showimage_fid';
$handler->display->display_options['fields']['field_event_showimage_fid_1']['label'] = '';
$handler->display->display_options['fields']['field_event_showimage_fid_1']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_event_showimage_fid_1']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_event_showimage_fid_1']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_event_showimage_fid_1']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_event_showimage_fid_1']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_event_showimage_fid_1']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_event_showimage_fid_1']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_event_showimage_fid_1']['link_to_node'] = 0;
/* Champ: Content : Restaurant - image (field_event_restaurantimage) */
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['id'] = 'field_event_restaurantimage_fid';
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['table'] = 'node_data_field_event_restaurantimage';
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['field'] = 'field_event_restaurantimage_fid';
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['label'] = '';
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_event_restaurantimage_fid']['link_to_node'] = 0;
/* Champ: Content : Spectacle (field_event_show) */
$handler->display->display_options['fields']['field_event_show_nid']['id'] = 'field_event_show_nid';
$handler->display->display_options['fields']['field_event_show_nid']['table'] = 'node_data_field_event_show';
$handler->display->display_options['fields']['field_event_show_nid']['field'] = 'field_event_show_nid';
$handler->display->display_options['fields']['field_event_show_nid']['label'] = '';
$handler->display->display_options['fields']['field_event_show_nid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_event_show_nid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_event_show_nid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_event_show_nid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_event_show_nid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_event_show_nid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_event_show_nid']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_event_show_nid']['link_to_node'] = 0;
/* Champ: Content : Catégorie (field_event_category) */
$handler->display->display_options['fields']['field_event_category_value']['id'] = 'field_event_category_value';
$handler->display->display_options['fields']['field_event_category_value']['table'] = 'node_data_field_event_category';
$handler->display->display_options['fields']['field_event_category_value']['field'] = 'field_event_category_value';
$handler->display->display_options['fields']['field_event_category_value']['label'] = '';
$handler->display->display_options['fields']['field_event_category_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_event_category_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_event_category_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_event_category_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_event_category_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_event_category_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_event_category_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_event_category_value']['link_to_node'] = 0;
/* Champ: Content : Restaurant (field_event_restaurant) */
$handler->display->display_options['fields']['field_event_restaurant_nid']['id'] = 'field_event_restaurant_nid';
$handler->display->display_options['fields']['field_event_restaurant_nid']['table'] = 'node_data_field_event_restaurant';
$handler->display->display_options['fields']['field_event_restaurant_nid']['field'] = 'field_event_restaurant_nid';
$handler->display->display_options['fields']['field_event_restaurant_nid']['label'] = '';
$handler->display->display_options['fields']['field_event_restaurant_nid']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_event_restaurant_nid']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_event_restaurant_nid']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_event_restaurant_nid']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_event_restaurant_nid']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_event_restaurant_nid']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_event_restaurant_nid']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_event_restaurant_nid']['link_to_node'] = 0;
/* Champ: Content : Texte libre (field_event_text) */
$handler->display->display_options['fields']['field_event_text_value']['id'] = 'field_event_text_value';
$handler->display->display_options['fields']['field_event_text_value']['table'] = 'node_data_field_event_text';
$handler->display->display_options['fields']['field_event_text_value']['field'] = 'field_event_text_value';
$handler->display->display_options['fields']['field_event_text_value']['label'] = '';
$handler->display->display_options['fields']['field_event_text_value']['alter']['alter_text'] = 0;
$handler->display->display_options['fields']['field_event_text_value']['alter']['make_link'] = 0;
$handler->display->display_options['fields']['field_event_text_value']['alter']['trim'] = 0;
$handler->display->display_options['fields']['field_event_text_value']['alter']['word_boundary'] = 1;
$handler->display->display_options['fields']['field_event_text_value']['alter']['ellipsis'] = 1;
$handler->display->display_options['fields']['field_event_text_value']['alter']['strip_tags'] = 0;
$handler->display->display_options['fields']['field_event_text_value']['alter']['html'] = 0;
$handler->display->display_options['fields']['field_event_text_value']['link_to_node'] = 0;
/* Critère de tri: Noeud : Date de publication */
$handler->display->display_options['sorts']['created']['id'] = 'created';
$handler->display->display_options['sorts']['created']['table'] = 'node';
$handler->display->display_options['sorts']['created']['field'] = 'created';
$handler->display->display_options['sorts']['created']['order'] = 'DESC';
/* Filtre: Noeud : Type */
$handler->display->display_options['filters']['type']['id'] = 'type';
$handler->display->display_options['filters']['type']['table'] = 'node';
$handler->display->display_options['filters']['type']['field'] = 'type';
$handler->display->display_options['filters']['type']['value'] = array(
  'show_events' => 'show_events',
);
$handler->display->display_options['filters']['type']['expose']['operator'] = FALSE;
/* Filtre: Noeud : Publié */
$handler->display->display_options['filters']['status']['id'] = 'status';
$handler->display->display_options['filters']['status']['table'] = 'node';
$handler->display->display_options['filters']['status']['field'] = 'status';
$handler->display->display_options['filters']['status']['value'] = '1';
$handler->display->display_options['filters']['status']['expose']['operator'] = FALSE;


******** VIEW 3