- Posts: 2
- Thank you received: 0
Kunena 6.3.0 released
The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3
Solved K 3.0.5 : How to change the name of the writer of a topic
8 years 6 months ago #1
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
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.
8 years 6 months ago #2
by sozzled
Blue Eagle vs. Crypsis reference guide
Read my blog and
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.
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
Please Log in or Create an account to join the conversation.
- WolfgangOWL
- Offline
- Senior Member
8 years 6 months ago #3
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'
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'
Please Log in or Create an account to join the conversation.
8 years 6 months ago #4
by sozzled
Blue Eagle vs. Crypsis reference guide
Read my blog and
Replied by sozzled on topic K 3.0.5 : How to change the name of the writer of a topic
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 .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'
Blue Eagle vs. Crypsis reference guide
Read my blog and
Please Log in or Create an account to join the conversation.
8 years 6 months ago #5
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
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.455 seconds