I see many people asking about ways to improve on the Blog Defaults and the Blog Templates ideas. I would love to see something myself where you could setup every last part of the blog that someone would get.
So in thinking about this and looking at the database, it seems like there is an easier solution than any of the approaches I have seen so far.
In theory, you should able to simply copy any blog and create another one with fairly simple SQL statements, right? Just copy all the tables starting 'wp_5_' (where 5 is the ID of the blog you want to copy) and then create a new set of tables with the prefix 'wp_25_' and where 25 wouyld be the new blog id.
So the idea would be ask what blog we want to use as the template (could even allow for multiple templates.) So I select which one I want to use. Then all I have to do is update that blog. The site you are using as the basis would then work as live demo of the site as well.
Whenever someone signs up they get an exact copy of up to the minute changes, reading right from that blogs tables. Save them from setting up pages, categories, etc. They would just switch out the content on each page for themselves.
In creating the new tables. you could just do a text replace to swap out what the new url would be based on their signup info. Then replace the user info with that of the new signup as well.
Essentially there would be almost no settings in this plugin except for what each template should be called and which blog is to be used as the model.
Does this make sense? It almost sounds too easy. I'm just not very good at the SQL end of things. :slight_smile: