Go Back   vb.org Archive > Community Discussions > Modification Requests/Questions (Unpaid)
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-18-2004, 12:02 PM
Davey-UK's Avatar
Davey-UK Davey-UK is offline
 
Join Date: Feb 2003
Location: Sheffield-UK
Posts: 244
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Last Members

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
Reply With Quote
  #2  
Old 04-18-2004, 02:02 PM
TouchingVirus's Avatar
TouchingVirus TouchingVirus is offline
 
Join Date: Nov 2001
Location: Bogland
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #3  
Old 04-18-2004, 02:36 PM
Davey-UK's Avatar
Davey-UK Davey-UK is offline
 
Join Date: Feb 2003
Location: Sheffield-UK
Posts: 244
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Code:
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
Reply With Quote
  #4  
Old 04-18-2004, 02:50 PM
TouchingVirus's Avatar
TouchingVirus TouchingVirus is offline
 
Join Date: Nov 2001
Location: Bogland
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You added that code into a template?

You mad thing, thats a php page in itself
Reply With Quote
  #5  
Old 04-18-2004, 02:54 PM
TouchingVirus's Avatar
TouchingVirus TouchingVirus is offline
 
Join Date: Nov 2001
Location: Bogland
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

let me get vbindex and sort it out myself and then i will post how to do it
Reply With Quote
  #6  
Old 04-18-2004, 04:16 PM
TouchingVirus's Avatar
TouchingVirus TouchingVirus is offline
 
Join Date: Nov 2001
Location: Bogland
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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
Reply With Quote
  #7  
Old 04-18-2004, 04:18 PM
TouchingVirus's Avatar
TouchingVirus TouchingVirus is offline
 
Join Date: Nov 2001
Location: Bogland
Posts: 76
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

By the way, change $lastlimit = 7; to whatever you want it to show
Reply With Quote
  #8  
Old 04-19-2004, 04:30 PM
Davey-UK's Avatar
Davey-UK Davey-UK is offline
 
Join Date: Feb 2003
Location: Sheffield-UK
Posts: 244
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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:
Reply With Quote
  #9  
Old 05-19-2004, 01:56 PM
jiggle jiggle is offline
 
Join Date: Jan 2002
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:41 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07508 seconds
  • Memory Usage 2,248KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (3)bbcode_code
  • (3)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete