[Beta Test] Database Event

[The Hero of Winds]

Coming Soon!
Don't Ask Me When
Inspired by Oxcorp and awesome few hours of eventing database without this mod build.... ....

Servers With This Event:
DarkLights RP (Official)
Zekes Server

We are Beta testing the database event in DarkLight's RP.  What is the Database Event?  It acts somewhat like a mySQL database, allowing multiple rows and databases.  The database info is all stored on the server, so it's always saved.  This will never replace the variable system, I'm making it work with it to make the database experience much better.

What does the database event have?:
Outputs:
databaseDump - Dumps your database to the chat.
ifPlayerInDatabase - returns true or false.
ifDatabaseRowEquals - returns true or false.
addToBLIDDatabase - Add a BLID to your database, along with 3 rows. (Makes new Database) (Beginners)
addToBLIDDatabaseADV - Add a BLID to your database, unlimited rows.  (Makes new Database)  (Advanced)
databaseToDatabase - Appends a new database on your existing database, 3 starting rows. (In dev, but database is created)
databaseToDatabaseADV - Appends a new database existing database, unlimited rows. (In dev, but database is created)
appendToDatabaseID - Append more rows to the selected BLID.
RemoveFromBLIDDatabase - Delete player from database.
setDatabaseRow - Change a row without appending.


Inputs:
onDataBaseRowEquals - We all know what this means.
onDataBaseRowNotEquals - We know what this is also.
onDatabaseQuery - When someone query's your database this function is called. (1 Second Timeout)
onDataBaseError - This is called when there is an error with your Database.


Also, for security, the database files are stored in your own data folder. (By BL User Name)

You can test this on DarkLight's RP.

Screenshots:

What does this do, it allows the player to create databases for their builds, for a hotel as an example.  Say you created a hotel, and someone wants a room.  But you have database protection on that room, they will not be able to get in without being on the database.  So you can simply just use the addToBLIDDatabase or addToBLIDDatabaseADV to add them to the database.  A quick example on a 3 row database.

BL_ID Column1 Column2 Column3

Here is an example if you were to do a permission database for doors or something.

BL_ID:      Room1         Room2       Room3   
   0              1               0              0

BL_ID:      Room1         Room2       Room3   
   1              0               1              1

With the advanced database you can have more rows.  Or you can use appendToDatabaseID.

[Ad Bot]

[ryanb31394]

So what EXACTLY does this do?

[The Hero of Winds]

So what EXACTLY is this used for?

Well, it could be used on build such as office builds, hotels (for rooms), and many more possibility's.

[ryanb31394]

Sorry, fixed my post...

[The Hero of Winds]

So what EXACTLY does this do?

What does this do, it allows the player to create databases for their builds, for a hotel as an example.  Say you created a hotel, and someone wants a room.  But you have database protection on that room, they will not be able to get in without being on the database.  So you can simply just use the addToBLIDDatabase or addToBLIDDatabaseADV to add them to the database.  A quick example on a 3 row database.

BL_ID Column1 Column2 Column3

Here is an example if you were to do a permission database for doors or something.

BL_ID:      Room1         Room2       Room3   
   0              1               0              0

BL_ID:      Room1         Room2       Room3   
   1              0               1              1

With the advanced database you can have more rows.  Or you can use appendToDatabaseID.

[ryanb31394]

So you can choose who can do what, and the people that are not on the list can't activate that event?

[The Hero of Winds]

So you can choose who can do what, and the people that are not on the list can't activate that event?

You can use onDataBaseRowEquals to call the event, or use ifPlayerInDatabase to do a check.  It all depends on what your doing, but yes, they can't activate it if you set it up to not activate.

[Ephialtes]

Why would you call it a mysql database - it isn't even relational. Surely you just mean a simple flatfile database?

[The Hero of Winds]

Why would you call it a mysql database - it isn't even relational. Surely you just mean a simple flatfile database?

I never called it a mySQL database, I said it was somewhat like a mySQL database.  But yes, flatfile would be the correct term.

[BobAndRob]

not really, no

[The Hero of Winds]

not really, no

What?

[BobAndRob]

not like any sql DB that i know of, ephi is right, its a flatfile DB unless you are actually useing an sql DB, and i know you arnt because you would just be creating a new table record for each person instead of having separate DBs in folders.

[The Hero of Winds]

Added two more screen shots for examples, they just show the simple stuff you can do.

[black knight]

So , By what you mean is you can let others build on your bricks if their not on trust list, so only could build on that one brick?

[The Hero of Winds]

So , By what you mean is you can let others build on your bricks if their not on trust list, so only could build on that one brick?

They still need trust to build on your bricks.