Item DataBase

[callimuc]

Well I have seen on several threads, heard from several people and realized on several servers that an ´Item-DataBase´ seems to be something good.
I wanted to try also making such a thing but how exactly are they made? Like is everything bumped in an array (doesn´t seem to be good in my oppinion)?

PHP Code:

this.items = {weapon, {stats, more stats, ...}, weapon2, {stats, more stats, ...}, ...}; 


Is it prefered to make them like

PHP Code:

this.item0001 = {weapon, info, damage, image, icon, more stats, ....};
this.item0002 = {"skip", "ani", NULL, "skip.png", "skip-icon.png", {"chat", "funny"}, ....};
.... 


Can anyone maybe tell me some goods and bads about that, maybe give me an example and how they should be used and stuff? No I´m not asking for a full code, just never saw/worked with such a system so I want to see how to work with it.

I do know that everything is stored in a DB.

[Gunderak]

Use SQLITE for an item db, or even a DBNPC and then have method of sending and retrieving data from it.
That would be an even better item system.

One bad thing about what you're currently using, this. variables as soon as you restart graal it's value will be reset to null.

[DustyPorViva]

Only use SQLite for a DB if you're going to actually learn how to use it securely and efficiently. If you're not going to bother doing it right or to debug it, it's going to be slow and insecure.

[fowlplay4]

Originally Posted by Gunderak

Use SQLITE for an item db, or even a DBNPC and then have method of sending and retrieving data from it.
That would be an even better item system.

One bad thing about what you're currently using, this. variables as soon as you restart graal it's value will be reset to null.

Ignore him he doesn't know what he's talking about.

SQL, NPC Flags, Files are all just storage for the item data. Establish a basic item system first:

For tracking the quantity of the item:
clientr.item.("item name") = quantity

Store item data in a DB:
this.("item name") = {item, data};

For making the data of the weapon accessible to your client-side scripts set the following as needed in player flags (this should be a mirror of your DB data):
clientr.data.("item name") = {item, data}

Search MUDlib on the forums for discussion on the topic of "item systems".

[DeCeaseD]

Originally Posted by fowlplay4

Ignore him he doesn't know what he's talking about.

SQL, NPC Flags, Files are all just storage for the item data. Establish a basic item system first:

For tracking the quantity of the item:
clientr.item.("item name") = quantity

Store item data in a DB:
this.("item name") = {item, data};

For making the data of the weapon accessible to your client-side scripts set the following as needed in player flags (this should be a mirror of your DB data):
clientr.data.("item name") = {item, data}

Search MUDlib on the forums for discussion on the topic of "item systems".

For my first item system DB I actually did it so that a players items were stored in a DB, than the information was retrieved via an item info DB since I found that items in client flags tend to become a bit wholesome after awhile, just wondering if it was a bad thing to do it this way?

[DustyPorViva]

Originally Posted by DeCeaseD

For my first item system DB I actually did it so that a players items were stored in a DB, than the information was retrieved via an item info DB since I found that items in client flags tend to become a bit wholesome after awhile, just wondering if it was a bad thing to do it this way?

You need a way to easily access the item data on the clientside, yet be secure on the serverside. Clientr strings are the only way to do this.

[callimuc]

Ok thanks guys. I will look around for those stuff (MUDlib and so on) and mess around with that

[Mark Sir Link]

babby's first item storage might work well by just using classes in which all fields are defined as own variable and saving/loading as JSON.