Although the database access planned is great news, sometimes its just not soon enough. If this is the case, I have a tool that uses MySQL as a database and lets you persist information to it in a fairly simple manner. It is not unlike other tools out there, although I have been using this one since about September? without any problems. I recently updated it to add the MySQL support, as well as fix a few bugs. You will need to install MYSQL, and I will not provide support on how to do that, and only refer you to www.mysql.com If you find a bug, feel free to contact me with details, and I will try to fix it. NEW README WITH MORE INFO!
This is a compilation of the old system into a single score. There were 3 that made this score of 8.33 then rounded to 8.
Posted by Timdalos ( ..xxx.xxx ) at 2003-02-06 15:36:00
YES! Thankyouthankyou :)
The executable runs fine on my 98se system :) Haven't (obviously) had time to really mess with it beyond that, but I DID rtfm :) and that strikes me as the most difficult bit.
A couple thoughts... the player data persistance looks quite good, but is there any way to set world-specific data? Even if it was a kludgey as having to create a "dummy" player somehow (Though a datastore item/object or NPC would be better)... the best looking (in my admittedly VERY limited experience) idea might be a preset Container Object with a blueprint or Tag defined type of "Data Object" -- that way a Builder could put more or less anything they wanted into persistant storage... I see something like a gem, but with a single String (in the Name? How long can a Name be?) that gets put in or out, and interpreted inside the module using a Tokenizer type array access to actually plug the info back into the running game...? How doable would that be?
Posted by Timdalos ( ..xxx.xxx ) at 2003-02-06 15:17:00
OK, this looks good, and the fact that it compiles in Delphi and has source included makes me have hopes even if it isn't intrinsic... but please, what versions of Windows will the exe/dll's run on? As I mentioned in the comments for the more dynamic new PW/MySQL system (APS) -- NOT everyone has XP/2K/NT, nor wants it. Knowing in advance whther I can use this would be nice.
Posted by Disgrace ( ..xxx.xxx ) at 2003-01-28 15:40:00
Sorry Pap if my comment sounded rude (No source. No
thanks). I was very disturbed that you released you NWNX
without source, and I was on my lunch break. You had
mentioned on the bioware official forums that you would be
making the source available. Perhaps at a later time. When
the source is available, I will gladly check it out.
I hope the "strange"ness you mention was in reguards to the
thread on NWVault, not on your official boards. Last I
checked nothing I had said on your official boards
was "strange" (to me anyhow).
Posted by Papillon ( ..xxx.xxx ) at 2003-01-28 08:56:00
I was curious why you (Disgrace) have posted this strange
comment on the APS/NWNX page... and I think I understand
after reading the last two posts here.
While what wrote down there is right to a certain
degree, this is not what an Avlis Team member would post in
a foreign thread, as we wouldn't consider this "good style".
Posted by Disgrace ( ..xxx.xxx ) at 2003-01-23 15:24:00
I do not claim real-time anything. If you knew how to read,
you would have read the "how to" that describes how the
system works. It reads logs, and generates script source
code. Apperantely you thought other-wise...
As for data loss. This system does not "lose" data. Not for
any reason other than you typeing "DELETE FROM [TABLENAME]"
or similar SQL statements. Data is only overwritten if that
is what you have scripted it to do. If the server goes
down, oh-well. All state to that point is still available
to the database.
If you want to use "NWNX" go ahead. I am not trying to stop
you. It sounds good. It sounds like a tool lots of people
will want. I am not making money off my tool. I provided it
because I use it, and it works great. Oh, and because I
like programming. I figured other people "might" want it.
If this tool had 0 downloads it would not affect my life at
all. =)
Good luck with your tool. =)
Posted by Disgrace ( ..xxx.xxx ) at 2003-01-20 09:46:00
It will take me a little while, but I will port it to
Kylix/Linux. I have to see if my work will allow me to use
their Kylix compiler.
In the case they won't, I will see what is available in the
OpenEdition. I will let you know at any rate.
Posted by Vallis ( ..xxx.xxx ) at 2003-01-19 23:36:00
"This system is not for everyone. Only those that want to
persist data and have advanced control over the data. Its
here now, not in 8-10 months when Bioware gets something
in themselves."
Not only that, but MySQL is a proven relational database.
Not some bug-ridden, feature-lacking hack that Bioware
cooked up at the last minute. If anyone is working on
porting this to Linux PLEASE let me know - I'd like to
help.
V.
Posted by Disgrace ( ..xxx.xxx ) at 2003-01-17 06:54:00
MYSQL seems like a gimic? It lets you store your data in a
database that you can query.
IE:
SELECT * FROM PLAYERVARS WHERE VARNAME = 'UNIQUE_ARTIFACT1'
That would let you know which player has that unique item.
Or, if you made an item that you think is too powerful, and
you want to remove it from people easily,
DELETE FROM PLAYERVARS WHERE VARNAME = 'BADITEM1'
Or you want to add a variable to every player in the game
etc....
This system is not for everyone. Only those that want to
persist data and have advanced control over the data. Its
here now, not in 8-10 months when Bioware gets something in
themselves.
Posted by Ravenswing ( ..xxx.xxx ) at 2003-01-17 02:38:00
Just looking at the readme file, I can't see where the
MySQL stuff come in. "Although the database access planned
is great news, sometimes its just not soon enough" implies
something better than the planned database access, but
that access will be live (I hope, or it's useless) and
this requires module rebuild as do all the other PW data
systems.
BTW, I'm not intending to put your system down, it looks
good as a PW data system. More automated than many. It's
just the MySQL aspect seems more like a gimic than a
feature.
Posted by Disgrace ( ..xxx.xxx ) at 2003-01-16 17:12:00
I will see if I can put together a tutorial. I will be
putting up a patch tomorrow that adds
Set/GetPersistentObject and fixes a couple of issues with
the SQL tracing and even a few memory leaks. Sorry. I just
recently added the MYSQL support, so there was bound to be
a couple of things I missed.
I am glad you think it is revolutionary. Please provide
suggestings and such so I can make it the best tool I
possibly can.
Disgrace.
You must be Logged In to post comments in this section.