Advertisement
Guest User

Untitled

a guest
Jun 10th, 2017
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.01 KB | None | 0 0
  1. require("mysqloo")
  2. local DATABASE_HOST = "renderwizard.co.uk"
  3. local DATABASE_PORT = ****
  4. local DATABASE_NAME = "****"
  5. local DATABASE_USERNAME = "****"
  6. local DATABASE_PASSWORD = "****"
  7. local Player = FindMetaTable("Player")
  8.  
  9. function connectToDatabase()
  10. print("Start Connect")
  11. local databaseObject = mysqloo.connect(DATABASE_HOST, DATABASE_USERNAME, DATABASE_PASSWORD, DATABASE_NAME, DATABASE_PORT)
  12. databaseObject.onConnected = afterConnected
  13. databaseObject:connect()
  14. print("Finish Connect")
  15. end
  16. concommand.Add( "sqlcon", connectToDatabase )
  17.  
  18. function afterConnected(database)
  19. print("Connection Successful")
  20. end
  21.  
  22. function LoadStuff(database)
  23. local strSteamID = string.Replace(self:SteamID(), ":", "!")
  24. if strSteamID != "STEAM_ID_PENDING" then
  25. local loaddatasql = databaseObject:query("SELECT index, steamid, items FROM inventory")
  26. loaddatasql.onData = print(loaddatasql)
  27. loaddatasql.onError = print("Failed Loading")
  28. loaddatasql:start()
  29. end
  30. end
  31. concommand.Add( "sqltest", LoadStuff )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement