there is a tutorial posted last year telling how to build up modules for XOOPS with cakePHP
https://xoops.org/modules/news/article.php?storyid=4045
<{section name=i loop=$block.friends}>
<div style="width:80%; text-align: center; page-break-after: always; margin: auto; page-break-before: always;">
<a href="<{$xoops_url}>/modules/yogurt/index.php?uid=<{$block.friends[i].uid}>" title="<{$block.friends[i].uname}>"><{ if $block.friends[i].user_avatar=="blank.gif" }> <img src="<{$xoops_url}>/modules/yogurt/images/noavatar.gif" /> <{else}> <img src="<{$xoops_upload_url}>/<{$block.friends[i].user_avatar}>" /><{/if}><br /><{$block.friends[i].uname}> </a>
<br /><a href='javascript:openWithSelfMain("<{$xoops_url}>/pmlite.php?send2=1&to_userid=<{$block.friends[i].uid}>","pmlite",500,450);'><img src="<{$xoops_url}>/images/icons/pm.gif" /></a>
</div><br />
<{/section}>
<a href="<{$xoops_url}>/modules/yogurt/friends.php"><{$block.lang_allfriends}></a>
<{section name=i loop=$friends}>
<{if $smarty.section.i.first}><table><{/if}>
<{if $smarty.section.i.iteration % 2 == 1 }><tr><{/if}>
<td valign="top">
<a href="<{$xoops_url}>/modules/yogurt/index.php?uid=<{$block.friends[i].uid}>" title="<{$block.friends[i].uname}>"><{ if $block.friends[i].user_avatar=="blank.gif" }> <img src="<{$xoops_url}>/modules/yogurt/images/noavatar.gif" /> <{else}> <img src="<{$xoops_upload_url}>/<{$block.friends[i].user_avatar}>" /><{/if}><br /><{$block.friends[i].uname}> </a>
<br /><a href='javascript:openWithSelfMain("<{$xoops_url}>/pmlite.php?send2=1&to_userid=<{$block.friends[i].uid}>","pmlite",500,450);'><img src="<{$xoops_url}>/images/icons/pm.gif" /></a>
<br />
</td>
<{if $smarty.section.i.iteration % 2 == 2 }></tr><{/if}>
<{if $smarty.section.i.last}>
<{if ($smarty.section.i.iteration % 2 == 1)}><td colspan="2" valign="top"></td><{/if}>
</tr></table>
<{/if}>
<{/section}>
<a href="<{$xoops_url}>/modules/yogurt/friends.php"><{$block.lang_allfriends}></a>
DELETE FROM myprefix_yogurt_visitors WHERE (datetime<(DATE_SUB(NOW(), INTERVAL 7 DAY)))
Error number: 1054
Error message: Unknown column 'datetime' in 'where clause'
<{if $topic_post.poster.status == '<img src="images/imagesets/xoops-magazine/english/online-a.png">'}>On-Line<{else}>Off-Line<{/if}>