ryancbarnes
Member
you set your "Max Featured Members" to say... 10... and an 11th wants to become "Featured"?
Next question is:
the logic of this setting is simple: // Featured member
if ($CONF['featured_member'] && $TMPL['num_members']) {
$result = $DB->select_limit("SELECT username, url, title, description, banner_url FROM {$CONF['sql_prefix']}_sites WHERE active = 1 ORDER BY RAND()", 1, 0, __FILE__, __LINE__);
$row = $DB->fetch_array($result);
$TMPL = array_merge($TMPL, $row);
if your feeling adventurous take the newest members plugin and use that as a base for your new plugin, use this query to select a random member:$result = $DB->select_limit("SELECT username, url, title, description, banner_url FROM {$CONF['sql_prefix']}_sites WHERE active = 1 ORDER BY RAND()", 55, 0, __FILE__, __LINE__);