<?php

                            $GetRanks = mysql_query("SELECT id,name,tab_colour,title FROM `ranks` WHERE `id` =2 OR `id` =3 OR `id` =4 OR `id` =6 OR `id` =8 OR `id` =9  ORDER BY id DESC");
                            while($Ranks = mysql_fetch_assoc($GetRanks))
                            {
							    echo "<div class=\"habblet-container \"><div class=\"cbb clearfix {$Ranks['tab_colour']} \"><h2 class=\"title\"><span style=\"float: left;\">{$Ranks['name']}</span><span style=\"float: right; font-weight: normal; font-size: 75%\">{$Ranks['title']}" . "</span></h2><div style=\"padding:5px\"><p>";
                                $GetUsers = mysql_query("SELECT username,motto,rank,last_online,online,look FROM users WHERE rank = {$Ranks['id']} ORDER by id");
								if (mysql_num_rows($GetUsers) > 0)
                            {
                             while ($Users = mysql_fetch_assoc($GetUsers))
                                {
                                  if($Users['online'] == 1){ $OnlineStatus = "<img style=\"float: right;\" src='{url}/app/tpl/skins/Habbo/images/online.gif'/> "; } else { $OnlineStatus = "<img style=\"float: right;\" src='{url}/app/tpl/skins/Habbo/images/offline.gif'/> "; }
                                  echo "<div style='float:left'><img position:absolute; src='http://www.habbo.com/habbo-imaging/avatarimage?figure={$Users['look']}&size=b&direction=2&head_direction=2&headonly=1&gesture=sml&size=2'></div>"
                                  ."<p style=\"font-size: 90%; padding: 0px;\"><u><strong>{$Users['username']}</strong></u></p> {$OnlineStatus}
								 <br>
								  <p style=\"font-size: 90%; padding: 0px;\"><img src=\"{url}/app/tpl/skins/Habbo/images/motto.gif\"/>&nbsp;{$Users['motto']}</p>
								  <p style=\"font-size: 90%; padding: 0px;\"><img src=\"http://habboemotion.com/resources/images/icons/new_07.gif\"/> ". date('D, d M Y', $Users['last_online']) ."</p><hr>";
                                }
							}
							else
                            {
                            echo "<p style=\"font-size: 90%;\"><i>There are currently no members in this rank.</i></p>";
                            }

                                echo "</div></div></div>";
                            }
                        ?>