#!/bin/sh | |
# jfindfiles -- Find used and unused content files in your Joomla website | |
# | |
# This scripts supports Joomla versions 2.5 - 3.x | |
# | |
# Copyright 2014 Rene Kreijveld - email@renekreijveld.nl | |
# | |
# This program is free software; you may redistribute it and/or modify it. | |
# | |
# Warning! This script needs the file jfunctions. This has to be installed in the same directory as this script. | |
# | |
# general variables | |
mypath=$(cd $(dirname ${0}); pwd -P) | |
myname=$(basename ${0}) | |
# include general functions | |
. ${mypath}/jfunctions | |
# version | |
version=2.2 | |
# Setup Vvariables | |
start=./images | |
curdir=`pwd` | |
echo "Creating database dump..." | |
# Dump the database to a .sql file | |
if mysqldump --skip-opt --add-drop-table --add-locks --create-options --disable-keys --lock-tables --quick --set-charset --host=${host} --user=${dbuser} --password=${password} ${database} > ${database}.sql | |
then | |
echo "Database dump ${database}.sql created." | |
else | |
echo "Error creating database dump." | |
exit 1 | |
fi | |
dbdump=${curdir}/${database}.sql | |
usedfile=${curdir}/${sitename}-used.txt | |
notusedfile=${curdir}/${sitename}-notused.txt | |
echo "The following files were mentioned in your Joomla database:" > ${usedfile} | |
echo "The following files were NOT mentioned in your Joomla database:" > ${notusedfile} | |
echo "Checking for used and unused files..." | |
# Move into the images/stories directory | |
cd ${start} | |
# Find all files and check if they are mentioned in the database dump | |
for file in `find . -type f -print | cut -c 3- | sed 's/ /#}/g'` | |
do | |
file2=`echo $file | sed 's/#}/ /g'` | |
file3=`echo $file | sed 's/#}/%20/g'` | |
result1=`grep -c "$file2" ${dbdump}` | |
result2=`grep -c "$file3" ${dbdump}` | |
if [[ $result1 = 0 ]]; then | |
if [[ $result2 = 0 ]]; then | |
echo $file2 >> ${notusedfile} | |
else | |
echo $file2 >> ${usedfile} | |
fi | |
else | |
echo $file2 >> ${usedfile} | |
fi | |
done | |
# Move back to the root of the website | |
cd ${curdir} | |
# Cleanup database dump | |
rm ${dbdump} | |
# Report findings | |
echo "Files checking done." | |
echo "Check the following text-files for results:" | |
echo "${usedfile}" | |
echo "${notusedfile}" |
This comment has been minimized.
This comment has been minimized.
Hi Javier, In order for this script to work, you need to install the script joomlafunctions as well" https://gist.github.com/renekreijveld/9663741 |
This comment has been minimized.
This comment has been minimized.
Won't parse configuration file. |
This comment has been minimized.
This comment has been minimized.
Hi Rene, found this forum by Google in search for finding pics in joomla's image folder which are unused. Have no idea how to install your code to make it work. So could you just step back from prof talk and tell a newbie how to use / where to put the code you provide here? Since it's the only hit for my search… Thanks, Herbert |
This comment has been minimized.
This comment has been minimized.
Hello @HerKle, So here my Instruction:
is not working for me. I got an error. I changed the code to:
|
This comment has been minimized.
This comment has been minimized.
Hi, Thanks for this very useful script. Here is my gist with @wehsemann modifications, with a script to delete files using the unused text file and with the howto |
This comment has been minimized.
This comment has been minimized.
Hello, What can be the causes? How to fix it? I have diskspace available, so it's not the problem. My system is Red Hat Enterprise Linux Server release 6.7 (Santiago) Thanks |
This comment has been minimized.
This comment has been minimized.
Thank you so much renekreijveld, wehseman and psyray! With the usage comment by user psyray and his adapted files (as commented above) I was able to get it to work (I'm new to ssh).
There were three errors for the jfunctions.sh file
just because the version directory does not exist in in my Joomla 3.9.6 installation. That is not a problem at all though! |
This comment has been minimized.
This is a great idea! ^_^ thanks for sharing Rene
what is this ". ${MYPATH}/joomlafunctions" ?