Bash Script to execute wp-cron.php on a Multisite Wordpress.

wp-cron.sh

#!/bin/sh
db_host="host";
db_user="user";
db_pass="password";
db_name="database";

domains=`mysql --silent --skip-column-names --host $db_host --user $db_user -p$db_pass $db_name --execute "SELECT domain FROM wp_blogs WHERE archived = '0' AND spam = '0' AND deleted = '0';"`;

for domain in $domains; do
	the_date=`date`;
	echo -ne "$the_date\t$domain\t";
	response=`GET http://$domain/wp-cron.php`;
	exit_status=$?;
	if [ $exit_status != 0 ]; then
		echo "ERR"
	else
		echo "OK"
	fi
done;

I'm going to test it on a 200+ WP
I'll adapt the script if I experience some troubles :p

I forked the scrip to:

• extract the database values from wp-config.php automatically
• use domain and path for subdomain / mixed installs
• use wget instead of GET

I also dropped error logging and output because in my case I don't really need it. Thanks for an excellent starting point.

I'm glad it helped you!