Reply to thread

Message

<blockquote data-quote="SBste01" data-source="post: 426087" data-attributes="member: 40804">Hey,I've noticed that on a lot of retros, the Hot Rooms on the /community page has the owners username on it. When I put it into my community page, it comes up with the user's ID instead of the username. Is there a way you are able to convert it from their ID to their username? Attached below is a photo of it and the /community.php page.Photo:[SPOILER][ATTACH=full]6716[/ATTACH][/SPOILER]community.php[SPOILER]&lt;?php$eo = 'even';function GenerateRoomOccupancy($usersNow, $usersMax){&nbsp; &nbsp; $num = 1;&nbsp; &nbsp; $percentage = intval(($usersNow / $usersMax) * 100);&nbsp; &nbsp; if ($percentage &lt;= 0)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $num = 1;&nbsp; &nbsp; }&nbsp; &nbsp; else if ($percentage &lt; 35)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $num = 2;&nbsp; &nbsp; }&nbsp; &nbsp; else if ($percentage &lt; 75)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $num = 3;&nbsp; &nbsp; }&nbsp; &nbsp; else if ($percentage &lt; 100)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $num = 4;&nbsp; &nbsp; }&nbsp; &nbsp; else if ($percentage &gt;= 100)&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $num = 5;&nbsp; &nbsp; }&nbsp; &nbsp; return 'room-occupancy-' . $num;}?&gt;&lt;div class=&quot;habblet-container &quot;&gt;&lt;div class=&quot;cbb clearfix settings &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;Hot Rooms&lt;/h2&gt;&lt;style type=&quot;text/css&quot;&gt;.room-occupancy-1 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_1.gif') !important; }.room-occupancy-2 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_2.gif') !important; }.room-occupancy-3 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_3.gif') !important; }.room-occupancy-4 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_4.gif') !important; }.room-occupancy-5 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_5.gif') !important; }&lt;/style&gt;&lt;div id=&quot;rooms-habblet-list-container-h124&quot; class=&quot;recommendedrooms-lite-habblet-list-container&quot;&gt;&lt;ul class=&quot;habblet-list&quot;&gt;&lt;?php$get = mysql_query(&quot;SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 5&quot;)or die(mysql_error());while ($room = mysql_fetch_assoc($get)){&nbsp; &nbsp; if ($eo == 'even')&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $eo = 'odd';&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $eo = 'even';&nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;li class=&quot;' . $eo . '&quot;&gt;&nbsp; &nbsp; &lt;span class=&quot;clearfix enter-room-link ' . GenerateRoomOccupancy($room['users_now'], $room['users_max']) . '&quot; title=&quot;Go There&quot; roomid=&quot;' . $room['id'] . '&quot;&gt;&nbsp; &nbsp; &lt;span class=&quot;room-enter&quot;&gt;Enter room&lt;/span&gt;&nbsp; &nbsp; &lt;span class=&quot;room-name&quot;&gt;' . ($room['caption']) . '&lt;/span&gt;&nbsp; &nbsp; &lt;span class=&quot;room-description&quot;&gt;' . ($room['description']) . '&lt;/span&gt;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &lt;span class=&quot;room-owner&quot;&gt;Owner: &lt;a href=&quot;/home/' . ($room['owner']) . '&quot;&gt;' . ($room['owner']) . '&lt;/a&gt;&lt;/span&gt;&nbsp; &nbsp; &lt;/span&gt;&nbsp; &nbsp; &lt;/li&gt;';}?&gt;&lt;div id=&quot;room-more-data-h124&quot; style=&quot;display: none&quot;&gt;&lt;ul class=&quot;habblet-list room-more-data&quot;&gt;&lt;?php$get = mysql_query(&quot;SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 6,10&quot;)or die(mysql_error());while ($room = mysql_fetch_assoc($get)){&nbsp; &nbsp; if ($eo == 'even')&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $eo = 'odd';&nbsp; &nbsp; }&nbsp; &nbsp; else&nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; $eo = 'even';&nbsp; &nbsp; }&nbsp; &nbsp; echo '&lt;li class=&quot;' . $eo . '&quot;&gt;&nbsp; &nbsp; &lt;span class=&quot;clearfix enter-room-link ' . GenerateRoomOccupancy($room['users_now'], $room['users_max']) . '&quot; title=&quot;Go There&quot; roomid=&quot;' . $room['id'] . '&quot;&gt;&nbsp; &nbsp; &lt;span class=&quot;room-enter&quot;&gt;Enter room&lt;/span&gt; &lt;br&gt;&nbsp; &nbsp; &lt;span class=&quot;room-name&quot;&gt;' . ($room['caption']) . '&lt;/span&gt; &lt;br&gt;&nbsp; &nbsp; &lt;span class=&quot;room-description&quot;&gt;' . ($room['description']) . '&lt;/span&gt;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &lt;span class=&quot;room-owner&quot;&gt;Owner: &lt;a href=&quot;/home/' . ($room['owner']) . '&quot;&gt;' . ($room['owner']) . '&lt;/a&gt;&lt;/span&gt;&nbsp; &nbsp; &lt;/span&gt;&nbsp; &nbsp; &lt;/li&gt;';}?&gt;&lt;/ul&gt;&lt;/div&gt;&lt;div class=&quot;clearfix&quot;&gt;&lt;a href=&quot;#&quot; class=&quot;room-toggle-more-data&quot; id=&quot;room-toggle-more-data-h124&quot;&gt;More Rooms!&lt;/a&gt;&lt;/div&gt;&lt;/div&gt;&lt;script type=&quot;text/javascript&quot;&gt;L10N.put(&quot;show.more&quot;, &quot;Show more rooms&quot;);L10N.put(&quot;show.less&quot;, &quot;Show less rooms&quot;);var roomListHabblet_h124 = new RoomListHabblet(&quot;rooms-habblet-list-container-h124&quot;, &quot;room-toggle-more-data-h124&quot;, &quot;room-more-data-h124&quot;);&lt;/script&gt;&lt;/div&gt;&lt;/div&gt;[/SPOILER]I'd really appreciate if you were able to help.Contact me on our hotel Discord here: <a href="https://discordapp.com/invite/gGpZKwz" target="_blank">https://discordapp.com/invite/gGpZKwz</a> or comment below.</blockquote>

[QUOTE="SBste01, post: 426087, member: 40804"] Hey, I've noticed that on a lot of retros, the Hot Rooms on the /community page has the owners username on it. When I put it into my community page, it comes up with the user's ID instead of the username. Is there a way you are able to convert it from their ID to their username? Attached below is a photo of it and the /community.php page. Photo: [SPOILER] [ATTACH=full]6716[/ATTACH] [/SPOILER] community.php [SPOILER] <?php $eo = 'even'; function GenerateRoomOccupancy($usersNow, $usersMax) { $num = 1; $percentage = intval(($usersNow / $usersMax) * 100); if ($percentage <= 0) { $num = 1; } else if ($percentage < 35) { $num = 2; } else if ($percentage < 75) { $num = 3; } else if ($percentage < 100) { $num = 4; } else if ($percentage >= 100) { $num = 5; } return 'room-occupancy-' . $num; } ?> <div class="habblet-container "> <div class="cbb clearfix settings "> <h2 class="title">Hot Rooms</h2> <style type="text/css"> .room-occupancy-1 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_1.gif') !important; } .room-occupancy-2 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_2.gif') !important; } .room-occupancy-3 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_3.gif') !important; } .room-occupancy-4 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_4.gif') !important; } .room-occupancy-5 { background-image: url('{url}/app/tpl/skins/Habbo/images/rooms/room_icon_5.gif') !important; } </style> <div id="rooms-habblet-list-container-h124" class="recommendedrooms-lite-habblet-list-container"> <ul class="habblet-list"> <?php $get = mysql_query("SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 5")or die(mysql_error()); while ($room = mysql_fetch_assoc($get)) { if ($eo == 'even') { $eo = 'odd'; } else { $eo = 'even'; } echo '<li class="' . $eo . '"> Enter room ' . ($room['caption']) . ' ' . ($room['description']) . ' Owner: <a href="/home/' . ($room['owner']) . '">' . ($room['owner']) . '</a> </li>'; } ?> <div id="room-more-data-h124" style="display: none"> <ul class="habblet-list room-more-data"> <?php $get = mysql_query("SELECT * FROM rooms WHERE roomtype = 'private' ORDER BY users_now DESC LIMIT 6,10")or die(mysql_error()); while ($room = mysql_fetch_assoc($get)) { if ($eo == 'even') { $eo = 'odd'; } else { $eo = 'even'; } echo '<li class="' . $eo . '"> Enter room ' . ($room['caption']) . ' ' . ($room['description']) . ' Owner: <a href="/home/' . ($room['owner']) . '">' . ($room['owner']) . '</a> </li>'; } ?> </ul> </div> <div class="clearfix"> <a href="#" class="room-toggle-more-data" id="room-toggle-more-data-h124">More Rooms!</a> </div> </div> <script type="text/javascript"> L10N.put("show.more", "Show more rooms"); L10N.put("show.less", "Show less rooms"); var roomListHabblet_h124 = new RoomListHabblet("rooms-habblet-list-container-h124", "room-toggle-more-data-h124", "room-more-data-h124"); </script> </div> </div> [/SPOILER] I'd really appreciate if you were able to help. Contact me on our hotel Discord here: [URL]https://discordapp.com/invite/gGpZKwz[/URL] or comment below. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members