Server Totals
Mikona - (3)
Elysia - (2)
Le'Or - (0)
Ferrell - (0)
M'Chek - (0)
Deglos - (0)
Wilderness - (0)
Visimontium - (0)
Underdark - (0)
Total players: 5
Gallery
  • Winter Ball 2015
    Album name: DM Events
    Uploaded by: Ronan
    Uploaded: Sat Jan 03, 2015 4:15 pm

Links Menu

Best way to see if a table exists using NWNX2?

Moderators: Nighthawk4, Dungeon Masters

Best way to see if a table exists using NWNX2?

PostAuthor: johnymutton » Wed Apr 14, 2004 9:39 pm

Hiya friends!

I am really enjoying nwnx2. I just converted my persistent world over to it and it has solved alot of my problems that i was experiencing with the bioware database system.

One question that I haven't been able to answer is whats the best way to determine if a table exists?

I like the way the bioware database engine creates the table if it doens't exist automatically when you store a campaign variable.

I have created a workaround for this for nwnx2, but i think there must be a better way.

I would very much like a sql call or something of that nature that can tell me if a table exists or not.

thanks

johnymutton

Server Name: 0 - - - newbies welcome!
Genre: Action
My NWN Resource Page I Cant Find My Sheep

johnymutton
Newbie
 
Posts: 2
Joined: Tue Apr 13, 2004 6:07 am

PostAuthor: Manuel the White » Wed Apr 14, 2004 10:02 pm

Hi. 8 )

The best place to find information on NWNX is the NWNX Guild located at Bioware's website. It can be found here: http://nwn.bioware.com/guilds_registry/ ... l?gid=3087

We're glad that NWNX is working well for you and so many other persistent worlds. I'm sure Papillion will be pleased by your kind words.

Yours,

- Manuel
ACTIVE CHARACTERS: Casey Landry, Jessie Morrice
SOMETIMES CHARACTERS: Silinde, Luthias
INACTIVE CHARACTERS: Manuel (the White) Thay't Le'Megen, Zven Reaplenoose, Drashter Volterz
User avatar
Manuel the White
Team Member; Retired with Honors
 
Posts: 7424
Joined: Wed Mar 05, 2003 6:45 pm

PostAuthor: johnymutton » Thu Apr 15, 2004 4:20 am

thank you!

here is the link to the message I posted on the bioware site regarding this question in case anyone else is interested.

http://nwn.bioware.com/guilds_registry/ ... 0&gid=3087

Server Name: 0 - - - newbies welcome!
Genre: Action
My NWN Resource Page I Cant Find My Sheep

johnymutton
Newbie
 
Posts: 2
Joined: Tue Apr 13, 2004 6:07 am

PostAuthor: _LuCkY_ » Thu Apr 15, 2004 5:49 am

I don't think its nessecarily NWNx2 that you should ask the question to, but the database server. For instance in SQL Server there is a table in the master database that stores all the names of the existing tables. All you'd have to do is write a query that checks that table to see if it exists. Might be a bit tougher to do with NWNx2 as you can only work with queries and not with database schemes and the like (or am I wrong here?).
User avatar
_LuCkY_
Scholar of Fools
 
Posts: 478
Joined: Tue Apr 29, 2003 10:25 am
Location: Netherlands


Return to NWN Scripting

Who is online

Registered users: BeyondInfinity, Bing [Bot]