I need a basic php script or plugin to automatically create a new city with all of its categories and groups in my member site MySQL database
I'm building a Joomla group member site using "groups" and "events" plug-ins and I must replicate the category fields in one city into 50 more cities.
Each city will have 13 categories (sports, language etc...) Each category will have four or five groups
Philadelphia/Languages/Italian, French, German, Russian (groups)
Philadelphia/Sports/Baseball, Football, Hockey (groups)
Philadelphia/Games/Poker, Chess, Pool (groups) etc....
I need this done in New York, Chicago, Miami etc....
Is there a plugin that exists for this already? If not, what would this cost?