Subject: Enable, disable or close comments for all stories

Posted on: 05/05/2013 05:54am
By: ::Ben

If you need to enable, disable or close comments for all stories, a tool such as phpMyAdmin can help you.

1. Login to phpMyAdmin. If you do not know where or how to do this, please consult your host.

2. In some cases, you may have to choose which database your Geeklog tables are located on. If this is the case, please choose using the dropdown box.

3. To run a SQL query, click on "SQL" on the navigation bar.

4. Enter your SQL in the box provided :

To enable comments for all stories

PHP Formatted Code
UPDATE `gl_stories` SET `commentcode`= 0 WHERE 1


To disable comments for all stories

PHP Formatted Code
UPDATE `gl_stories` SET `commentcode`= -1 WHERE 1


To close comments for all stories

PHP Formatted Code
UPDATE `gl_stories` SET `commentcode`= 1 WHERE 1


5. Click "Execute".

Geeklog - Forum
https://www.geeklog.net/forum/viewtopic.php?showtopic=94984