/> <?php include('system/sideads.php'); ?><br /> </div></div><br /> </div><br /> <br /> <br /> <br /> </div> <br /> <br /> <div class="columnTwo"><br /> <?php $query = mysql_query("SELECT * FROM cms_news ORDER BY published DESC LIMIT 1"); $num = mysql_num_rows($query); if($num > 0)<br /> {<br /> $news = mysql_fetch_array($query);<br /> echo'<div class="newsHeader"> <div class="HeadlineStory" id="'.$news["id"].'" style="background: url('.$news["image"].') no-repeat; display:block;"> <p class="Mainheadline"><h3><a href="articles.php?story='.$news["id"].'">'.stripslashes($news["title"]).'</a></h3></p> <p class="Mainstory">'.strip_tags($news["shortstory"], '<br><br/><br />').'</p> <p class="readmorenews"><a href="articles.php?story='.$news['id'].'">Leitura completa </a></p> </div> </div>';<br /> $color = 'odd';<br /> $query = mysql_query("SELECT * FROM cms_news ORDER BY published DESC LIMIT 3");<br /> while($news = mysql_fetch_array($query))<br /> {<br /> echo'<div class="storybox" id="'.$color.'" ref="'.$news["id"].'"> <p class="headline"><a href="articles.php?story='.$news["id"].'">'.$news["title"].'</a></p> <p class="date">'.@date("d-m-Y", $news['published']).'</p> <br /> </div>';<br /> if($color == 'odd')<br /> $color='even';<br /> else<br /> $color='odd';<br /> }<br /> }<br /> ?><br /> <div class="storyboxEnd"> <div class="readmore"><a href="articles.php">Outras noticias </a></div> </div><br /> <div class="contentBox"><div class="boxHeaderBlue"> <h1>Quartos</h1></div><?php $query1 = mysql_query("SELECT * FROM rooms WHERE users_now >= '1'");<br /> $num1 = mysql_num_rows($query1);<br /> if($num1 == 0) {<br /> echo "Sinto muito, Olhe como nao ha qualquer salas ativas para mostrar neste momento no tempo. Por que nao ir preencher um?";<br /> } else {<br /> ?><br /> <br /> <?php $query = mysql_query("SELECT * FROM rooms WHERE users_now >= '1' ORDER BY users_now DESC LIMIT 5");<br /> $num = mysql_num_rows($query);<br /> if($num > 0)<br /> {<br /> $color = 'odd';<br /> while($campaign = mysql_fetch_array($query))<br /> {<br /> echo' <br /> <div class="campaigncontainer" id="'.$color.'"> <div class="campaign"> <div class="title"><a href="home.php?u='.$campaign['owner'].'">'.$campaign['caption'].'</a></div> <div class="story">';strip_tags($campaign['description'], '<br><br/><br />')?><br /> <?php if($campaign['users_now'] >= '8') {<br /> echo "<div class=\"redBg\">";<br /> echo "{$campaign['users_now']}";<br /> echo "</div>";<br /> } elseif($campaign['users_now'] >= '5') {<br /> echo "<div class=\"orangeBg\">";<br /> echo "{$campaign['users_now']}";<br /> echo "</div>";<br /> }<br /> else {<br /> echo "<div class=\"greenBg\">";<br /> echo "{$campaign['users_now']}";<br /> echo "</div>";<br /> }<br /> <br /> ?><br /> <?php echo '</div><br /> <div class="readmore">Owner: <a href="home.php?u='.$campaign['owner'].'">'.$campaign['owner'].'</a></div> </div> </div>';<br /> if($color == 'odd')<br /> $color='even';<br /> else<br /> $color='odd';<br /> }<br /> } <br /> <br /> }<br /> ?><br /> </div><div class="contentBox"><div class="boxHeaderGreen"> <h1>Mais ricos do hotel</h1></div><table><?php $datosTop = mysql_query("SELECT * FROM users ORDER BY credits DESC LIMIT 5"); while($datosTop10 = mysql_fetch_array($datosTop)){ echo ' <tr><td width="5px"></td> <td width="20px">';<br /> <br /> echo '<img src="http://www.habbo.com.es/habbo-imaging/avatarimage?figure=' . $datosTop10['look'] . '&direction=3&head_direction=3&gesture=sml&action=crr=2&size=s" align="left"></td> <td width="195px"> <a href="#">'.$datosTop10['username'].'</a><br />'.$datosTop10['credits'].' creditos';<br /> <br /> <br /> echo '</td> '; } ?> </table></div> </div> <?php include('includes/footer.php'); ?> <br /> </div><br /> </body> <br /> </html>