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']);