PhotoPost Community

PhotoPost Community (
-   General Discussion (
-   -   Category Help (

alma townsend August 19th, 2004 01:39 AM

Category Help
I have setup 489 categories, and want to setup 2 main categories with these 489 as subcats in each. Anyway to do this without having to recreate the same subcats? Anyway to duplicate them?
Thanks for your help

Chuck S August 19th, 2004 06:25 AM

Some fancy mysql

You need to create the first block say category 1 with all its subcategories

Then you do a mysql export and in a text editor you need to change the main cat entry to another id value say whichever is the next autoincrement number next to come. You then need to edit the parent value in the export of all the subcats to be that new number. You then need to make the id value in all the subcats blank so it will follow the autoincrement on install.

Then take that tweaked mysql sql and run it.

All times are GMT -5. The time now is 05:51 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.