The secure CMS.

Welcome to Geeklog, Anonymous Thursday, April 18 2024 @ 09:11 pm EDT

Geeklog Forums

Enable, disable or close comments for all stories

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

::Ben

Forum User
Full Member
Registered: 01/14/05
Posts: 1569
Location:la rochelle, France
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".
I'm available to customise your themes or plugins for your Geeklog CMS
 Quote
 New Topic  Post Reply
All times are EDT. The time is now 09:11 pm.
  • 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