Send Server Message to Multiple Servers

[maddogfargo]

This may be more trouble than it's worth, but I figured I would ask the experts to see what you guys think.

Does anyone know if an NWNx plugin exists or can be created to pass a server message or chat message to multiple servers?

I know this can be done without any special plugins in a heterogeneous environment with a group of servers that all have the same database path. And I know how to do it in such an environment.

But...I need to be able to do this in an environment that does not have a shared database path. So...I was wondering if anyone had any idea/knowledge of how this might be done...or if it is even possible within reason.

Alternatively...Is it possible to have ONE shared database file accessible by all servers while keeping all the other databases unique per server?

I know...it's a weird request. The goal is to have the server that triggers the reset plugin, which kills all servers, also be able to send a notification to all servers. If it's out of reach then nevermind. But if something exists that might work with some tweaking, I'd like to check it out.
_________________
* illegible scribble *

[Zebranky]

MySQL (via nwnx_odbc) with the same database?
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?

[FunkySwerve]

That's how we do it.

Funky

[Baaleos]

You dont even necessarily need them to be sharing the same database.

I once created a Fairy Companion, for a First Person Physics Sandbox game called Garrys Mod.

I added Network capability, and the ability for the Fairys to receive and send private messages even cross servers.


The way I did this, was through one database which was being used by all servers, however, in the case of Neverwinter nights, you may not want 'other' servers having access to your nwnx database.

Thats where you impliment a sort of Daemon protocol (im just picking terminology out of my head here)


mySQL allows for local privilages per table, within a database,

so....

You could either
1. Add a public table to your nwnx nwn database, which will allow edits from any host, and with a public username and password.

2. Impliment a CronJob on a php server, which will read the data from a servers nwnx database, and then post it via another query, to another nwnx database. So, in effect, its not another nwn server that is accessing your nwnx database, its actually a php script, that you have control off, and can trust.

I've actually explored the possiblity of using method 2, for things such as Vaultster etc.
You could, in theory, make a php website, where people could freely register their PW's on, eg - ip address, description, name etc.
And then a php cron job, sends everyones PW's to everyone else.

(Note - You can even add a second cron job, which verifies the Server Details via a udp query - this can retrieve details like - Amount of players online, if the server is online, if the server requires a password etc, and a small description of the server. - If the server was offline, you might want it to be excluded from peoples Databases. - Or just update it to say that the server is offline.)

Eg - 50 People register, so 50 people all receive a datastream via mySQL query, into their public nwn nwnx database table, which then holds a list of PW Server details. Then, via a nwn dialogue, you can choose which pwServer you wish to join.

All of this is do-able, Its remarkably similar in principle to a cross server travel stargate system I was working on for Garrys Mod too.


I use the second method, mainly for Forum Interactivity with my Server.
Eg - Someone Registers on the Forum, if they add their public CDKEY, it allows them to buy items in our forum, and receive them ingame.

[Zebranky]

That works too, of course, but I assumed he has control over and trusts both servers. If not, then sure, time for fun with scripts.
_________________
Win32 SVN builds: http://www.mercuric.net/nwn/nwnx/

<Fluffy-Kooshy> NWNx plugin is to this as nuclear warheads are to getting rid of fire ants.

<ThriWork> whenever I hear nwn extender, I think what does NWN need a penis extender for?

[maddogfargo]

[maddogfargo]

[Zebranky]

[maddogfargo]