]>
git.p6c8.net - jirafeau_project.git/blob - lib/functions.php
9672fe13deed1fe03f647363dc4decaa51e9043b
3 * Jirafeau, your web file repository
4 * Copyright (C) 2008 Julien "axolotl" BERNARD <axolotl@magieeternelle.org>
5 * Copyright (C) 2015 Jerome Jutteau <jerome@jutteau.fr>
6 * Copyright (C) 2015 Nicola Spanti (RyDroid) <dev@nicola-spanti.info>
8 * This program is free software: you can redistribute it and/or modify
9 * it under the terms of the GNU Affero General Public License as
10 * published by the Free Software Foundation, either version 3 of the
11 * License, or (at your option) any later version.
13 * This program is distributed in the hope that it will be useful,
14 * but WITHOUT ANY WARRANTY; without even the implied warranty of
15 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 * GNU Affero General Public License for more details.
18 * You should have received a copy of the GNU Affero General Public License
19 * along with this program. If not, see <https://www.gnu.org/licenses/>.
23 * Transform a string in a path by separating each letters by a '/'.
24 * @return path finishing with a '/'
30 for ( $i = 0 ; $i < strlen ( $s ); $i ++
) {
32 if (( $i +
1 ) %
$block_size == 0 ) {
36 if ( strlen ( $s ) %
$block_size != 0 ) {
43 * Convert base 16 to base 64
44 * @returns A string based on 64 characters (0-9, a-z, A-Z, "-" and "_")
46 function base_16_to_64 ( $num )
48 $m = '0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-_' ;
49 $hex2bin = array ( '0000' , # 0
68 # Convert long hex string to bin.
70 for ( $i = 0 ; $i < $size ; $i ++
) {
71 $b .= $hex2bin [ hexdec ( $num [ $i ])];
73 # Convert long bin to base 64.
75 for ( $i = $size - 6 ; $i >= 0 ; $i -= 6 ) {
76 $o = $m [ bindec ( substr ( $b , $i , 6 ))] . $o ;
78 # Some few bits remaining ?
79 if ( $i < 0 && $i > - 6 ) {
80 $o = $m [ bindec ( substr ( $b , 0 , $i +
6 ))] . $o ;
86 * Generate a random code.
87 * @param $l code length
88 * @return random code.
90 function jirafeau_gen_random ( $l )
97 for ( $i = 0 ; $i < $l ; $i ++
) {
98 $code .= dechex ( rand ( 0 , 15 ));
106 if ( isset ( $_SERVER [ 'HTTPS' ])) {
107 if ( 'on' == strtolower ( $_SERVER [ 'HTTPS' ]) ||
108 '1' == $_SERVER [ 'HTTPS' ]) {
111 } elseif ( isset ( $_SERVER [ 'SERVER_PORT' ]) && ( '443' == $_SERVER [ 'SERVER_PORT' ])) {
113 } elseif ( isset ( $_SERVER [ 'HTTP_X_FORWARDED_PROTO' ])) {
114 if ( $_SERVER [ 'HTTP_X_FORWARDED_PROTO' ] == 'https' ) {
121 function jirafeau_human_size ( $octets )
123 $u = array ( 'B' , 'KB' , 'MB' , 'GB' , 'TB' );
124 $o = max ( $octets , 0 );
125 $p = min ( floor (( $o ?
log ( $o ) : 0 ) / log ( 1024 )), count ( $u ) - 1 );
127 return round ( $o , 1 ) . $u [ $p ];
130 // Convert UTC timestamp to a datetime field
131 function jirafeau_get_datetimefield ( $timestamp )
133 $content = '<span class="datetime" data-datetime="' . strftime ( ' %Y - %m - %d %H : %M ' , $timestamp ) . '">'
134 . strftime ( ' %Y - %m - %d %H : %M ' , $timestamp ) . ' (GMT)</span>' ;
138 function jirafeau_fatal_error ( $errorText , $cfg = array ())
140 echo '<div class="error"><h2>Error</h2><p>' . $errorText . '</p></div>' ;
141 require ( JIRAFEAU_ROOT
. 'lib/template/footer.php' );
145 function jirafeau_clean_rm_link ( $link )
148 if ( file_exists ( VAR_LINKS
. $p . $link )) {
149 unlink ( VAR_LINKS
. $p . $link );
151 $parse = VAR_LINKS
. $p ;
153 while ( file_exists ( $parse )
154 && ( $scan = scandir ( $parse ))
155 && count ( $scan ) == 2 // '.' and '..' folders => empty.
156 && basename ( $parse ) != basename ( VAR_LINKS
)) {
158 $parse = substr ( $parse , 0 , strlen ( $parse ) - strlen ( basename ( $parse )) - 1 );
162 function jirafeau_clean_rm_file ( $hash )
165 $f = VAR_FILES
. $p . $hash ;
166 if ( file_exists ( $f ) && is_file ( $f )) {
169 if ( file_exists ( $f . '_count' ) && is_file ( $f . '_count' )) {
170 unlink ( $f . '_count' );
172 $parse = VAR_FILES
. $p ;
174 while ( file_exists ( $parse )
175 && ( $scan = scandir ( $parse ))
176 && count ( $scan ) == 2 // '.' and '..' folders => empty.
177 && basename ( $parse ) != basename ( VAR_FILES
)) {
179 $parse = substr ( $parse , 0 , strlen ( $parse ) - strlen ( basename ( $parse )) - 1 );
184 * transforms a php.ini string representing a value in an integer
185 * @param $value the value from php.ini
186 * @returns an integer for this value
188 function jirafeau_ini_to_bytes ( $value )
190 $modifier = substr ( $value , - 1 );
191 $bytes = substr ( $value , 0 , - 1 );
192 switch ( strtoupper ( $modifier )) {
194 return intval ( $value );
215 * gets the maximum upload size according to php.ini
216 * @returns the maximum upload size in bytes
218 function jirafeau_get_max_upload_size_bytes ()
221 jirafeau_ini_to_bytes ( ini_get ( 'post_max_size' )),
222 jirafeau_ini_to_bytes ( ini_get ( 'upload_max_filesize' ))
227 * gets the maximum upload size according to php.ini
228 * @returns the maximum upload size string
230 function jirafeau_get_max_upload_size ()
232 return jirafeau_human_size ( jirafeau_get_max_upload_size_bytes ());
236 * get the maximal upload size for a data chunk in async uploads
237 * @param max_upload_chunk_size_bytes
239 function jirafeau_get_max_upload_chunk_size_bytes ( $max_upload_chunk_size_bytes = 0 )
241 if ( $max_upload_chunk_size_bytes == 0 ) {
242 $size = jirafeau_get_max_upload_size_bytes ();
243 // Jirafeau must choose an arbitrary number as PHP config does not give any limit nor $max_upload_chunk_size_bytes
245 return 10000000 ; // 10MB
250 jirafeau_get_max_upload_size_bytes (),
251 $max_upload_chunk_size_bytes
254 return $max_upload_chunk_size_bytes ;
260 * gets a string explaining the error
261 * @param $code the error code
262 * @returns a string explaining the error
264 function jirafeau_upload_errstr ( $code )
267 case UPLOAD_ERR_INI_SIZE
:
268 case UPLOAD_ERR_FORM_SIZE
:
269 return t ( 'Your file exceeds the maximum authorized file size. ' );
271 case UPLOAD_ERR_PARTIAL
:
272 case UPLOAD_ERR_NO_FILE
:
274 t ( 'Your file was not uploaded correctly. You may succeed in retrying. ' );
276 case UPLOAD_ERR_NO_TMP_DIR
:
277 case UPLOAD_ERR_CANT_WRITE
:
278 case UPLOAD_ERR_EXTENSION
:
279 return t ( 'Internal error. You may not succeed in retrying. ' );
281 return t ( 'Unknown error. ' );
284 /** Remove link and it's file
285 * @param $link the link's name (hash)
288 function jirafeau_delete_link ( $link )
290 $l = jirafeau_get_link ( $link );
295 jirafeau_clean_rm_link ( $link );
301 if ( file_exists ( VAR_FILES
. $p . $hash . '_count' )) {
302 $content = file ( VAR_FILES
. $p . $hash . '_count' );
303 $counter = trim ( $content [ 0 ]);
308 $handle = fopen ( VAR_FILES
. $p . $hash . '_count' , 'w' );
309 fwrite ( $handle , $counter );
314 jirafeau_clean_rm_file ( $hash );
319 * Delete a file and it's links.
321 function jirafeau_delete_file ( $hash )
324 /* Get all links files. */
325 $stack = array ( VAR_LINKS
);
326 while (( $d = array_shift ( $stack )) && $d != null ) {
329 foreach ( $dir as $node ) {
330 if ( strcmp ( $node , '.' ) == 0 ||
strcmp ( $node , '..' ) == 0 ||
331 preg_match ( '/\.tmp/i' , " $node " )) {
335 if ( is_dir ( $d . $node )) {
336 /* Push new found directory. */
337 $stack [] = $d . $node . '/' ;
338 } elseif ( is_file ( $d . $node )) {
339 /* Read link informations. */
340 $l = jirafeau_get_link ( basename ( $node ));
344 if ( $l [ 'hash' ] == $hash ) {
346 jirafeau_delete_link ( $node );
351 jirafeau_clean_rm_file ( $hash );
356 /** hash file's content
357 * @param $method hash method, see 'file_hash' option. Valid methods are 'md5', 'md5_outside' or 'random'
358 * @param $file_path file to hash
359 * @returns hash string
361 function jirafeau_hash_file ( $method , $file_path )
365 return jirafeau_md5_outside ( $file_path );
367 return md5_file ( $file_path );
369 return jirafeau_gen_random ( 32 );
371 return md5_file ( $file_path );
374 /** hash part of file: start, end and size.
375 * This is a partial file hash, faster but weaker.
376 * @param $file_path file to hash
377 * @returns hash string
379 function jirafeau_md5_outside ( $file_path )
382 $handle = fopen ( $file_path , "r" );
383 if ( $handle === false ) {
386 $size = filesize ( $file_path );
387 if ( $size === false ) {
390 $first = fread ( $handle , 64 );
391 if ( $first === false ) {
394 if ( fseek ( $handle , $size < 64 ?
0 : $size - 64 ) == - 1 ) {
397 $last = fread ( $handle , 64 );
398 if ( $last === false ) {
401 $out = md5 ( $first . $last . $size );
408 * handles an uploaded file
409 * @param $file the file struct given by $_FILE[]
410 * @param $one_time_download is the file a one time download ?
411 * @param $key if not empty, protect the file with this key
412 * @param $time the time of validity of the file
413 * @param $ip uploader's ip
414 * @param $crypt boolean asking to crypt or not
415 * @param $link_name_length size of the link name
416 * @returns an array containing some information
417 * 'error' => information on possible errors
418 * 'link' => the link name of the uploaded file
419 * 'delete_link' => the link code to delete file
421 function jirafeau_upload ( $file , $one_time_download , $key , $time , $ip , $crypt , $link_name_length , $file_hash_method )
423 if ( empty ( $file [ 'tmp_name' ]) ||
! is_uploaded_file ( $file [ 'tmp_name' ])) {
426 array ( 'has_error' => true ,
427 'why' => jirafeau_upload_errstr ( $file [ 'error' ])),
429 'delete_link' => '' ));
432 /* array representing no error */
433 $noerr = array ( 'has_error' => false , 'why' => '' );
435 /* Crypt file if option is enabled. */
438 if ( $crypt == true && !( extension_loaded ( 'mcrypt' ) == true )) {
439 error_log ( "PHP extension mcrypt not loaded, won't encrypt in Jirafeau" );
441 if ( $crypt == true && extension_loaded ( 'mcrypt' ) == true ) {
442 $crypt_key = jirafeau_encrypt_file ( $file [ 'tmp_name' ], $file [ 'tmp_name' ]);
443 if ( strlen ( $crypt_key ) > 0 ) {
448 /* file information */
449 $hash = jirafeau_hash_file ( $file_hash_method , $file [ 'tmp_name' ]);
450 $name = str_replace ( NL
, '' , trim ( $file [ 'name' ]));
451 $mime_type = $file [ 'type' ];
452 $size = $file [ 'size' ];
454 /* does file already exist ? */
457 if ( file_exists ( VAR_FILES
. $p . $hash )) {
458 $rc = unlink ( $file [ 'tmp_name' ]);
459 } elseif (( file_exists ( VAR_FILES
. $p ) || @mkdir
( VAR_FILES
. $p , 0755 , true ))
460 && move_uploaded_file ( $file [ 'tmp_name' ], VAR_FILES
. $p . $hash )) {
466 array ( 'has_error' => true ,
467 'why' => t ( 'INTERNAL_ERROR_DEL' )),
469 'delete_link' => '' ));
472 /* Increment or create count file. */
474 if ( file_exists ( VAR_FILES
. $p . $hash . '_count' )) {
475 $content = file ( VAR_FILES
. $p . $hash . '_count' );
476 $counter = trim ( $content [ 0 ]);
479 $handle = fopen ( VAR_FILES
. $p . $hash . '_count' , 'w' );
480 fwrite ( $handle , $counter );
483 /* Create delete code. */
484 $delete_link_code = jirafeau_gen_random ( 5 );
486 /* hash password or empty. */
489 $password = md5 ( $key );
492 /* create link file */
493 $link_tmp_name = VAR_LINKS
. $hash . rand ( 0 , 10000 ) . '.tmp' ;
494 $handle = fopen ( $link_tmp_name , 'w' );
497 $name . NL
. $mime_type . NL
. $size . NL
. $password . NL
. $time .
498 NL
. $hash . NL
. ( $one_time_download ?
'O' : 'R' ) . NL
. time () .
499 NL
. $ip . NL
. $delete_link_code . NL
. ( $crypted ?
'C' : 'O' )
502 $hash_link = substr ( base_16_to_64 ( md5_file ( $link_tmp_name )), 0 , $link_name_length );
503 $l = s2p ( " $hash_link " );
504 if (! @mkdir
( VAR_LINKS
. $l , 0755 , true ) ||
505 ! rename ( $link_tmp_name , VAR_LINKS
. $l . $hash_link )) {
506 if ( file_exists ( $link_tmp_name )) {
507 unlink ( $link_tmp_name );
512 $handle = fopen ( VAR_FILES
. $p . $hash . '_count' , 'w' );
513 fwrite ( $handle , $counter );
516 jirafeau_clean_rm_file ( $hash_link );
520 array ( 'has_error' => true ,
521 'why' => t ( 'Internal error during file creation. ' )),
523 'delete_link' => '' );
525 return array ( 'error' => $noerr ,
526 'link' => $hash_link ,
527 'delete_link' => $delete_link_code ,
528 'crypt_key' => $crypt_key );
532 * Tells if a mime-type is viewable in a browser
533 * @param $mime the mime type
534 * @returns a boolean telling if a mime type is viewable
536 function jirafeau_is_viewable ( $mime )
539 $viewable = array ( 'image' , 'video' , 'audio' );
540 $decomposed = explode ( '/' , $mime );
541 if ( in_array ( $decomposed [ 0 ], $viewable ) && strpos ( $mime , 'image/svg+xml' ) === false ) {
544 $viewable = array ( 'text/plain' );
545 if ( in_array ( $mime , $viewable )) {
552 // Error handling functions.
553 //! Global array that contains all registered errors.
554 $error_list = array ();
557 * Adds an error to the list of errors.
558 * @param $title the error's title
559 * @param $description is a human-friendly description of the problem.
561 function add_error ( $title , $description )
564 $error_list [] = '<p>' . $title . '<br />' . $description . '</p>' ;
568 * Informs whether any error has been registered yet.
569 * @return true if there are errors.
574 return ! empty ( $error_list );
578 * Displays all the errors.
580 function show_errors ()
584 echo '<div class="error">' ;
585 foreach ( $error_list as $error ) {
592 function check_errors ( $cfg )
594 if (!( $cfg [ 'installation_done' ] === true )) {
595 if ( file_exists ( JIRAFEAU_ROOT
. 'install.php' )) {
596 header ( 'Location: install.php' );
599 add_error ( t ( 'INSTALL_FILE_NOT_FOUND_TITLE' ), t ( 'INSTALL_FILE_NOT_FOUND_DESC' ));
603 if (! is_writable ( VAR_FILES
)) {
604 add_error ( t ( 'FILE_DIR_W' ), VAR_FILES
);
607 if (! is_writable ( VAR_LINKS
)) {
608 add_error ( t ( 'LINK_DIR_W' ), VAR_LINKS
);
611 if (! is_writable ( VAR_ASYNC
)) {
612 add_error ( t ( 'ASYNC_DIR_W' ), VAR_ASYNC
);
615 if ( $cfg [ 'enable_crypt' ] && $cfg [ 'litespeed_workaround' ]) {
616 add_error ( t ( 'INCOMPATIBLE_OPTIONS_W' ), 'enable_crypt=true<br>litespeed_workaround=true' );
619 if ( $cfg [ 'one_time_download' ] && $cfg [ 'litespeed_workaround' ]) {
620 add_error ( t ( 'INCOMPATIBLE_OPTIONS_W' ), 'one_time_download=true<br>litespeed_workaround=true' );
625 * Read link information
626 * @return array containing information.
628 function jirafeau_get_link ( $hash )
631 $link = VAR_LINKS
. s2p ( " $hash " ) . $hash ;
633 if (! file_exists ( $link )) {
638 $out [ 'file_name' ] = trim ( $c [ 0 ]);
639 $out [ 'mime_type' ] = trim ( $c [ 1 ]);
640 $out [ 'file_size' ] = trim ( $c [ 2 ]);
641 $out [ 'key' ] = trim ( $c [ 3 ], NL
);
642 $out [ 'time' ] = trim ( $c [ 4 ]);
643 $out [ 'hash' ] = trim ( $c [ 5 ]);
644 $out [ 'onetime' ] = trim ( $c [ 6 ]);
645 $out [ 'upload_date' ] = trim ( $c [ 7 ]);
646 $out [ 'ip' ] = trim ( $c [ 8 ]);
647 $out [ 'link_code' ] = trim ( $c [ 9 ]);
648 $out [ 'crypted' ] = trim ( $c [ 10 ]) == 'C' ;
654 * List files in admin interface.
656 function jirafeau_admin_list ( $name , $file_hash , $link_hash )
658 echo '<fieldset><legend>' ;
660 echo t ( 'FILENAME' ) . ": " . jirafeau_escape ( $name );
662 if (! empty ( $file_hash )) {
663 echo t ( 'FILE' ) . ": " . jirafeau_escape ( $file_hash );
665 if (! empty ( $link_hash )) {
666 echo t ( 'LINK' ) . ": " . jirafeau_escape ( $link_hash );
668 if ( empty ( $name ) && empty ( $file_hash ) && empty ( $link_hash )) {
675 echo '<th>' . t ( 'ACTION' ) . '</th>' ;
678 /* Get all links files. */
679 $stack = array ( VAR_LINKS
);
680 while (( $d = array_shift ( $stack )) && $d != null ) {
682 foreach ( $dir as $node ) {
683 if ( strcmp ( $node , '.' ) == 0 ||
strcmp ( $node , '..' ) == 0 ||
684 preg_match ( '/\.tmp/i' , " $node " )) {
687 if ( is_dir ( $d . $node )) {
688 /* Push new found directory. */
689 $stack [] = $d . $node . '/' ;
690 } elseif ( is_file ( $d . $node )) {
691 /* Read link information. */
692 $l = jirafeau_get_link ( $node );
698 if (! empty ( $name ) && ! @preg_match
( "/ $name /i" , jirafeau_escape ( $l [ 'file_name' ]))) {
701 if (! empty ( $file_hash ) && $file_hash != $l [ 'hash' ]) {
704 if (! empty ( $link_hash ) && $link_hash != $node ) {
707 /* Print link information. */
710 '<strong><a id="upload_link" href="f.php?h=' . jirafeau_escape ( $node ) . '" title="' .
711 t ( 'DL_PAGE' ) . '">' . jirafeau_escape ( $l [ 'file_name' ]) . '</a></strong><br/>' ;
712 echo t ( 'TYPE' ) . ': ' . jirafeau_escape ( $l [ 'mime_type' ]) . '<br/>' ;
713 echo t ( 'SIZE' ) . ': ' . jirafeau_human_size ( $l [ 'file_size' ]) . '<br>' ;
714 echo t ( 'EXPIRE' ) . ': ' . ( $l [ 'time' ] == - 1 ?
'∞' : jirafeau_get_datetimefield ( $l [ 'time' ])) . '<br/>' ;
715 echo t ( 'ONETIME' ) . ': ' . ( $l [ 'onetime' ] == 'O' ?
'Yes' : 'No' ) . '<br/>' ;
716 echo t ( 'UPLOAD_DATE' ) . ': ' . jirafeau_get_datetimefield ( $l [ 'upload_date' ]) . '<br/>' ;
717 if ( strlen ( $l [ 'ip' ]) > 0 ) {
718 echo t ( 'ORIGIN' ) . ': ' . $l [ 'ip' ] . '<br/>' ;
721 echo '<form method="post">' .
722 '<input type = "hidden" name = "action" value = "download"/>' .
723 '<input type = "hidden" name = "link" value = "' . $node . '"/>' .
724 jirafeau_admin_csrf_field () .
725 '<input type = "submit" value = "' . t ( 'DL' ) . '" />' .
727 '<form method="post">' .
728 '<input type = "hidden" name = "action" value = "delete_link"/>' .
729 '<input type = "hidden" name = "link" value = "' . $node . '"/>' .
730 jirafeau_admin_csrf_field () .
731 '<input type = "submit" value = "' . t ( 'DEL_LINK' ) . '" />' .
733 '<form method="post">' .
734 '<input type = "hidden" name = "action" value = "delete_file"/>' .
735 '<input type = "hidden" name = "hash" value = "' . $l [ 'hash' ] . '"/>' .
736 jirafeau_admin_csrf_field () .
737 '<input type = "submit" value = "' . t ( 'DEL_FILE_LINKS' ) . '" />' .
744 echo '</table></fieldset>' ;
748 * Clean expired files.
749 * @return number of cleaned files.
751 function jirafeau_admin_clean ()
754 /* Get all links files. */
755 $stack = array ( VAR_LINKS
);
756 while (( $d = array_shift ( $stack )) && $d != null ) {
759 foreach ( $dir as $node ) {
760 if ( strcmp ( $node , '.' ) == 0 ||
strcmp ( $node , '..' ) == 0 ||
761 preg_match ( '/\.tmp/i' , " $node " )) {
765 if ( is_dir ( $d . $node )) {
766 /* Push new found directory. */
767 $stack [] = $d . $node . '/' ;
768 } elseif ( is_file ( $d . $node )) {
769 /* Read link information. */
770 $l = jirafeau_get_link ( basename ( $node ));
774 $p = s2p ( $l [ 'hash' ]);
775 if ( $l [ 'time' ] > 0 && $l [ 'time' ] < time () ||
// expired
776 ! file_exists ( VAR_FILES
. $p . $l [ 'hash' ]) ||
// invalid
777 ! file_exists ( VAR_FILES
. $p . $l [ 'hash' ] . '_count' )) { // invalid
778 jirafeau_delete_link ( $node );
789 * Clean old async transfers.
790 * @return number of cleaned files.
792 function jirafeau_admin_clean_async ()
795 /* Get all links files. */
796 $stack = array ( VAR_ASYNC
);
797 while (( $d = array_shift ( $stack )) && $d != null ) {
800 foreach ( $dir as $node ) {
801 if ( strcmp ( $node , '.' ) == 0 ||
strcmp ( $node , '..' ) == 0 ||
802 preg_match ( '/\.tmp/i' , " $node " )) {
806 if ( is_dir ( $d . $node )) {
807 /* Push new found directory. */
808 $stack [] = $d . $node . '/' ;
809 } elseif ( is_file ( $d . $node )) {
810 /* Read async information. */
811 $a = jirafeau_get_async_ref ( basename ( $node ));
815 /* Delete transfers older than 1 hour. */
816 if ( time () - $a [ 'last_edited' ] > 3600 ) {
817 jirafeau_async_delete ( basename ( $node ));
827 * Better strval function for debug purposes
829 function jirafeau_strval ( $value )
831 if ( gettype ( $value ) == "boolean" ) {
832 return $value ?
'true' : 'false' ;
834 return strval ( $value );
838 * Show file/folder permissions
840 function jirafeau_fileperms ( $path )
842 $out = substr ( sprintf ( " %o " , @fileperms
( $path )), - 4 ) . ", " ;
843 $out .= "read " . ( is_readable ( $path ) ?
"OK" : "KO" ) . ", " ;
844 $out .= "write " . ( is_writable ( $path ) ?
"OK" : "KO" );
849 * Show some useful informations for bug reporting.
851 function jirafeau_admin_bug_report ( $cfg )
853 $out = "<fieldset><legend>" . t ( 'REPORTING_AN_ISSUE' ) . "</legend>" ;
854 $out .= "If you have a problem related to Jirafeau, please <a href='https://gitlab.com/mojo42/Jirafeau/-/issues'>open an issue</a>, explain your problem in english and copy-paste the following content:<br/><br/><code>" ;
856 $out .= "# Jirafeau<br/>" ;
857 $out .= "- version: " . JIRAFEAU_VERSION
. "<br/>" ;
858 $jirafeau_options = [
861 'litespeed_workaround' ,
866 'maximal_upload_size' ,
868 'max_upload_chunk_size_bytes'
870 foreach ( $jirafeau_options as & $o ) {
872 $out .= "- $o : " . jirafeau_strval ( $v ) . " (" . gettype ( $v ) . ")<br/>" ;
876 $out .= "# PHP options<br/>" ;
877 $out .= "- php version: " . phpversion () . "<br/>" ;
878 $out .= "- mcrypt version: " . phpversion ( 'mcrypt' ) . "<br/>" ;
881 'upload_max_filesize' ,
883 'max_execution_time' ,
886 foreach ( $php_options as & $o ) {
888 $out .= "- $o : " . jirafeau_strval ( $v ) . " (" . gettype ( $v ). ")<br/>" ;
890 $out .= "- can set_time_limit: " . ( set_time_limit ( 0 ) ?
"yes" : "no" ) . "<br/>" ;
893 $out .= "# File permissions<br/>" ;
894 $out .= "- 'var' folder permissions: " . jirafeau_fileperms ( $cfg [ 'var_root' ]) . "<br/>" ;
895 $out .= "- 'file' folder permissions: " . jirafeau_fileperms ( VAR_FILES
) . "<br/>" ;
896 $out .= "- 'links' folder permissions: " . jirafeau_fileperms ( VAR_LINKS
) . "<br/>" ;
897 $out .= "- 'async' folder permissions: " . jirafeau_fileperms ( VAR_ASYNC
) . "<br/>" ;
900 $out .= "# Server details<br/>" ;
901 $out .= "- server software: " . $_SERVER [ "SERVER_SOFTWARE" ] . "<br/>" ;
904 $out .= "# OS details<br/>" ;
905 $out .= "- OS: " . php_uname () . "<br/>" ;
908 $out .= "# Browser details<br/>" ;
909 $out .= "<script type='text/javascript' lang='Javascript'>
910 // @license magnet:?xt=urn:btih:0b31508aeb0634b347b8270c7bee4d411b5d4109&dn=agpl-3.0.txt AGPL-v3-or-Later
911 document.write('- html5 support: ' + (check_html5_file_api() ? 'yes' : 'no') + '<br/>');
912 document.write('- user agent: ' + navigator.userAgent + '<br/>');
917 $out .= "# Memory<br/>" ;
918 $out .= "- memory_get_peak_usage: " . jirafeau_human_size ( memory_get_peak_usage ()) . "<br/>" ;
920 $out .= "</code></fieldset>" ;
925 * Read async transfer information
926 * @return array containing information.
928 function jirafeau_get_async_ref ( $ref )
931 $refinfos = VAR_ASYNC
. s2p ( " $ref " ) . " $ref " ;
933 if (! file_exists ( $refinfos )) {
937 $c = file ( $refinfos );
938 $out [ 'file_name' ] = trim ( $c [ 0 ]);
939 $out [ 'mime_type' ] = trim ( $c [ 1 ]);
940 $out [ 'key' ] = trim ( $c [ 2 ], NL
);
941 $out [ 'time' ] = trim ( $c [ 3 ]);
942 $out [ 'onetime' ] = trim ( $c [ 4 ]);
943 $out [ 'ip' ] = trim ( $c [ 5 ]);
944 $out [ 'last_edited' ] = trim ( $c [ 6 ]);
945 $out [ 'next_code' ] = trim ( $c [ 7 ]);
950 * Delete async transfer information
952 function jirafeau_async_delete ( $ref )
955 if ( file_exists ( VAR_ASYNC
. $p . $ref )) {
956 unlink ( VAR_ASYNC
. $p . $ref );
958 if ( file_exists ( VAR_ASYNC
. $p . $ref . '_data' )) {
959 unlink ( VAR_ASYNC
. $p . $ref . '_data' );
961 $parse = VAR_ASYNC
. $p ;
963 while ( file_exists ( $parse )
964 && ( $scan = scandir ( $parse ))
965 && count ( $scan ) == 2 // '.' and '..' folders => empty.
966 && basename ( $parse ) != basename ( VAR_ASYNC
)) {
968 $parse = substr ( $parse , 0 , strlen ( $parse ) - strlen ( basename ( $parse )) - 1 );
973 * Init a new asynchronous upload.
974 * @param $filename Name of the file to send
975 * @param $one_time One time upload parameter
976 * @param $key eventual password (or blank)
977 * @param $time time limit
978 * @param $ip ip address of the client
979 * @return a string containing a temporary reference followed by a code or a string starting with 'Error'
981 function jirafeau_async_init ( $filename , $type , $one_time , $key , $time , $ip )
983 /* Create temporary folder. */
986 $code = jirafeau_gen_random ( 4 );
988 $ref = jirafeau_gen_random ( 32 );
989 $p = VAR_ASYNC
. s2p ( $ref );
990 } while ( file_exists ( $p ));
991 @mkdir
( $p , 0755 , true );
992 if (! file_exists ( $p )) {
993 return 'Error: cannot create async folder.' ;
996 /* touch empty data file */
997 $w_path = $p . $ref . '_data' ;
1000 /* md5 password or empty */
1003 $password = md5 ( $key );
1006 /* Store information. */
1008 $handle = fopen ( $p , 'w' );
1011 str_replace ( NL
, '' , trim ( $filename )) . NL
.
1012 str_replace ( NL
, '' , trim ( $type )) . NL
. $password . NL
.
1013 $time . NL
. ( $one_time ?
'O' : 'R' ) . NL
. $ip . NL
.
1014 time () . NL
. $code . NL
1018 return $ref . NL
. $code ;
1022 * Append a piece of file on the asynchronous upload.
1023 * @param $ref asynchronous upload reference
1024 * @param $file piece of data
1025 * @param $code client code for this operation
1026 * @param $max_file_size maximum allowed file size
1027 * @return a string containing a next code to use or a string starting with 'Error'
1029 function jirafeau_async_push ( $ref , $data , $code , $max_file_size )
1031 /* Get async infos. */
1032 $a = jirafeau_get_async_ref ( $ref );
1034 /* Check some errors. */
1035 if ( count ( $a ) == 0 ) {
1036 return "Error: cannot find transfer" ;
1038 if ( $a [ 'next_code' ] != " $code " ) {
1039 return "Error: bad transfer code" ;
1041 if ( $data [ 'error' ] != UPLOAD_ERR_OK
) {
1042 // Check error code in https://www.php.net/manual/en/features.file-upload.errors.php
1043 $data_details = print_r ( $data , true );
1044 return "Error: upload error: { $data_details }" ;
1046 if ( empty ( $data [ 'tmp_name' ])) {
1047 return "Error: missing tmp_name" ;
1049 if (! is_uploaded_file ( $data [ 'tmp_name' ])) {
1050 return "Error: tmp_name may not be uploaded" ;
1056 $r_path = $data [ 'tmp_name' ];
1057 $w_path = VAR_ASYNC
. $p . $ref . '_data' ;
1059 /* Check that file size is not above upload limit. */
1060 if ( $max_file_size > 0 &&
1061 filesize ( $r_path ) +
filesize ( $w_path ) > $max_file_size * 1024 * 1024 ) {
1062 jirafeau_async_delete ( $ref );
1063 return "Error: file size is above upload limit" ;
1066 /* Concatenate data. */
1067 $r = fopen ( $r_path , 'r' );
1068 $w = fopen ( $w_path , 'a' );
1070 if ( fwrite ( $w , fread ( $r , 1024 )) === false ) {
1073 jirafeau_async_delete ( $ref );
1074 return "Error: cannot write file" ;
1081 /* Update async file. */
1082 $code = jirafeau_gen_random ( 4 );
1083 $handle = fopen ( VAR_ASYNC
. $p . $ref , 'w' );
1086 $a [ 'file_name' ] . NL
. $a [ 'mime_type' ] . NL
. $a [ 'key' ] . NL
.
1087 $a [ 'time' ] . NL
. $a [ 'onetime' ] . NL
. $a [ 'ip' ] . NL
.
1088 time () . NL
. $code . NL
1095 * Finalize an asynchronous upload.
1096 * @param $ref asynchronous upload reference
1097 * @param $code client code for this operation
1098 * @param $crypt boolean asking to crypt or not
1099 * @param $link_name_length link name length
1100 * @return a string containing the download reference followed by a delete code or a string starting with 'Error'
1102 function jirafeau_async_end ( $ref , $code , $crypt , $link_name_length , $file_hash_method )
1104 /* Get async infos. */
1105 $a = jirafeau_get_async_ref ( $ref );
1107 ||
$a [ 'next_code' ] != " $code " ) {
1108 return "Error: bad code for ending transfer" ;
1111 /* Generate link infos. */
1112 $p = VAR_ASYNC
. s2p ( $ref ) . $ref . "_data" ;
1113 if (! file_exists ( $p )) {
1114 return "Error: referenced file does not exist" ;
1119 if ( $crypt == true && extension_loaded ( 'mcrypt' ) == true ) {
1120 $crypt_key = jirafeau_encrypt_file ( $p , $p );
1121 if ( strlen ( $crypt_key ) > 0 ) {
1126 $hash = jirafeau_hash_file ( $file_hash_method , $p );
1127 $size = filesize ( $p );
1129 $delete_link_code = jirafeau_gen_random ( 5 );
1131 /* File already exist ? */
1132 if (! file_exists ( VAR_FILES
. $np )) {
1133 @mkdir
( VAR_FILES
. $np , 0755 , true );
1135 if (! file_exists ( VAR_FILES
. $np . $hash )) {
1136 rename ( $p , VAR_FILES
. $np . $hash );
1139 /* Increment or create count file. */
1141 if ( file_exists ( VAR_FILES
. $np . $hash . '_count' )) {
1142 $content = file ( VAR_FILES
. $np . $hash . '_count' );
1143 $counter = trim ( $content [ 0 ]);
1146 $handle = fopen ( VAR_FILES
. $np . $hash . '_count' , 'w' );
1147 fwrite ( $handle , $counter );
1151 $link_tmp_name = VAR_LINKS
. $hash . rand ( 0 , 10000 ) . '.tmp' ;
1152 $handle = fopen ( $link_tmp_name , 'w' );
1155 $a [ 'file_name' ] . NL
. $a [ 'mime_type' ] . NL
. $size . NL
.
1156 $a [ 'key' ] . NL
. $a [ 'time' ] . NL
. $hash . NL
. $a [ 'onetime' ] . NL
.
1157 time () . NL
. $a [ 'ip' ] . NL
. $delete_link_code . NL
. ( $crypted ?
'C' : 'O' )
1160 $hash_link = substr ( base_16_to_64 ( md5_file ( $link_tmp_name )), 0 , $link_name_length );
1161 $l = s2p ( " $hash_link " );
1162 if (! @mkdir
( VAR_LINKS
. $l , 0755 , true )) {
1163 return "Error: cannot create folder in LINKS" ;
1165 if (! rename ( $link_tmp_name , VAR_LINKS
. $l . $hash_link )) {
1166 return "Error: cannot rename file in LINKS" ;
1169 /* Clean async upload. */
1170 jirafeau_async_delete ( $ref );
1171 return $hash_link . NL
. $delete_link_code . NL
. urlencode ( $crypt_key );
1174 function jirafeau_crypt_create_iv ( $base , $size )
1177 while ( strlen ( $iv ) < $size ) {
1180 $iv = substr ( $iv , 0 , $size );
1185 * Crypt file and returns decrypt key.
1186 * @param $fp_src file path to the file to crypt.
1187 * @param $fp_dst file path to the file to write crypted file (could be the same).
1188 * @return decrypt key composed of the key and the iv separated by a point ('.')
1190 function jirafeau_encrypt_file ( $fp_src , $fp_dst )
1192 $fs = filesize ( $fp_src );
1193 if ( $fs === false ||
$fs == 0 ||
!( extension_loaded ( 'mcrypt' ) == true )) {
1197 /* Prepare module. */
1198 $m = mcrypt_module_open ( 'rijndael-256' , '' , 'ofb' , '' );
1200 $crypt_key = jirafeau_gen_random ( 10 );
1201 $hash_key = md5 ( $crypt_key );
1202 $iv = jirafeau_crypt_create_iv ( $hash_key , mcrypt_enc_get_iv_size ( $m ));
1204 mcrypt_generic_init ( $m , $hash_key , $iv );
1206 $r = fopen ( $fp_src , 'r' );
1207 $w = fopen ( $fp_dst , 'c' );
1209 $enc = mcrypt_generic ( $m , fread ( $r , 1024 ));
1210 if ( fwrite ( $w , $enc ) === false ) {
1217 mcrypt_generic_deinit ( $m );
1218 mcrypt_module_close ( $m );
1224 * @param $fp_src file path to the file to decrypt.
1225 * @param $fp_dst file path to the file to write decrypted file (could be the same).
1226 * @param $k string composed of the key and the iv separated by a point ('.')
1227 * @return key used to decrypt. a string of length 0 is returned if failed.
1229 function jirafeau_decrypt_file ( $fp_src , $fp_dst , $k )
1231 $fs = filesize ( $fp_src );
1232 if ( $fs === false ||
$fs == 0 ||
extension_loaded ( 'mcrypt' ) == false ) {
1237 $m = mcrypt_module_open ( 'rijndael-256' , '' , 'ofb' , '' );
1238 /* Extract key and iv. */
1240 $hash_key = md5 ( $crypt_key );
1241 $iv = jirafeau_crypt_create_iv ( $hash_key , mcrypt_enc_get_iv_size ( $m ));
1243 $r = fopen ( $fp_src , 'r' );
1244 $w = fopen ( $fp_dst , 'c' );
1246 $dec = mdecrypt_generic ( $m , fread ( $r , 1024 ));
1247 if ( fwrite ( $w , $dec ) === false ) {
1254 mcrypt_generic_deinit ( $m );
1255 mcrypt_module_close ( $m );
1260 * Check if Jirafeau is password protected for visitors.
1261 * @return true if Jirafeau is password protected, false otherwise.
1263 function jirafeau_has_upload_password ( $cfg )
1265 return count ( $cfg [ 'upload_password' ]) > 0 ;
1269 * Challenge password for a visitor.
1270 * @param $password password to be challenged
1271 * @return true if password is valid, false otherwise.
1273 function jirafeau_challenge_upload_password ( $cfg , $password )
1275 if (! jirafeau_has_upload_password ( $cfg )) {
1278 foreach ( $cfg [ 'upload_password' ] as $p ) {
1279 if ( $password == $p ) {
1287 * Test if the given IP is whitelisted by the given list.
1289 * @param $allowedIpList array of allowed IPs
1290 * @param $challengedIp IP to be challenged
1291 * @return true if IP is authorized, false otherwise.
1293 function jirafeau_challenge_ip ( $allowedIpList , $challengedIp )
1295 foreach ( $allowedIpList as $i ) {
1296 if ( $i == $challengedIp ) {
1299 // CIDR test for IPv4 only.
1300 if ( strpos ( $i , '/' ) !== false ) {
1301 list ( $subnet , $mask ) = explode ( '/' , $i );
1302 if (( ip2long ( $challengedIp ) & ~
(( 1 << ( 32 - $mask )) - 1 )) == ip2long ( $subnet )) {
1311 * Check if Jirafeau has a restriction on the IP address for uploading.
1312 * @return true if uploading is IP restricted, false otherwise.
1314 function jirafeau_upload_has_ip_restriction ( $cfg )
1316 return count ( $cfg [ 'upload_ip' ]) > 0 ;
1320 * Test if visitor's IP is authorized to upload at all.
1322 * @param $cfg configuration
1323 * @param $challengedIp IP to be challenged
1324 * @return true if IP is authorized, false otherwise.
1326 function jirafeau_challenge_upload_ip ( $cfg , $challengedIp )
1328 // If no IP address have been listed, allow upload from any IP
1329 if (! jirafeau_upload_has_ip_restriction ( $cfg )) {
1332 return jirafeau_challenge_ip ( $cfg [ 'upload_ip' ], $challengedIp );
1336 * Test if visitor's IP is authorized to upload without a password.
1338 * @param $cfg configuration
1339 * @param $challengedIp IP to be challenged
1340 * @return true if IP is authorized, false otherwise.
1342 function jirafeau_challenge_upload_ip_without_password ( $cfg , $challengedIp )
1344 return jirafeau_challenge_ip ( $cfg [ 'upload_ip_nopassword' ], $challengedIp );
1348 * Test if visitor's IP is authorized or password is supplied and authorized
1349 * @param $ip IP to be challenged
1350 * @param $password password to be challenged
1351 * @return true if access is valid, false otherwise.
1353 function jirafeau_challenge_upload ( $cfg , $ip , $password )
1355 return jirafeau_challenge_upload_ip_without_password ( $cfg , $ip ) ||
1356 (! jirafeau_has_upload_password ( $cfg ) && ! jirafeau_upload_has_ip_restriction ( $cfg )) ||
1357 ( jirafeau_challenge_upload_password ( $cfg , $password ) && jirafeau_challenge_upload_ip ( $cfg , $ip ));
1360 /** Tell if we have some HTTP headers generated by a proxy */
1361 function has_http_forwarded ()
1364 ! empty ( $_SERVER [ 'HTTP_X_FORWARDED_FOR' ]) ||
1365 ! empty ( $_SERVER [ 'http_X_forwarded_for' ]);
1369 * Generate IP list from HTTP headers generated by a proxy
1370 * @return array of IP strings
1372 function get_ip_list_http_forwarded ()
1375 if (! empty ( $_SERVER [ 'HTTP_X_FORWARDED_FOR' ])) {
1376 $l = explode ( ',' , $_SERVER [ 'HTTP_X_FORWARDED_FOR' ]);
1380 foreach ( $l as $ip ) {
1381 array_push ( $ip_list , preg_replace ( '/\s+/' , '' , $ip ));
1384 if (! empty ( $_SERVER [ 'http_X_forwarded_for' ])) {
1385 $l = explode ( ',' , $_SERVER [ 'http_X_forwarded_for' ]);
1386 foreach ( $l as $ip ) {
1387 // Separate IP from port
1388 $ipa = explode ( ':' , $ip );
1389 if ( $ipa === false ) {
1393 array_push ( $ip_list , preg_replace ( '/\s+/' , '' , $ip ));
1400 * Get the ip address of the client from REMOTE_ADDR
1401 * or from HTTP_X_FORWARDED_FOR if behind a proxy
1402 * @returns the client ip address
1404 function get_ip_address ( $cfg )
1406 $remote = $_SERVER [ 'REMOTE_ADDR' ];
1407 if ( count ( $cfg [ 'proxy_ip' ]) == 0 ||
! has_http_forwarded ()) {
1411 $ip_list = get_ip_list_http_forwarded ();
1412 if ( count ( $ip_list ) == 0 ) {
1416 foreach ( $cfg [ 'proxy_ip' ] as $proxy_ip ) {
1417 if ( $remote != $proxy_ip ) {
1420 // Take the last IP (the one which has been set by the defined proxy).
1421 return end ( $ip_list );
1427 * Convert hexadecimal string to base64
1429 function hex_to_base64 ( $hex )
1432 foreach ( str_split ( $hex , 2 ) as $pair ) {
1433 $b .= chr ( hexdec ( $pair ));
1435 return base64_encode ( $b );
1439 * Replace markers in templates.
1441 * Available markers have the scheme "###MARKERNAME###".
1443 * @param $content string Template text with markers
1444 * @param $htmllinebreaks boolean Convert linebreaks to BR-Tags
1445 * @return Template with replaced markers
1447 function jirafeau_replace_markers ( $content , $htmllinebreaks = false )
1450 '/###ORGANISATION###/' ,
1451 '/###CONTACTPERSON###/' ,
1454 $replacements = array (
1455 $GLOBALS [ 'cfg' ][ 'organisation' ],
1456 $GLOBALS [ 'cfg' ][ 'contactperson' ],
1457 $GLOBALS [ 'cfg' ][ 'web_root' ]
1459 $content = preg_replace ( $patterns , $replacements , $content );
1461 if ( true === $htmllinebreaks ) {
1462 $content = nl2br ( $content );
1468 function jirafeau_escape ( $string )
1470 return htmlspecialchars ( $string , ENT_QUOTES
);
1473 function jirafeau_admin_session_start ()
1475 $_SESSION [ 'admin_auth' ] = true ;
1476 $_SESSION [ 'admin_csrf' ] = md5 ( uniqid ( mt_rand (), true ));
1479 function jirafeau_session_end ()
1481 $_SESSION = array ();
1485 function jirafeau_admin_session_logged ()
1487 return isset ( $_SESSION [ 'admin_auth' ]) &&
1488 isset ( $_SESSION [ 'admin_csrf' ]) &&
1489 isset ( $_POST [ 'admin_csrf' ]) &&
1490 $_SESSION [ 'admin_auth' ] === true &&
1491 $_SESSION [ 'admin_csrf' ] === $_POST [ 'admin_csrf' ];
1494 function jirafeau_admin_csrf_field ()
1496 return "<input type='hidden' name='admin_csrf' value='" . $_SESSION [ 'admin_csrf' ] . "'/>" ;
1499 function jirafeau_user_session_start ()
1501 $_SESSION [ 'user_auth' ] = true ;
1504 function jirafeau_user_session_logged ()
1506 return isset ( $_SESSION [ 'user_auth' ]) &&
1507 $_SESSION [ 'user_auth' ] === true ;
1510 function jirafeau_dir_size ( $dir )
1513 foreach ( glob ( rtrim ( $dir , '/' ). '/*' , GLOB_NOSORT
) as $entry ) {
1514 $size +
= is_file ( $entry ) ?
filesize ( $entry ) : jirafeau_dir_size ( $entry );
1519 function jirafeau_export_cfg ( $cfg )
1521 $content = '<?php' . NL
;
1522 $content .= '/* This file was generated by the install process. ' .
1523 'You can edit it. Please see config.original.php to understand the ' .
1524 'configuration items. */' . NL
;
1525 $content .= ' $cfg = ' . var_export ( $cfg , true ) . ';' ;
1527 $fileWrite = file_put_contents ( JIRAFEAU_CFG
, $content );
1529 if ( false === $fileWrite ) {
1530 jirafeau_fatal_error ( t ( 'Can not write local configuration file' ));
1534 function jirafeau_mkdir ( $path )
1536 return !(! file_exists ( $path ) && ! @mkdir
( $path , 0755 ));
1540 * Returns true whether the path is writable or we manage to make it
1541 * so, which essentially is the same thing.
1542 * @param $path is the file or directory to be tested.
1543 * @return true if $path is writable.
1545 function jirafeau_is_writable ( $path )
1547 /* "@" gets rid of error messages. */
1548 return is_writable ( $path ) || @chmod
( $path , 0777 );
1551 function jirafeau_check_var_dir ( $path )
1553 $mkdir_str1 = t ( 'CANNOT_CREATE_DIR' ) . ':' ;
1554 $mkdir_str2 = t ( 'MANUAL_CREATE' );
1555 $write_str1 = t ( 'DIR_NOT_W' ) . ':' ;
1556 $write_str2 = t ( 'You should give the write permission to the web server on ' .
1558 $solution_str = t ( 'HERE_SOLUTION' ) . ':' ;
1560 if (! jirafeau_mkdir ( $path ) ||
! jirafeau_is_writable ( $path )) {
1561 return array ( 'has_error' => true ,
1562 'why' => $mkdir_str1 . '<br /><code>' .
1563 $path . '</code><br />' . $solution_str .
1564 '<br />' . $mkdir_str2 );
1567 foreach ( array ( 'files' , 'links' , 'async' ) as $subdir ) {
1568 $subpath = $path . $subdir ;
1570 if (! jirafeau_mkdir ( $subpath ) ||
! jirafeau_is_writable ( $subpath )) {
1571 return array ( 'has_error' => true ,
1572 'why' => $mkdir_str1 . '<br /><code>' .
1573 $subpath . '</code><br />' . $solution_str .
1574 '<br />' . $mkdir_str2 );
1578 return array ( 'has_error' => false , 'why' => '' );
1581 function jirafeau_add_ending_slash ( $path )
1583 return $path . (( substr ( $path , - 1 ) == '/' ) ?
'' : '/' );
1586 function jirafeau_default_web_root ()
1588 return $_SERVER [ 'HTTP_HOST' ] . str_replace ( 'install.php' , '' , $_SERVER [ 'REQUEST_URI' ]);
patrick-canterino.de