View Single Post
  #6  
Old 03-10-2012, 07:08 AM
Draenin Draenin is offline
Magnificent Bastard
Draenin's Avatar
Join Date: Dec 2004
Location: Bermuda Triangle
Posts: 6,790
Draenin has much to be proud ofDraenin has much to be proud ofDraenin has much to be proud ofDraenin has much to be proud ofDraenin has much to be proud ofDraenin has much to be proud of
Send a message via AIM to Draenin Send a message via MSN to Draenin Send a message via Yahoo to Draenin
Quote:
Originally Posted by Cubical View Post
The item information is stored in a SQL database and cached into a DBNPC. The unique item information in the array is pulled directly from the SQL database. All this is done on login and if a specific items information is updated it will update it on all the online players.
Problem?

Unless you want players to be able to customize items or weapons, this is a perfectly good way of storing this information. It can significantly reduce the amount of data being loaded by the server at any given time.

If you consider the fact that players could have hundreds of things stored on their account at any given time, and that those things might have up to ten or more variables associated with them, the numbers add up fast. And loading all of those things every time a player logs in doesn't make things any better.
Reply With Quote