Latest comments

[smartmouse]

Hello, any way to create a tp module that shows latest comments added?

Thank you.

[smartmouse]

Is it possible to do it?

[SMFHacks]

Yes it is would require checking the gallery comments table with a database query

[smartmouse]

I can't do it... is it easy for you create that query?

[smartmouse]

Please some one can help me to create a php module that show latest comments?

[rumboogy]

I like that idea...but unfortunately it would take more expertise than I have...interesting though...I will watch this thread. You could also check over at the TP Site.

Wally

[smartmouse]

@admin: can you create a module like this?

http://www.smfhacks.com/index.php/topic,125.msg8845.html#msg8845

I think you can modify it to make it showing latest comments instead of random images.
Am i right or maybe it is more difficult than i think?

I hope can do it.

Thank you.

[smartmouse]

Anyone (maybe a programmer) can help me?

[smartmouse]

I'm here again!

I tried my best to write this:

Code: [Select]

function ssi_lastcom ($cat)
{
global $scripturl,$db_prefix;
$cat = (int) $cat;

$request = db_query("SELECT comment, date, ID_MEMBER, ID_PICTURE FROM {$db_prefix}gallery_comment GROUP BY comment ORDER BY date DESC LIMIT 5", __FILE__, __LINE__);
$row = mysql_fetch_assoc($request);
mysql_free_result($request);
echo' <a href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><small>', $row['comment'], '</small></a><br />Written by: <strong>', $row['ID_MEMBER'],  ' '
;}
It works, but it shows only 1 comment...
So, do you know how to make it to show more than 1 comment? I write LIMIT 5 but it does not work!
In addition, do you know how to show member name instead of member id ?

[SMFHacks]

Try this

Code: [Select]

function ssi_lastcom ($cat)
{
global $scripturl,$db_prefix;
$cat = (int) $cat;

$request = db_query("SELECT comment, date, ID_MEMBER, ID_PICTURE FROM {$db_prefix}gallery_comment ORDER BY date DESC LIMIT 5", __FILE__, __LINE__);
while($row = mysql_fetch_assoc($request))
      {
echo' <a href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><small>', $row['comment'], '</small></a><br />Written by: <strong>', $row['ID_MEMBER'];
       }
mysql_free_result($request);

}


[rumboogy]

I tried smartmouse's code and got no errors, but I also got no comment.

I tried Mr. Hacks code...and got the same thing. Just curious...and you may or may not want to develop this or work on it...but to me it seems like it would have more meaning if the block ALSO included the image that was being commented on...

Thanks.

Wally

[smartmouse]

My friend help me and now it works. Here is the working code:

Code: [Select]

function ssi_lastcom ($cat)
{
global $scripturl,$db_prefix;
$cat = (int) $cat;
 
$request = db_query("SELECT comment, date, ID_MEMBER, ID_PICTURE FROM {$db_prefix}gallery_comment GROUP BY comment ORDER BY date DESC LIMIT 5", __FILE__, __LINE__);
while ($row = mysql_fetch_assoc($request)) {
echo' <a href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><small>', $row['comment'], '</a><br />Scritto da: <strong>', $row['ID_MEMBER'],  '<br /><br /></strong></small> ';
}
mysql_free_result($request);
}
Now i have to fix just the last thing: how to show member name instead of member id?
It results in messages like "Hello world" written by: 2, instead of "Hello world" written by: John.

Do you understand what i mean? How to fix it?

[smartmouse]

Ehm.. it is the same code posted by SMFHacks.
Anyway how to fix my problem?

[rumboogy]

Ehm.. it is the same code posted by SMFHacks.
Anyway how to fix my problem?

Smartmouse...I only get a blank block with your new code.

Also...don't you think the block should also include the image with the last comment?  yes, no?

Maybe I am missing something, the function ssi_lastcom ($cat)...is that something that should be in my SSI.php file?

Wally

[smartmouse]

I added the code that i posted above at the end of SSI.php file.
Then i create a new block in TPortal and i added the following code:

Code: [Select]

ssi_lastcom();
It works.