Welcome to Geeklog, Anonymous Saturday, December 21 2024 @ 09:06 pm EST

Geeklog Forums

How do you mass delete stories?


OhHelp!

Anonymous
caffeinated
I'm trying to delete stories (I have more than 200 stories) and I can only go in and edit each one one by one. Is there any way to select many at a time and delete at the same time?

Help!
 Quote

OhHelp!

Anonymous
can anybody help me with this?
 Quote

Status: offline

jmucchiello

Forum User
Full Member
Registered: 08/29/05
Posts: 985
Create a dummy topic. Move all the stories into the topic using SQL (if you know how). Drop the topic from within geeklog (not using SQL). That should properly delete all the stories. The trick is assigning the stories you want to a specific topic.
 Quote

OhHelp!

Anonymous
I don't know how to use sql. Can you give me a step by step? Or is it too complicated....?
 Quote

Status: offline

jmucchiello

Forum User
Full Member
Registered: 08/29/05
Posts: 985
Are there stories you don't want to delete as well as stories you do want to delete? If there are, you need some way to differentiate them.

If you want to delete all stories you can do this
In the admin section create a dummy topic (call it dummy).
In phpmysqladmin run this query: UPDATE gl_stories SET tid = 'dummy'
Then go back to the topic admin and drop the dummy topic.
 Quote

All times are EST. The time is now 09:06 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