Welcome to Geeklog, Anonymous Friday, April 19 2024 @ 03:00 pm EDT

Geeklog Forums

Joining different topics


John.

Anonymous
Hey all,

We've just upgraded a newswire to geeklog, and we wanted to cut down the number of topics from 20-odd to 5. Is there any way I can move all the articles from several topics into one new one? Because I can't seem to find a way do it (save from going through each story doing it manually)

Any information appreciated, thanks!
J
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
You'll have to dive into the database for this, but it's pretty easy nonetheless.

Say you want to move all stories from the topic with the topic id (not to be confused with the topic name) "music" to the topic id "food", then you'd do:
Text Formatted Code
UPDATE gl_stories WHERE tid = 'music' SET tid = 'food';
 

bye, Dirk
 Quote

John.

Anonymous
that worked a treat Dirk, thanks very much! This software is excellent Cool
 Quote

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