Here's the updated one with datastore
index.php:
Find:
// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###
Above it, add:
// Show 5 Newest Members //
$numbermembers = vb_number_format($userstats['numbermembers']);
$newestmembers = unserialize($datastore['newestmembers']);
foreach ($newestmembers as $two)
{
$counter++;
$newuserid = $two['userid'];
$newusername = $two['username'];
$newestbit .= "<a href=\"member.php?$session['sessionurl']u=$newuserid\">$newusername</a>";
if ($counter < 5)
{
$newestbit .= ", ";
}
}
// END Show 5 Newest Members //
Find: (in $specialtemplates)
'eventcache',
'mailqueue'
Replace it with:
'eventcache',
'mailqueue',
'newestmembers'
In the FORUMHOME TEMPLATE, find:
<div><phrase 1="member.php?$session[sessionurl]u=$newuserid" 2="$newusername">$vbphrase[welcome_to_our_newest_member_x]</phrase></div>
Replace it with:
<div>Welcome to our newest members, $newestbit </div>
Cron file:
(newestmemberscron.php - put in /includes/cron)
<?php
error_reporting(E_ALL & ~E_NOTICE);
if (!is_object($DB_site))
{
exit;
}
$newestmembers = $DB_site->query("
SELECT userid, username
FROM user
ORDER BY userid DESC
LIMIT 5
");
while($newestmemberss=$DB_site->fetch_array($newestmembers))
{ $counter++;
echo $counter;
$array[$counter] = $newestmemberss;
}
$fivenewestmembers = addslashes(serialize($array));
// Update DataStore
$check = $DB_site->query("
SELECT *
FROM datastore
WHERE title='newestmembers'
");
if ($DB_site->num_rows($check) == 0)
{
$insertdatastore = $DB_site->query("
INSERT INTO datastore
(title, data)
VALUES ('newestmembers', '$fivenewestmembers')
");
}
elseif ($DB_site->num_rows($check) != 0)
{
$updatedatastore = $DB_site->query("
UPDATE datastore
SET data='$fivenewestmembers'
WHERE title='newestmembers'
");
}
?>
Be sure to add that file to scheduled tasks, and set the run date as often as you'd like (probably an hour to a day, up to you).
.. first time having to use datastore, hopefully it's somewhat right. :)