Quote:
Originally Posted by salesman
Not really sure what you're trying to say with this.
|
I'm saying that you can fetch information more efficiently by just running a query for a single record, pulling all the associated information from that record's row.
So if you want to load information for a 'Wooden Sword,' you just run a query for a record with that name entered under the 'itemname' column, and then load other information from that record's row, like the 'itemthumbnail' and 'itemtype' and so forth.
The advantage of this is that instead of having to store all of this data on a player's account, the only information you'd really need to read from the account is what the player currently has equipped. It's the only thing that the client needs to read from a player because it's under a player's direct control.