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]

PHP Code:


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

[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

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

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