Using Databases to store values such as money. (Tutorial Request)

[LuaTenshi]

Can some one make a good video tutorial about how to use databases to store values like money? (For both online and offline databases.)

[MrPresident]

Are you wanting to use the built in sv.db SQLite that is included in Gmod?

Or do you want something that you can tie into a website like MySQL?

[LuaTenshi]

Are you wanting to use the built in sv.db SQLite that is included in Gmod?

Or do you want something that you can tie into a website like MySQL?

Well I would like to use the sv.db, because all I really need to do is store money (scores), ...and I don't feel like I need an online scoreboard.

---

But it really depends on what is better, I need to store players scores, perks, and inventory items.

[MrPresident]

I'm not sure if this is new to GM13 or not (I've never seen it...)

but it certainly looks promising..

wiki.garrysmod.com/page/Classes/Player/GetPData

[krooks]

I was actually trying to do the same exact thing, I found this tutorial here: http://maurits.tv/data/garrysmod/wiki/wiki.garrysmod.com/index69ca.html
and followed it, only changing some values like the name of the shop etc. but it wouldn't store the data, I'm wondering now if that's because the tutorial was for GM12.

There is also SetPData. My next question would be is, how do I create the "money" column? Would it auto create if I ran
player.GetByID( 1 ):SetPData( "money", 100 ) before trying to GetPData money?

[MrPresident]

Yes. You don't have to worry about setting anything up when using GetPData/SetPData. It will do all of the backend stuff for you.

[krooks]

Great, thanks for the info -- I could see this file getting a bit messy/overloaded? Is there some way to clean it out without deleting it completely?

Maybe that doesn't even matter?