Skins: |

NWN SCRIPTS

- Jump to comments -

Title

1.32 Compatible PHP Web Status Via NWNX

Author

Lanthar D'Alton

Submitted / Updated

09-30-2003 / 11-22-2006

Category

Database Related

Expansions

NWN-1.32

View Code

Steps:

Import the playertracking.ERF into your module.

STEP 1:  CREATING THE TABLE:
   mySQL database: save your module, load it, and do the following when logged in as a DM:
   type ~
   type dm_runscript tracking_create
   Exit the server.

   Access database: you will need to convert the create statement I included in tracking_create.

STEP 2:  ENABLE PLAYER TRACKING:  (note: you may need to alter the tracking_inc file if you are using an ACCESS DB).
   Reload the module in the editor.  Open your module heartbeat script and add the following lines:

      //above void main()
      #include "tracking_inc"

      //below void main(), between the { and }.
      updatePlayerTracking(oPC);

  Now save and compile the module heartbeat script, save your module, and reload it.
  Player data will be recorded from this point on to the player_tracking table.

STEP 3:  ADD SELECT ONLY USER TO DATABASE:
  Using mySQL control center, open your database.
  Right click on users and create a user account with only SELECT permissions.
  Put your web server's ip as the hostname.

STEP 3:  SET UP THE PHP SCRIPT:
  Replace the following global variables in the php script with the accurate info for your server:
    $ipaddr
    $port
    $timeout
    $mysqlport
    $mysqlipaddr
    $mysqluser
    $mysqlpass
    $mysqldb
    $servername
    $modulename
    $printjunk
  These are listed at the top of the script.  Just replace the values after them.
    NOTES:
     $ipaddr should be the internal ip if you are behind a router.  If not, then it should be the
             external ip.
     $timeout should be the best safe time of response by the server.  If game server and web server
              are on the same local network, 1 will do.  If not, I'd advise 5 or even 10.
     $servername should be the default name of the server.  If the server is online, this will be
                 overwritten with the name from the server itself.
     $modulename should be the default name of the module.  If the server is online, this will be
                 overwritten with the running module from the server.
     $printjunk can be set to 0 to disable extra info or 1 to enable extra info below the players list.


STEP 4: UPLOAD SCRIPT TO PHP ENABLED SERVER:
    Just put the script in the html directory and link to it.
       note for linux web servers:  Most installs don't actually put php-mysql.x.x.x.x on when you install.
       You may find the rpms at redhat's website, or that of your linux provider.  Then install the rpm.

STEP 5: Visit your new status page.  For Windows users, consider embedding it in your active desktop...

If you have trouble with this, feel free to let me know.  (I prefer ICQ)
Josh Dalton (Lanthar D'Alton)
lanthardalton@icqmail.com
ICQ: 7349572

Credits:
Original Author: Ingmar Stieger (Papillon)  (papillon@blackdagger.com or istieger@gmx.de)
HTML Reformatted by: Angelique Sipos (Anj)
Fully Extrapolated 1.32 Server Info From : tigerphoenixdragon on bioware nwn forums.
Reworked for NWN 1.32 and up by: Josh Dalton (Lanthar D'Alton) (lanthardalton@icqmail.com)

These scripts are released under the GPL (see gpl.txt).

Select All Text | View Code in separate window

Format

Code Only

Type

Type - Player Property Tracking

Includes

BioWare Standard

Description

This is an alteration of Papillon' original php web status script to work with the 1.32 changes. Version 1.32 broke the original script, and closed off the player list queries. I include a nwnx database updating system in an erf that must be added to your module. NOTE: Requires mySQL database (Access may work with sql changes). The system updates a database table via nwnx, every heartbeat, or every couple of heartbeats (code included, pick one). The table tracks levels, classes, xp, dm or not, and a bunch of other things are stored on first entry. It uses a last_seen value to show who is currently on. Updated: Fixed status querying, and added full server info below characters (toggleable with one tiny change.) 10-7-03: altered to avoid checking db if server is known to be down.

Files

Name	Type	Size	Downloads
ldplayertrackserverstat22.rarldplayertrackserverstat22.rar Submitted: 09-30-2003 / Last Updated: 10-06-2003	rar	19.49Kb	1308
--

SCORE OUT OF 10

9.5
2 votes
View Stats
Cast Your Vote!

PORTFOLIO

Add this entry to your portfolio so you can track it

Manage your existing portfolios or create a new one.

SCREENS

No Images

You Must Be Logged In to Participate.

Comments (17):

Posted by Vladiat0r at 2005-05-15 20:25:25

Updated my script to 1.3 which no longer requires NWNX/ODBC or MySQL DB, and instead reads the built-in Bioware-generated FPT file. ^^
_________________________
Link

Posted by Lanthar D'Alton ( 65.68.xxx.xxx ) at 2004-07-02 15:50:00

You might need to go change the tracking_inc to remove the use of two of the constants. Just open tracking_inc and put:
void main() {}
into it and compile. This will expose the line numbers of the constants that bioware removed, so you can delete those lines.

-Lanthar

Posted by aidonor at 2004-05-04 11:47:00

I'm assuming from the newer dates of the posts that this will work with HOTU 1.62? I'd like to use this for my world but want to be sure it works with both expansion packs.

Thanks!---Aidonor
Dragon's Prophecy PW Admin
XCR dev team member
_________________________
---Aidonor
Dragon's Prophecy PW Admin
aidonor@(removeifnotspam)dragonsprophecy.net

Posted by Lanthar D'Alton ( ..xxx.xxx ) at 2004-03-05 17:14:00

Okay, first, that heartbeat script is wrong (my bad on that), it should loop through the players...

like this:

void main()
{
object oPC=GetFirstPC();
while(oPC!=OBJECT_INVALID)
{
updatePlayerTracking(oPC);
oPC=GetNextPC();
}
}

As for the php...
You changed the target IP and port to match those for your server, right? What that error means to me (not 100% certain) is that it is failing to get to your nwn server from your web server. Hope that helps.

-Lanthar

Posted by SoulDeaD ( ..xxx.xxx ) at 2004-03-04 15:12:00

i have the same problem...

i put in OnHeartBear module this script

#include "aps_include"
#include "tracking_inc"

void main()
{
updatePlayerTracking(oPC);
}

but tell this error:

variable defined without type.

and the serverinfo.php (the php file modified) says that:

Fatal error: Maximum execution time of 30 seconds exceeded in /home/bioware/public_html/status/index.php on line 183

can you help me?

Posted by Old_Scores_Transfered at 2004-02-20 10:29:30 Voted 9.00 on 02/20/04

This is a compilation of the old system into a single score. There were 3 that made this score of 9.33 then rounded to 9.

Posted by Lanthar D'Alton ( ..xxx.xxx ) at 2004-02-16 10:39:00

H3r0n & Sco357:
I'll email you the solution h3r0n... but sco posted no address...:/

Anyway, the system was written for use with servers using NWNX already, and most already have the aps_include file as part of their heartbeat... All you need to do is add this line at the top of your heartbeat file:

#include "aps_include"

That should fix it.

Blackie:
Impact on the server is minimal. I do not notice any impact on my own. If it becomes an issue for you, you can strip columns from the queries and only store player name, pc name, and timestamp...

-Lanthar

Posted by BLaCKie_MoRGaN at 2004-02-05 09:02:00

Hey guys for those who has tested it...

What is the performance of the server after the install??

I really want to know that

Posted by Sco357 ( ..xxx.xxx ) at 2004-01-28 20:52:00

H3rOn - I am getting the same error message. Anyone know how to fix this?

Posted by H3rOn ( ..xxx.xxx ) at 2004-01-17 08:34:00

Hi !
Your script is very interresant for SoU 1.32 :)
But i have an error on the HeartBeat Script.. :(

#include "tracking_inc"
void main()
{
updatePlayerTracking(oPC);
}

The toolset generate an error like this : VARIABLE DEFINED WITHOUT TYPE
Please help me! :) thx

p.s. : Sorry for my bad english :s

Posted by PrplPplEater ( ..xxx.xxx ) at 2003-12-09 12:27:00

Sounds good and all, except the erf in the file says I need an expansion pack to install.

Got a native 1.32 version of this ?

Posted by darwinscusp ( ..xxx.xxx ) at 2003-10-12 05:07:00

Great update Lanthar! Thanks!

Posted by Lanthar D'Alton ( ..xxx.xxx ) at 2003-10-06 22:29:00

Realizing that only 5 people grabbed V2.1, but those that did should grab V2.2 because 2.1 would try to check the mySQL DB even if the game server was down. That was a bit foolish, since it will result in no players, and possible mySQL errors if the mySQL server is down too (i.e. on the same box as the game server). Anyway... grab this update. It's a very minor change from 2.1, but it makes a big difference.

-Lanthar

Posted by Lanthar D'Alton ( ..xxx.xxx ) at 2003-10-06 21:34:00

Okay, I've updated this to actually check whether it got anything back... (duh)

Anyway, I also added the full server info response received that shows everything but the player names at the bottom of the page. To show this, just change:
$printjunk=0;
to
$printjunk=1;

It also now shows the live servername/modulename if online.

Posted by darwinscusp ( ..xxx.xxx ) at 2003-10-04 11:34:00

Works well. Doesn't seem to detect server online/offline status properly on linux though.

Posted by buu ( ..xxx.xxx ) at 2003-10-01 12:20:00

i already said evertying in the nwnx forum ;)

Posted by No one special ( ..xxx.xxx ) at 2003-10-01 03:05:00

Good work, yo da man!

You must be Logged In to post comments in this section.