Banner with Online Count ( No Other File Needed )

[FreeZa™]

Hello,

i have seen this been released but i thought i'd let my code out as it doesn't need an external file some people need as an online.cfm or online.php

<?php

$dbhost = 'localhost';
$dbuser = 'Username';
$dbpass = 'Password';
$dbname = 'Database';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
mysql_select_db($dbname);

$result = mysql_query("SELECT * FROM server_status");

$row = mysql_fetch_array( $result );
$text = "Habbos Online";
$image = imagecreatefrompng('images/02.png');
$black = imagecolorallocate($image, 0, 0, 0);
imagefttext($image, 8, 0, 182, 80, $black, './verdanab.ttf', $row['users_online']);
// imagefttext($image, 8, 0, 182, 75, $black, './verdana.ttf', $text); // Remove the // ahead of this line to use it
header('Content-type: image/png');
imagepng($image);
imagedestroy($image);
?>

Use this code or download it Here

Replace the image.

Credits All To Me

[MentaL]

[Law]

WOW, changing mine and Hejula's code A LITTLE you should be proud

NOOT.

[Someuser]

And this would spam your MySQL server over if i would DoS at that file.

[ntl200]

shh :) i know whos release im using lol

[</Meap>]

WOW, changing mine and Hejula's code A LITTLE you should be proud

NOOT.

for your information dickweed, Edward coded this well before you lot
I was one of the first people to have this code
hes had this code since he re-opened clan and habbobz and merged them
get your facts right
go back to school :)

[Law]

for your information dickweed, Edward coded this well before you lot
I was one of the first people to have this code
hes had this code since he re-opened clan and habbobz and merged them
get your facts right
go back to school :)

I'm on springbreak

/facepalm

And oh, then it is okay..

And he released it before me too, soz sorry :P

[FreeZa™]

And this would spam your MySQL server over if i would DoS at that file.

Very Nice Like no1 knew your could spam reloading the online.cfm or online.php or Any damn page of a CMS which includes user details.

Grow Up, Stop Trolling.

[Quackster]

MUCH better code, use this!

You are not reading a whole ROW from a db only 1 colum so it's best to use mysql_result.

Also I added functions so it would be less laggy (:

So a MUCH better example would be:

Set the pic and font path yourselfs in order for it to work! (:

http://pastebin.com/C6Zz0ed3

[FreeZa™]

Thanks xD

[Quackster]

Thanks xD

Fixed the snippet, text wasn't showing.

Now it does, cheers. (:

[mmaxwell]

could someone do this with phpretro useing system table that shows the users online

[</Meap>]

Edwards code by itself works fine for me so Im cool :)

[Quackster]

could someone do this with phpretro useing system table that shows the users online

Here, should work for holograph.
Change the image path and font path!

Press the 'like' button if I helped :)

http://pastebin.com/PEjdvXpd

[Roper]

Great release, thanks for sharing. I'll use this on my localhost to test it out and make modifications to it :)

@Quackster - cba to press 'Like' as i'm lazy.

[Law]

could someone do this with phpretro useing system table that shows the users online

There is one for phpretro...

credits goes to FreeZa™

<?php

$dbhost = 'localhost';
$dbuser = 'Username';
$dbpass = 'Password';
$dbname = 'Database';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
mysql_select_db($dbname);

$result = mysql_query("SELECT * FROM system");

$row = mysql_fetch_array( $result );
$text = "Habbos Online";
$image = imagecreatefrompng('images/02.png');
$black = imagecolorallocate($image, 0, 0, 0);
imagefttext($image, 8, 0, 182, 80, $black, './verdanab.ttf', $row['onlinecount']);
// imagefttext($image, 8, 0, 182, 75, $black, './verdana.ttf', $text); // Remove the // ahead of this line to use it
header('Content-type: image/png');
imagepng($image);
imagedestroy($image);
?>