Welcome to Geeklog Wednesday, October 18 2017 @ 01:37 am EDT


Status: offline

::Ben

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

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".
I'm available to customise your themes or plugins for your Geeklog CMS

All times are EDT. The time is now 01:37 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