Updating admin user e-mail, when you only have MySQL command line access: UPDATE `wp_users` SET `user_email` = 'INSERT_MAIL' WHERE `ID` = '1';
generate wordpress password for insertion in database: echo -n "password" | md5sum
Articles
1 kg of borax or boric acid mixed with 20 liters of water to soak bamboo.
1 teaspoon of borax or boric acid mixed with 2 teaspoons of sugar. Mix a bit of water into this to make it a paste to control the amount of termites and ants.
High quality chaya products including plants and powder products - very good for your health: https://shopee.co.th/inlikasatfarm
High quality non bleached flours and oats: https://shopee.co.th/cmbakermart
Using Tesseract 4 with standard settings for OCR, will you give you odd spaces in the Thai letters.
I found this command example to be a good option: tesseract image.png outfile -l Thai -c preserve_interword_spaces=1
CodeIgniter is a PHP framework that will help you create web applications and web sites faster than writing code from scratch.
Login system
http://mfikri.com/en/blog/codeigniter-login
https://www.codexworld.com/codeigniter-user-registration-login-system/
Prestashop together with Thirty Bees is a PHP based webshop system widely used by many webshop owners.
Modules
Multi store and marketplace: https://www.knowband.com/prestashop-free-marketplace-modules
Examples of google review link generators. The options they provide are similar and they are easy to use.
Review Greg:
Short link: https://supple.live/aKFwxAVbXXGY3AoQ6
2018-01-29: Populate TableView with Database Data JavaFX - Load Data on TableView from MySQL Database: https://www.youtube.com/watch?v=LoiQVoNil9Q
2017: JavaFX examples github: https://github.com/callicoder/javafx-examples
Button with eventhandler: https://www.geeksforgeeks.org/javafx-button-with-examples/
I was very surprised that a function BAHTTEXT() exists in Excel. It converts a number to written words.
There is no English equivalent, but many functions and workarounds exist on the internet. For example the VBA function here: https://www.sumproduct.com/blog/article/a-to-z-of-excel-functions/the-bahttext-function
Advanced Custom Fields (ACF): https://wordpress.org/plugins/advanced-custom-fields/
SSL: https://wordpress.org/plugins/really-simple-ssl/
Cookie Notice (GDPR) by dFactory: https://wordpress.org/plugins/cookie-notice/
Menu icons by ThemeIsle: https://wordpress.org/plugins/menu-icons/
Use the =TEXTJOIN(",",1,A:A)
This will join all values in the A-column into a single cell separated by ",". You can of course change the value to whatever you like.
If you have a lot of content including taxonomies and you suddenly would like to change the language of the interface it is not that easy. The current solution I use is to change the default language to your desired language and then export the database. Then replace the string 'en' with your desired language code and reimport the database.
You need to export the node and taxonomy tables only.
For example: sed "s/'en'/'sv'/g" input.sql > output.sql
Or you need to build sql queries like this, not complete list:
Taxonomy term depth module: https://www.drupal.org/project/taxonomy_term_depth
Term hierarchies:
For content: [node:field_tags:0:entity:parents:join-path]/[node:field_tags:0:entity]/[node:title]
For taxononomy terms: [term:vocabulary]/[term:parents:join-path]/[term:name]
Redirect - we need redirection if the title of an entity changes. Very good for search engine optimization and being able to contain links coming from outside.
Google Analytics - we need to track what is going on.
Pathauto - we need search engine friendly titles on our articles and pages populated automatically.
simple_sitemap - a nice xml sitemap generator.
Corrects urls automatically: pathologic
Core: responsive_image
Compress:
tar -czvf name-of-archive.tar.gz /path/to/directory-or-file
The Drupal Shell is an amazing tool if you maintain Drupal web sites and you have shell access to the server, where the Drupal site is hosted. This is also an unvaluable tool if you develop i in Drupal.
Drush 8
Updating drush: composer global update drush/drush
Manual install: http://docs.drush.org/en/8.x/install/
Check latest drush version: https://github.com/drush-ops/drush/releases/
Example procedure:
Configuring SquirrelSQL and MS SQL
Remove 100 row limit: File -> New Sessions Properties -> Object Tree -> Contents -> limit rows.