Simple User Of The Week Script (UberCMS)

[Meap]

Right just go to INC > TPL > generic-column3 and paste this in it
idc if you flame

<div id="column3" class="column"> 
<div class="cbb clearfix white ">  
<h2 class="title"><span style="float: center;">User Of The Week!</span> </h2> 

<div align="center" style="border: 0; padding-top: 5px;">



<table width="100%">
<?php
$getTopStats = mysql_query("SELECT * FROM users WHERE username = 'usernamehere' ORDER BY credits DESC LIMIT 1");
while($topSpats = mysql_fetch_array($getTopStats)){
echo '<tr><td width="5px"> </td>
            <td width="20px">';
  echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure=' . $topSpats['look'] . '&size=lrg&direction=2&head_direction=2&gesture=sml&size=m" align="left"></td> <td width="195px"><a href="#"><b>'.$topSpats['username'].'</b></a><br />'.$topSpats['motto'].'</b>';
echo '</td>
           ';

}
?>

when you want to change the user, change the usernamehere to there user then you get the flow

 

[Kieren]

You made this, screen shots, come on stop being a Chav!

 

[Nimiq]

that's awsome i dont use ubercms at the moment thanks for releasing though

 

[Meap]

Its on my hotel kieren, fine ill take a screenie

there you go, on the right