Major thanks to assassingod for giving me the key to this hack, and to my other ones that were in the DEV stage because i didnt know i had to loop
Find this in vbindex.php
PHP Code:
$DB_site->free_result($getthreads);
}
Underneath, add:
PHP Code:
// #################### PROCESS LATEST MEMBERS #######################
$lastlimit = 7;
$lastquery = $DB_site->query('SELECT username,userid FROM '.TABLE_PREFIX.'user ORDER BY joindate DESC LIMIT '.$lastlimit.'');
while ($lastmember = $DB_site->fetch_array($lastquery))
{
$lastusername = $lastmember['username'];
$lastuserid = $lastmember['userid'];
exec_switch_bg();
eval("\$lastmemberbits .= \"".fetch_template('vbindex_lastmemberbit')."\";");
}
Save & Upload!
Next to the templates..go to the custombox you want the information to appear in & change the code to this..
Code:
<table cellpadding="0" cellspacing="0" border="0" class="tborder" width="100%">
<tr>
<td>
<table cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%">
<thead>
<tr>
<td class="tcat" style="text-align: center">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('vbindex_customblock$box')"><img id="collapseimg_vbindex_customblock$box" src="$stylevar[imgdir_button]/collapse_tcat$collapseimg_vbindex_customblock.gif" alt="" border="0" /></a>
<strong>Last $lastlimit Members</strong>
</td>
</tr>
</thead>
<tbody id="collapseobj_vbindex_customblock$box" style="$collapseobj_vbindex_customblock">
$lastmemberbits </tbody>
</table>
</td>
</tr>
</table>
<br />
Next add in a template named vbindex_lastmemberbit with contents..
Code:
<tr class="$bgclass">
<td>
<div class="smallfont">
<a href="member.php?u=$lastuserid"><strong>$lastusername</strong></a>
</div>
</td>
</tr>
Leave the php in the vbindex.php file, for some strange reason, if you add it into vbindex_custombox_php it doesnt work..so if this is Custom box 1, make sure that in vbindex_custombox_php under Case 1: is empty