Ah, that’s an interesting request. Not sure how this is doable (it’d probably require some customization on your end) but let me see if anybody from our dev team has a suggestion to point you in the right direction. Thanks for the words so far!
Quick Answer
Yes, it’s possible, but not easy.
Long Answer
WordPress multisite saves each site’s data in a separate set of tables. Each site’s wp_db object only knows about it’s tables. There’s a nifty function called switch_to_blog() that allows you to grab data from other site’s tables, but it’s *very* slow as everything has to be dumped and reloaded every time you switch. Plus you have to cram all the queries together, sort them to get everything in order, then display them.
The better way would probably be to hook into the save/edit/delete function(s) and have all events saved/updated (as duplicates) to a single site then use that as the data source for your combined events table. That way the heavy lifting is on the backend and not on every request. But that’s no walk in the park either… and may not be completely possible without adding some hooks to the core plugin files — I can’t remember if we have hooks for all those scenarios in there yet.
If you do attempt it (or hire a dev to do so) good luck and let us know how it goes.
http://codex.wordpress.org/Function_Reference/switch_to_blog
Thank you for your answer. I did not realise that it would be so tricky. I think I will have to look at some other solutions.
Thank you again.
Thanks, Nick!
Steilenhang: If you have any other questions down the road, let us know. Happy to help when we can.