Random VIP script

[Danny]

I created a small script that chooses random VIP's on your r63(Phoenix) hotel. (As I am aware no one released this)

Script:

<?php
$query = mysql_query("SELECT * FROM users WHERE vip='1' ORDER BY RAND() LIMIT 1") or die(mysql_error());
$username = mysql_fetch_assoc($query) or die(mysql_error());
echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure=' . $username['look'] . '"';
echo "</br> </br>";
echo "<b><i>" . $username['username'] . "</b></i>";
?>

People who want to edit it, so I broke the code down so it's easier to edit.(Mainly for noobs)

<?php
// Select the random VIP
$query = mysql_query("SELECT * FROM users WHERE vip='1' ORDER BY RAND() LIMIT 1") or die(mysql_error());
$username = mysql_fetch_assoc($query) or die(mysql_error());

// Image
echo '<img src="http://www.habbo.com/habbo-imaging/avatarimage?figure=' . $username['look'] . '"';

// Linebreaks
echo "</br> </br>";

// Print username
echo "<b><i>" . $username['username'] . "</b></i>";
?>

Image: 

So every time you refresh your page a new VIP user on your hotel appear...

[MentaL]

[Makarov]

I'm sorry but this has just about no purpose at all.. Possibly think of a better idea that will actually help the community?

[Hejula]

I'm sorry but this has just about no purpose at all.. Possibly think of a better idea that will actually help the community?

Of course it has a purpose, it is a content filler for a VIP page. They are useful so you don't have random big gaps where you cant think of what to write.

[BoomHotel]

I like it but I'm using User Of The Week one so theres no space but I would use it if there was space so Nice Release mate :D

[Livar]

Loving these mini-releases.

[Makarov]

Of course it has a purpose, it is a content filler for a VIP page. They are useful so you don't have random big gaps where you cant think of what to write.

I guess you have a point there, didn't think of it in the sense of that way. Although it shouldn't be to hard to fill it with something, even a random picture I guess.

[Supreme]

I guess you have a point there, didn't think of it in the sense of that way. Although it shouldn't be to hard to fill it with something, even a random picture I guess.

A random picture wouldn't be the same
Having something habboish, and something that involves the users, always a good sign! Anyway me personally? I like this

[Danny]

Thanks guys, I plan to do more types of CMS addons like this one...

[ELSD]

I'm sorry but this has just about no purpose at all.. Possibly think of a better idea that will actually help the community?

Idk what your talking about... This is hot and I would like to see it on habjamz....

[DoctorCooper]

Thanks for the release :)

[TashiaLurvesYou]

This is useful for those people who havent have this code.
Thanks alot (: i was finding for this code! THANK YOU SO MUCH!