Pull the last paid subsciber

[Jenta]

in template phpinclude_start

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...

<div><strong>Latest Contributer: <a href="member.php?$session[sessionurl]u=$latest_subscription[userid]>$latest_subscription[username]</a></strong></div>