Reply to thread

Message

<blockquote data-quote="Gajeel" data-source="post: 100954" data-attributes="member: 7688">[PHP]&lt;?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $GetRanks = mysql_query(&quot;SELECT id,name FROM ranks WHERE id &lt; 5 ORDER BY id DESC&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($Ranks = mysql_fetch_assoc($GetRanks))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;div class=\&quot;habblet-container \&quot;&gt;&lt;div class=\&quot;cbb clearfix blue \&quot;&gt;&lt;h2 class=\&quot;title\&quot;&gt;{$Ranks['name']}s&lt;/h2&gt;&lt;div style=\&quot;padding:5px\&quot;&gt;&lt;p&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $GetUsers = mysql_query(&quot;SELECT username,motto,rank,last_online,online,look FROM users WHERE rank = {$Ranks['id']}&quot;);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while($Users = mysql_fetch_assoc($GetUsers))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if($Users['online'] == 1){ $OnlineStatus = &quot;&lt;font color=\&quot;darkgreen\&quot;&gt;&lt;b&gt;Online&lt;/b&gt;&lt;/font&gt;&quot;; } else { $OnlineStatus = &quot;&lt;font color=\&quot;darkred\&quot;&gt;&lt;b&gt;Offline&lt;/b&gt;&lt;/font&gt;&quot;; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;img style=\&quot;position:absolute;\&quot; src=\&quot;http://www.habbo.com/habbo-imaging/avatarimage?figure={$Users['look']}&amp;action=wav&amp;direction=2&amp;head_direction=3&amp;gesture=srp&amp;size=l\&quot;&gt;&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .&quot;&lt;p style=\&quot;margin-left:80px;margin-top:20px;\&quot;&gt;Username: &lt;strong&gt;{$Users['username']}&lt;/strong&gt;&lt;br&gt;Motto: &lt;strong&gt;{$Users['motto']}&lt;/strong&gt;&lt;br&gt;&lt;small&gt;Last Online: &quot;. date(&quot;D, d F Y H:i (P)&quot;, $Users['last_online']) .&quot;&lt;/small&gt;&lt;/p&gt;&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; .&quot;&lt;p style=\&quot;float:right;margin-top:-30px;margin-right:5px;\&quot;&gt;{$OnlineStatus}&lt;/p&gt;&lt;br&gt;&lt;br&gt;&lt;br&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ?&gt;[/PHP]&nbsp;That is the PHP code for the staff page @ Habbo Theme. How can I tell it to fetch id and name from ranks 4 and below, except 1? I am re-doing the staff page to turn it out as a VIP page, as there will be 3 levels of VIP and they are partitioned through ranks.</blockquote>

[QUOTE="Gajeel, post: 100954, member: 7688"] [PHP]<?php $GetRanks = mysql_query("SELECT id,name FROM ranks WHERE id < 5 ORDER BY id DESC"); while($Ranks = mysql_fetch_assoc($GetRanks)) { echo "<div class=\"habblet-container \"><div class=\"cbb clearfix blue \"><h2 class=\"title\">{$Ranks['name']}s</h2><div style=\"padding:5px\">"; $GetUsers = mysql_query("SELECT username,motto,rank,last_online,online,look FROM users WHERE rank = {$Ranks['id']}"); while($Users = mysql_fetch_assoc($GetUsers)) { if($Users['online'] == 1){ $OnlineStatus = "Online"; } else { $OnlineStatus = "Offline"; } echo "<img style=\"position:absolute;\" src=\"http://www.habbo.com/habbo-imaging/avatarimage?figure={$Users['look']}&action=wav&direction=2&head_direction=3&gesture=srp&size=l\">" ."Username: {$Users['username']} Motto: {$Users['motto']} Last Online: ". date("D, d F Y H:i (P)", $Users['last_online']) ."" ."{$OnlineStatus} "; } echo "</div></div></div>"; } ?>[/PHP] That is the PHP code for the staff page @ Habbo Theme. How can I tell it to fetch id and name from ranks 4 and below, except 1? I am re-doing the staff page to turn it out as a VIP page, as there will be 3 levels of VIP and they are partitioned through ranks. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members