| Server IP : 49.231.201.246 / Your IP : 216.73.216.149 Web Server : Apache/2.4.18 (Ubuntu) System : Linux 246 4.4.0-210-generic #242-Ubuntu SMP Fri Apr 16 09:57:56 UTC 2021 x86_64 User : root ( 0) PHP Version : 7.0.33-0ubuntu0.16.04.16 Disable Function : exec,passthru,shell_exec,system,proc_open,popen,pcntl_exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/old/libraries/kunena/forum/message/attachment/ |
Upload File : |
<?php
/**
* Kunena Component
* @package Kunena.Framework
* @subpackage Forum.Message.Attachment
*
* @copyright (C) 2008 - 2014 Kunena Team. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL
* @link http://www.kunena.org
**/
defined ( '_JEXEC' ) or die ();
/**
* Kunena Forum Message Attachment Helper Class
*/
abstract class KunenaForumMessageAttachmentHelper {
/**
* @var KunenaForumMessageAttachment[]
*/
protected static $_instances = array();
protected static $_messages = array();
/**
* Returns KunenaForumMessageAttachment object.
*
* @param int $identifier The attachment to load - Can be only an integer.
* @param bool $reload
*
* @return KunenaForumMessageAttachment
*/
static public function get($identifier = null, $reload = false) {
if ($identifier instanceof KunenaForumMessageAttachment) {
return $identifier;
}
$id = intval ( $identifier );
if ($id < 1)
return new KunenaForumMessageAttachment ();
if ($reload || empty ( self::$_instances [$id] )) {
self::$_instances [$id] = new KunenaForumMessageAttachment ( $id );
self::$_messages [self::$_instances [$id]->mesid][$id] = self::$_instances [$id];
}
return self::$_instances [$id];
}
/**
* @param bool|array|int $ids
* @param string $authorise
*
* @return KunenaForumMessageAttachment[]
*/
static public function getById($ids = false, $authorise='read') {
if ($ids === false) {
return self::$_instances;
} elseif (is_array ($ids) ) {
$ids = array_unique($ids);
} else {
$ids = array($ids);
}
if (empty($ids)) return array();
self::loadById($ids);
$list = array ();
foreach ( $ids as $id ) {
if (!empty(self::$_instances [$id]) && self::$_instances [$id]->authorise($authorise, null, true)) {
$list [$id] = self::$_instances [$id];
}
}
return $list;
}
/**
* @param bool|array|int $ids
* @param string $authorise
*
* @return KunenaForumMessageAttachment[]
*/
static public function getByMessage($ids = false, $authorise='read') {
if ($ids === false) {
return self::$_instances;
} elseif (is_array ($ids) ) {
$ids2 = array();
foreach ($ids as $id) {
if ($id instanceof KunenaForumMessage) $id = $id->id;
$ids2[(int)$id] = (int)$id;
}
$ids = $ids2;
} else {
$ids = array($ids);
}
if (empty($ids)) return array();
self::loadByMessage($ids);
$list = array ();
foreach ( $ids as $id ) {
if (!empty(self::$_messages [$id])) {
foreach (self::$_messages [$id] as $instance) {
/** @var KunenaForumMessageAttachment $instance */
if ($instance->authorise($authorise, null, true)) {
$list [$instance->id] = $instance;
}
}
}
}
return $list;
}
/**
* @param mixed $category
* @param null $user
*
* @return array
*/
static public function getExtensions($category, $user = null) {
$imagetypes = self::getImageExtensions($category, $user);
$filetypes = self::getFileExtensions($category, $user);
if ($imagetypes === false && $filetypes === false) return false;
return (array) array_merge((array)$imagetypes, (array)$filetypes);
}
/**
* @param mixed $category
* @param mixed $user
*
* @return array|bool
*/
static public function getImageExtensions($category = null, $user = null) {
if ($category !== null) $category = KunenaForumCategoryHelper::get($category);
$user = KunenaUserHelper::get($user);
$config = KunenaFactory::getConfig();
$types = explode(',', $config->imagetypes);
foreach ($types as &$type) {
$type = trim($type);
if (empty($type)) unset ($type);
}
// Check if attachments are allowed at all
if (!$config->image_upload) return false;
if ($config->image_upload == 'everybody') return $types;
// For now on we only allow registered users
if (!$user->exists()) return false;
if ($config->image_upload == 'registered') return $types;
// For now on we only allow moderators
if (!$user->isModerator($category)) return false;
if ($config->image_upload == 'moderator') return $types;
// For now on we only allow administrators
if (!$user->isAdmin($category)) return false;
if ( $config->image_upload == 'admin') return $types;
return false;
}
/**
* @param mixed $category
* @param mixed $user
*
* @return array|bool
*/
static public function getFileExtensions($category = null, $user = null) {
$category = KunenaForumCategoryHelper::get($category);
$user = KunenaUserHelper::get($user);
$config = KunenaFactory::getConfig();
$types = explode(',', $config->filetypes);
foreach ($types as &$type) {
$type = trim($type);
if (empty($type)) unset ($type);
}
// Check if attachments are allowed at all
if (!$config->file_upload) return false;
if ($config->file_upload == 'everybody') return $types;
// For now on we only allow registered users
if (!$user->exists()) return false;
if ($config->file_upload == 'registered') return $types;
// For now on we only allow moderators
if (!$user->isModerator($category)) return false;
if ($config->file_upload == 'moderator') return $types;
// For now on we only allow administrators
if (!$user->isAdmin($category)) return false;
if ( $config->file_upload == 'admin') return $types;
return false;
}
/**
* @return bool
*/
static public function cleanup() {
$db = JFactory::getDBO ();
// Find up to 50 orphan attachments and delete them
$query = "SELECT a.* FROM #__kunena_attachments AS a LEFT JOIN #__kunena_messages AS m ON a.mesid=m.id WHERE m.id IS NULL";
$db->setQuery ( $query, 0, 50 );
$results = (array) $db->loadAssocList ('id');
if (KunenaError::checkDatabaseError ()) return false;
if (empty($results)) return true;
foreach ($results as $result) {
$instance = new KunenaForumMessageAttachment ();
$instance->bind ( $result );
$instance->exists(false);
unset ($instance);
}
$ids = implode(',', array_keys($results));
unset ($results);
$query = "DELETE FROM #__kunena_attachments WHERE id IN ($ids)";
$db->setQuery ( $query );
$db->query ();
return KunenaError::checkDatabaseError ();
}
/**
* This function shortens long filenames for display purposes.
* The first 8 characters of the filename, followed by three dots
* and the last 5 character of the filename.
*
* @param string $filename Filename to be shortened.
* @param int $front
* @param int $back
* @param string $filler
*
* @return string
*/
public static function shortenFilename($filename, $front=10, $back=8, $filler='...') {
$len = strlen($filename);
if ($len>($front+strlen($filler)+$back)){
$output=substr($filename,0,$front).$filler.substr($filename,$len-$back,$back);
}else{
$output=$filename;
}
return $output;
}
/**
* @param mixed $user
* @param array $params
*
* @return KunenaForumMessageAttachment[]
*/
public static function getByUserid($user, array $params) {
if ( $params['file'] == '1' && $params['image'] != '1' ) $filetype = " AND filetype=''";
elseif ( $params['image'] == '1' && $params['file'] != '1' ) $filetype = " AND filetype!=''";
elseif ( $params['file'] == '1' && $params['image'] == '1' ) $filetype = '';
else return array();
if ( $params['orderby'] == 'desc' ) $orderby = ' ORDER BY id DESC';
else $orderby = ' ORDER BY id ASC';
$db = JFactory::getDBO ();
$query = "SELECT * FROM #__kunena_attachments WHERE userid='$user->userid' $filetype $orderby";
$db->setQuery ( $query, 0, $params['limit'] );
$results = $db->loadAssocList ('id');
KunenaError::checkDatabaseError ();
$list = array();
foreach ( $results as $result ) {
$id = $result['id'];
if (!isset(self::$_instances [$id])) {
$instance = new KunenaForumMessageAttachment ();
$instance->bind ( $result );
$instance->exists(true);
self::$_instances [$id] = $instance;
self::$_messages [$instance->mesid][$id] = $instance;
}
$list[] = self::$_instances[$id];
}
return $list;
}
// Internal functions
/**
* @param array $ids
*/
static protected function loadById(array $ids) {
foreach ($ids as $i=>$id) {
if (isset(self::$_instances [$id]))
unset($ids[$i]);
}
if (empty($ids))
return;
$idlist = implode(',', $ids);
$db = JFactory::getDBO ();
$query = "SELECT * FROM #__kunena_attachments WHERE id IN ({$idlist})";
$db->setQuery ( $query );
$results = (array) $db->loadAssocList ('id');
KunenaError::checkDatabaseError ();
foreach ( $ids as $id ) {
if (isset($results[$id])) {
$instance = new KunenaForumMessageAttachment ();
$instance->bind ( $results[$id] );
$instance->exists(true);
self::$_instances [$id] = $instance;
self::$_messages [$instance->mesid][$id] = $instance;
} else {
self::$_instances [$id] = null;
}
}
unset ($results);
}
/**
* @param array $ids
*/
static protected function loadByMessage(array $ids) {
foreach ($ids as $i=>$id) {
$id = intval($id);
if (!$id || isset(self::$_messages [$id]))
unset($ids[$i]);
}
if (empty($ids))
return;
$idlist = implode(',', $ids);
$db = JFactory::getDBO ();
$query = "SELECT * FROM #__kunena_attachments WHERE mesid IN ({$idlist})";
$db->setQuery ( $query );
$results = (array) $db->loadAssocList ('id');
KunenaError::checkDatabaseError ();
foreach ( $ids as $mesid ) {
if (!isset(self::$_messages [$mesid])) {
self::$_messages [$mesid] = array();
}
}
foreach ( $results as $id=>$result ) {
$instance = new KunenaForumMessageAttachment ();
$instance->bind ( $result );
$instance->exists(true);
self::$_instances [$id] = $instance;
self::$_messages [$instance->mesid][$id] = $instance;
}
unset ($results);
}
}