Getting the latest Article to display

[Necrophyte]

TY, that's what I needed to know!

--------------- Added [DATE]1475776484[/DATE] at [TIME]1475776484[/TIME] ---------------

For anyone that comes to this page looking for answers. You can open a PHP Module.
I wanted mine to be displayed in a max height of 800px. You can change that to what you want or remove it.
In the Query if you do not wish to have a taglist search. Just remove : 'AND taglist LIKE '%spotlight%''

You'll also need to know the nodeid for articles. Mine is 13. Change 13 to whatever your article nodeid is. You can find them in the channel manager.

Put the following code:

	global $vbulletin;
	echo "<div style='height: 800px; max-height: 800px; overflow: auto;'>";
	$result = $vbulletin->db->query("SELECT nodeid FROM " . TABLE_PREFIX . "node WHERE parentid = 13 AND taglist LIKE '%spotlight%' ORDER BY created DESC LIMIT 1");
	if ($row = $result->fetch_assoc()){
		echo vB5_Frontend_Controller_Bbcode::parseNodeText($row['nodeid']);
	}else{
		echo "<div style='text-align: center; padding: 10px;'><h2>Could not find any articles using tag 'spotlight'</h2></div>";
	}
	unset($row);
	unset($result);
	echo "</div>";