[REV] Community Page Error [REV]

[Satan]

Hey guys, i just changed databases and got this error on the community page.

Screenie:

You must be registered for see links

Any help would be greatly appreciated.

 

[Lionches]

Maybe something is there that is not supposed to be. Also, I thought you we're a developer?

 

[Evian]

There's a problem with the MySQL grabbing the date they were last online. You can use replace the random habbos snippet with this;

<div class="habblet-container ">   
<div class="cbb clearfix activehomes ">
<h2 class="title">Random {hotelName} - Click Us!</h2>
<div id="homes-habblet-list-container" class="habblet-list-container">
<img class="active-habbo-imagemap" src="{url}/app/tpl/skins/Habbo/images/activehomes/transparent_area.gif" width="435px" height="230px" usemap="#habbomap" />
<?php
$getRandom = mysql_query("SELECT id,username,look,motto,account_created,online FROM users ORDER BY RAND() LIMIT 18");
$i = 0;
 
while ($randomHabbo = mysql_fetch_assoc($getRandom))
{   
echo '<div id="active-habbo-data-' . $i . '" class="active-habbo-data">
<div class="active-habbo-data-container">
<div class="active-name ' . (($randomHabbo['online'] == "1") ? 'online' : 'offline') . '">' . $randomHabbo['username'] . '</div>
{hotelName} created on: ' . date('d M, Y', $randomHabbo['account_created']) . '
<p class="moto">' . $randomHabbo['motto'] . '</p>
</div>
</div>
<input type="hidden" id="active-habbo-url-' . $i . '">
<input type="hidden" id="active-habbo-image-' . $i . '" class="active-habbo-image" value="http://www.habbo.com/habbo-imaging/avatarimage?figure' . $randomHabbo['look'] . '&direction=4&head_direction=4" />';
 
$i++;
}
?>
<div id="placeholder-container">
<div id="active-habbo-image-placeholder-0" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-1" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-2" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-3" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-4" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-5" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-6" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-7" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-8" class="active-habbo-image-placeholder"></div>
 
<div id="active-habbo-image-placeholder-9" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-10" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-11" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-12" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-13" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-14" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-15" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-16" class="active-habbo-image-placeholder"></div>
<div id="active-habbo-image-placeholder-17" class="active-habbo-image-placeholder"></div>
</div>
</div>
<map id="habbomap" name="habbomap">
<area id="imagemap-area-0" shape="rect" coords="55,53,95,103" href="#" alt=""/>
<area id="imagemap-area-1" shape="rect" coords="120,53,160,103" href="#" alt=""/>
<area id="imagemap-area-2" shape="rect" coords="185,53,225,103" href="#" alt=""/>
<area id="imagemap-area-3" shape="rect" coords="250,53,290,103" href="#" alt=""/>
<area id="imagemap-area-4" shape="rect" coords="315,53,355,103" href="#" alt=""/>
<area id="imagemap-area-5" shape="rect" coords="380,53,420,103" href="#" alt=""/>
<area id="imagemap-area-6" shape="rect" coords="28,103,68,153" href="#" alt=""/>
<area id="imagemap-area-7" shape="rect" coords="93,103,133,153" href="#" alt=""/>
<area id="imagemap-area-8" shape="rect" coords="158,103,198,153" href="#" alt=""/>
<area id="imagemap-area-9" shape="rect" coords="223,103,263,153" href="#" alt=""/>
<area id="imagemap-area-10" shape="rect" coords="288,103,328,153" href="#" alt=""/>
<area id="imagemap-area-11" shape="rect" coords="353,103,393,153" href="#" alt=""/>
<area id="imagemap-area-12" shape="rect" coords="55,153,95,203" href="#" alt=""/>
<area id="imagemap-area-13" shape="rect" coords="120,153,160,203" href="#" alt=""/>
<area id="imagemap-area-14" shape="rect" coords="185,153,225,203" href="#" alt=""/>
<area id="imagemap-area-15" shape="rect" coords="250,153,290,203" href="#" alt=""/>
<area id="imagemap-area-16" shape="rect" coords="315,153,355,203" href="#" alt=""/>
<area id="imagemap-area-17" shape="rect" coords="380,153,420,203" href="#" alt=""/>
</map>
<script type="text/javascript">
var activeHabbosHabblet = new ActiveHabbosHabblet();
document.observe("dom:loaded", function() { activeHabbosHabblet.generateRandomImages(); });
</script>
</div>
</div>

Any problem's feel free to message me!