Welcome to Geeklog, Anonymous Sunday, September 01 2024 @ 12:29 am 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
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
7
9
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:
bye, Dirk
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
7
8
Quote
John.
Anonymous
that worked a treat Dirk, thanks very much! This software is excellent
![Cool Cool](http://www.geeklog.net/images/smiles/icon_cool.gif)
9
4
Quote
All times are EDT. The time is now 12:29 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