WP3 DB Fields for Socrates

[spradlig]

I run a lot of blogs with geo location as part of the keywords strategy. However, this means the I create a blog for each state or for dozens of cities. The easiest thing would be to copy the relevant WP3 DB fields for Socrates from one install to the next. (And preferably the DB fields for the widgets as well.)

What are the relelvant tables and fields? (I'm somewhat familiar with the WP 2.9 DB but I haven't studied the WP 3 DB. I expect most of the relevant fields will be in the wp_options table.)

Thanks

[Dan Nickerson]

Did you figure this out? Looks like no one responded, probably because the answer is a bit complex

[compusol]

I guess you could set up your first blog with all the theme and plugin customizations then simply clone the complete blog to a new install.

All you would need to do then is to change the geo location for each install.

The only tool that I know that clones blogs quickly is Mike Filsaime's WP-Cloner (http://csgl.net/wp_cloner/)

I heard some good reports of how easy this tool makes it, and as with most of Mike's products it should work without any problems.

[spradlig]

The DB fields aren't complicated as far as I can tell but it did take a long time to figure them out.

Clearly the obvious solution is to copy everything and then just change the geo location. However, if I ever want to do anything with just hte header and not copy the whole DB then I really need the Socrates specific DB fields.

As far as I can tell all of the fields are in the _options table. The option_names are:

headerOptions
socratesOptions
analyticOptions
layoutOptions
bgOptions
navOptions
primaryNavOptions
footerNavRightOptions
footerNavLeftOptions
styleOptions
metaSettings
smallAdOptions


I may have missed one or two but this is the list I could find. Altering them is different matter. The way many of them are stored (and many other standard WP DB options are stored) takes a little time to decipher.

Gabe