Last Members

[Davey-UK]

Is there a quite easy way to add a list of say the last 5 members to a none vb page?

Or better still into a vbindex custom block!

Cheers

[TouchingVirus]

// ### Get vBulletin Backend ###

require_once('./global.php');

// ### Run Query ###

$last5 = $DB_site->query("SELECT username FROM `user` ORDER BY joindate DESC LIMIT 5");

// ### Output Results ###

while ($last5members = $DB_site->fetch_array($last5))
{
$last5usernames = $last5members['username'];
echo $last5usernames;
echo '<br>';
}


Of course this is very basic ..it retreives the usernames and just puts them out in plain text..

you could utilize a little template..let me know if you want to if you cant figure it out

[Davey-UK]

Thanks, thats a great response, but when trying to put this in a vbindex custom block, i get this when trying to save the template.
The following error occurred when attempting to evaluate this template:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /hsphere/local/home/contrast/mydomain.co.uk/forum/includes/adminfunctions_template.php(3037) : eval()'d code on line 29

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.

Any ideas

[TouchingVirus]

You added that code into a template?

You mad thing, thats a php page in itself :D

[TouchingVirus]

let me get vbindex and sort it out myself and then i will post how to do it :)

[TouchingVirus]

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


$DB_site->free_result($getthreads);
}


Underneath, add:


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


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


<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 ;)

[TouchingVirus]

By the way, change $lastlimit = 7; to whatever you want it to show :)

[Davey-UK]

Excellent!

Works perfectly..........Suberb.

1 thing to note, the link in vbindex_lastmemberbit template should have forum/ before it, or whatever you forums folder is called.

I would release this a s a hack in the addons section if i were you, cos i think it will be popular.

Thanks again :devious:

[jiggle]

Is it also possible to have this for the TOP5 Posters with the most postings ?