The secure CMS.

Welcome to Geeklog, Anonymous Thursday, November 21 2024 @ 08:00 am EST

Geeklog Forums

Enable, disable or close comments for all stories

 New Topic  Post Reply
 05/05/13 05:54am (Read 2,728 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 EST. The time is now 08:00 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