View Full Version : Move mass categories in one click
October 27th, 2007, 03:02 AM
I've imported a very large gallery from Smartors gallery. The old hierarchy was dropped down and now I've to organize many categories and subcategories located at the same level (without parent categories).
So, I'm searching for a fast method that allow me to move 300 categories in one action.
There's a way to make it? I've discover the ACP and I don't find anything that could help me.
October 27th, 2007, 02:10 PM
All 300 cats under a main parent ?
- Main Parent
- - 300 sub cats
*I am using my own ##'s.
I am assuming all categories in the gallery must be moved under 1 parent.
Main Parent category ID is needed .
- this will be the category all under fall under.
- if you have a table prefix on your vBulletin tables include please.
I will use catid: 10
UPDATE ppgal_categories SET parent = '10'
- this moves all Cats under Cat 10.
I will use catid: 10 (same as above)
UPDATE ppgal_categories SET parent = '0' WHERE catid = '10'
- this will make the "Main" category have "no parent" (be on top)
- will fix the rest
October 27th, 2007, 03:16 PM
I'll try , Thank you Zachariah
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.