How can I get ATS 1 to work with the sqlite database?

[Master Lexx]

I don´t know if i am right here, but I was told to post here instead at bioware. My problem is, I dl ATS ( Ambrosia Tradeskill System 1.00 ) but I don´t want to use mysql. I tried it and I don´t like it, to much to do and I really don´t need it, sqlite is fine. I tried the sqlite database of nwnx2 /odbc2 and all works well, the demo mod works, can read and write and I got it to work with my mod.

But I can´t get it to work with ATS, I have read that there are more tables used than one, to store the ATS info sperate from the player variables and the location variables. ATS 1 is hosted on nwvault at http://nwvault.ign.com/View.php?view=Scripts.Detail&id=57

There are 3 mysql data files included so that the database is already right setup. But I don´t want to use mysql, is there a way to get the configuration out of those 3 files (.frm .myd .myi)?. I am no database professional, but I have seen that it can be easy, you only have to create such a table and can use it then. Like in the APS demo mod.

But the provider of ATS 1 gave no info about how to set up the database, just install mysql, get it to work and use the 3 files,.... thanks, nice.

Maybe somebody can help me, and tell me how I need to set the right tables to get them to work with ATS?

[Papillon]

You (or someone else you know) will need to have MySQL running to extract the table definition from the three files. I think it is rather strange that the authors of ATS did not include the table create statements, since not everyone is using MySQL.

Alternatively, maybe someone on this forum has ATS running and can post the create statements ?
_________________
Papillon

[Makzimia De Graf]

The Author, being my wife and I made it with KISS in mind and clearly told everyone, that a: it would not be supported beyond that release, which with the later fixes, I added, works fine, and b: that it was just for NWNX2 and MySQL . The table create statements weren't needed for us, because, my wife is a DB expert, I am not, and then, when I was asked for our version to be made public, I incuded those files to KISS . Now, it really is not that hard to do a search for those that need it in the actual thread under the release on NWvault is in fact the commands for making the tables.

I am officially retired totally from NWN so thanks to Pap and team for what was a great way to run what is now IMO a totally outdated game... NEXT!!! have fun!.

Makz.
_________________
Makzimia De Graf

DM/Creator Island of Fredian
fredian.game-host.org:5123
Forums at http://castille.us/fredian/Forums

[Master Lexx]

Yes, I already knew this. I knew that the authors don´t support anything, it is how it is. But i had have the hope, that somebody who knows a bit about databases could tell me how to set the tables for sqlite. I am no database professional! And I tried to get help here, because there is no useable info in nwvault, and the authors of ATS2 give no support. So please, can somebody tell me how to get the tables out of the 3 files? Or is there somebody who is enough expert to tell me how to make the config for sqlite?

Thanks!

(Makzimia De Graf: if you don´t want to help, please don´t post, you already made clear that you give no help for ATS2, that´s why I asked here and not you)

[Papillon]

I played around with this stuff (just for you ) and here it is:

[Master Lexx]

Thanks. You helped me a bit. I tried to use the Database Manager, but had have no luck with it yet. But I found the sqlite CC which helped me to set the table you wrote. But whenever I try to set the triggers I get an error:

Error: near ")": syntax error , Error: cannot commit - no transaction is active ,

The code you provided should be all I need to set the database up but sqliteCC won´t do it. Both triggers have the syntax error. And I am still no database expert........ I have no idea where the error is. One last time help would be nice. It´now just a small syntax problem.

[Papillon]

I can not get it to work with SQLCC either. No idea what the problem is.
_________________
Papillon