Import from yvcomment the username rather than the real name

[djb]

Hi,

Having been a long time user of yvcomment, I have been looking for a commenting component for 2.5.  I have been using JComment 2.3.0 today and am really impressed with it.

The only issue I have is with the import of the comments from yvcomment.  Whereas yvcomment shows the username in posts, when these are imported into JComment, the name displayed is the real name.  Ideally I would want the username to continue to be the display name for the comment.

Can you tell me if this is possible please?

in Jos_Content, my yvcomments have categoryid=99.  The created_by_alias field holds the username of the person who made the comment.  in Jos_JComment, both the Name and UserName fields are set to the value of the value of username from ycvomment.  I imagine a simple script could be written to update the UserName in Jos_JComment with the UserName from Jos_Users?

Many thanks
David

[smart]

You can setup what do you want to show - name or username in JComments settings...

[djb]

Thank you.

Here's the code to add the username from the jos_users to the username field on jos_jcomments in case anyone needs it:

Code: (sql)

update jos_jcomments, jos_users
set jos_jcomments.username = jos_users.username
where jos_jcomments.userid = jos_users.id

Regards
David

[smart]

Thank you David for sharing the solution!