FriendsOfFlarum upload, the intelligent file attachment extension

@samus14

Here's mine for docs and archives:
^application\/(x-(7z|rar|zip)-compressed|zip|gzip|arj|x-(bzip2|gzip|lha|stuffit|tar)|pdf|msword|vnd.openxmlformats-officedocument.wordprocessingml.document|vnd.ms-excel|vnd.openxmlformats-officedocument.spreadsheetml.sheet|vnd.ms-powerpoint|vnd.openxmlformats-officedocument.presentationml.presentation)

Audio files:
^audio\/(flac|x-flac|mp3|x-mp3|mpg|mpeg|mpeg3|x-mpeg|x-mpeg3|x-mpg|x-mp4a|x-mpegaudio|mp4|vnd.wave|wav|wave|x-wav|x-pn-wav|ogg|x-ogg|x-ogg-flac)

MIDI files:
^audio\/(mid|midi|x-mid|x-midi|sp-midi)

Images:
^image\/.*

Text files:
^text\/(plain|pdf|json|rtf|xml)

I have separate templates for those but you can merge them into one.

Hello!

Some question and tips about this good extension.
Testing only with Imgur image storage ID.

1- If go with "BBcode template" all the images upload go with URL LINK. If any one click in the image redirect to imgur.com webpage. If upload with "Mardown image template" no have any url link. Not have possibility to delete the URL link in BBcode ? or maybe optional to select the link?

2- About the links to open the image in full- page view that other similar extension "imgur Upload" have and option in the admin panel to select or no the option to link the imagen to full page, as you prefer. In this case, if you select "with link" the image not open in imgur gallery as view in FoF Upload, open directly in the image url link with *jpg final address and not view any for imgur. The background is completly black. In think is a good tip to implement if it´s possible.

3- I testing other extension: "Imgur Upload by Matteo Contrini" and view that have a good point that not view implemented in FoF upload. In Android mobile devices, if working only with "upload button" in Fof upload when click in the button I have some options: Take a photo with the camera or explore the mobile folders to search the photo. In the Matteo Contrini extensión when click in the upload button go directly to mobile gallery to select the photo you need to upload. I think this option is better when working via mobile device, directly to the gallery.

4- Create and option in admin panel to hide Markdown image button to no duplicate the same action with different icons.

luceos

the error is (with stuff changed to "X" to obfuscate )

flarum.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1059 Identifier name 'xxxxxxpreffof_upload_files_actor_id_hide_from_media_manager_index' is too long in C:\xxxxx\xxxxxx\xxxxxxxxxxx\vendor\doctrine\dbal\lib\Doctrine\DBAL\Driver\PDOStatement.php:117
Stack trace:

maybe related to this length limits? https://dev.mysql.com/doc/refman/8.0/en/identifier-length.html

as "xxxxxxpreffof_upload_files_actor_id_hide_from_media_manager_index" is 65 characters while the limit is 64.

Only way to fix this is by nuking the flarum and installing it again with shorter database name?

------------ your database table prefix is too long.

Flarum (or more specifically, the Laravel schema builder) automatically generates index names based on table name + column name, so the longer your table prefix is, the more likely errors like this will occur. This is not specific to this extension, this extension just happens to have long table and column names already which bring index names closer to the limit.

You will likely need to rollback the migrations before trying again ("Uninstall" on extension page after disabling) to attempt the migration again. Or restore from backup before trying again.

If you want to keep your table prefix unchanged, you will have to manually fix/apply the migrations to the database and then mark the migration as applied.

I recommend not using a table prefix longer than 4 characters. Best solution is to use a dedicated database and no prefix.

The length of the database name doesn't matter, only the table prefix.