SQL DB - Communicating Items from Server to Client

[jamitsu89]

Hey,

Say there's 100 items in default.items within the SQL DB and I'm looking to access the fields for a few of those items, I'm going to need the info Clientside.

Now, I need these ASAP, and so can't put in a request to the server to find the info and then send it back to the Client, so the way I'm considering is to have a weapon that loads all the info when a function (for when it is updated also) is called and brings it to the Clientside so that it can be requested via the other weapons.

I suppose my first question is, how would you retrieve the fields from the SQL DB, and if it's similar, how would you take all that information from the server to the client for later use?

Cheers in advance