12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022 |
- <?php
- /**
- * Simple elFinder driver for MySQL.
- *
- * @author Dmitry (dio) Levashov
- **/
- class elFinderVolumeMySQL extends elFinderVolumeDriver
- {
- /**
- * Driver id
- * Must be started from letter and contains [a-z0-9]
- * Used as part of volume id
- *
- * @var string
- **/
- protected $driverId = 'm';
- /**
- * Database object
- *
- * @var mysqli
- **/
- protected $db = null;
- /**
- * Tables to store files
- *
- * @var string
- **/
- protected $tbf = '';
- /**
- * Directory for tmp files
- * If not set driver will try to use tmbDir as tmpDir
- *
- * @var string
- **/
- protected $tmpPath = '';
- /**
- * Numbers of sql requests (for debug)
- *
- * @var int
- **/
- protected $sqlCnt = 0;
- /**
- * Last db error message
- *
- * @var string
- **/
- protected $dbError = '';
- /**
- * This root has parent id
- *
- * @var boolean
- */
- protected $rootHasParent = false;
- /**
- * Constructor
- * Extend options with required fields
- *
- * @author Dmitry (dio) Levashov
- */
- public function __construct()
- {
- $opts = array(
- 'host' => 'localhost',
- 'user' => '',
- 'pass' => '',
- 'db' => '',
- 'port' => null,
- 'socket' => null,
- 'files_table' => 'elfinder_file',
- 'tmbPath' => '',
- 'tmpPath' => '',
- 'rootCssClass' => 'elfinder-navbar-root-sql',
- 'noSessionCache' => array('hasdirs'),
- 'isLocalhost' => false
- );
- $this->options = array_merge($this->options, $opts);
- $this->options['mimeDetect'] = 'internal';
- }
- /*********************************************************************/
- /* INIT AND CONFIGURE */
- /*********************************************************************/
- /**
- * Prepare driver before mount volume.
- * Connect to db, check required tables and fetch root path
- *
- * @return bool
- * @author Dmitry (dio) Levashov
- **/
- protected function init()
- {
- if (!($this->options['host'] || $this->options['socket'])
- || !$this->options['user']
- || !$this->options['pass']
- || !$this->options['db']
- || !$this->options['path']
- || !$this->options['files_table']) {
- return $this->setError('Required options "host", "socket", "user", "pass", "db", "path" or "files_table" are undefined.');
- }
- $err = null;
- if ($this->db = @new mysqli($this->options['host'], $this->options['user'], $this->options['pass'], $this->options['db'], $this->options['port'], $this->options['socket'])) {
- if ($this->db && $this->db->connect_error) {
- $err = $this->db->connect_error;
- }
- } else {
- $err = mysqli_connect_error();
- }
- if ($err) {
- return $this->setError(array('Unable to connect to MySQL server.', $err));
- }
- if (!$this->needOnline && empty($this->ARGS['init'])) {
- $this->db->close();
- $this->db = null;
- return true;
- }
- $this->db->set_charset('utf8');
- if ($res = $this->db->query('SHOW TABLES')) {
- while ($row = $res->fetch_array()) {
- if ($row[0] == $this->options['files_table']) {
- $this->tbf = $this->options['files_table'];
- break;
- }
- }
- }
- if (!$this->tbf) {
- return $this->setError('The specified database table cannot be found.');
- }
- $this->updateCache($this->options['path'], $this->_stat($this->options['path']));
- // enable command archive
- $this->options['useRemoteArchive'] = true;
- // check isLocalhost
- $this->isLocalhost = $this->options['isLocalhost'] || $this->options['host'] === 'localhost' || $this->options['host'] === '127.0.0.1' || $this->options['host'] === '::1';
- return true;
- }
- /**
- * Set tmp path
- *
- * @return void
- * @throws elFinderAbortException
- * @author Dmitry (dio) Levashov
- */
- protected function configure()
- {
- parent::configure();
- if (($tmp = $this->options['tmpPath'])) {
- if (!file_exists($tmp)) {
- if (mkdir($tmp)) {
- chmod($tmp, $this->options['tmbPathMode']);
- }
- }
- $this->tmpPath = is_dir($tmp) && is_writable($tmp) ? $tmp : false;
- }
- if (!$this->tmpPath && ($tmp = elFinder::getStaticVar('commonTempPath'))) {
- $this->tmpPath = $tmp;
- }
- // fallback of $this->tmp
- if (!$this->tmpPath && $this->tmbPathWritable) {
- $this->tmpPath = $this->tmbPath;
- }
- $this->mimeDetect = 'internal';
- }
- /**
- * Close connection
- *
- * @return void
- * @author Dmitry (dio) Levashov
- **/
- public function umount()
- {
- $this->db && $this->db->close();
- }
- /**
- * Return debug info for client
- *
- * @return array
- * @author Dmitry (dio) Levashov
- **/
- public function debug()
- {
- $debug = parent::debug();
- $debug['sqlCount'] = $this->sqlCnt;
- if ($this->dbError) {
- $debug['dbError'] = $this->dbError;
- }
- return $debug;
- }
- /**
- * Perform sql query and return result.
- * Increase sqlCnt and save error if occured
- *
- * @param string $sql query
- *
- * @return bool|mysqli_result
- * @author Dmitry (dio) Levashov
- */
- protected function query($sql)
- {
- $this->sqlCnt++;
- $res = $this->db->query($sql);
- if (!$res) {
- $this->dbError = $this->db->error;
- }
- return $res;
- }
- /**
- * Create empty object with required mimetype
- *
- * @param string $path parent dir path
- * @param string $name object name
- * @param string $mime mime type
- *
- * @return bool
- * @author Dmitry (dio) Levashov
- **/
- protected function make($path, $name, $mime)
- {
- $sql = 'INSERT INTO %s (`parent_id`, `name`, `size`, `mtime`, `mime`, `content`, `read`, `write`, `locked`, `hidden`, `width`, `height`) VALUES (\'%s\', \'%s\', 0, %d, \'%s\', \'\', \'%d\', \'%d\', \'%d\', \'%d\', 0, 0)';
- $sql = sprintf($sql, $this->tbf, $path, $this->db->real_escape_string($name), time(), $mime, $this->defaults['read'], $this->defaults['write'], $this->defaults['locked'], $this->defaults['hidden']);
- // echo $sql;
- return $this->query($sql) && $this->db->affected_rows > 0;
- }
- /*********************************************************************/
- /* FS API */
- /*********************************************************************/
- /**
- * Cache dir contents
- *
- * @param string $path dir path
- *
- * @return string
- * @author Dmitry Levashov
- **/
- protected function cacheDir($path)
- {
- $this->dirsCache[$path] = array();
- $sql = 'SELECT f.id, f.parent_id, f.name, f.size, f.mtime AS ts, f.mime, f.read, f.write, f.locked, f.hidden, f.width, f.height, IF(ch.id, 1, 0) AS dirs
- FROM ' . $this->tbf . ' AS f
- LEFT JOIN ' . $this->tbf . ' AS ch ON ch.parent_id=f.id AND ch.mime=\'directory\'
- WHERE f.parent_id=\'' . $path . '\'
- GROUP BY f.id, ch.id';
- $res = $this->query($sql);
- if ($res) {
- while ($row = $res->fetch_assoc()) {
- $id = $row['id'];
- if ($row['parent_id'] && $id != $this->root) {
- $row['phash'] = $this->encode($row['parent_id']);
- }
- if ($row['mime'] == 'directory') {
- unset($row['width']);
- unset($row['height']);
- $row['size'] = 0;
- } else {
- unset($row['dirs']);
- }
- unset($row['id']);
- unset($row['parent_id']);
- if (($stat = $this->updateCache($id, $row)) && empty($stat['hidden'])) {
- $this->dirsCache[$path][] = $id;
- }
- }
- }
- return $this->dirsCache[$path];
- }
- /**
- * Return array of parents paths (ids)
- *
- * @param int $path file path (id)
- *
- * @return array
- * @author Dmitry (dio) Levashov
- **/
- protected function getParents($path)
- {
- $parents = array();
- while ($path) {
- if ($file = $this->stat($path)) {
- array_unshift($parents, $path);
- $path = isset($file['phash']) ? $this->decode($file['phash']) : false;
- }
- }
- if (count($parents)) {
- array_pop($parents);
- }
- return $parents;
- }
- /**
- * Return correct file path for LOAD_FILE method
- *
- * @param string $path file path (id)
- *
- * @return string
- * @author Troex Nevelin
- **/
- protected function loadFilePath($path)
- {
- $realPath = realpath($path);
- if (DIRECTORY_SEPARATOR == '\\') { // windows
- $realPath = str_replace('\\', '\\\\', $realPath);
- }
- return $this->db->real_escape_string($realPath);
- }
- /**
- * Recursive files search
- *
- * @param string $path dir path
- * @param string $q search string
- * @param array $mimes
- *
- * @return array
- * @throws elFinderAbortException
- * @author Dmitry (dio) Levashov
- */
- protected function doSearch($path, $q, $mimes)
- {
- if (!empty($this->doSearchCurrentQuery['matchMethod'])) {
- // has custom match method use elFinderVolumeDriver::doSearch()
- return parent::doSearch($path, $q, $mimes);
- }
- $dirs = array();
- $timeout = $this->options['searchTimeout'] ? $this->searchStart + $this->options['searchTimeout'] : 0;
- if ($path != $this->root || $this->rootHasParent) {
- $dirs = $inpath = array(intval($path));
- while ($inpath) {
- $in = '(' . join(',', $inpath) . ')';
- $inpath = array();
- $sql = 'SELECT f.id FROM %s AS f WHERE f.parent_id IN ' . $in . ' AND `mime` = \'directory\'';
- $sql = sprintf($sql, $this->tbf);
- if ($res = $this->query($sql)) {
- $_dir = array();
- while ($dat = $res->fetch_assoc()) {
- $inpath[] = $dat['id'];
- }
- $dirs = array_merge($dirs, $inpath);
- }
- }
- }
- $result = array();
- if ($mimes) {
- $whrs = array();
- foreach ($mimes as $mime) {
- if (strpos($mime, '/') === false) {
- $whrs[] = sprintf('f.mime LIKE \'%s/%%\'', $this->db->real_escape_string($mime));
- } else {
- $whrs[] = sprintf('f.mime = \'%s\'', $this->db->real_escape_string($mime));
- }
- }
- $whr = join(' OR ', $whrs);
- } else {
- $whr = sprintf('f.name LIKE \'%%%s%%\'', $this->db->real_escape_string($q));
- }
- if ($dirs) {
- $whr = '(' . $whr . ') AND (`parent_id` IN (' . join(',', $dirs) . '))';
- }
- $sql = 'SELECT f.id, f.parent_id, f.name, f.size, f.mtime AS ts, f.mime, f.read, f.write, f.locked, f.hidden, f.width, f.height, 0 AS dirs
- FROM %s AS f
- WHERE %s';
- $sql = sprintf($sql, $this->tbf, $whr);
- if (($res = $this->query($sql))) {
- while ($row = $res->fetch_assoc()) {
- if ($timeout && $timeout < time()) {
- $this->setError(elFinder::ERROR_SEARCH_TIMEOUT, $this->path($this->encode($path)));
- break;
- }
- if (!$this->mimeAccepted($row['mime'], $mimes)) {
- continue;
- }
- $id = $row['id'];
- if ($id == $this->root) {
- continue;
- }
- if ($row['parent_id'] && $id != $this->root) {
- $row['phash'] = $this->encode($row['parent_id']);
- }
- $row['path'] = $this->_path($id);
- if ($row['mime'] == 'directory') {
- unset($row['width']);
- unset($row['height']);
- } else {
- unset($row['dirs']);
- }
- unset($row['id']);
- unset($row['parent_id']);
- if (($stat = $this->updateCache($id, $row)) && empty($stat['hidden'])) {
- $result[] = $stat;
- }
- }
- }
- return $result;
- }
- /*********************** paths/urls *************************/
- /**
- * Return parent directory path
- *
- * @param string $path file path
- *
- * @return string
- * @author Dmitry (dio) Levashov
- **/
- protected function _dirname($path)
- {
- return ($stat = $this->stat($path)) ? (!empty($stat['phash']) ? $this->decode($stat['phash']) : $this->root) : false;
- }
- /**
- * Return file name
- *
- * @param string $path file path
- *
- * @return string
- * @author Dmitry (dio) Levashov
- **/
- protected function _basename($path)
- {
- return (($stat = $this->stat($path)) && isset($stat['name'])) ? $stat['name'] : false;
- }
- /**
- * Join dir name and file name and return full path
- *
- * @param string $dir
- * @param string $name
- *
- * @return string
- * @author Dmitry (dio) Levashov
- **/
- protected function _joinPath($dir, $name)
- {
- $sql = 'SELECT id FROM ' . $this->tbf . ' WHERE parent_id=\'' . $dir . '\' AND name=\'' . $this->db->real_escape_string($name) . '\'';
- if (($res = $this->query($sql)) && ($r = $res->fetch_assoc())) {
- $this->updateCache($r['id'], $this->_stat($r['id']));
- return $r['id'];
- }
- return -1;
- }
- /**
- * Return normalized path, this works the same as os.path.normpath() in Python
- *
- * @param string $path path
- *
- * @return string
- * @author Troex Nevelin
- **/
- protected function _normpath($path)
- {
- return $path;
- }
- /**
- * Return file path related to root dir
- *
- * @param string $path file path
- *
- * @return string
- * @author Dmitry (dio) Levashov
- **/
- protected function _relpath($path)
- {
- return $path;
- }
- /**
- * Convert path related to root dir into real path
- *
- * @param string $path file path
- *
- * @return string
- * @author Dmitry (dio) Levashov
- **/
- protected function _abspath($path)
- {
- return $path;
- }
- /**
- * Return fake path started from root dir
- *
- * @param string $path file path
- *
- * @return string
- * @author Dmitry (dio) Levashov
- **/
- protected function _path($path)
- {
- if (($file = $this->stat($path)) == false) {
- return '';
- }
- $parentsIds = $this->getParents($path);
- $path = '';
- foreach ($parentsIds as $id) {
- $dir = $this->stat($id);
- $path .= $dir['name'] . $this->separator;
- }
- return $path . $file['name'];
- }
- /**
- * Return true if $path is children of $parent
- *
- * @param string $path path to check
- * @param string $parent parent path
- *
- * @return bool
- * @author Dmitry (dio) Levashov
- **/
- protected function _inpath($path, $parent)
- {
- return $path == $parent
- ? true
- : in_array($parent, $this->getParents($path));
- }
- /***************** file stat ********************/
- /**
- * Return stat for given path.
- * Stat contains following fields:
- * - (int) size file size in b. required
- * - (int) ts file modification time in unix time. required
- * - (string) mime mimetype. required for folders, others - optionally
- * - (bool) read read permissions. required
- * - (bool) write write permissions. required
- * - (bool) locked is object locked. optionally
- * - (bool) hidden is object hidden. optionally
- * - (string) alias for symlinks - link target path relative to root path. optionally
- * - (string) target for symlinks - link target path. optionally
- * If file does not exists - returns empty array or false.
- *
- * @param string $path file path
- *
- * @return array|false
- * @author Dmitry (dio) Levashov
- **/
- protected function _stat($path)
- {
- $sql = 'SELECT f.id, f.parent_id, f.name, f.size, f.mtime AS ts, f.mime, f.read, f.write, f.locked, f.hidden, f.width, f.height, IF(ch.id, 1, 0) AS dirs
- FROM ' . $this->tbf . ' AS f
- LEFT JOIN ' . $this->tbf . ' AS ch ON ch.parent_id=f.id AND ch.mime=\'directory\'
- WHERE f.id=\'' . $path . '\'
- GROUP BY f.id, ch.id';
- $res = $this->query($sql);
- if ($res) {
- $stat = $res->fetch_assoc();
- if ($stat['id'] == $this->root) {
- $this->rootHasParent = true;
- $stat['parent_id'] = '';
- }
- if ($stat['parent_id']) {
- $stat['phash'] = $this->encode($stat['parent_id']);
- }
- if ($stat['mime'] == 'directory') {
- unset($stat['width']);
- unset($stat['height']);
- $stat['size'] = 0;
- } else {
- if (!$stat['mime']) {
- unset($stat['mime']);
- }
- unset($stat['dirs']);
- }
- unset($stat['id']);
- unset($stat['parent_id']);
- return $stat;
- }
- return array();
- }
- /**
- * Return true if path is dir and has at least one childs directory
- *
- * @param string $path dir path
- *
- * @return bool
- * @author Dmitry (dio) Levashov
- **/
- protected function _subdirs($path)
- {
- return ($stat = $this->stat($path)) && isset($stat['dirs']) ? $stat['dirs'] : false;
- }
- /**
- * Return object width and height
- * Usualy used for images, but can be realize for video etc...
- *
- * @param string $path file path
- * @param string $mime file mime type
- *
- * @return string
- * @author Dmitry (dio) Levashov
- **/
- protected function _dimensions($path, $mime)
- {
- return ($stat = $this->stat($path)) && isset($stat['width']) && isset($stat['height']) ? $stat['width'] . 'x' . $stat['height'] : '';
- }
- /******************** file/dir content *********************/
- /**
- * Return files list in directory.
- *
- * @param string $path dir path
- *
- * @return array
- * @author Dmitry (dio) Levashov
- **/
- protected function _scandir($path)
- {
- return isset($this->dirsCache[$path])
- ? $this->dirsCache[$path]
- : $this->cacheDir($path);
- }
- /**
- * Open file and return file pointer
- *
- * @param string $path file path
- * @param string $mode open file mode (ignored in this driver)
- *
- * @return resource|false
- * @author Dmitry (dio) Levashov
- **/
- protected function _fopen($path, $mode = 'rb')
- {
- $fp = $this->tmpPath
- ? fopen($this->getTempFile($path), 'w+')
- : $this->tmpfile();
- if ($fp) {
- if (($res = $this->query('SELECT content FROM ' . $this->tbf . ' WHERE id=\'' . $path . '\''))
- && ($r = $res->fetch_assoc())) {
- fwrite($fp, $r['content']);
- rewind($fp);
- return $fp;
- } else {
- $this->_fclose($fp, $path);
- }
- }
- return false;
- }
- /**
- * Close opened file
- *
- * @param resource $fp file pointer
- * @param string $path
- *
- * @return void
- * @author Dmitry (dio) Levashov
- */
- protected function _fclose($fp, $path = '')
- {
- is_resource($fp) && fclose($fp);
- if ($path) {
- $file = $this->getTempFile($path);
- is_file($file) && unlink($file);
- }
- }
- /******************** file/dir manipulations *************************/
- /**
- * Create dir and return created dir path or false on failed
- *
- * @param string $path parent dir path
- * @param string $name new directory name
- *
- * @return string|bool
- * @author Dmitry (dio) Levashov
- **/
- protected function _mkdir($path, $name)
- {
- return $this->make($path, $name, 'directory') ? $this->_joinPath($path, $name) : false;
- }
- /**
- * Create file and return it's path or false on failed
- *
- * @param string $path parent dir path
- * @param string $name new file name
- *
- * @return string|bool
- * @author Dmitry (dio) Levashov
- **/
- protected function _mkfile($path, $name)
- {
- return $this->make($path, $name, '') ? $this->_joinPath($path, $name) : false;
- }
- /**
- * Create symlink. FTP driver does not support symlinks.
- *
- * @param string $target link target
- * @param string $path symlink path
- * @param string $name
- *
- * @return bool
- * @author Dmitry (dio) Levashov
- */
- protected function _symlink($target, $path, $name)
- {
- return false;
- }
- /**
- * Copy file into another file
- *
- * @param string $source source file path
- * @param string $targetDir target directory path
- * @param string $name new file name
- *
- * @return bool
- * @author Dmitry (dio) Levashov
- **/
- protected function _copy($source, $targetDir, $name)
- {
- $this->clearcache();
- $id = $this->_joinPath($targetDir, $name);
- $sql = $id > 0
- ? sprintf('REPLACE INTO %s (id, parent_id, name, content, size, mtime, mime, width, height, `read`, `write`, `locked`, `hidden`) (SELECT %d, %d, name, content, size, mtime, mime, width, height, `read`, `write`, `locked`, `hidden` FROM %s WHERE id=%d)', $this->tbf, $id, $this->_dirname($id), $this->tbf, $source)
- : sprintf('INSERT INTO %s (parent_id, name, content, size, mtime, mime, width, height, `read`, `write`, `locked`, `hidden`) SELECT %d, \'%s\', content, size, %d, mime, width, height, `read`, `write`, `locked`, `hidden` FROM %s WHERE id=%d', $this->tbf, $targetDir, $this->db->real_escape_string($name), time(), $this->tbf, $source);
- return $this->query($sql);
- }
- /**
- * Move file into another parent dir.
- * Return new file path or false.
- *
- * @param string $source source file path
- * @param $targetDir
- * @param string $name file name
- *
- * @return bool|string
- * @internal param string $target target dir path
- * @author Dmitry (dio) Levashov
- */
- protected function _move($source, $targetDir, $name)
- {
- $sql = 'UPDATE %s SET parent_id=%d, name=\'%s\' WHERE id=%d LIMIT 1';
- $sql = sprintf($sql, $this->tbf, $targetDir, $this->db->real_escape_string($name), $source);
- return $this->query($sql) && $this->db->affected_rows > 0 ? $source : false;
- }
- /**
- * Remove file
- *
- * @param string $path file path
- *
- * @return bool
- * @author Dmitry (dio) Levashov
- **/
- protected function _unlink($path)
- {
- return $this->query(sprintf('DELETE FROM %s WHERE id=%d AND mime!=\'directory\' LIMIT 1', $this->tbf, $path)) && $this->db->affected_rows;
- }
- /**
- * Remove dir
- *
- * @param string $path dir path
- *
- * @return bool
- * @author Dmitry (dio) Levashov
- **/
- protected function _rmdir($path)
- {
- return $this->query(sprintf('DELETE FROM %s WHERE id=%d AND mime=\'directory\' LIMIT 1', $this->tbf, $path)) && $this->db->affected_rows;
- }
- /**
- * undocumented function
- *
- * @param $path
- * @param $fp
- *
- * @author Dmitry Levashov
- */
- protected function _setContent($path, $fp)
- {
- elFinder::rewind($fp);
- $fstat = fstat($fp);
- $size = $fstat['size'];
- }
- /**
- * Create new file and write into it from file pointer.
- * Return new file path or false on error.
- *
- * @param resource $fp file pointer
- * @param string $dir target dir path
- * @param string $name file name
- * @param array $stat file stat (required by some virtual fs)
- *
- * @return bool|string
- * @author Dmitry (dio) Levashov
- **/
- protected function _save($fp, $dir, $name, $stat)
- {
- $this->clearcache();
- $mime = !empty($stat['mime']) ? $stat['mime'] : $this->mimetype($name, true);
- $w = !empty($stat['width']) ? $stat['width'] : 0;
- $h = !empty($stat['height']) ? $stat['height'] : 0;
- $ts = !empty($stat['ts']) ? $stat['ts'] : time();
- $id = $this->_joinPath($dir, $name);
- if (!isset($stat['size'])) {
- $stat = fstat($fp);
- $size = $stat['size'];
- } else {
- $size = $stat['size'];
- }
- if ($this->isLocalhost && ($tmpfile = tempnam($this->tmpPath, $this->id))) {
- if (($trgfp = fopen($tmpfile, 'wb')) == false) {
- unlink($tmpfile);
- } else {
- elFinder::rewind($fp);
- stream_copy_to_stream($fp, $trgfp);
- fclose($trgfp);
- chmod($tmpfile, 0644);
- $sql = $id > 0
- ? 'REPLACE INTO %s (id, parent_id, name, content, size, mtime, mime, width, height) VALUES (' . $id . ', %d, \'%s\', LOAD_FILE(\'%s\'), %d, %d, \'%s\', %d, %d)'
- : 'INSERT INTO %s (parent_id, name, content, size, mtime, mime, width, height) VALUES (%d, \'%s\', LOAD_FILE(\'%s\'), %d, %d, \'%s\', %d, %d)';
- $sql = sprintf($sql, $this->tbf, $dir, $this->db->real_escape_string($name), $this->loadFilePath($tmpfile), $size, $ts, $mime, $w, $h);
- $res = $this->query($sql);
- unlink($tmpfile);
- if ($res) {
- return $id > 0 ? $id : $this->db->insert_id;
- }
- }
- }
- $content = '';
- elFinder::rewind($fp);
- while (!feof($fp)) {
- $content .= fread($fp, 8192);
- }
- $sql = $id > 0
- ? 'REPLACE INTO %s (id, parent_id, name, content, size, mtime, mime, width, height) VALUES (' . $id . ', %d, \'%s\', \'%s\', %d, %d, \'%s\', %d, %d)'
- : 'INSERT INTO %s (parent_id, name, content, size, mtime, mime, width, height) VALUES (%d, \'%s\', \'%s\', %d, %d, \'%s\', %d, %d)';
- $sql = sprintf($sql, $this->tbf, $dir, $this->db->real_escape_string($name), $this->db->real_escape_string($content), $size, $ts, $mime, $w, $h);
- unset($content);
- if ($this->query($sql)) {
- return $id > 0 ? $id : $this->db->insert_id;
- }
- return false;
- }
- /**
- * Get file contents
- *
- * @param string $path file path
- *
- * @return string|false
- * @author Dmitry (dio) Levashov
- **/
- protected function _getContents($path)
- {
- return ($res = $this->query(sprintf('SELECT content FROM %s WHERE id=%d', $this->tbf, $path))) && ($r = $res->fetch_assoc()) ? $r['content'] : false;
- }
- /**
- * Write a string to a file
- *
- * @param string $path file path
- * @param string $content new file content
- *
- * @return bool
- * @author Dmitry (dio) Levashov
- **/
- protected function _filePutContents($path, $content)
- {
- return $this->query(sprintf('UPDATE %s SET content=\'%s\', size=%d, mtime=%d WHERE id=%d LIMIT 1', $this->tbf, $this->db->real_escape_string($content), strlen($content), time(), $path));
- }
- /**
- * Detect available archivers
- *
- * @return void
- **/
- protected function _checkArchivers()
- {
- return;
- }
- /**
- * chmod implementation
- *
- * @param string $path
- * @param string $mode
- *
- * @return bool
- */
- protected function _chmod($path, $mode)
- {
- return false;
- }
- /**
- * Unpack archive
- *
- * @param string $path archive path
- * @param array $arc archiver command and arguments (same as in $this->archivers)
- *
- * @return void
- * @author Dmitry (dio) Levashov
- * @author Alexey Sukhotin
- **/
- protected function _unpack($path, $arc)
- {
- return;
- }
- /**
- * Extract files from archive
- *
- * @param string $path archive path
- * @param array $arc archiver command and arguments (same as in $this->archivers)
- *
- * @return true
- * @author Dmitry (dio) Levashov,
- * @author Alexey Sukhotin
- **/
- protected function _extract($path, $arc)
- {
- return false;
- }
- /**
- * Create archive and return its path
- *
- * @param string $dir target dir
- * @param array $files files names list
- * @param string $name archive name
- * @param array $arc archiver options
- *
- * @return string|bool
- * @author Dmitry (dio) Levashov,
- * @author Alexey Sukhotin
- **/
- protected function _archive($dir, $files, $name, $arc)
- {
- return false;
- }
- } // END class
|