4images Forum & Community

4images Modifications / Modifikationen => Mods & Plugins (Requests & Discussions) => Topic started by: Gwydion on February 14, 2008, 01:02:51 AM

Title: Batch edit/move categories?
Post by: Gwydion on February 14, 2008, 01:02:51 AM

Is there a mod or way to move several categories in one go?

Example:
magazines
--- 2007
--- 2007-name1
--- 2007-name2
If I want to move both 2007-name categories into the category 2007 I now must edit each one.
No problem with 2 but tiresome with several categories.

Is there a way round like there is for images with the batch copy/move/edit/delete mod?

Title: Re: Batch edit/move categories?
Post by: thunderstrike on February 14, 2008, 04:35:47 AM

Use this:

http://www.4homepages.de/forum/index.php?topic=6759.0

Please use search - I find first result in search page for request ...

Title: Re: Batch edit/move categories?
Post by: Gwydion on February 14, 2008, 11:27:48 AM

With all due respect but I searched.
And I know this mod, use it and it is NOT what I need.
I need to batch move categories.

Title: Re: Batch edit/move categories?
Post by: Gwydion on February 21, 2008, 02:11:13 PM

No way to do that? Pity. :(

Title: Re: Batch edit/move categories?
Post by: Nicky on February 22, 2008, 03:42:24 PM

hi....

Quote

-magazines
-- 2007
-- 2007-name1
-- 2007-name2

2007-name1 and 2007-name2 should be subcategories of 2007

Quote

-magazines
-- 2007
--- 2007-name1
--- 2007-name2

correct?

Title: Re: Batch edit/move categories?
Post by: Nicky on February 22, 2008, 04:08:18 PM

i hope this is what you searching for...

1st) PLEASE test it AFTER you did a BACKUP from your MySQL DataBase!

mysql query for phpmyadmin >>

example:
UPDATE PREFIX_categories SET cat_parent_id = '5' where cat_parent_id = '4' and cat_id not in ('5')

example description:
PREFIX_ = your 4images prefix in mysql database (see config.php under $table_prefix = "xxxxx_";)
SET cat_parent_id = '5' = here set your cat_id from category 2007
where cat_parent_id = '4' = here set your cat_id from category magazines
and cat_id not in ('5') =  here set again your cat_id from category 2007  :arrow: means this one should be not changed.


quick and no need for a mod :)
maybe some1 will do it one day...

gruss aus wien

Title: Re: Batch edit/move categories?
Post by: metal_13 on March 09, 2009, 02:35:28 PM

i also need this... i have 645 categories and i need to edit their permissions... errr...
is there a way to auto approve uploaded images?

Title: Re: Batch edit/move categories?
Post by: metal_13 on March 15, 2009, 08:01:01 AM

can sum1 make this please... batch edit permissions and move Categories.....

like SMF categories... you just select the categories and move/add the settings u like

Title: Re: Batch edit/move categories?
Post by: Nicky on March 15, 2009, 02:17:49 PM

hi,

if you want to auto approve uploaded images and change this for all your categories
run this mysql query within your SQL admin

only for registered users:

Code: [Select]

UPDATE PREFIX_categories SET auth_upload = 2, auth_directupload = 2
or for ALL(guests included):

Code: [Select]

UPDATE PREFIX_categories SET auth_upload = 0, auth_directupload = 0
change PREFIX_ to match yours.