Is it possible to get a copy of the server snapshot and website code for testing?!?

I'm running a server for our local players here in Northern Ireland and the feedback I'm getting is that a leaderboard on our website would make things a lot more interesting.

If not, when do you expect to release the next server version?!?

Thanks,
Kieran

Big thanks for useful info!

rascalli wrote:

Can some one help me , as i have no idea how to make a stats page with this & the other code on the forum.

Do you want to build a stats-page OR a ranking-page? For stats-page this is the wrong code; have a look at this one.

You'll need a running holdingnuts-server, a webserver running PHP and customizing the mentioned script.

Does that help?

rascalli wrote:

So I tried the php in : http://www.holdingnuts.net/forum/viewto … d=130#p130
But that does nothing for me .. and I had no idea what to do with the "code" that is posted there

This is the code for displaying simple server stats (top-right corner on main-page of this website).

What you need is:
- An own running holdingnuts game-server. The ranking-system isn't included in release 0.0.5 but in current trunk (development-version). So this might be a problem, as there are no prebuilt-binaries. Either you try to compile your own or contact me via mail
- A webserver with PHP (which runs on the same host as the game-server!)
- The PHP code-snippet in THIS thread. You might need to customize some things (e.g. path of the sqlite3 database file).

Please have understanding that this all isn't that easy to setup, but the ranking-system isn't (yet) an official feature of the server. The main purpose was to have a simple ranking for our game-server.

rascalli wrote:

What do I do with the PHP-code snippet in THIS thread, where do I place it ?

It depends on your setup. Lets say:
- you're using a UNIX-like OS (e.g. Linux)
- you're running the game-server (compiled from trunk and with sqlite3-feature) as user "holdingnuts" -> this means that the database-file is stored in /home/holdingnuts/.holdingnuts/server.db  (by default)
- your webserver-root is /var/www -> copy the code snippet to a text file and name it /var/www/ranking.php
- you might need to enable sqlite3 support for PHP as well

$db_file = '/home/holdingnuts/.holdingnuts/server.db';

$dbh = new PDO("sqlite:$db_file");
$sql = 'SELECT uuid,name,gamecount,ranking,t_lastgame 
		FROM players 
		ORDER BY ranking DESC, t_lastgame DESC, gamecount DESC';

foreach ($dbh->query($sql) as $pstat)
{
	// DO SOMETHING USEFUL WITH EACH ENTRY HERE
	print_r($pstat);

	// echo $pstat['ranking'];

	// uuid is the identifier
	// name is the nickname
	// gamecount is the number of games the player was involved
	// ranking is the current ranking
	// t_lastgame is the date of the last game played
}

This example code intentionally doesn't include error-/exception-handling and doesn't include cosmetics used on our site in order to keep things simple. Of course you need to customize this script to actually display the ranking.

foreach ($dbh->query($sql) as $pstat)
{
	echo "Player " . $pstat['name'] . " has ranking " . $pstat['ranking'] . " and has played " . $pstat['gamecount'] . " games.";
}

Hope this helps.

Last edited by datag (2010-06-08 23:24:24)

rascalli wrote:

Tx for the help , but unfortunately somewhere i do something totally wrong.
As it does not work for me , might be because I am just a noob with linux ;-)

What exactly is the problem/error?

rascalli wrote:

I guess I need to wait till this is included
Any idea on a time line ?

Well, at the moment there isn't any development in progress and there is no schedule for a next release. Maybe another dev will be working on this again, but nothing's sure.

rascalli wrote:

But how to make a webpage that reads into that and converts it to statistics ?

Just copy&paste this code into a file "ranking.php" and place it into your www-root.

<?php

$db_file = '/home/holdingnuts/.holdingnuts/server.db';

$dbh = new PDO("sqlite:$db_file");
$sql = "SELECT
          uuid,name,gamecount,ranking,t_lastgame 
	FROM
	  players 
	WHERE 
	  name NOT LIKE '__unknown__' 
	ORDER BY
	  ranking DESC, t_lastgame DESC, gamecount DESC";
?>


<table border="1">
 <thead>
  <tr>
   <th>Name</th>
   <th>Games played</th>
   <th>Ranking</th>
  </tr>
 </thead>
 <tbody>

<?php foreach ($dbh->query($sql) as $pstat) : ?>

  <tr>
   <td><?php echo htmlentities($pstat['name']); ?></td>
   <td><?php echo $pstat['gamecount']; ?></td>
   <td><?php echo $pstat['ranking']; ?></td>
  </tr>

<?php endforeach; ?>

 </tbody>
</table>

someone build me please client and server for windows with ranking system and send me an e-mail.
r5i.alexey@yandex.ru
thanks

Thank you!

r5isc wrote:

Error opening database
How to fix?

Some more information would be helpful. I tested the build on Windows XP and Windows 7. You need to extract all files (the *.dll files need to be in the same directory).

And you need write access to the %APPDATA%\HoldingNuts directory.

Last edited by datag (2010-07-22 21:16:22)

r5isc wrote:

I have a Windows 2003 Server.
Perhaps because of this error?

At home computer everything works ...

I'm not sure. You could try to run holdingnuts-server.exe from the command-line.

Assumption: You extracted the contents of the ZIP to C:\

> C:
> cd \holdingnuts-server-r750-win32
> mkdir config
> holdingnuts-server.exe -c config