Website dev

open all    close all

Color contrast check
https://webaim.org/resources/contrastchecker/

Add back to top
https://www.freecodecamp.org/news/css-only-back-to-top-button/

Export icon list from Fontawesome

https://fontawesome.com/changelog

https://github.com/mackilroy007/font-awesome-v6
Using Node js:
 download icons.json file
 execute following code in node js:

var json = require("{file-path}/icons.json"); 
var FA6Json = {}; Object.keys(json).forEach(iconName => { const icon = json[iconName]; icon.styles.forEach(style => { if (!FA6Json[style]) { FA6Json[style] = []; } FA6Json[style].push(`fa-${style} fa-${iconName}`); }) }); require("fs").writeFile("{file-path}/FA6icons.json", JSON.stringify(FA6Json,null,2), () => {});

Local Apache HTTPS SSL
https://shaonmajumder.medium.com/secure-local-development-with-mkcert-a-step-by-step-guide-99e24317b305
https://www.baeldung.com/linux/secure-sockets-layer-local-network
https://www.digitalocean.com/community/tutorials/how-to-create-a-self-signed-ssl-certificate-for-apache-in-ubuntu-18-04
https://medium.com/@pasanglamatamang/configuring-a-self-signed-ssl-certificate-on-a-apache-server-cbcd6eefdf1a

Flarum migration
https://discuss.flarum.org/d/5138-moving-flarum-install-between-servers/11

Backup following elements

 Database 
PhpMyAdmin 
mysqldump -u mysql_user -p DATABASE_NAME > backup.sql
 composer.json
 composer.lock
 config.php files,
 extend.php for those who added any customizations,
 assets directory.

--------

Restore

 Install a bare flarum as per the instructions here without configuring it.
 Copy over your composer.json and composer.lock files.
 Run composer install --prefer-dist --no-dev
 Copy over your config.php file.
 Restore your database:
 PhpMyAdmin 
 b. mysql -u mysql_user -p DATABASE < backup.sql

 Copy over your flarum-root/assets folder.

--------

Reindex search (for chinese, 

MySQL only, performance impact

)

USE YourFlarumDataBaseName;
ALTER TABLE posts DROP INDEX content;
CREATE FULLTEXT INDEX content ON `posts` (`content`) WITH PARSER ngram;

USE YourFlarumDataBaseName;
ALTER TABLE discussions DROP INDEX title;
CREATE FULLTEXT INDEX title ON `discussions` (`title`) WITH PARSER ngram;