Using contents of databases

Print Thread

Using contents of databases #549543 01/09/14 02:45 PM
Joined: Aug 2014 M Mag OP journeyman
OP Mag journeyman M Joined: Aug 2014	From the tutorial videos it looks like you can Add to a database Remove from a database Query a database for the existence of data Are there other uses? For instance can we retrieve a value and store it in a variable. Can we use the database query within a formula as a parameter?

Mag #549547 01/09/14 03:03 PM

Joined: Jul 2014

addict

addict

Joined: Jul 2014

Storing a value in a database:

Code

IF
Event
THEN
DB_MyOwnDatabase(9001);

Retrieving the (first) value from a database for use in another function:

Code

IF
Event
AND
DB_MyOwnDatabase(_outputVariable)
THEN
PartyAddExperience(_outputVariable);

Checking for existence of a value:

Code

IF
Event
AND
DB_MyOwnDatabase(9001)
THEN
Stuff

Removing a value:

Code

IF
Event
THEN
NOT DB_MyOwnDatabase(9001);

Making a database with multiple entries:

Code

INIT SECTION
DB_Stuff(1, 1000);
DB_Stuff(2, 2000);
DB_Stuff(3, 3000);
DB_Stuff(4, 4000);
DB_Stuff(5, 5000);

Passing one value to retrieve another from the database:

Code

IF
CharacterLeveledUp(_Char)
AND
CharacterGetLevel(_Char, _level)
AND
DB_Stuff(_level, _output)
THEN
PartyAddExperience(_output);

Using a database as an event:

Code

IF
DB_Stuff(_level, _experience)
THEN
PartyAddExperience(_experience);
NOT DB_Stuff(_level, _experience);


IF
Event
THEN
DB_Stuff(9, 9001);

Checking if something doesn't exist within the database:

Code

IF
Event
AND
NOT DB_Stuff(9, 9001)
THEN
PartyAddExperience(5000);

Checking for just one of the many values in a database:

Code

IF
Event
AND
DB_Stuff(_level, 9001)
THEN
PartyAddExperience(9001);

----
I think that covers all of the database uses that I know of.

Re: Using contents of databases Mag #549552 01/09/14 03:37 PM
Joined: Aug 2014 M Mag OP journeyman
OP Mag journeyman M Joined: Aug 2014	Wow, thanks Rhidian! That was super helpful.

Re: Using contents of databases Mag #550782 07/09/14 01:34 AM
Joined: Aug 2014 M Mag OP journeyman
OP Mag journeyman M Joined: Aug 2014	Can you store a 0 in a database? It sounds like an obvious question but I'm trying to reset a counter by writing zero do the DB used to track the counter. It seems like It's not working.

Re: Using contents of databases Mag #550784 07/09/14 01:43 AM
Joined: Jul 2014 R Rhidian addict
Rhidian addict R Joined: Jul 2014	You can store a 0, but if you're using a database as a counter then you need to be sure to remove the previous Database values as well. Databases store values until they are manually deleted. Code INIT SECTION DB_Counter(1); KB SECTION IF CharacterLeveledUp(_Char) THEN DB_Counter(0); In this code above, it initializes the DB_Counter at 1. When a character levels up, it adds a 0 to the database. At that point, the database would look like this- Code DB_Counter(1) DB_Counter(0) If you really want to reset a database, you could do something like this: Code PROC ProcResetCounter() AND DB_Counter(_int) THEN NOT DB_Counter(_int) ProcResetCounter()

Re: Using contents of databases Rhidian #550820 07/09/14 03:13 AM
Joined: Aug 2014 M Mag OP journeyman
OP Mag journeyman M Joined: Aug 2014	Ah okay. That makes sense. Thanks!

Re: Using contents of databases Mag #551089 07/09/14 06:45 PM
Joined: Aug 2014 H Hutto stranger
Hutto stranger H Joined: Aug 2014	Thank you! I see how I can use the db to do what I was trying to do over here. Is there a unique character id that we can snag and put in the DB?

Re: Using contents of databases Mag #551100 07/09/14 09:45 PM
Joined: Jul 2014 R Rhidian addict
Rhidian addict R Joined: Jul 2014	If you already know which Character you want to use (ie they are in the Character Panel), then you just need to put CHARACTER_ just prior to their name (the name listed in the Character Panel). I believe the character needs to be Global as well to be specifically used in Story scripts Player 1 for example is listed as Player1 in the Character Panel. Scripts often refer to this character by using CHARACTER_Player1. Player 2 is listed as Player2, and is referred to with CHARACTER_Player2.

Re: Using contents of databases Mag #552415 10/09/14 01:12 PM
Joined: Sep 2014 Cadmus88 journeyman
Cadmus88 journeyman Joined: Sep 2014	gj Rhidian this should be pinned really

Re: Using contents of databases Rhidian #554960 17/09/14 02:33 PM
Joined: Sep 2014 Cadmus88 journeyman
Cadmus88 journeyman Joined: Sep 2014	Originally Posted by Rhidian Storing a value in a database: Retrieving the (first) value from a database for use in another function: Code IF Event AND DB_MyOwnDatabase(_outputVariable) THEN PartyAddExperience(_outputVariable); Actually it`s not, it will execute THEN part for every value in database

Hop To

Link Copied to Clipboard

Larian Studios Forums Divinity - Original Sin Divinity Original Sin - Mods Using contents of databases