[MOD] Last comments v1.2.0

[ucladidas]

Is there a way to display the user first and last name instead of user name?  I have the additional custom db fields of user_firstname and user_lastname.  How can I have these show up instead of the username.

Thanks.

[V@no]

Re-do step 1 and customize your template to your needs (the list of new tags you can find at the bottom of first post)

[AntiNSA2]

Replying to the correct thread...

how do we get the user flag to display on home.html wise one

[ucladidas]

V@no,

Thank you for your quick reply and posting a new code.  The {comment_additionalUserFieldName} and {image_user_additionaUserFieldName} don't seem to be working.  I just get blanks.  The additional field name I use (which is inputted in registration page and subsequently does show up in member profile pages) are user_firstname and user_lastname.  When I try using those tags (i.e., {comment_user_firstname} and even {comment_firstname}) nothing shows up on the webpage.

Do you have any ideas what might be going on?  Thank you for your help.

[V@no]

hmmm strangely not all changes I've made in my editor endup here...sorry about that,
Re-do step 1 again.
In your case {comment_user_firstname} is what you are looking for.

P.S.
I did not test the changes myself, hopefully I didn't mess it up.

[ucladidas]

Hi V@no,

I tried re-pasting your changes, but now I get a "DB error", saying that there is an error in my SQL syntax...

[V@no]

I'm sorry, put an extra comma at the end:

Code: [Select]

$sql = "SELECT c.image_id, c.comment_id, c.user_id as comment_user_id, c.user_name as guest_user_name, c.comment_headline, c.comment_text, c.comment_date, i.cat_id, i.user_id, i.image_name, i.image_media_file, i.image_thumb_file".get_user_table_field(", u.", "user_name")." as user_name".get_user_table_field(", s.", "user_name")." as comment_user_name, $additional_sql

Correct line is:

Code: [Select]

$sql = "SELECT c.image_id, c.comment_id, c.user_id as comment_user_id, c.user_name as guest_user_name, c.comment_headline, c.comment_text, c.comment_date, i.cat_id, i.user_id, i.image_name, i.image_media_file, i.image_thumb_file".get_user_table_field(", u.", "user_name")." as user_name".get_user_table_field(", s.", "user_name")." as comment_user_name $additional_sql

I've updated the original post with the correct line.

[ucladidas]

I still get blanks.  Nothing shows up on the webpage when I try using the {comment_user_firstname} tag...

[V@no]

ok, I found what I did wrong. Re-do step 1 one more time. it should work now.
Sorry about that.

[ucladidas]

Perfect!  Thank you so much!  Your skills are unparalleled...

[AntiNSA2]

Greetigns...

Two questions

1) I tried to get user flags to work with this mod, but they always show the lan.gif.... even though the user flags mods works in the other comment areas...

And...

how can you get the google Ajax translation from this thread http://www.4homepages.de/forum/index.php?topic=24018.new#new

to work on this? I tried to change the code by replacing this in

<div id="translate_comment_{comment_id}">{comment_text}</div>


last_comment_bit.html

and I added this

<p>View this Comment in: <a href="javascript:google_translate('en','comment',{comment_id});"><img src="{template_url}/images/gb.png" border="0"></a> <a href="javascript:google_translate('de','comment',{comment_id});"><img src="{template_url}/images/de.png" border="0"></a> <a href="javascript:google_translate('fr','comment',{comment_id});"><img src="{template_url}/images/fr.png" border="0"></a></p>

I can see the flags but it doesnt translate....

however the mod does work fine in the normal comment_bit template....



Thanks great master for your input....

[4ella]

Gotta say compliments to the authors of this Mod , works perfectly , easy 5 minuts instalation . Thought that most Mods here are only till 1.7.2 - 1.7.4 because I see mostly very old posts , but maybe I was wrong . Wanted to ask the people who create those Mods (authors) : Are you always trying the update the original (first )posts? I'm new here and I like many MOds here , but I'm forced to read all the pages from the year 2002 till 2009 if the Mod is also working in latest  1.7.6 version ,  Thanks again !!!

[rescue911]

i already have this mod installed for a while and it works just perfectly.
however today i switched over to "thumbnail_openwindow" which also works ok. however i had to modify the top.html to make it work there.

but my problem now is that when i click on the pictures or text links from the last comments, it does not open a pop-up but opens directly in the same window.
so my question: what do i need to modify there?

[V@no]

re-do step 1 and use {comment_image_openwindow} and {comment_image_name_openwindow} tags in last_comment_bit.html template

[rescue911]

ok now it does not open anymore in the same window. i now get it in a new tab of my browser.
but...how to make to get it as a pop-up, just like the details pages with "thumbnail_openwindow"?