UESPWiki:DailyEdits/uesp-create-dailyedits-plot

#!/bin/sh
#
# Note: Change "wikidb" below to match the name of your MediaWiki database. The mysql command below likely requires addition 
# of user/password or credential file for permission. The GNUPlot file also looks for the dailyedits.dat file in the same 
# location as specified.
#
rm -f /tmp/dailyedits.dat
mysql -e "SELECT COUNT( * ) , LEFT( rev_timestamp, 8 ) AS revdate FROM wikidb.revision GROUP BY revdate INTO OUTFILE '/tmp/dailyedits.dat';"
gnuplot dailyedits-plot.cfg