Kunena 7.0.11 & Kunena 6.4.16 – Security Updates Released and K7.1 in RC1 2

The Kunena team has announce the arrival of three simultaneous security release : K6.4.16, K7.0.11 and K7.1 RC2. Just a reminder K6.4.16 receives only securities fixes untill end of 2026, so it's advised for users to upgrade to K7.0.11. K7.0.11 is the last release of the K7.0 because it's replaced by K7.1 branch with the stable release in the corner. The translations for K7.1 on crowdin.com/project/kunena-forum-7-1 needs to be checked or improved becasue it has been generated by TM (Translation Machine).

Solved K 3.0.5 : How to change the name of the writer of a topic

More
11 years 3 weeks ago #169117 by phiphi22
K 3.0.5 : How to change the name of the writer of a topic was created by phiphi22
Hi all,

Everything is in the title, I would like to know if it's possible to change the name of the writer of a topic and how to. Even if I need to go into the database (which table, column, etc.)?

Thanks in advance.

Philippe

Please Log in or Create an account to join the conversation.

More
11 years 3 weeks ago #169118 by sozzled
Replied by sozzled on topic K 3.0.5 : How to change the name of the writer of a topic
The information is stored in the database (in the table _kunena_messages)

To change the name of the "writer of a topic", locate the record that corresponds to the first post in the topic and change the userid field (and, optionally, the name field) to what you need.
Blue Eagle vs. Crypsis reference guide
Read my blog and image missing https://g.twimg.com/twitter-bird-16x16.png

Please Log in or Create an account to join the conversation.

More
11 years 3 weeks ago #169120 by WolfgangOWL
Replied by WolfgangOWL on topic K 3.0.5 : How to change the name of the writer of a topic
update xxx_kunena_messages set name = 'newname' where name = 'oldname'

update xxx_kunena_topics set first_post_guest_name = 'newname' where first_post_guest_name = 'oldname'

update xxx_kunena_topics set last_post_guest_name = 'newname' where last_post_guest_name = 'oldname'
www.scrollsawprojects.net

Please Log in or Create an account to join the conversation.

More
11 years 3 weeks ago #169122 by sozzled
Replied by sozzled on topic K 3.0.5 : How to change the name of the writer of a topic

WolfgangOWL wrote:

Code:
update xxx_kunena_messages set name = 'newname' where name = 'oldname' update xxx_kunena_topics set first_post_guest_name = 'newname' where first_post_guest_name = 'oldname' update xxx_kunena_topics set last_post_guest_name = 'newname' where last_post_guest_name = 'oldname'

I would be very careful about using this technique. This will change all topics created by someone with a new name. The last thing we want is to destroy the data .
Blue Eagle vs. Crypsis reference guide
Read my blog and image missing https://g.twimg.com/twitter-bird-16x16.png

Please Log in or Create an account to join the conversation.

More
11 years 3 weeks ago #169149 by phiphi22
Replied by phiphi22 on topic K 3.0.5 : How to change the name of the writer of a topic
Thank you very much sozzled and WolfgangOWL for your answer.

It works very well : changing one post with sozzled method.
I keep the method of WolfgangOWL for massive change.

Philippe

Please Log in or Create an account to join the conversation.

Time to create page: 0.116 seconds