El bloc que mostra les últimes entrades al fòrum amb una foto de cada usuari
<?php
$result = db_query_range('SELECT node.nid, node_revisions.nid, node_revisions.uid, node_revisions.title,LEFT(node_revisions.teaser,126) as camp_tallat,users.uid, users.name,users.picture from (node LEFT JOIN node_revisions ON node.nid=node_revisions.nid) LEFT JOIN users ON users.uid=node_revisions.uid WHERE node.type=forum order by node.nid desc', 0,10);
?> <table> <?php
while ($myrow = mysql_fetch_array($result)) { ?>
<tr><td valign="top"><img class="foto_block" width="70px" height="70px" src="/files/pictures/picture-<?php echo ($myrow[uid]);?>.jpg" alt="" /></td>
<td valign="top"><p class="lastaj_aldonoj"><a href="/node/<?php echo ($myrow[nid]); ?>"><?php echo ($myrow[title]);?></a><br /><?php echo ($myrow[camp_tallat]); ?>...</p></td></tr>
<?php } ?>
</table>
Bloc mostrant els últims usuaris amb l'avatar
<?php
$result = db_query_range('SELECT uid, name, picture from users order by uid desc', 0,12);
while ($myrow = mysql_fetch_array($result)) {
if (!empty($myrow[picture])) { ?>
<a href="/user/<?php echo ($myrow[uid]);?>"><img class="avatars_usuaris" width="40px" height="40px" src="/files/pictures/picture-<?php echo ($myrow[uid]);?>.jpg" alt="" /></a>
<?php } else { ?>
<a href="/user/<?php echo ($myrow[uid]);?>"><img class="avatars_usuaris" width="40px" height="40px" src="/files/pictures/onklo_zam.jpg" alt="" /></a>
<?php }
} ?>
Envia un nou comentari