Latest comments

[rumboogy]

Thank you SmartMouse...I am hopeful I can make the PHP article work....

Wally

[spurry]

hello i have tryed this code in every block i have and in a article and nothing works, i no it will be me so could any one tell me where i am going rong please

thanks

[smartmouse]

You have to put the code in SSI.php file.
Then you have to create a phpblock and just write ssi_lastcom();.

[trifox]

hi there, i was in need of such a component also, i modified the query, so that it does not need to query for the username on each user!
and i added a table around,

Latest Item may be found here:
http://prollcoder.com/index.php?option=com_content&task=view&id=25&Itemid=1

Item in action:
http://www.fractalforums.com/index.php?action=gallery

and here is the sourcecode:

Code: [Select]

function ssi_lastcom ()
 {
global $scripturl,$db_prefix;
echo '<center><script type="text/javascript"><!-- google_ad_client = "pub-4885104155050142"; /* 728x90, Erstellt 05.03.08 */ google_ad_slot = "0199758893"; google_ad_width = 728; google_ad_height = 90; //-->  </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></center>  ';
  $query="SELECT comment,memberName,title, comments.date, comments.ID_MEMBER, comments.ID_PICTURE,thumbfilename     
FROM     
{$db_prefix}gallery_comment as comments     
RIGHT JOIN     
({$db_prefix}gallery_pic as pics,      {$db_prefix}members as members)       
ON       
(pics.ID_PICTURE =comments.ID_PICTURE       AND       members.ID_MEMBER=comments.ID_MEMBER       )       ORDER BY comments.date       DESC       LIMIT 10";

$request = db_query($query, __FILE__, __LINE__);   
while ($row = mysql_fetch_assoc($request))
{
echo '<table border="0" width="100%">   
<tr> <td colspan=2>
<a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '">     <small>on <b>', parse_bbc($row['title'],1) , '</b></small>     <small>by ', $row['memberName'], '</small></a>
</td></tr><tr>     
<td calign="top" width="68">
     <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="/gallery/0/',$row['thumbfilename'].'" width="64" ></a>
</td><td valign="top"><small>', parse_bbc($row['comment'],1) , '</small> <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><small>view</small></a>
<td> </tr>       
<tr><td colspan="2"><small>[', timeformat($row['date']), ']</small></td></tr>
<tr><td colspan="2"><hr></td></tr>
</table>';
}   
mysql_free_result($request);     

}


[Dylert]

Is it possible to use these codes for SMF 2.0.1 and the latest version of Tiny Portal? I only get a blank block, but maybe I'm doing something wrong. If not, where can I find a code for "Latest comments from the gallery" block?

[SMFHacks]

Updated to 2.0x call ssicom

Code: [Select]


function ssi_lastcom()
 {
global $scripturl, $smcFunc;

  $query="SELECT comment,real_name,title, comments.date, comments.ID_MEMBER, comments.ID_PICTURE,thumbfilename     
FROM     
{db_prefix}gallery_comment as comments     
RIGHT JOIN     
({db_prefix}gallery_pic as pics,      {db_prefix}members as members)       
ON       
(pics.ID_PICTURE =comments.ID_PICTURE       AND       members.ID_MEMBER=comments.ID_MEMBER       )       ORDER BY comments.date       DESC       LIMIT 10";

$request = $smcFunc['db_query']('', $query);   
while ($row = $smcFunc['db_fetch_assoc']($request))
{
echo '<table border="0" width="100%">   
<tr> <td colspan=2>
<a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '">     <small>on <b>', parse_bbc($row['title'],1) , '</b></small>     <small>by ', $row['real_name'], '</small></a>
</td></tr><tr>     
<td calign="top" width="68">
     <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="/gallery/',$row['thumbfilename'].'" width="64" alt="" ></a>
</td><td valign="top"><small>', parse_bbc($row['comment'],1) , '</small> <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><small>view</small></a>
<td> </tr>       
<tr><td colspan="2"><small>[', timeformat($row['date']), ']</small></td></tr>
<tr><td colspan="2"><hr></td></tr>
</table>';
}   
$smcFunc['db_free_result']($request);     

}


[Dylert]

Thanks a lot SMFHacks! 

Unfortunately I'm doing something wrong, because my block doesn't show anything.

I put ssi_lastcom(); in a php block?

I also put the code for 2.0x in SSI.php?

Below is the end of my SSI-file. Is it something wrong there??

Code: [Select]

foreach ($attachments as $attach)
echo '
<tr>
<td>', $attach['file']['link'], '</td>
<td>', $attach['member']['link'], '</td>
<td align="center">', $attach['file']['downloads'], '</td>
<td>', $attach['file']['filesize'], '</td>
</tr>';
echo '
</table>';
}

function ssi_lastcom()
 {
global $scripturl, $smcFunc;

  $query="SELECT comment,real_name,title, comments.date, comments.ID_MEMBER, comments.ID_PICTURE,thumbfilename     
FROM     
{db_prefix}gallery_comment as comments     
RIGHT JOIN     
({db_prefix}gallery_pic as pics,      {db_prefix}members as members)       
ON       
(pics.ID_PICTURE =comments.ID_PICTURE       AND       members.ID_MEMBER=comments.ID_MEMBER       )       ORDER BY comments.date       DESC       LIMIT 10";

$request = $smcFunc['db_query']('', $query);   
while ($row = $smcFunc['db_fetch_assoc']($request))
{
echo '<table border="0" width="100%">   
<tr> <td colspan=2>
<a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '">     <small>on <b>', parse_bbc($row['title'],1) , '</b></small>     <small>by ', $row['real_name'], '</small></a>
</td></tr><tr>     
<td calign="top" width="68">
     <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="/gallery/',$row['thumbfilename'].'" width="64" alt="" ></a>
</td><td valign="top"><small>', parse_bbc($row['comment'],1) , '</small> <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><small>view</small></a>
<td> </tr>       
<tr><td colspan="2"><small>[', timeformat($row['date']), ']</small></td></tr>
<tr><td colspan="2"><hr></td></tr>
</table>';
}   
$smcFunc['db_free_result']($request);     

}

?>

[SMFHacks]

It looks right anything in the forums error log.

[Dylert]

I can't find anything in the error log that seems to help. I got this.....

Fil: /customers/d/7/7/hellasforum.net/httpd.www/Themes/default/languages/TPortal.english.php (tp_below sub template - eval?)
Linje: 285

....a lot of times.

I use version 3.0.22 of Gallery Pro.

[Dylert]

Now I got this error:


Feil i databasen: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay

SELECT comment,real_name,title, comments.date, comments.ID_MEMBER, comments.ID_PICTURE,thumbfilename
FROM
smf_gallery_comment as comments
RIGHT JOIN
(smf_gallery_pic as pics, smf_members as members)
ON
(pics.ID_PICTURE =comments.ID_PICTURE AND members.ID_MEMBER=comments.ID_MEMBER ) ORDER BY comments.date DESC LIMIT 10

[SMFHacks]

Retry this

Code: [Select]

function ssi_lastcom()
 {
global $scripturl, $smcFunc;

  $query="SELECT comment,real_name,title, comments.date, comments.ID_MEMBER, comments.ID_PICTURE,thumbfilename     
FROM     
({db_prefix}gallery_comment as comments,
{db_prefix}gallery_pic as pics)
LEFT JOIN {db_prefix}members as members)  on     (members.ID_MEMBER=comments.ID_MEMBER )
WHERE  pics.ID_PICTURE =comments.ID_PICTURE ORDER BY comments.date       DESC       LIMIT 10";

$request = $smcFunc['db_query']('', $query);   
while ($row = $smcFunc['db_fetch_assoc']($request))
{
echo '<table border="0" width="100%">   
<tr> <td colspan=2>
<a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '">     <small>on <b>', parse_bbc($row['title'],1) , '</b></small>     <small>by ', $row['real_name'], '</small></a>
</td></tr><tr>     
<td calign="top" width="68">
     <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="/gallery/',$row['thumbfilename'].'" width="64" alt="" ></a>
</td><td valign="top"><small>', parse_bbc($row['comment'],1) , '</small> <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><small>view</small></a>
<td> </tr>       
<tr><td colspan="2"><small>[', timeformat($row['date']), ']</small></td></tr>
<tr><td colspan="2"><hr></td></tr>
</table>';
}   
$smcFunc['db_free_result']($request);     

}


[Dylert]

Still doesn't work for me. 

I got this error:

Feil (error) i databasen: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') on (members.ID_MEMBER=comments.ID_MEMBER )
WHERE pics.ID_PICTURE =comm' at line 5

SELECT comment,real_name,title, comments.date, comments.ID_MEMBER, comments.ID_PICTURE,thumbfilename
FROM
(smf_gallery_comment as comments,
smf_gallery_pic as pics)
LEFT JOIN smf_members as members) on (members.ID_MEMBER=comments.ID_MEMBER )
WHERE pics.ID_PICTURE =comments.ID_PICTURE ORDER BY comments.date DESC LIMIT 10
Aktiver filtrering: Bare vise feilene fra denne filen
File: /customers/d/7/7/hellasforum.net/httpd.www/SSI.php
Line: 1981

[SMFHacks]

Reply

Code: [Select]

function ssi_lastcom()
 {
global $scripturl, $smcFunc;

  $query="SELECT comment,real_name,title, comments.date, comments.ID_MEMBER, comments.ID_PICTURE,thumbfilename     
FROM     
({db_prefix}gallery_comment as comments,
{db_prefix}gallery_pic as pics
LEFT JOIN {db_prefix}members as members)  on     (members.ID_MEMBER=comments.ID_MEMBER )
WHERE  pics.ID_PICTURE =comments.ID_PICTURE ORDER BY comments.date       DESC       LIMIT 10";

$request = $smcFunc['db_query']('', $query);   
while ($row = $smcFunc['db_fetch_assoc']($request))
{
echo '<table border="0" width="100%">   
<tr> <td colspan=2>
<a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '">     <small>on <b>', parse_bbc($row['title'],1) , '</b></small>     <small>by ', $row['real_name'], '</small></a>
</td></tr><tr>     
<td calign="top" width="68">
     <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><img src="/gallery/',$row['thumbfilename'].'" width="64" alt="" ></a>
</td><td valign="top"><small>', parse_bbc($row['comment'],1) , '</small> <a style="text-decoration: none;" href="', $scripturl, '?action=gallery;sa=view;id=', $row['ID_PICTURE'], '"><small>view</small></a>
<td> </tr>       
<tr><td colspan="2"><small>[', timeformat($row['date']), ']</small></td></tr>
<tr><td colspan="2"><hr></td></tr>
</table>';
}   
$smcFunc['db_free_result']($request);     

}
This should work now.

[Dylert]

Hm, it doesn't work for me.

I have put the new code in the SSI file and uploaded it to the server.

I add a new PHP block (left block) in TinyPortal.
In the body area i write ssi_lastcom();

The block is still empty. If I make a top or bottom block my entire frontpage shows up in the block.  

[SMFHacks]

At a loss now try to do a test function like

Code: [Select]

function ssi_test()
{
 echo 'test';
}
And see if it does anything.