Author Topic: Batch edit/move categories?  (Read 9000 times)

0 Members and 1 Guest are viewing this topic.

Offline Gwydion

  • Full Member
  • ***
  • Posts: 126
    • View Profile
Batch edit/move categories?
« 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?


Offline thunderstrike

  • 4images Guru
  • *******
  • Posts: 2.327
    • View Profile
Re: Batch edit/move categories?
« Reply #1 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 ...
8 steps need when ask question -

- PHP version (ACP - > phpinfo())
- mySQL version (ACP - > phpinfo())
- 4images version
- Post screenshot / URL
- Post code in BB Code (no need full file for code) or post attach file
- It doesn't work. What is say - what is do for no work
- Install MOD ? If so - please say (troubleshooting)
- Read FAQ ? Install Bug fixes ?

Offline Gwydion

  • Full Member
  • ***
  • Posts: 126
    • View Profile
Re: Batch edit/move categories?
« Reply #2 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.

Offline Gwydion

  • Full Member
  • ***
  • Posts: 126
    • View Profile
Re: Batch edit/move categories?
« Reply #3 on: February 21, 2008, 02:11:13 PM »
No way to do that? Pity. :(

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Batch edit/move categories?
« Reply #4 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?
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Batch edit/move categories?
« Reply #5 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
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline metal_13

  • Pre-Newbie
  • Posts: 7
    • View Profile
Re: Batch edit/move categories?
« Reply #6 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?

Offline metal_13

  • Pre-Newbie
  • Posts: 7
    • View Profile
Re: Batch edit/move categories?
« Reply #7 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

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Batch edit/move categories?
« Reply #8 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.
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi