function browseUploaded($kunena_db, $option, $type) { $kunena_db =& JFactory::getDBO(); $kunena_config = KunenaFactory::getConfig(); if ($type) { $extensionsAllowed = explode(',', $kunena_config->imagetypes); } else { $extensionsAllowed = explode(',', $kunena_config->filetypes); } // type = 1 -> images ; type = 0 -> files $image_types = explode(',', $kunena_config->imagemimetypes); $imageTypes = array(); foreach ($image_types as $images) { $imageTypes[] = "'" . trim($images) . "'"; } $imageTypes = implode(',', $imageTypes); if ($type) { $where = ' WHERE filetype IN (' . $imageTypes . ')'; } else { $where = ' WHERE filetype NOT IN (' . $imageTypes . ')'; } $query = "SELECT a.*, b.catid, b.thread FROM #__kunena_attachments AS a LEFT JOIN #__kunena_messages AS b ON a.mesid=b.id {$where}"; $kunena_db->setQuery($query); $uploaded = $kunena_db->loadObjectlist(); if (KunenaError::checkDatabaseError()) { return; } html_Kunena::browseUploaded($option, $uploaded, $type); }
function browseUploaded($kunena_db, $option, $type) { $kunena_db =& JFactory::getDBO(); if ($type) { //we're doing images $dir = @opendir(KUNENA_PATH_UPLOADED . DS . 'images'); $uploaded_path = KUNENA_PATH_UPLOADED . DS . 'images'; } else { //we're doing regular files $dir = @opendir(KUNENA_PATH_UPLOADED . DS . 'files'); $uploaded_path = KUNENA_PATH_UPLOADED . DS . 'files'; } $uploaded = array(); $uploaded_col_count = 0; while ($file = @readdir($dir)) { if ($file != '.' && $file != '..' && $file != 'index.php' && is_file($uploaded_path . DS . $file) && !is_link($uploaded_path . DS . $file)) { //if( preg_match('/(\.gif$|\.png$|\.jpg|\.jpeg)$/is', $file) ) //{ $uploaded[$uploaded_col_count] = $file; $uploaded_name[$uploaded_col_count] = ucfirst(str_replace("_", " ", preg_replace('/^(.*)\\..*$/', '\\1', $file))); $uploaded_col_count++; //} } } @closedir($dir); @ksort($uploaded); @reset($uploaded); html_Kunena::browseUploaded($option, $uploaded, $uploaded_path, $type); }