online counter on homepage

[Breaker]

hi i was just wondering how to include the current online counter on the top of the header (like the most of the sites have now) im pretty new to all this stuff and dont know that much if its somehow teachable i would be very thankful of your replies

thanks in advance

Breaker

[Gerome]

all you need is just a simple query.

make a file, name it count_player.php

<?php

$host  = 'localhost';
$username  = 'username';    // Your Mysql Username
$password  = 'password';    // Your Mysql Password
$db    = 'ragnarok'; // Database name


$link = mysql_connect($host, $username, $password) or die(mysql_error());
@mysql_select_db($db,$link);

$query = 'SELECT COUNT(char_id) AS players_online FROM `char` WHERE online > 0';
$result = mysql_query($query,$link);

mysql_close($link);

$arr = mysql_fetch_array($result);
$players_online = $arr['players_online'];

?>
<p><?php echo $players_online; ?></p>

on your header just put this line of code

<?php include('count_player.php'); ?>

[Breaker]

thank you that works totally fine! super fast reply here!

another question is (goes in the same direction) how can i filter out different playernames lets say make a pvp ladder and display the first 3 names and their guild emblems? or the same for woe castles, display which guilds holds the current woe castle and such!

thanks in advance

BREAKER

[Asura]

Hi Breaker,

You need to have a custom in-game script which uses a custom SQL table to keep track of the kills. I know there's probably a way with the @ variable, but I'm not sure about the specifics.

But yeah, you need to have a custom PVP Script to keep counts of kills and then update the custom table with the kills. Then you will have to just create a MySQL Query for your PHP script to grab the first 3 after you place them in order by kills.

[WhiteEagle]

Hey there,

I have a question.

Know everyone how can I include the online counter with "Afk / Vending" Status?

Example: 25 player are online and 6 of them has a shop opened. (@autotrade)

Like: User Online: 25 (6)

It would be very nice, if someone help me.

Thanks in advanced.

[WhiteEagle]

Nobody knows any solution?

[michaelsoftman]

I have a question about this myself.

If you include your mysql info in the page, won't players be able to view the source of count_player.php and see it?

[Emistry]

I have a question about this myself.

If you include your mysql info in the page, won't players be able to view the source of count_player.php and see it?

the content you write inside the Module Folder are invisible to other users....even when they try to view the source of HTML page / php page generated...the SQL Query / data will be hidden ... depend on how your HTML / Php show the data in your Theme folder.

the content is parsed from PHP from module folder into HTML in theme folder...