Shadow Sysop Posted April 12, 2023 Share Posted April 12, 2023 My knowledge base is massive and public. Going article to article, setting each as private, is not viable to accomplish making the knowledge base viewable only by logged in users. Can anyone offer some guidance on how I can do this on a mass scale? I was thinking this might be accomplished via phpMyAdmin but I'm not entirely sure. 0 Quote Link to comment Share on other sites More sharing options...
web2008 Posted April 12, 2023 Share Posted April 12, 2023 Yes, you can do this via phpMyAdmin in the table tblknowledgebase ... 0 Quote Link to comment Share on other sites More sharing options...
Shadow Sysop Posted April 12, 2023 Author Share Posted April 12, 2023 Yes, thanks for the confirmation, but I'm not a database guy and was hoping for specific SQL commands to accomplish this. 0 Quote Link to comment Share on other sites More sharing options...
Solution DennisHermannsen Posted April 12, 2023 Solution Share Posted April 12, 2023 Do you want to set everyone as private? If that's the case, just execute the following SQL UPDATE tblknowledgebase SET `private` = 1 1 Quote Link to comment Share on other sites More sharing options...
Shadow Sysop Posted April 12, 2023 Author Share Posted April 12, 2023 Yes this is exactly what I wanted. Thank you very much @DennisHermannsen 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.