The secure CMS.

Welcome to Geeklog, Anonymous Sunday, January 18 2026 @ 01:55 am EST

Geeklog Forums

Enable, disable or close comments for all stories

 New Topic  Post Reply
 05/05/13 05:54am (Read 2,991 times)  
Status: offline

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1581
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

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


To disable comments for all stories

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


To close comments for all stories

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


5. Click "Execute".
 Quote
 New Topic  Post Reply
All times are EST. The time is now 01:55 am.
  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content