function recursiveFolderSearch($dir, $data)
{
$returnstring = '';
foreach ($data as $val) {
if ($val['f_id'] == $dir) {
if ($val['f_aktiv'] == 1 && $val['f_trash'] == 0) {
if ($val['f_pid']) {
$returnstring .= $val['f_id'];
$returnstring .= recursiveFolderSearch($val['f_pid'], $data);
} elseif ($val['f_pid'] == 0) {
//toplevel
$returnstring .= $val['f_id'];
$returnstring .= 0;
}
} else {
//if not active or deleted
$returnstring .= $val['f_id'];
$returnstring .= 'abort';
}
break;
}
}
return $returnstring;
}
$mod_sliderjs['br_sliderjs']['imagesdata'] = json_decode($content['br_sliderjs']['jqs_imagedata'], true);
//data will get all images, we loop through all folders and add the images for each folder
/*
TODO
jqs_folders has the order from the CP with sort order of the folders they had when
the CP was last saved, but this could have changed since
*/
//get all file-folders from DB
$mod_sliderjs['br_sliderjs']['fldr_sql'] = "SELECT * FROM " . DB_PREPEND . "phpwcms_file WHERE f_kid=0";
$mod_sliderjs['br_sliderjs']['fldr_data'] = _dbQuery($mod_sliderjs['br_sliderjs']['fldr_sql']);
//will get the images
$mod_sliderjs['br_sliderjs']['data'] = array();
//loop through all folders
foreach ($content['br_sliderjs']['jqs_folders'] as $key => $val) {
//first check if curr folder and all its parents are active and not deleted
if (strpos(recursiveFolderSearch($val, $mod_sliderjs['br_sliderjs']['fldr_data']), 'abort')) {
//something pathupwards is inactive therfore do nothing
$mod_sliderjs['br_sliderjs']['img_sql_data'] = array();
} else {
//phpwcms images - get only active and not deleted images with curr parent
$mod_sliderjs['br_sliderjs']['img_sql'] = "SELECT * FROM " . DB_PREPEND . "phpwcms_file ";
$mod_sliderjs['br_sliderjs']['img_sql'] .= "WHERE f_pid=" . $val . " ";
$mod_sliderjs['br_sliderjs']['img_sql'] .= "AND f_aktiv=1 AND f_trash=0 AND f_kid=1 AND f_ext IN ('jpeg', 'jpg', 'png', 'gif') ";
$mod_sliderjs['br_sliderjs']['img_sql'] .= "ORDER BY f_sort, f_name";
//join deprecated
// $mod_sliderjs['br_sliderjs']['img_sql'] = "SELECT f1.* FROM " . DB_PREPEND . "phpwcms_file AS f1 JOIN " . DB_PREPEND . "phpwcms_file AS f2 ON f1.f_pid = f2.f_id ";
// $mod_sliderjs['br_sliderjs']['img_sql'] .= "WHERE f2.f_id=".$val." ";
// $mod_sliderjs['br_sliderjs']['img_sql'] .= "AND f2.f_aktiv=1 AND f2.f_kid=0 AND f2.f_trash=0 ";
// $mod_sliderjs['br_sliderjs']['img_sql'] .= "AND f1.f_aktiv=1 AND f1.f_trash=0 AND f1.f_kid=1 AND f1.f_ext IN ('jpeg', 'jpg', 'png', 'gif') ";
// $mod_sliderjs['br_sliderjs']['img_sql'] .= "ORDER BY f1.f_sort, f1.f_name";
$mod_sliderjs['br_sliderjs']['img_sql_data'] = _dbQuery($mod_sliderjs['br_sliderjs']['img_sql']);
