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);
}
