<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  // load viewer library
  $libraryPath = 'cms/lib/viewer_functions.php';
  $dirsToCheck = array('/home/luxurychartergroup/luxurychartergroup.com/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

  list($newsRecords, $newsMetaData) = getRecords(array(
    'tableName'   => 'news_fr',
    'where'     => whereRecordNumberInUrl(1) . ' AND active ="1"',
    'limit'       => '1',
    'useSeoUrls'  => true,
  ));
  $newsRecord = @$newsRecords[0]; // get first record

  // show error message if no matching record is found
  if (!$newsRecord) {
    header("HTTP/1.0 404 Not Found");
    include("../404.php");
    exit;
  }

  if ($newsRecord['yacht']) {
  $yachtID = $newsRecord['yacht'];
  list($yachtsRecords, $yachtsMetaData) = getRecords(array(
    'tableName'   => 'yachts',
    'where'       => "num = '". mysql_escape($yachtID) ."' ", 
    'limit'       => '1',
  ));
  $yachtsRecord = @$yachtsRecords[0]; // get first record
  }

  list($settingsRecords, $settingsMetaData) = getRecords(array(
    'tableName'   => 'settings',
    'limit'       => '1',
    'allowSearch'   => false,
  ));
  $settingsRecord = @$settingsRecords[0]; // get first record
  
?>
<? include("includes/headers.php"); ?>
<!doctype html>
<html class="no-js" lang="en" >
  <head>
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title><?php echo $newsRecord['title'] ?></title>
    <?php if ($newsRecord['meta_desc']): ?><meta name="description" content="<?php echo $newsRecord['meta_desc'] ?>" /><?php endif ?>
    <link rel="canonical" href="<?php echo $settingsRecord['web'] ?>/<?php echo $settingsRecord['french_directory'] ?><?php echo strtolower($newsRecord['_link']); ?>" />


    <meta property="og:type" content="article">
    <?php if ($newsRecord['title']): ?><meta property="og:title" content="<?php echo htmlencode($newsRecord['title']) ?>"><?php endif ?>
    
    <?php if ($newsRecord['intro']): ?><meta property="og:description" content="<?php echo htmlencode($newsRecord['intro']) ?>"><?php endif ?>

    <meta property="og:url" content="<?php echo $settingsRecord['web'] ?>/<?php echo $settingsRecord['french_directory'] ?><?php echo strtolower($newsRecord['_link']); ?>">

    <?php if ($newsRecord['list_image']): ?><meta property="og:image" content="<?php echo $settingsRecord['web'] ?><?php foreach ($newsRecord['list_image'] as $index => $upload): ?><?php echo htmlencode($upload['urlPath']) ?><?php break ?><?php endforeach ?>"><?php endif ?>

    <meta property="og:site_name" content="<?php echo htmlencode($settingsRecord['title']) ?>">
    <meta property="article:published_time" content="<?php echo date("c", strtotime($newsRecord['publishDate'])) ?>">
    <meta property="article:author" content="<?php echo htmlencode($settingsRecord['title']) ?>">
    <meta name="twitter:card" content="summary_large_image">
    <meta name="twitter:site" content="@luxchartergroup">
    <meta name="twitter:creator" content="@luxchartergroup">
    <?php if ($newsRecord['title']): ?><meta name="twitter:title" content="<?php echo htmlencode($newsRecord['title']) ?>"><?php endif ?>

    <?php if ($newsRecord['intro']): ?><meta name="twitter:description" content="<?php echo htmlencode($newsRecord['intro']) ?>"><?php endif ?>

    <?php if ($newsRecord['list_image']): ?><meta name="twitter:image" content="<?php echo $settingsRecord['web'] ?><?php foreach ($newsRecord['list_image'] as $index => $upload): ?><?php echo htmlencode($upload['urlPath']) ?><?php break ?><?php endforeach ?>"><?php endif ?>

    
<? include("includes/head.php"); ?>

  </head>
<body>

<div id="skip"><a href="#content">Retour au menu principal</a></div>

<div class="off-canvas-wrap" data-offcanvas>
<div class="inner-wrap">

<? include("includes/top.php"); ?>

<div id="content">

<?php // Top Banner Set
$topbannerissmall = "";
$topbannerimage = "";
$showbanner = "";
if ($newsRecord['banner_image']) {
  foreach ($newsRecord['banner_image'] as $upload) { 
    $topbannerimage = $upload['urlPath'];
    $bannerwidth = $upload['width'];
      if ($bannerwidth >= '650') {
        $showbanner = 1;
      } 
  }
} elseif ($newsRecord['yacht']) {
  foreach ($yachtsRecord['banner_image'] as $upload) { 
    $topbannerimage = $upload['urlPath'];
    $bannerwidth = $upload['width'];
      if ($bannerwidth >= '650') {
        $showbanner = 1;
      } 
  }
} 
?>
<?php if ($newsRecord['banner_image'] && $showbanner != 0): ?>
<div class="media-photo destination-hero">
    <div class="media-cover" style="background-image:url(<?php echo $topbannerimage ?>)"></div>
    <div class="row row-table collapse">
        <div class="title small-12 text-center col-middle column">
        </div>
    </div>
</div>
<?php elseif ($newsRecord['yacht'] && $showbanner != 0): ?>
<div class="media-photo destination-hero">
    <div class="media-cover" style="background-image:url(<?php echo $topbannerimage ?>)"></div>
    <div class="row row-table collapse">
        <div class="title small-12 text-center col-middle column">
        </div>
    </div>
</div>
<?php else: ?>
<div class="media-photo media-photo-page" style="height: 200px !important;">
    <div class="media-cover" style="background-image:url(/images/oceanscape-tile.jpg)"></div>
    <div class="row row-table collapse">
        <div class="title small-12 text-center col-middle column">
            <h2 class="h1">Latest News &amp; Updates</h2>
        </div>
    </div>
</div>
<?php endif ?>

<div class="content-body row-space-top-2 row-space-bottom-4">

        <div class="row">
            <div class="large-8 column content-main">

                <div class="row">

                    <div class="small-12 columns">

                    <div class="post-info">
                      <?php if ($newsRecord['publishDate']): ?><span class="post-date"><?php setlocale(LC_TIME, "fr_FR.utf8"); echo strftime("%d %B, %Y", strtotime($newsRecord['publishDate'])) ?></span><?php endif ?>
                      <?php if ($newsRecord['category']): ?>
                      <?php 
                        $values = getListValues('news_fr','category',$newsRecord['category']); 
                        $labels = getListLabels('news_fr','category',$newsRecord['category']); 
                        $valuesToLabels = array_combine($values, $labels); 
                      ?>
                      <?php $countD=0; ?><span class="blog-category"><?php foreach ($valuesToLabels as $value => $label): ?><?php echo ($countD==0)? "" : ", " ?><a href="/fr/blog.php?category=<?php echo $value ?>"><?php echo htmlspecialchars($label); ?></a><?php $countD++;?><?php endforeach ?></span>
                      <?php endif ?>
                    </div>

                    <?php if ($newsRecord['heading']): ?><h1><?php echo $newsRecord['heading'] ?></h1><?php endif ?>

                    <!-- Go to www.addthis.com/dashboard to customize your tools -->
                    <div class="addthis_sharing_toolbox"></div>

                    <?php if ($newsRecord['list_image'] && $newsRecord['hide_images'] != "1"): ?>
                      <?php foreach ($newsRecord['list_image'] as $upload): ?>
                        <?php if ($upload['thumbWidth'] <= '800'): ?>
                          <img src="<?php echo $upload['urlPath'] ?>" width="100%" alt="<?php echo $newsRecord['heading'] ?>" class="row-space-bottom-1" />
                        <?php else: ?>
                        <img src="<?php echo $upload['thumbUrlPath'] ?>" width="100%" alt="<?php echo $newsRecord['heading'] ?>" class="row-space-bottom-1" />
                        <?php endif ?>
                        <?php break ?>
                      <?php endforeach ?>
                    <?php endif ?>

                    <?php if ($newsRecord['intro']): ?><div class="summary"><p><?php echo $newsRecord['intro'] ?></p></div><?php endif ?>

                    <?php if ($newsRecord['yacht']): ?>
                                <div class="gallery">
                                    <ul class="gallery-tiles clearing-thumbs clearing-feature medium-block-grid-4" data-clearing>

                                        <?php if ($topbannerissmall == 1): // show banner image as first large ?>
                                            <?php foreach ($yachtsRecord['banner_image'] as $upload): ?>
                                                <li class="gallery-hero clearing-featured-img hide hide-for-small"><a href="<?php echo $upload['urlPath'] ?>"><img class="img-responsive" data-caption="<?php echo $yachtsRecord['yacht_name'] ?>" src="<?php echo $upload['urlPath'] ?>" alt="<?php echo $yachtsRecord['yacht_name'] ?>"></a></li>
                                                <?php break ?>
                                            <?php endforeach ?>
                                        <?php endif ?>

                                        <?php // Number of gallery images to show based on top banner size
                                                if ($topbannerissmall==1) {
                                                    $gallerycountmax = 3; 
                                                } 
                                                else {
                                                    $gallerycountmax = 4;
                                                } 
                                        ?>

                                        <?php $gallerycount = 0; ?>
                                        <?php foreach ($yachtsRecord['gallery_images'] as $upload): ?>
                                            <?php $gallerycount++; ?> 
                                            <?php if ($gallerycount == 1) { $slideshowlink = $upload['urlPath']; $slideshowalt = $upload['info1']; } ?>
                                            <?php if ($upload['thumbWidth2'] > "195"): ?>
                                                <?php $galleryimage = $upload['thumbUrlPath2'] ?>
                                            <?php else: ?>
                                                <?php $galleryimage = $upload['urlPath'] ?>
                                            <?php endif ?>

                                            <?php if ($gallerycount==1 && $topbannerissmall==0): // show gallery image as first large ?>
                                                <li class="gallery-hero clearing-featured-img hide"><a href="<?php echo $upload['urlPath'] ?>"><img class="img-responsive" data-caption="<?php echo $upload['info1'] ?>" src="<?php echo $upload['urlPath'] ?>" alt="<?php echo $upload['info1'] ?>"></a></li>
                                            <?php elseif ($gallerycount==$gallerycountmax): ?>
                                                <li class="clearing-featured-img hide"><a href="<?php echo $upload['urlPath'] ?>"><img src="<?php echo $galleryimage; ?>" data-caption="<?php echo $upload['info1'] ?>" alt="<?php echo $upload['info1'] ?>"></a></li>
                                            <?php elseif ($gallerycount>$gallerycountmax): // all images after first 3 or 4 based on $gallerycountmax value ?>
                                                <li><a href="<?php echo $upload['urlPath'] ?>"><img src="<?php echo $galleryimage; ?>" data-caption="<?php echo $upload['info1'] ?>" alt="<?php echo $upload['info1'] ?>"></a></li>
                                            <?php else: ?>
                                                <li class="clearing-featured-img hide"><a href="<?php echo $upload['urlPath'] ?>"><img src="<?php echo $galleryimage; ?>" data-caption="<?php echo $upload['info1'] ?>" alt="<?php echo $upload['info1'] ?>"></a></li>
                                            <?php endif ?>
                                        <?php endforeach ?>
                                    </ul>
                                </div>
                                <?php if ($yachtsRecord['photo_credit']): ?><p class="small">Crédit photo : <?php echo $yachtsRecord['photo_credit']; ?></p><?php endif ?>
                    <?php endif ?>

                    <?php echo $newsRecord['content'] ?>

                    <?php if ($newsRecord['embed']): ?>
                    <div class="flex-video">
                        <?php echo $newsRecord['embed'] ?>
                    </div>
                    <?php endif ?>

                    <?php echo $newsRecord['content_2'] ?>
                    
                    <?php if ($newsRecord['yacht']): ?>

                      <div class="layout-info">

                          <?php if ($yachtsRecord['guests_day']||$yachtsRecord['guests_night']||$yachtsRecord['crew']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    <?php if ($yachtsRecord['guests_night']): ?><p>Invités</p><?php endif ?>
                                    <?php if ($yachtsRecord['guests_day']): ?><p>Invités (Jour)</p><?php endif ?>
                                    <?php if ($yachtsRecord['crew']): ?><p>Crew</p><?php endif ?>
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <?php if ($yachtsRecord['guests_night']): ?><p><?php echo $yachtsRecord['guests_night'] ?></p><?php endif ?>
                                  <?php if ($yachtsRecord['guests_day']): ?><p><?php echo $yachtsRecord['guests_day'] ?></p><?php endif ?>
                                  <?php if ($yachtsRecord['crew']): ?><p><?php echo $yachtsRecord['crew'] ?></p><?php endif ?>
                              </div>
                          </div>
                          <?php endif ?>
                          
                          <?php if ($yachtsRecord['cabins']||$yachtsRecord['accommodation_fr']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    <?php if ($yachtsRecord['cabins']): ?><p>Cabins</p><?php endif ?>
                                    <?php if ($yachtsRecord['accommodation_fr']): ?><p>Hébergement</p><?php endif ?>
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <?php if ($yachtsRecord['cabins']): ?><p><?php echo $yachtsRecord['cabins'] ?></p><?php endif ?>
                                  <?php if ($yachtsRecord['accommodation_fr']): ?><p><?php echo $yachtsRecord['accommodation_fr'] ?></p><?php endif ?>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['events_fr']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    <?php if ($yachtsRecord['events_fr']): ?><p>Événements</p><?php endif ?>
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <?php if ($yachtsRecord['events_fr']): ?><p><?php echo $yachtsRecord['events_fr'] ?></p><?php endif ?>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['entertainment_fr']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Divertissement
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['entertainment_fr'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['leisure_fr']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Loisirs
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['leisure_fr'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['equipment_fr']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Equipement
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['equipment_fr'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['communications_fr']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Moyens de communication
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['communications_fr'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['flag']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Drapeau
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['flag'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['design_fr']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Design
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['design_fr'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['design']): ?>
                            <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Design extérieur
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['design'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['design_interior']): ?>
                            <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Design d'intérieur
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['design_interior'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['builder']): ?>
                            <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Constructeur
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['builder'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>


                          <?php if ($yachtsRecord['built']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Construction
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['built'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['refit']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Dernière rénovation
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['refit'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['yacht_length']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Longueur
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['yacht_length'] ?>m, <?php echo round($yachtsRecord['yacht_length'] * 3.2808399); ?>'</p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['yacht_beam']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Largeur
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['yacht_beam'] ?>m, <?php echo round($yachtsRecord['yacht_beam'] * 3.2808399); ?>'</p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['yacht_draft']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Tirant d’eau
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['yacht_draft'] ?>m, <?php echo round($yachtsRecord['yacht_draft'] * 3.2808399); ?>'</p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['tonnage']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Tonnage
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['tonnage'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['engines']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Moteurs
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['engines'] ?></p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['fuel_capacity']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Réservoir de carburant
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['fuel_capacity'] ?> l, <?php echo round($yachtsRecord['fuel_capacity'] * 0.264172); ?> g</p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['fuel_consumption']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Consommation de carburant
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['fuel_consumption'] ?> l, <?php echo round($yachtsRecord['fuel_consumption'] * 0.264172); ?> g (par heure)</p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['water_capacity']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Réservoir d’eau
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['water_capacity'] ?> l, <?php echo round($yachtsRecord['water_capacity'] * 0.264172); ?> g</p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['cruising_speed']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Vitesse de croisière
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['cruising_speed'] ?> kts</p>
                              </div>
                          </div>
                          <?php endif ?>

                          <?php if ($yachtsRecord['maximum_speed']): ?>
                          <hr>
                          <div class="row">
                              <div class="medium-3 column">
                                  <div class="grey">
                                    Vitesse maximum
                                  </div>
                              </div>
                              <div class="medium-9 column">
                                  <p><?php echo $yachtsRecord['maximum_speed'] ?> kts</p>
                              </div>
                          </div>
                          <?php endif ?>
                      </div>
                    <?php endif ?>

                    <!-- Go to www.addthis.com/dashboard to customize your tools -->
                    <div class="addthis_sharing_toolbox"></div>

                      <?php if ($newsRecord['show_comments'] == "1"): ?>
                      <div class="news_comments">
                          <h2>Comments</h2>
                          <div id="disqus_thread"></div>
                          <script type="text/javascript">
                              /* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
                              var disqus_shortname = 'luxurychartergroup'; // required: replace example with your forum shortname

                              /* * * DON'T EDIT BELOW THIS LINE * * */
                              (function() {
                                  var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
                                  dsq.src = '//' + disqus_shortname + '.disqus.com/embed.js';
                                  (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
                              })();
                          </script>
                          <noscript>Please enable JavaScript to view the <a href="https://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
                      </div>
                      <?php endif ?>

                      <?php // Get latest blog posts 
                        $thisblogID = $newsRecord['num'];
                        // load records from 'news/blog' for promo
                        list($newsRecords, $newsMetaData) = getRecords(array(
                          'tableName'   => 'news_fr',
                          'limit'       => '4',
                          'loadUploads' => true,
                          'allowSearch' => false,
                          'where'       => 'active ="1"' . " AND num !='". mysql_escape($thisblogID) ."'",
                          'useSeoUrls'    => true,
                          // 'debugSql' => true,
                        ));
                      ?>

                      <?php if ($newsRecords): ?>
                      <div class="feature-block-wrapper">
                      <h2>Latest Blog Posts</h2>
                      <?php foreach ($newsRecords as $record): ?>

                      <div class="feature-block">
                          <div class="row">
                              <?php if ($record['list_image']): ?>
                              <div class="small-12 medium-4 column">
                                  <?php foreach ($record['list_image'] as $index => $upload): ?>
                                  <?php if ($upload['thumbWidth'] > "250"): ?>
                                      <?php $newsimage = $upload['thumbUrlPath2'] ?>
                                  <?php else: ?>
                                      <?php $newsimage = $upload['urlPath'] ?>
                                  <?php endif ?>
                                  <a href="/<?php echo $settingsRecord['french_directory'] ?><?php echo strtolower($record['_link']) ?>"><img src="<?php echo $newsimage ?>" alt="<?php echo htmlencode($record['title']) ?>" /></a><?php break ?>
                                  <?php endforeach ?>
                              </div>
                              <?php endif ?>
                              <div class="small-12 medium-8 column">
                                  <h3 class="block-feature-title"><a href="/<?php echo $settingsRecord['french_directory'] ?><?php echo strtolower($record['_link']) ?>"><?php echo htmlencode($record['title']) ?></a></h3>
                                  <p><?php echo htmlencode($record['intro']) ?> <a href="/<?php echo $settingsRecord['french_directory'] ?><?php echo strtolower($record['_link']) ?>">En savoir plus</a></p>
                              </div>
                          </div>
                      </div>
                      <?php endforeach ?>
                      </div>
                      <?php endif ?>

                      <div class="disclaimer">
                          <p><?php echo $settingsRecord['disclaimer_fr'] ?></p>
                      </div>

                    </div>

                </div>

            </div>
            <div class="large-3 large-offset-1 column sidebar">

<? include("includes/search-box.php"); ?>

              <div class="widget">
                <div class="widget-inner">
                  <div class="nav-tree">
                      <h3>Blog Categories</h3>
                      <?php
                        list($news_categoriesRecords, $news_categoriesMetaData) = getRecords(array(
                          'tableName'   => 'news_categories',
                          'loadUploads' => false,
                          'allowSearch' => false,
                          'useSeoUrls'  => true,
                        ));
                      ?>
                      <ul class="no-bullet sidebar-nav">
                        <?php foreach ($news_categoriesRecords as $catrecord): ?>
                        <li><a href="/<?php echo $settingsRecord['french_directory'] ?>/blog.php?category=<?php echo $catrecord['num'] ?>"><?php echo htmlencode($catrecord['title_fr']) ?></a></li>
                        <?php endforeach ?>
                      </ul>
                  </div>
                </div>
              </div>

              <div class="widget widget-broker-contact">
                  <a name="request"></a>
                  <div class="widget-inner widget-inner-leader">
                      <div class="row">
  <? include("includes/broker.php"); ?>
                      </div>
                  </div>
                  <div class="widget-inner">
                      <h4>Se Renseigner</h4>
                      <div class="row sidebar-contact ">
  <? include("includes/form-sidebar.php"); ?>
                      </div>
                  </div>
              </div>

            </div>
        </div>

</div>

</div><!-- /#content-->

<? include("includes/footer.php"); ?>

<!-- close the off-canvas menu -->
<a class="exit-off-canvas"></a>

</div><!-- .inner-wrap -->
</div><!-- .off-canvas-wrap -->

<? include("includes/footer-scripts.php"); ?>

<!-- Go to www.addthis.com/dashboard to customize your tools -->
<script type="text/javascript" src="//s7.addthis.com/js/300/addthis_widget.js#pubid=ra-56e60227646a2bdb"></script>

</body>
</html>
