in template phpinclude_start
Code:
if (THIS_SCRIPT == 'index')
{
$latest_subscription = $DB_site->query_first("SELECT subscriptionlog.subscriptionid, user.username, subscriptionlog.userid
FROM " . TABLE_PREFIX . "subscriptionlog AS subscriptionlog LEFT JOIN " . TABLE_PREFIX . "user AS user ON (user.userid = subscriptionlog.userid)
ORDER BY subscriptionlog.subscriptionlogid
DESC LIMIT 1");
}
In template forumhome add something like this in the what's going on area...
Code:
<div><strong>Latest Contributer: <a href="member.php?$session[sessionurl]u=$latest_subscription[userid]>$latest_subscription[username]</a></strong></div>