Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- require("mysqloo")
- local DATABASE_HOST = "renderwizard.co.uk"
- local DATABASE_PORT = ****
- local DATABASE_NAME = "****"
- local DATABASE_USERNAME = "****"
- local DATABASE_PASSWORD = "****"
- local Player = FindMetaTable("Player")
- function connectToDatabase()
- print("Start Connect")
- local databaseObject = mysqloo.connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME, DATABASE_PORT)
- databaseObject.onConnected = afterConnected
- databaseObject:connect()
- print("Finish Connect")
- end
- concommand.Add( "sqlcon", connectToDatabase )
- function afterConnected(database)
- print("Connection Successful")
- end
- function LoadStuff(database)
- local strSteamID = string.Replace(self:SteamID(), ":", "!")
- if strSteamID != "STEAM_ID_PENDING" then
- local loaddatasql = databaseObject:query("SELECT index, steamid, items FROM inventory")
- loaddatasql.onData = print(loaddatasql)
- loaddatasql.onError = print("Failed Loading")
- loaddatasql:start()
- end
- end
- concommand.Add( "sqltest", LoadStuff )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement