New member block

[WasdMan]

I made a PHP block:

Code Select Expand


<?php
// Created by WasdMan
// 2012
$url = 'http://yourforum.net/'; // Give me your exact address
$prefix = 'smf_'; // The table prefix in this forum
// All posts not based group
$result=mysql_query("SELECT id_group, group_name, online_color FROM `".$prefix."membergroups` WHERE min_posts = -1");
$accounts = 0;
while($row=mysql_fetch_array($result))
{
   $count = 0;
   echo '<b><font color="'.$row['online_color'].'">'.$row['group_name'].'</font></b><br>';
   $result2=mysql_query('SELECT id_member, real_name FROM `'.$prefix.'members` WHERE id_group = '.$row['id_group']);
   echo '<ul class="sp_list">';
   while($row2=mysql_fetch_array($result2))
   {
       $username = $row2['real_name'];
       echo '<li>'.sp_embed_image('dot').' <a href="'.$url.'index.php?action=profile;u='.$row2['id_member'].'"><font color="'.$row['online_color'].'">'.$row2['real_name'].'</font></a></li>';
       $count++;
       $accounts++;
   }
   if($count == 0) echo "<li><i><b>User not found ...</b></i></li>";
   echo "</ul>";
}
echo "<br><center><i>(<b>".$accounts."</b> user)</i></center>";
?>


Mod image:

[Dhayzon]

veria nice