Generate a live server status webpage with a list of all players in a sortable grid. Doesn't need nwnx, odbc or mysql. Easy to add additional fields like gold, hours online, etc.
See NBDE by Knat Grid control by ActiveWidgets Cookies by Jason Davies A special thanks to Jantima for suggesting to release this.
This script is released under the GPL license (see gpl.txt).
Prerequisites: At least an ftp/http server on the gameserver, and a web server with PHP to display the status page (preferably on the same machine).
Note: the zip includes a /sql subfolder for those who want to use the NWNX/ODBC/MySQL-based system. If you want to use the /sql version, I will refer to the Database setup instructions of Lanthar D'Alton.
Module Instructions 1. Download and import player_status.erf into your module.
2. Download NBDE and import nbde.erf into your module.
3. Add ExecuteScript("player_status", OBJECT_SELF); to your module heartbeat.
If the web server and game server on separate machines, you will need to host the database/playerstatus.fpt file anonymously and set $fptfile in status.php to the URL of the hosted file as in "ftp://gameserver/playerstatus.fpt"
Web server Instructions 1. Download Grid control to your web folder.
2. Download Cookies.js script to your web folder.
3. Copy status.php to your web folder and edit the settings in it, including the paths to ActiveWidgets and cookies.js
To add additional fields you need to edit the player_status.txt and status.php in marked locations. Contact me for assistance: [email protected]
Please post links here if you implement it for your server. Feedback, comments, suggestions, questions, bug reports and votes welcome. ^^
I'm getting the following error.. I'm sure its something simple. fopen(pathto/database/playerstatus.fpt): failed to open stream: Permission denied in /var/www/localhost/htdocs/status.php on line 97 ERROR: Could not open fpt file
Posted by Anonymous at 2005-07-2321:08:41
I'm getting the following error.. I'm sure its something simple. fopen(pathto/database/playerstatus.fpt): failed to open stream: Permission denied in /var/www/localhost/htdocs/status.php on line 97 ERROR: Could not open fpt file
Posted by Anonymous at 2005-07-2320:59:44
I'm getting the following error.. I'm sure its something simple. fopen(pathto/database/playerstatus.fpt): failed to open stream: Permission denied in /var/www/localhost/htdocs/status.php on line 97 ERROR: Could not open fpt file
Posted by Tatus at on07/19/05
This is an awesome script. Had some issues I was unsure of (not a script kid I am :D ).. Mailed Vlad for help.. 5 minutes after he replied and within 20 minutes I had all the info I needed that were specific for the module I was trying to add a status page to.. Awesome script and great help.. Deffo a 10 score from me..
Posted by Vladiat0r at 15:43:57 Voted10.00
Apparently, NWN doesn't like it when the FPT file is being read at the same time as NWN is writing to it--causing a crash. -_- If you set INTERVAL to 10 (to update every once a minute) it alleviates the issue somewhat. The alternative is to setup and configure NWNX, ODBC and MySQL and use the /sql version of the script, which unfortunately isn't exactly as simple. :S The only alternative I can think of is using the nwserverLog1.txt file instead, but that has its own issues... _________________________ Link
Posted by Vladiat0r at 19:57:23 Voted10.00
New release: 1.6 * Fixed performance issue by using NBDE. * Added setting to specify status update interval to improve performance. * Added override setting to disable udp server status check if port 5121 is blocked. * DeleteCampaignDatabase isn't working on Linux, so removing support for Linux. _________________________ Link
Posted by OOA-Forge at on06/23/05
Wow this is some great work. it functions flawlessly. Genius.
Posted by Lord_Alexander at on06/22/05
Nicely done! _________________________ Alec Usticke - alec@usticke.org NWNWiki NWN2Wiki, databases anyone can edit Bastions of War team PvP arena
Posted by Vladiat0r at 19:27:51 Voted10.00
Also, forgot to mention, in 1.5 I updated the /sql version to correctly handle backslashes in player names. _________________________ Link
Posted by Vladiat0r at 17:15:13 Voted10.00
Updated to 1.5 with some code reorganizing. $query changed to use the simpler form. Merged Linux version into one. _________________________ Link