<?php

$inDB=cmsDatabase::getInstance();

$sql='SELECT f.file, f.description FROM  cms_photo_files AS f JOIN cms_photo_albums AS a ON f.album_id=a.id WHERE a.title="Slider" AND f.published=1 ORDER BY f.title';

$res=$inDB->query($sql) ;

$arr=array();

if($inDB->num_rows($res)){

  while($row = $inDB->fetch_assoc($res)){

    $arr[ $row['file'] ] = $row['description'];

  }

}else return;

?>

<link href="/includes/myphp/carousel/carousel.css" type="text/css" rel="stylesheet" />

<!--<script type="text/javascript" src="/includes/myphp/carousel/jquery-1.7.1.min.js"></script>-->

<script type="text/javascript" src="/includes/myphp/carousel/jquery.carouFredSel.js"></script>

 

<div class="block-index"><div class="block">

<ul id="index-carousel">

<?php

$s='';

foreach($arr as $k => $v){

  preg_match('/href\s*=\s*[\'"]([^\'"]+?)[\'"]/i', $v, $link);

  $link=(isset($link[1])) ? $link[1] : ''; 

  $s.='<li><div class="img">';

  if($link) $s.='<a href="'.$link.'">';

  $s.='<img src="/images/photos/medium/'.$k.'" />';

  if($link) $s.='</a>';

  $s.='</div><div class="title">'.$v.'</div>';

  $s.='</li>';

}

echo $s;

?>

 

</ul>

<div class="block-pagination">

  <div id="index-pagination" class="pagination"></div>

</div>

</div></div>

 

<script type="text/javascript">

                $("#index-carousel").carouFredSel({

                               items : {width : 400 }, 

                               curcular: true,

                               infinite: false,

                               auto: 5000,

                               pagination  : "#index-pagination",

                               scroll: {

                                               pauseOnHover: true

                               }

                });

</script>