Alot of questions

[Peskyone]

Alright very very new to building..trying to add a teleport spell system. The creator suggests SQL so I followed the directions imported the erf into my mod added the dll file..made sure everything was set to SQL but where do i put the datebase? How do I make SQL file? He gave a example but when I plugged it into the mod script compiler it did not compile...does it go under NWN folder database? How do I make it a SQL file? I see no editor included with the download...

here is a example the creator provided

--
-- Table structure for table `teleport`
--

CREATE TABLE teleport (
Id int(10) unsigned NOT NULL auto_increment,
Spoken char(20) NOT NULL default '',
Target char(50) NOT NULL default '',
Familiarity char(20) NOT NULL default '',
FQHN char(255) NOT NULL default 'localhost.localnet',
Password char(20) NOT NULL default '',
Direction enum('None','Both','In','Out') NOT NULL default 'None',
Random enum('None','Both','In','Out') NOT NULL default 'None',
PRIMARY KEY (Id)
) TYPE=MyISAM;

--
-- Dumping data for table `teleport`
--


INSERT INTO teleport VALUES (1,'caverns','Caverns_below_Tower','TP_CAVERN','localhost.localnet','','Both','None');
INSERT INTO teleport VALUES (2,'containment','Containment_Area','TP_CONTAIN','localhost.localnet','','Both','None');
INSERT INTO teleport VALUES (3,'exterior','Tower_exterior','TP_EXTERIOR','localhost.localnet','','Both','None');
INSERT INTO teleport VALUES (4,'ground','Tower_ground_floor_Kitchen','TP_GROUND','localhost.localnet','','Both','None');
INSERT INTO teleport VALUES (5,'first','Tower_first_floor_Guest_room','TP_FIRST','localhost.localnet','','Out','None');
INSERT INTO teleport VALUES (6,'second','Tower_second_floor_Bedroom','TP_SECOND','localhost.localnet','','Both','Both');
INSERT INTO teleport VALUES (7,'third','Tower_third_floor_Library','TP_THIRD','localhost.localnet','','Both','None');
INSERT INTO teleport VALUES (8,'fourth','Tower_fourth_floor_Laboratory','TP_FOURTH','localhost.localnet','','Both','None');
INSERT INTO teleport VALUES (9,'portal','MD_SH_PORTAL','TP_EXTERIOR','localhost.localnet','','Both','None');


of course i had to paste with notebook..is there a sql editor? how and where do i put this after I adjust it to fit my areas?

[Peskyone]

I guess to make my questions clearer they are..

1.How do I make a database file? and

2.Where do I put it after it is made?

[monezz]

sql files basicly have nothing to do with nwn.
It are just plain text files with sql statements in it.

In youre case, copy the sample text and paste it into a file.
Give it the extention sql (ie something like teleport.sql) to recognize it as such in the future.
You can execute the statements in the file from the mysql command prompt with: \. path_to\teleport.sql

[Peskyone]

That answered it! Thank you ever so much

[Peskyone]

Still doesn't seem to be functioning...where do i put the database file? in NWN? or on the mod itself?

Second question is there a seperate table file? and if so where does that go?

[Peskyone]

[Acrodania]

[Peskyone]

wow thank you for aswering so quickly and throughly!

[Peskyone]

hmm for some reason iI can't seem to do much with it..i typed in help but nothing comes up that is the command line prompter i tried the second utility but it gives me a message saying it cannot connect...

[Peskyone]

I imported aps2.erf
overwrite all it asked to...


#include "aps_include"
#include "x2_inc_switches"
#include "x2_inc_restsys"
void main()
{
SQLInit();
if (GetGameDifficulty() == GAME_DIFFICULTY_CORE_RULES || GetGameDifficulty() == GAME_DIFFICULTY_DIFFICULT)
{


I have that in the onmodload ..under module events

I have only have sqllite uncomment

added all the files to my nwn directory

I am still at a lose...how do i make and link this database?

The commandprompt...well I am not sure how to use it there is no read me it said to type help for directions but when i do nothing happens

I tried help
.help
and ".help"
all with nothing coming up

I tried the outside utility and it says it won't connect

I looked up the outside utilities manual MySQL-Font for a answer

and all it said was

**
Menu: File / Connection... (only standard mode)


Opens a connection with a database.
**
Which unfortunatly doesn't tell my novice self much

Is there anything...a walkthrough in laymens terms for a non programer?

Thank you ever so much for your help and patience thus far.

[Peskyone]

Alright so it seems this is set up for mysql....is there a way I can make it use sqllite instead since it seems to be the easier database for a novice..if not i take it i need to find this Mysql and download it?

[Acrodania]

The INI file you posted above was already setup for SQLite. Reread my post for instructions

As for "setting up" or "linking" the database, just copy the one in the link I sent you into your NWN directory and make sure the entry in the NWNX.INI file is the same as the name. It should be, but verify You DO NOT set anything inside the module; the NWNX process handles that for you. It is the INI file that determines where the database file is located and which one is being used.....

Once you have the database in place you should be able to run the "aps_demo" module to test it.

IMPORTANT: In case you missed this, you MUST START THE NWNX APPLICATION FIRST!!! You do not start the NWServer, you do NOT start NWN and then open a module. To use NWNX you must let IT control the server process just like you were hosting a PW or the database connections won't work.... Read the documentation. Make sure you edit your INI file with the NAME of the module but do NOT put the .mod on the end.....

Luck!

[Peskyone]

alright but will the scripts i posted care if it is mysql or sqlite?

[Peskyone]

One more question my apoliges I finally have it connecting but now what?

Are the table and database seperate? Do I make both in the sqlite command prompt window? if not which one? and where does the other go?

[Peskyone]

Still not funtioning

I have read the manual at http://www.nwnx.org/index.php?id=doc_odbc2

several times through

I tried my best to follow all the direction given here I really want teleport spells for my mod and would appreciate some aid with credit board kudos...

1st I did what was I think i was told to do I am attempting to make this work on a test mode with only two areas so I used notepad to make a database and named it teleport.db


Spoken Target Familiarity FQHN Password Direction Random
0 farms Farms TP_FARMS localhost.localnet **** Both None
1 forest Forest TP_FOREST localhost.localnet**** Both None


then I linked it through nwnx.ini
; Use these two settings for the SQLite internal database
source = sqlite
file = teleport.db

then ran the mod on gamespy via nwnx

and no teleporting yet if i add this same file and name it teliport.2da into a hak and uncomment this line and comment 2da

//#include "md_teleport_2da" // Enables teleport functionality via teleport.2da
#include "md_teleport_sql" // Enables teleport functionality via MySQL/NWNASPX

It works and i have teliport

unfortinatly the creator who doesn't answer any questions via the vault says this system is undesirable for a PW and to use sql

now i was under the impression that sqlite is self linking..no set up ie CREATE TABLE functions needed? am I wrong? I have the SQLite files from the previous link generously given in my NWN folder and

this is a line from md_teleport_sql to find the databas
// Local constants
const string MD_TELEPORT_SQL_TABLE = "teleport"; // Table to retrieve teleport locations from

and i have this in onmodload

#include "aps_include"
#include "x2_inc_switches"
#include "x2_inc_restsys"
void main()
{
SQLInit();

and downloaded the aps.erf
am i just missing something?

Happy to give more infor if needed I have downloaded two sqLite editors and have yet to be sucessful in making a sqlite file if that is what I need other then a db...been thought the directions from the creators and aps..at a loss please help