vb.org Archive - View Single Post

#5 03-16-2001, 06:54 AM

Try this

lastten.php

Code:

<?php

$templatesused = "lastten,lasttenbit";
require ("./global.php");

$threads = $DB_site->query("
	SELECT thread.*, forum.*,
		thread.title AS threadtitle,
		forum.title AS forumtitle
	FROM thread
	LEFT JOIN post ON (post.threadid = thread.threadid)
	LEFT JOIN forum ON (forum.forumid = thread.forumid)
	GROUP BY thread.threadid
	ORDER BY thread.lastpost DESC LIMIT 0,10");

while ($thread = $DB_site->fetch_array($threads)) {
	if (($counter++ % 2) == 0)
		$backcolor = "{ secondaltcolor }";
	else
		$backcolor = "{ firstaltcolor }";
	$lastpost = vbdate("$timeformat $dateformat", $thread[lastpost]);
	eval("\$lasttenbits .= \"".gettemplate('lasttenbit')."\";");
}

eval("dooutput(\"".gettemplate('lastten')."\");");

?>

template - lastten

Code:

{ htmldoctype }
<HTML>
<HEAD><TITLE>$pagetitle</title>
$headinclude
</head>
<body>
$header

<!-- border colour table -->
<table cellpadding=0 cellspacing=0 border=0
	bgcolor="{ tablebordercolor }" width="{ tablewidth }" align="center">
	<tr><td>

<table cellpadding=4 cellspacing=1 border=0 width=100%>
<tr bgcolor="{ tableheadbgcolor }">
	<td colspan=5><normalfont color="{ tableheadtextcolor }"><b>Last ten modified threads</b></normalfont></td>
</tr>
<tr bgcolor="{ firstaltcolor }">
	<td><smallfont>Thread</smallfont></td>
	<td><smallfont>Forum</smallfont></td>
	<td><smallfont>Replies</smallfont></td>
	<td><smallfont>Views</smallfont></td>
	<td><smallfont>Last Post</smallfont></td>
</tr>
$lasttenbits
</table>

	</tr></td>
</table>
<!-- /border colour table -->

$footer

</body>
</html>

template - lasttenbit

Code:

<tr bgcolor="$backcolor">
	<td><normalfont><a href="showthread.php?s=$session[sessionhash]&threadid=$thread[threadid]">$thread[threadtitle]</a></normalfont></td>
	<td><normalfont><a href="forumdisplay.php?s=$session[sessionhash]&forumid=$thread[forumid]">$thread[forumtitle]</a></normalfont></td>
	<td><normalfont>$thread[replycount]</normalfont></td>
	<td><normalfont>$thread[views]</normalfont></td>
	<td><normalfont>$lastpost</normalfont></td>
</tr>

You will need to remove the spaces from all the {xxx} replacement variables.

I think that was what you were asking for?

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01019 seconds Memory Usage 1,766KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD_SHOWPOST (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_box (1)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (1)post_thanks_postbit_info (1)postbit (1)postbit_wrapper (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit reputationlevel showthread	Included Files: ./showpost.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_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showpost_start bbcode_fetch_tags bbcode_create postbit_factory showpost_post 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 bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start showpost_complete
Messages: