It is currently 19 Feb 2018, 05:59

Anything Goesphpbb How to change Topic titles of posts (in phpMyAdmin) (Showcase | Slideshow)

Anything, almost anything at all
(even advertisement if it's decent, spammers will be banned)
Post Reply
User avatar
tim

Administrator
View: Showcase | Slideshow
Topic Posts: 1/1
Posts: 2157
Joined: 26 Sep 2016, 00:16
Cash on hand: 7,894.01 GLP
Bank: 51,356.25 GLP
Gender: Guy
Location: Victoria, BC
Website: https://gimplearn.net
Operating System: Windows
GIMP Version: 2.8.22
My Personal Blog
My FineArtAmerica
x 1196
x 256
Contact:
Canada

phpbb How to change Topic titles of posts (in phpMyAdmin)

Post#1 by tim » 07 Apr 2017, 15:23


phpbb currently allows you to edit Topic title(Subject) of first each post.
To change topic title, just change first post's subject.

But I wanted to change all posts subjects. Here's what i did in phpMyAdmin.

First I selected the topic of interest.

Code: Select all

SELECT * FROM phpbbsf_topics WHERE topic_title = 'Glimps';
It returned a single row with topic_id = 238

Then I ran these 3 queries

Code: Select all

UPDATE phpbbsf_topics SET topic_title = 'Glimps RJKD artwork' WHERE topic_id = 238 AND topic_title = 'Glimps';
UPDATE phpbbsf_posts SET post_subject = 'Re: Glimps RJKD artwork' WHERE topic_id = 238 AND post_subject = 'Re: Glimps';
UPDATE phpbbsf_posts SET post_subject = 'Glimps RJKD artwork' WHERE topic_id = 238 AND post_subject = 'Glimps';
First update statement updates the topic's record to reflect new topic title.
Second Update updates all the posts replying to the topic with the 'Re: ' in front of it.
Third Update updates just updates the first post's subject to say that the topic title does.

There you have it.
Now you can manually change all your posts subjects that belong to a specific topic.
0 x



aka Tin
Image gimplearn.net                                              

Registered members enjoy ads-free content
Post Reply

Last 20 Members Who Visited This Topic

  • Similar Topics
    Replies
    Views
    Last post
• Featuring Members' Works (Image Attachments Only) •
1: RJKD
2: animicule
3: Issabella
4: dinasset
5: dinasset
6: Pat625
7: Ella

Who is online

Users browsing this forum: No registered users and 1 guest