Script pour lister les thèmes WP
One liner par kaiyou :
read -s MYSQL_PASSWORD; for blog in $(docker-compose exec db mysql -u blogs -p$MYSQL_PASSWORD -A blogs -B -N -e 'select TABLE_NAME from INFORMATION_SCHEMA.TABLES where TABLE_NAME like "wp_%_options" AND TABLE_SCHEMA="blogs";'); do echo $blog; docker-compose exec db mysql -u blogs -p$MYSQL_PASSWORD -A blogs -N -e "select * from $blog where option_name='current_theme' or option_name='blogname';" ; done
Edited by MickGe