From GMod Wiki
So in this tutorial I will attempt to show you how you can save and load data such as money or scores using Andy Vincent's Gm_MySql Module
From here on I'm assuming that you have installed the module correctly,know a little bit about Lua and that you have setup a mysql database.
This tutorial will just be a rough outline on how you would use MySQL so its probably not the best and anyone who can fix/patch/update my snippets are more than welcome to.
This is basically just the example script that Andy give's you in the thread but with a practical use I guess...
To connect the module has to have the information what you used to make your database and account, don't worry this is all server side so none can see it!
This is the easiest way of organising the settings in my eyes.
require ("mysqloo") // Include the modules local DATABASE_HOST = "www.freesql.org" // database host (can be an ip) local DATABASE_PORT = 3306 // port to the database, you probably wont need to change this unless you get told to local DATABASE_NAME = "bamboserver" // name of the database local DATABASE_USERNAME = "bambo" // username which you use to access it local DATABASE_PASSWORD = "root" // password of the username
Before we can start ripping things from our database we have to actually connect to it, here's how.
function connectToDatabase() databaseObject = mysqloo.connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME, DATABASE_PORT) databaseObject.onConnected = function() print("Database linked!") end databaseObject.onConnectionFailed = function() print("Failed to connect to the database.") end databaseObject:connect() end connectToDatabase()
Line 2 - Connect to the database using the info from before
Line 3 - When its connected do something, in our case print "Database Linked!"
Line 4 - If it doesn't connect do something else
Line 5 - Tell it to connect
Line 7 - Run the function when the script is ran
Yippe! we are now connected to our database, now we can start to get things or save things, here we will save the users SteamID when s/he first joins.
My database looks like this...
Table Name = Players First Column = ID Second Column = Money
function checkQuery(query) local playerInfo = query:getData() if playerInfo ~= nil then return true else return false end end function FirstJoinMysql( ply ) local query1 = databaseObject:query("SELECT * FROM Players WHERE ID = '" .. ply:SteamID() .. "'") query1.onSuccess = function(q) if not checkQuery(q) then local query2 = databaseObject:query("INSERT INTO Players(ID, money) VALUES ('" .. ply:SteamID() .. "', " .. 15 .. ")") // else create the bugger query2.onSuccess = function(q) print("Created you!") end query2.onError = function(q,e) print("something went wrong") end query2:start() else print("You are already created!") end end query1.onError = function(q,e) print("something went wrong when checking") end query1:start() end hook.Add( "PlayerInitialSpawn", "PlayerInitialSpawn", FirstJoinMysql )
- Theres probably something wrong in there but you get the idea*
(MORE TO COME)