1
|
|
|
<?php |
2
|
|
|
|
3
|
|
|
/** |
4
|
|
|
* Simple elFinder driver for MySQL. |
5
|
|
|
* |
6
|
|
|
* @author Dmitry (dio) Levashov |
7
|
|
|
**/ |
8
|
|
|
class elFinderVolumeMySQL extends elFinderVolumeDriver { |
|
|
|
|
9
|
|
|
|
10
|
|
|
/** |
11
|
|
|
* Driver id |
12
|
|
|
* Must be started from letter and contains [a-z0-9] |
13
|
|
|
* Used as part of volume id |
14
|
|
|
* |
15
|
|
|
* @var string |
16
|
|
|
**/ |
17
|
|
|
protected $driverId = 'm'; |
18
|
|
|
|
19
|
|
|
/** |
20
|
|
|
* Database object |
21
|
|
|
* |
22
|
|
|
* @var mysqli |
23
|
|
|
**/ |
24
|
|
|
protected $db = null; |
25
|
|
|
|
26
|
|
|
/** |
27
|
|
|
* Tables to store files |
28
|
|
|
* |
29
|
|
|
* @var string |
30
|
|
|
**/ |
31
|
|
|
protected $tbf = ''; |
32
|
|
|
|
33
|
|
|
/** |
34
|
|
|
* Directory for tmp files |
35
|
|
|
* If not set driver will try to use tmbDir as tmpDir |
36
|
|
|
* |
37
|
|
|
* @var string |
38
|
|
|
**/ |
39
|
|
|
protected $tmpPath = ''; |
40
|
|
|
|
41
|
|
|
/** |
42
|
|
|
* Numbers of sql requests (for debug) |
43
|
|
|
* |
44
|
|
|
* @var int |
45
|
|
|
**/ |
46
|
|
|
protected $sqlCnt = 0; |
47
|
|
|
|
48
|
|
|
/** |
49
|
|
|
* Last db error message |
50
|
|
|
* |
51
|
|
|
* @var string |
52
|
|
|
**/ |
53
|
|
|
protected $dbError = ''; |
54
|
|
|
|
55
|
|
|
/** |
56
|
|
|
* Constructor |
57
|
|
|
* Extend options with required fields |
58
|
|
|
* |
59
|
|
|
* @return void |
|
|
|
|
60
|
|
|
* @author Dmitry (dio) Levashov |
61
|
|
|
**/ |
62
|
|
|
public function __construct() { |
63
|
|
|
$opts = array( |
64
|
|
|
'host' => 'localhost', |
65
|
|
|
'user' => '', |
66
|
|
|
'pass' => '', |
67
|
|
|
'db' => '', |
68
|
|
|
'port' => null, |
69
|
|
|
'socket' => null, |
70
|
|
|
'files_table' => 'elfinder_file', |
71
|
|
|
'tmbPath' => '', |
72
|
|
|
'tmpPath' => '', |
73
|
|
|
'rootCssClass' => 'elfinder-navbar-root-sql' |
74
|
|
|
); |
75
|
|
|
$this->options = array_merge($this->options, $opts); |
76
|
|
|
$this->options['mimeDetect'] = 'internal'; |
77
|
|
|
} |
78
|
|
|
|
79
|
|
|
/*********************************************************************/ |
80
|
|
|
/* INIT AND CONFIGURE */ |
81
|
|
|
/*********************************************************************/ |
82
|
|
|
|
83
|
|
|
/** |
84
|
|
|
* Prepare driver before mount volume. |
85
|
|
|
* Connect to db, check required tables and fetch root path |
86
|
|
|
* |
87
|
|
|
* @return bool |
88
|
|
|
* @author Dmitry (dio) Levashov |
89
|
|
|
**/ |
90
|
|
|
protected function init() { |
91
|
|
|
|
92
|
|
|
if (!($this->options['host'] || $this->options['socket']) |
93
|
|
|
|| !$this->options['user'] |
94
|
|
|
|| !$this->options['pass'] |
95
|
|
|
|| !$this->options['db'] |
96
|
|
|
|| !$this->options['path'] |
97
|
|
|
|| !$this->options['files_table']) { |
98
|
|
|
return false; |
99
|
|
|
} |
100
|
|
|
|
101
|
|
|
|
102
|
|
|
$this->db = new mysqli($this->options['host'], $this->options['user'], $this->options['pass'], $this->options['db'], $this->options['port'], $this->options['socket']); |
103
|
|
|
if ($this->db->connect_error || @mysqli_connect_error()) { |
|
|
|
|
104
|
|
|
return false; |
105
|
|
|
} |
106
|
|
|
|
107
|
|
|
$this->db->set_charset('utf8'); |
108
|
|
|
|
109
|
|
|
if ($res = $this->db->query('SHOW TABLES')) { |
110
|
|
|
while ($row = $res->fetch_array()) { |
111
|
|
|
if ($row[0] == $this->options['files_table']) { |
112
|
|
|
$this->tbf = $this->options['files_table']; |
113
|
|
|
break; |
114
|
|
|
} |
115
|
|
|
} |
116
|
|
|
} |
117
|
|
|
|
118
|
|
|
if (!$this->tbf) { |
119
|
|
|
return false; |
120
|
|
|
} |
121
|
|
|
|
122
|
|
|
$this->updateCache($this->options['path'], $this->_stat($this->options['path'])); |
|
|
|
|
123
|
|
|
|
124
|
|
|
return true; |
125
|
|
|
} |
126
|
|
|
|
127
|
|
|
|
128
|
|
|
|
129
|
|
|
/** |
130
|
|
|
* Set tmp path |
131
|
|
|
* |
132
|
|
|
* @return void |
133
|
|
|
* @author Dmitry (dio) Levashov |
134
|
|
|
**/ |
135
|
|
|
protected function configure() { |
136
|
|
|
parent::configure(); |
137
|
|
|
|
138
|
|
|
if (($tmp = $this->options['tmpPath'])) { |
139
|
|
View Code Duplication |
if (!file_exists($tmp)) { |
|
|
|
|
140
|
|
|
if (@mkdir($tmp)) { |
141
|
|
|
@chmod($tmp, $this->options['tmbPathMode']); |
|
|
|
|
142
|
|
|
} |
143
|
|
|
} |
144
|
|
|
|
145
|
|
|
$this->tmpPath = is_dir($tmp) && is_writable($tmp) ? $tmp : false; |
146
|
|
|
} |
147
|
|
|
|
148
|
|
|
if (!$this->tmpPath && $this->tmbPath && $this->tmbPathWritable) { |
149
|
|
|
$this->tmpPath = $this->tmbPath; |
150
|
|
|
} |
151
|
|
|
|
152
|
|
|
$this->mimeDetect = 'internal'; |
153
|
|
|
} |
154
|
|
|
|
155
|
|
|
/** |
156
|
|
|
* Close connection |
157
|
|
|
* |
158
|
|
|
* @return void |
159
|
|
|
* @author Dmitry (dio) Levashov |
160
|
|
|
**/ |
161
|
|
|
public function umount() { |
162
|
|
|
$this->db->close(); |
163
|
|
|
} |
164
|
|
|
|
165
|
|
|
/** |
166
|
|
|
* Return debug info for client |
167
|
|
|
* |
168
|
|
|
* @return array |
169
|
|
|
* @author Dmitry (dio) Levashov |
170
|
|
|
**/ |
171
|
|
|
public function debug() { |
172
|
|
|
$debug = parent::debug(); |
173
|
|
|
$debug['sqlCount'] = $this->sqlCnt; |
174
|
|
|
if ($this->dbError) { |
175
|
|
|
$debug['dbError'] = $this->dbError; |
176
|
|
|
} |
177
|
|
|
return $debug; |
178
|
|
|
} |
179
|
|
|
|
180
|
|
|
/** |
181
|
|
|
* Perform sql query and return result. |
182
|
|
|
* Increase sqlCnt and save error if occured |
183
|
|
|
* |
184
|
|
|
* @param string $sql query |
185
|
|
|
* @return misc |
186
|
|
|
* @author Dmitry (dio) Levashov |
187
|
|
|
**/ |
188
|
|
|
protected function query($sql) { |
189
|
|
|
$this->sqlCnt++; |
190
|
|
|
$res = $this->db->query($sql); |
191
|
|
|
if (!$res) { |
192
|
|
|
$this->dbError = $this->db->error; |
|
|
|
|
193
|
|
|
} |
194
|
|
|
return $res; |
195
|
|
|
} |
196
|
|
|
|
197
|
|
|
/** |
198
|
|
|
* Create empty object with required mimetype |
199
|
|
|
* |
200
|
|
|
* @param string $path parent dir path |
201
|
|
|
* @param string $name object name |
202
|
|
|
* @param string $mime mime type |
203
|
|
|
* @return bool |
204
|
|
|
* @author Dmitry (dio) Levashov |
205
|
|
|
**/ |
206
|
|
|
protected function make($path, $name, $mime) { |
207
|
|
|
$sql = 'INSERT INTO %s (`parent_id`, `name`, `size`, `mtime`, `mime`, `content`, `read`, `write`) VALUES ("%s", "%s", 0, %d, "%s", "", "%d", "%d")'; |
208
|
|
|
$sql = sprintf($sql, $this->tbf, $path, $this->db->real_escape_string($name), time(), $mime, $this->defaults['read'], $this->defaults['write']); |
209
|
|
|
// echo $sql; |
210
|
|
|
return $this->query($sql) && $this->db->affected_rows > 0; |
|
|
|
|
211
|
|
|
} |
212
|
|
|
|
213
|
|
|
/*********************************************************************/ |
214
|
|
|
/* FS API */ |
215
|
|
|
/*********************************************************************/ |
216
|
|
|
|
217
|
|
|
/** |
218
|
|
|
* Cache dir contents |
219
|
|
|
* |
220
|
|
|
* @param string $path dir path |
221
|
|
|
* @return void |
222
|
|
|
* @author Dmitry Levashov |
223
|
|
|
**/ |
224
|
|
|
protected function cacheDir($path) { |
225
|
|
|
$this->dirsCache[$path] = array(); |
226
|
|
|
|
227
|
|
|
$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 |
228
|
|
|
FROM '.$this->tbf.' AS f |
229
|
|
|
LEFT JOIN '.$this->tbf.' AS ch ON ch.parent_id=f.id AND ch.mime="directory" |
230
|
|
|
WHERE f.parent_id="'.$path.'" |
231
|
|
|
GROUP BY f.id'; |
232
|
|
|
|
233
|
|
|
$res = $this->query($sql); |
234
|
|
|
if ($res) { |
235
|
|
|
while ($row = $res->fetch_assoc()) { |
236
|
|
|
// debug($row); |
|
|
|
|
237
|
|
|
$id = $row['id']; |
238
|
|
|
if ($row['parent_id']) { |
239
|
|
|
$row['phash'] = $this->encode($row['parent_id']); |
240
|
|
|
} |
241
|
|
|
|
242
|
|
View Code Duplication |
if ($row['mime'] == 'directory') { |
|
|
|
|
243
|
|
|
unset($row['width']); |
244
|
|
|
unset($row['height']); |
245
|
|
|
} else { |
246
|
|
|
unset($row['dirs']); |
247
|
|
|
} |
248
|
|
|
|
249
|
|
|
unset($row['id']); |
250
|
|
|
unset($row['parent_id']); |
251
|
|
|
|
252
|
|
|
|
253
|
|
|
|
254
|
|
|
if (($stat = $this->updateCache($id, $row)) && empty($stat['hidden'])) { |
255
|
|
|
$this->dirsCache[$path][] = $id; |
256
|
|
|
} |
257
|
|
|
} |
258
|
|
|
} |
259
|
|
|
|
260
|
|
|
return $this->dirsCache[$path]; |
261
|
|
|
} |
262
|
|
|
|
263
|
|
|
/** |
264
|
|
|
* Return array of parents paths (ids) |
265
|
|
|
* |
266
|
|
|
* @param int $path file path (id) |
267
|
|
|
* @return array |
268
|
|
|
* @author Dmitry (dio) Levashov |
269
|
|
|
**/ |
270
|
|
|
protected function getParents($path) { |
271
|
|
|
$parents = array(); |
272
|
|
|
|
273
|
|
|
while ($path) { |
274
|
|
|
if ($file = $this->stat($path)) { |
275
|
|
|
array_unshift($parents, $path); |
276
|
|
|
$path = isset($file['phash']) ? $this->decode($file['phash']) : false; |
277
|
|
|
} |
278
|
|
|
} |
279
|
|
|
|
280
|
|
|
if (count($parents)) { |
281
|
|
|
array_pop($parents); |
282
|
|
|
} |
283
|
|
|
return $parents; |
284
|
|
|
} |
285
|
|
|
|
286
|
|
|
/** |
287
|
|
|
* Return correct file path for LOAD_FILE method |
288
|
|
|
* |
289
|
|
|
* @param string $path file path (id) |
290
|
|
|
* @return string |
291
|
|
|
* @author Troex Nevelin |
292
|
|
|
**/ |
293
|
|
|
protected function loadFilePath($path) { |
294
|
|
|
$realPath = realpath($path); |
295
|
|
|
if (DIRECTORY_SEPARATOR == '\\') { // windows |
296
|
|
|
$realPath = str_replace('\\', '\\\\', $realPath); |
297
|
|
|
} |
298
|
|
|
return $this->db->real_escape_string($realPath); |
299
|
|
|
} |
300
|
|
|
|
301
|
|
|
/** |
302
|
|
|
* Recursive files search |
303
|
|
|
* |
304
|
|
|
* @param string $path dir path |
305
|
|
|
* @param string $q search string |
306
|
|
|
* @param array $mimes |
307
|
|
|
* @return array |
308
|
|
|
* @author Dmitry (dio) Levashov |
309
|
|
|
**/ |
310
|
|
|
protected function doSearch($path, $q, $mimes) { |
311
|
|
|
$dirs = array(); |
312
|
|
|
$timeout = $this->options['searchTimeout']? $this->searchStart + $this->options['searchTimeout'] : 0; |
313
|
|
|
|
314
|
|
|
if ($path != $this->root) { |
315
|
|
|
$inpath = array(intval($path)); |
316
|
|
|
while($inpath) { |
|
|
|
|
317
|
|
|
$in = '('.join(',', $inpath).')'; |
318
|
|
|
$inpath = array(); |
319
|
|
|
$sql = 'SELECT f.id FROM %s AS f WHERE f.parent_id IN '.$in.' AND `mime` = \'directory\''; |
320
|
|
|
$sql = sprintf($sql, $this->tbf); |
321
|
|
|
if ($res = $this->query($sql)) { |
322
|
|
|
$_dir = array(); |
|
|
|
|
323
|
|
|
while ($dat = $res->fetch_assoc()) { |
324
|
|
|
$inpath[] = $dat['id']; |
325
|
|
|
} |
326
|
|
|
$dirs = array_merge($dirs, $inpath); |
327
|
|
|
} |
328
|
|
|
} |
329
|
|
|
} |
330
|
|
|
|
331
|
|
|
$result = array(); |
332
|
|
|
|
333
|
|
|
if ($mimes) { |
|
|
|
|
334
|
|
|
$whrs = array(); |
335
|
|
|
foreach($mimes as $mime) { |
336
|
|
|
if (strpos($mime, '/') === false) { |
337
|
|
|
$whrs[] = sprintf('f.mime LIKE "%s/%%"', $this->db->real_escape_string($mime)); |
338
|
|
|
} else { |
339
|
|
|
$whrs[] = sprintf('f.mime = "%s"', $this->db->real_escape_string($mime)); |
340
|
|
|
} |
341
|
|
|
} |
342
|
|
|
$whr = join(' OR ', $whrs); |
343
|
|
|
} else { |
344
|
|
|
$whr = sprintf('f.name RLIKE "%s"', $this->db->real_escape_string($q)); |
345
|
|
|
} |
346
|
|
|
if ($dirs) { |
|
|
|
|
347
|
|
|
$whr = '(' . $whr . ') AND (`parent_id` IN (' . join(',', $dirs) . '))'; |
348
|
|
|
} |
349
|
|
|
|
350
|
|
|
$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 |
351
|
|
|
FROM %s AS f |
352
|
|
|
WHERE %s'; |
353
|
|
|
|
354
|
|
|
$sql = sprintf($sql, $this->tbf, $whr); |
355
|
|
|
|
356
|
|
|
if (($res = $this->query($sql))) { |
357
|
|
|
while ($row = $res->fetch_assoc()) { |
358
|
|
View Code Duplication |
if ($timeout && $timeout < time()) { |
|
|
|
|
359
|
|
|
$this->setError(elFinder::ERROR_SEARCH_TIMEOUT, $this->path($this->encode($path))); |
360
|
|
|
break; |
361
|
|
|
} |
362
|
|
|
|
363
|
|
|
if (!$this->mimeAccepted($row['mime'], $mimes)) { |
|
|
|
|
364
|
|
|
continue; |
365
|
|
|
} |
366
|
|
|
$id = $row['id']; |
367
|
|
|
if ($row['parent_id']) { |
368
|
|
|
$row['phash'] = $this->encode($row['parent_id']); |
369
|
|
|
} |
370
|
|
|
$row['path'] = $this->_path($id); |
371
|
|
|
|
372
|
|
View Code Duplication |
if ($row['mime'] == 'directory') { |
|
|
|
|
373
|
|
|
unset($row['width']); |
374
|
|
|
unset($row['height']); |
375
|
|
|
} else { |
376
|
|
|
unset($row['dirs']); |
377
|
|
|
} |
378
|
|
|
|
379
|
|
|
unset($row['id']); |
380
|
|
|
unset($row['parent_id']); |
381
|
|
|
|
382
|
|
|
if (($stat = $this->updateCache($id, $row)) && empty($stat['hidden'])) { |
383
|
|
|
$result[] = $stat; |
384
|
|
|
} |
385
|
|
|
} |
386
|
|
|
} |
387
|
|
|
|
388
|
|
|
return $result; |
389
|
|
|
} |
390
|
|
|
|
391
|
|
|
|
392
|
|
|
/*********************** paths/urls *************************/ |
393
|
|
|
|
394
|
|
|
/** |
395
|
|
|
* Return parent directory path |
396
|
|
|
* |
397
|
|
|
* @param string $path file path |
398
|
|
|
* @return string |
399
|
|
|
* @author Dmitry (dio) Levashov |
400
|
|
|
**/ |
401
|
|
|
protected function _dirname($path) { |
402
|
|
|
return ($stat = $this->stat($path)) ? ($stat['phash'] ? $this->decode($stat['phash']) : $this->root) : false; |
|
|
|
|
403
|
|
|
} |
404
|
|
|
|
405
|
|
|
/** |
406
|
|
|
* Return file name |
407
|
|
|
* |
408
|
|
|
* @param string $path file path |
409
|
|
|
* @return string |
410
|
|
|
* @author Dmitry (dio) Levashov |
411
|
|
|
**/ |
412
|
|
|
protected function _basename($path) { |
413
|
|
|
return ($stat = $this->stat($path)) ? $stat['name'] : false; |
414
|
|
|
} |
415
|
|
|
|
416
|
|
|
/** |
417
|
|
|
* Join dir name and file name and return full path |
418
|
|
|
* |
419
|
|
|
* @param string $dir |
420
|
|
|
* @param string $name |
421
|
|
|
* @return string |
422
|
|
|
* @author Dmitry (dio) Levashov |
423
|
|
|
**/ |
424
|
|
|
protected function _joinPath($dir, $name) { |
425
|
|
|
$sql = 'SELECT id FROM '.$this->tbf.' WHERE parent_id="'.$dir.'" AND name="'.$this->db->real_escape_string($name).'"'; |
426
|
|
|
|
427
|
|
|
if (($res = $this->query($sql)) && ($r = $res->fetch_assoc())) { |
428
|
|
|
$this->updateCache($r['id'], $this->_stat($r['id'])); |
|
|
|
|
429
|
|
|
return $r['id']; |
430
|
|
|
} |
431
|
|
|
return -1; |
432
|
|
|
} |
433
|
|
|
|
434
|
|
|
/** |
435
|
|
|
* Return normalized path, this works the same as os.path.normpath() in Python |
436
|
|
|
* |
437
|
|
|
* @param string $path path |
438
|
|
|
* @return string |
439
|
|
|
* @author Troex Nevelin |
440
|
|
|
**/ |
441
|
|
|
protected function _normpath($path) { |
442
|
|
|
return $path; |
443
|
|
|
} |
444
|
|
|
|
445
|
|
|
/** |
446
|
|
|
* Return file path related to root dir |
447
|
|
|
* |
448
|
|
|
* @param string $path file path |
449
|
|
|
* @return string |
450
|
|
|
* @author Dmitry (dio) Levashov |
451
|
|
|
**/ |
452
|
|
|
protected function _relpath($path) { |
453
|
|
|
return $path; |
454
|
|
|
} |
455
|
|
|
|
456
|
|
|
/** |
457
|
|
|
* Convert path related to root dir into real path |
458
|
|
|
* |
459
|
|
|
* @param string $path file path |
460
|
|
|
* @return string |
461
|
|
|
* @author Dmitry (dio) Levashov |
462
|
|
|
**/ |
463
|
|
|
protected function _abspath($path) { |
464
|
|
|
return $path; |
465
|
|
|
} |
466
|
|
|
|
467
|
|
|
/** |
468
|
|
|
* Return fake path started from root dir |
469
|
|
|
* |
470
|
|
|
* @param string $path file path |
471
|
|
|
* @return string |
472
|
|
|
* @author Dmitry (dio) Levashov |
473
|
|
|
**/ |
474
|
|
|
protected function _path($path) { |
475
|
|
|
if (($file = $this->stat($path)) == false) { |
476
|
|
|
return ''; |
477
|
|
|
} |
478
|
|
|
|
479
|
|
|
$parentsIds = $this->getParents($path); |
480
|
|
|
$path = ''; |
481
|
|
|
foreach ($parentsIds as $id) { |
482
|
|
|
$dir = $this->stat($id); |
483
|
|
|
$path .= $dir['name'].$this->separator; |
484
|
|
|
} |
485
|
|
|
return $this->rootName.$this->separator.$path.$file['name']; |
486
|
|
|
} |
487
|
|
|
|
488
|
|
|
/** |
489
|
|
|
* Return true if $path is children of $parent |
490
|
|
|
* |
491
|
|
|
* @param string $path path to check |
492
|
|
|
* @param string $parent parent path |
493
|
|
|
* @return bool |
494
|
|
|
* @author Dmitry (dio) Levashov |
495
|
|
|
**/ |
496
|
|
|
protected function _inpath($path, $parent) { |
497
|
|
|
return $path == $parent |
498
|
|
|
? true |
499
|
|
|
: in_array($parent, $this->getParents($path)); |
500
|
|
|
} |
501
|
|
|
|
502
|
|
|
/***************** file stat ********************/ |
503
|
|
|
/** |
504
|
|
|
* Return stat for given path. |
505
|
|
|
* Stat contains following fields: |
506
|
|
|
* - (int) size file size in b. required |
507
|
|
|
* - (int) ts file modification time in unix time. required |
508
|
|
|
* - (string) mime mimetype. required for folders, others - optionally |
509
|
|
|
* - (bool) read read permissions. required |
510
|
|
|
* - (bool) write write permissions. required |
511
|
|
|
* - (bool) locked is object locked. optionally |
512
|
|
|
* - (bool) hidden is object hidden. optionally |
513
|
|
|
* - (string) alias for symlinks - link target path relative to root path. optionally |
514
|
|
|
* - (string) target for symlinks - link target path. optionally |
515
|
|
|
* |
516
|
|
|
* If file does not exists - returns empty array or false. |
517
|
|
|
* |
518
|
|
|
* @param string $path file path |
519
|
|
|
* @return array|false |
520
|
|
|
* @author Dmitry (dio) Levashov |
521
|
|
|
**/ |
522
|
|
|
protected function _stat($path) { |
523
|
|
|
$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 |
524
|
|
|
FROM '.$this->tbf.' AS f |
525
|
|
|
LEFT JOIN '.$this->tbf.' AS p ON p.id=f.parent_id |
526
|
|
|
LEFT JOIN '.$this->tbf.' AS ch ON ch.parent_id=f.id AND ch.mime="directory" |
527
|
|
|
WHERE f.id="'.$path.'" |
528
|
|
|
GROUP BY f.id'; |
529
|
|
|
|
530
|
|
|
$res = $this->query($sql); |
531
|
|
|
|
532
|
|
|
if ($res) { |
533
|
|
|
$stat = $res->fetch_assoc(); |
534
|
|
|
if ($stat['parent_id']) { |
535
|
|
|
$stat['phash'] = $this->encode($stat['parent_id']); |
536
|
|
|
} |
537
|
|
View Code Duplication |
if ($stat['mime'] == 'directory') { |
|
|
|
|
538
|
|
|
unset($stat['width']); |
539
|
|
|
unset($stat['height']); |
540
|
|
|
} else { |
541
|
|
|
unset($stat['dirs']); |
542
|
|
|
} |
543
|
|
|
unset($stat['id']); |
544
|
|
|
unset($stat['parent_id']); |
545
|
|
|
return $stat; |
546
|
|
|
|
547
|
|
|
} |
548
|
|
|
return array(); |
549
|
|
|
} |
550
|
|
|
|
551
|
|
|
/** |
552
|
|
|
* Return true if path is dir and has at least one childs directory |
553
|
|
|
* |
554
|
|
|
* @param string $path dir path |
555
|
|
|
* @return bool |
556
|
|
|
* @author Dmitry (dio) Levashov |
557
|
|
|
**/ |
558
|
|
|
protected function _subdirs($path) { |
559
|
|
|
return ($stat = $this->stat($path)) && isset($stat['dirs']) ? $stat['dirs'] : false; |
560
|
|
|
} |
561
|
|
|
|
562
|
|
|
/** |
563
|
|
|
* Return object width and height |
564
|
|
|
* Usualy used for images, but can be realize for video etc... |
565
|
|
|
* |
566
|
|
|
* @param string $path file path |
567
|
|
|
* @param string $mime file mime type |
568
|
|
|
* @return string |
569
|
|
|
* @author Dmitry (dio) Levashov |
570
|
|
|
**/ |
571
|
|
|
protected function _dimensions($path, $mime) { |
572
|
|
|
return ($stat = $this->stat($path)) && isset($stat['width']) && isset($stat['height']) ? $stat['width'].'x'.$stat['height'] : ''; |
573
|
|
|
} |
574
|
|
|
|
575
|
|
|
/******************** file/dir content *********************/ |
576
|
|
|
|
577
|
|
|
/** |
578
|
|
|
* Return files list in directory. |
579
|
|
|
* |
580
|
|
|
* @param string $path dir path |
581
|
|
|
* @return array |
582
|
|
|
* @author Dmitry (dio) Levashov |
583
|
|
|
**/ |
584
|
|
|
protected function _scandir($path) { |
585
|
|
|
return isset($this->dirsCache[$path]) |
586
|
|
|
? $this->dirsCache[$path] |
587
|
|
|
: $this->cacheDir($path); |
588
|
|
|
} |
589
|
|
|
|
590
|
|
|
/** |
591
|
|
|
* Open file and return file pointer |
592
|
|
|
* |
593
|
|
|
* @param string $path file path |
594
|
|
|
* @param string $mode open file mode (ignored in this driver) |
595
|
|
|
* @return resource|false |
596
|
|
|
* @author Dmitry (dio) Levashov |
597
|
|
|
**/ |
598
|
|
|
protected function _fopen($path, $mode='rb') { |
599
|
|
|
$fp = $this->tmbPath |
600
|
|
|
? @fopen($this->getTempFile($path), 'w+') |
601
|
|
|
: @tmpfile(); |
602
|
|
|
|
603
|
|
|
|
604
|
|
|
if ($fp) { |
605
|
|
|
if (($res = $this->query('SELECT content FROM '.$this->tbf.' WHERE id="'.$path.'"')) |
606
|
|
|
&& ($r = $res->fetch_assoc())) { |
607
|
|
|
fwrite($fp, $r['content']); |
608
|
|
|
rewind($fp); |
609
|
|
|
return $fp; |
610
|
|
|
} else { |
611
|
|
|
$this->_fclose($fp, $path); |
612
|
|
|
} |
613
|
|
|
} |
614
|
|
|
|
615
|
|
|
return false; |
616
|
|
|
} |
617
|
|
|
|
618
|
|
|
/** |
619
|
|
|
* Close opened file |
620
|
|
|
* |
621
|
|
|
* @param resource $fp file pointer |
622
|
|
|
* @return bool |
623
|
|
|
* @author Dmitry (dio) Levashov |
624
|
|
|
**/ |
625
|
|
|
protected function _fclose($fp, $path='') { |
626
|
|
|
@fclose($fp); |
|
|
|
|
627
|
|
|
if ($path) { |
628
|
|
|
@unlink($this->getTempFile($path)); |
|
|
|
|
629
|
|
|
} |
630
|
|
|
} |
631
|
|
|
|
632
|
|
|
/******************** file/dir manipulations *************************/ |
633
|
|
|
|
634
|
|
|
/** |
635
|
|
|
* Create dir and return created dir path or false on failed |
636
|
|
|
* |
637
|
|
|
* @param string $path parent dir path |
638
|
|
|
* @param string $name new directory name |
639
|
|
|
* @return string|bool |
640
|
|
|
* @author Dmitry (dio) Levashov |
641
|
|
|
**/ |
642
|
|
|
protected function _mkdir($path, $name) { |
643
|
|
|
return $this->make($path, $name, 'directory') ? $this->_joinPath($path, $name) : false; |
644
|
|
|
} |
645
|
|
|
|
646
|
|
|
/** |
647
|
|
|
* Create file and return it's path or false on failed |
648
|
|
|
* |
649
|
|
|
* @param string $path parent dir path |
650
|
|
|
* @param string $name new file name |
651
|
|
|
* @return string|bool |
652
|
|
|
* @author Dmitry (dio) Levashov |
653
|
|
|
**/ |
654
|
|
|
protected function _mkfile($path, $name) { |
655
|
|
|
return $this->make($path, $name, 'text/plain') ? $this->_joinPath($path, $name) : false; |
656
|
|
|
} |
657
|
|
|
|
658
|
|
|
/** |
659
|
|
|
* Create symlink. FTP driver does not support symlinks. |
660
|
|
|
* |
661
|
|
|
* @param string $target link target |
662
|
|
|
* @param string $path symlink path |
663
|
|
|
* @return bool |
664
|
|
|
* @author Dmitry (dio) Levashov |
665
|
|
|
**/ |
666
|
|
|
protected function _symlink($target, $path, $name) { |
667
|
|
|
return false; |
668
|
|
|
} |
669
|
|
|
|
670
|
|
|
/** |
671
|
|
|
* Copy file into another file |
672
|
|
|
* |
673
|
|
|
* @param string $source source file path |
674
|
|
|
* @param string $targetDir target directory path |
675
|
|
|
* @param string $name new file name |
676
|
|
|
* @return bool |
677
|
|
|
* @author Dmitry (dio) Levashov |
678
|
|
|
**/ |
679
|
|
|
protected function _copy($source, $targetDir, $name) { |
680
|
|
|
$this->clearcache(); |
681
|
|
|
$id = $this->_joinPath($targetDir, $name); |
682
|
|
|
|
683
|
|
|
$sql = $id > 0 |
684
|
|
|
? 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) |
685
|
|
|
: 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); |
686
|
|
|
|
687
|
|
|
return $this->query($sql); |
|
|
|
|
688
|
|
|
} |
689
|
|
|
|
690
|
|
|
/** |
691
|
|
|
* Move file into another parent dir. |
692
|
|
|
* Return new file path or false. |
693
|
|
|
* |
694
|
|
|
* @param string $source source file path |
695
|
|
|
* @param string $target target dir path |
|
|
|
|
696
|
|
|
* @param string $name file name |
697
|
|
|
* @return string|bool |
698
|
|
|
* @author Dmitry (dio) Levashov |
699
|
|
|
**/ |
700
|
|
|
protected function _move($source, $targetDir, $name) { |
701
|
|
|
$sql = 'UPDATE %s SET parent_id=%d, name="%s" WHERE id=%d LIMIT 1'; |
702
|
|
|
$sql = sprintf($sql, $this->tbf, $targetDir, $this->db->real_escape_string($name), $source); |
703
|
|
|
return $this->query($sql) && $this->db->affected_rows > 0 ? $source : false; |
|
|
|
|
704
|
|
|
} |
705
|
|
|
|
706
|
|
|
/** |
707
|
|
|
* Remove file |
708
|
|
|
* |
709
|
|
|
* @param string $path file path |
710
|
|
|
* @return bool |
711
|
|
|
* @author Dmitry (dio) Levashov |
712
|
|
|
**/ |
713
|
|
|
protected function _unlink($path) { |
714
|
|
|
return $this->query(sprintf('DELETE FROM %s WHERE id=%d AND mime!="directory" LIMIT 1', $this->tbf, $path)) && $this->db->affected_rows; |
|
|
|
|
715
|
|
|
} |
716
|
|
|
|
717
|
|
|
/** |
718
|
|
|
* Remove dir |
719
|
|
|
* |
720
|
|
|
* @param string $path dir path |
721
|
|
|
* @return bool |
722
|
|
|
* @author Dmitry (dio) Levashov |
723
|
|
|
**/ |
724
|
|
|
protected function _rmdir($path) { |
725
|
|
|
return $this->query(sprintf('DELETE FROM %s WHERE id=%d AND mime="directory" LIMIT 1', $this->tbf, $path)) && $this->db->affected_rows; |
|
|
|
|
726
|
|
|
} |
727
|
|
|
|
728
|
|
|
/** |
729
|
|
|
* undocumented function |
730
|
|
|
* |
731
|
|
|
* @return void |
732
|
|
|
* @author Dmitry Levashov |
733
|
|
|
**/ |
734
|
|
|
protected function _setContent($path, $fp) { |
|
|
|
|
735
|
|
|
rewind($fp); |
736
|
|
|
$fstat = fstat($fp); |
737
|
|
|
$size = $fstat['size']; |
|
|
|
|
738
|
|
|
|
739
|
|
|
|
740
|
|
|
} |
741
|
|
|
|
742
|
|
|
/** |
743
|
|
|
* Create new file and write into it from file pointer. |
744
|
|
|
* Return new file path or false on error. |
745
|
|
|
* |
746
|
|
|
* @param resource $fp file pointer |
747
|
|
|
* @param string $dir target dir path |
748
|
|
|
* @param string $name file name |
749
|
|
|
* @param array $stat file stat (required by some virtual fs) |
750
|
|
|
* @return bool|string |
751
|
|
|
* @author Dmitry (dio) Levashov |
752
|
|
|
**/ |
753
|
|
|
protected function _save($fp, $dir, $name, $stat) { |
754
|
|
|
$this->clearcache(); |
755
|
|
|
|
756
|
|
|
$mime = $stat['mime']; |
757
|
|
|
$w = !empty($stat['width']) ? $stat['width'] : 0; |
758
|
|
|
$h = !empty($stat['height']) ? $stat['height'] : 0; |
759
|
|
|
|
760
|
|
|
$id = $this->_joinPath($dir, $name); |
761
|
|
|
rewind($fp); |
762
|
|
|
$stat = fstat($fp); |
763
|
|
|
$size = $stat['size']; |
764
|
|
|
|
765
|
|
|
if (($tmpfile = tempnam($this->tmpPath, $this->id))) { |
766
|
|
|
if (($trgfp = fopen($tmpfile, 'wb')) == false) { |
767
|
|
|
unlink($tmpfile); |
768
|
|
|
} else { |
769
|
|
|
while (!feof($fp)) { |
770
|
|
|
fwrite($trgfp, fread($fp, 8192)); |
771
|
|
|
} |
772
|
|
|
fclose($trgfp); |
773
|
|
|
chmod($tmpfile, 0644); |
774
|
|
|
|
775
|
|
|
$sql = $id > 0 |
776
|
|
|
? '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)' |
777
|
|
|
: 'INSERT INTO %s (parent_id, name, content, size, mtime, mime, width, height) VALUES (%d, "%s", LOAD_FILE("%s"), %d, %d, "%s", %d, %d)'; |
778
|
|
|
$sql = sprintf($sql, $this->tbf, $dir, $this->db->real_escape_string($name), $this->loadFilePath($tmpfile), $size, time(), $mime, $w, $h); |
779
|
|
|
|
780
|
|
|
$res = $this->query($sql); |
781
|
|
|
unlink($tmpfile); |
782
|
|
|
|
783
|
|
|
if ($res) { |
784
|
|
|
return $id > 0 ? $id : $this->db->insert_id; |
|
|
|
|
785
|
|
|
} |
786
|
|
|
} |
787
|
|
|
} |
788
|
|
|
|
789
|
|
|
|
790
|
|
|
$content = ''; |
791
|
|
|
rewind($fp); |
792
|
|
|
while (!feof($fp)) { |
793
|
|
|
$content .= fread($fp, 8192); |
794
|
|
|
} |
795
|
|
|
|
796
|
|
|
$sql = $id > 0 |
797
|
|
|
? 'REPLACE INTO %s (id, parent_id, name, content, size, mtime, mime, width, height) VALUES ('.$id.', %d, "%s", "%s", %d, %d, "%s", %d, %d)' |
798
|
|
|
: 'INSERT INTO %s (parent_id, name, content, size, mtime, mime, width, height) VALUES (%d, "%s", "%s", %d, %d, "%s", %d, %d)'; |
799
|
|
|
$sql = sprintf($sql, $this->tbf, $dir, $this->db->real_escape_string($name), $this->db->real_escape_string($content), $size, time(), $mime, $w, $h); |
800
|
|
|
|
801
|
|
|
unset($content); |
802
|
|
|
|
803
|
|
|
if ($this->query($sql)) { |
804
|
|
|
return $id > 0 ? $id : $this->db->insert_id; |
805
|
|
|
} |
806
|
|
|
|
807
|
|
|
return false; |
808
|
|
|
} |
809
|
|
|
|
810
|
|
|
/** |
811
|
|
|
* Get file contents |
812
|
|
|
* |
813
|
|
|
* @param string $path file path |
814
|
|
|
* @return string|false |
815
|
|
|
* @author Dmitry (dio) Levashov |
816
|
|
|
**/ |
817
|
|
|
protected function _getContents($path) { |
818
|
|
|
return ($res = $this->query(sprintf('SELECT content FROM %s WHERE id=%d', $this->tbf, $path))) && ($r = $res->fetch_assoc()) ? $r['content'] : false; |
|
|
|
|
819
|
|
|
} |
820
|
|
|
|
821
|
|
|
/** |
822
|
|
|
* Write a string to a file |
823
|
|
|
* |
824
|
|
|
* @param string $path file path |
825
|
|
|
* @param string $content new file content |
826
|
|
|
* @return bool |
827
|
|
|
* @author Dmitry (dio) Levashov |
828
|
|
|
**/ |
829
|
|
|
protected function _filePutContents($path, $content) { |
830
|
|
|
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)); |
|
|
|
|
831
|
|
|
} |
832
|
|
|
|
833
|
|
|
/** |
834
|
|
|
* Detect available archivers |
835
|
|
|
* |
836
|
|
|
* @return void |
837
|
|
|
**/ |
838
|
|
|
protected function _checkArchivers() { |
839
|
|
|
return; |
840
|
|
|
} |
841
|
|
|
|
842
|
|
|
/** |
843
|
|
|
* chmod implementation |
844
|
|
|
* |
845
|
|
|
* @return bool |
846
|
|
|
**/ |
847
|
|
|
protected function _chmod($path, $mode) { |
848
|
|
|
return false; |
849
|
|
|
} |
850
|
|
|
|
851
|
|
|
/** |
852
|
|
|
* Unpack archive |
853
|
|
|
* |
854
|
|
|
* @param string $path archive path |
855
|
|
|
* @param array $arc archiver command and arguments (same as in $this->archivers) |
856
|
|
|
* @return void |
857
|
|
|
* @author Dmitry (dio) Levashov |
858
|
|
|
* @author Alexey Sukhotin |
859
|
|
|
**/ |
860
|
|
|
protected function _unpack($path, $arc) { |
|
|
|
|
861
|
|
|
return; |
862
|
|
|
} |
863
|
|
|
|
864
|
|
|
/** |
865
|
|
|
* Recursive symlinks search |
866
|
|
|
* |
867
|
|
|
* @param string $path file/dir path |
868
|
|
|
* @return bool |
869
|
|
|
* @author Dmitry (dio) Levashov |
870
|
|
|
**/ |
871
|
|
|
protected function _findSymlinks($path) { |
|
|
|
|
872
|
|
|
return false; |
873
|
|
|
} |
874
|
|
|
|
875
|
|
|
/** |
876
|
|
|
* Extract files from archive |
877
|
|
|
* |
878
|
|
|
* @param string $path archive path |
879
|
|
|
* @param array $arc archiver command and arguments (same as in $this->archivers) |
880
|
|
|
* @return true |
881
|
|
|
* @author Dmitry (dio) Levashov, |
882
|
|
|
* @author Alexey Sukhotin |
883
|
|
|
**/ |
884
|
|
|
protected function _extract($path, $arc) { |
885
|
|
|
return false; |
886
|
|
|
} |
887
|
|
|
|
888
|
|
|
/** |
889
|
|
|
* Create archive and return its path |
890
|
|
|
* |
891
|
|
|
* @param string $dir target dir |
892
|
|
|
* @param array $files files names list |
893
|
|
|
* @param string $name archive name |
894
|
|
|
* @param array $arc archiver options |
895
|
|
|
* @return string|bool |
896
|
|
|
* @author Dmitry (dio) Levashov, |
897
|
|
|
* @author Alexey Sukhotin |
898
|
|
|
**/ |
899
|
|
|
protected function _archive($dir, $files, $name, $arc) { |
900
|
|
|
return false; |
901
|
|
|
} |
902
|
|
|
|
903
|
|
|
} // END class |
904
|
|
|
|
You can fix this by adding a namespace to your class:
When choosing a vendor namespace, try to pick something that is not too generic to avoid conflicts with other libraries.