croc Posted January 9, 2015 Share Posted January 9, 2015 Hello All, could somebody tell me who has experience with database cleaner module by PS 1.6 , if after removing of categories will be removed also root and home category or of these two will stay in database. Thanks. Link to comment Share on other sites More sharing options...
vekia Posted January 9, 2015 Share Posted January 9, 2015 hello module will not remove home and root category $db->execute('DELETE FROM `'._DB_PREFIX_.'category` WHERE id_category NOT IN ('.implode(',', array_map('intval', $id_home)).', '.implode(',', array_map('intval', $id_root)).')'); 1 Link to comment Share on other sites More sharing options...
croc Posted January 9, 2015 Author Share Posted January 9, 2015 hello module will not remove home and root category $db->execute('DELETE FROM `'._DB_PREFIX_.'category` WHERE id_category NOT IN ('.implode(',', array_map('intval', $id_home)).', '.implode(',', array_map('intval', $id_root)).')'); Thanks for info. Link to comment Share on other sites More sharing options...
Recommended Posts