Advertisement
Guest User

Untitled

a guest
Jul 10th, 2017
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Lua 2.34 KB | None | 0 0
  1. local meta = FindMetaTable("Player")
  2. if !meta then return end
  3.  
  4. require("tmysql")
  5.  
  6. DB = {}
  7.  
  8. // Login info.
  9. local HOST = "mysql.xenonservers.com"
  10. local PORT = 3306
  11. local NAME = "kunden_53984"
  12. local USERNAME = "kunden_53984"
  13. local PASSWORD = "selthion"
  14.  
  15. // Connect.
  16. function Connect()
  17.     tmysql.initialize( HOST, NAME , PASSWORD, USERNAME, PORT, 2, 2)
  18. end
  19.  
  20. // Create a new account...
  21. function DB.NewAccount( pl )
  22.     --if !pl then return end
  23.     SteamID = pl:SteamID()
  24.     name = pl:Name()
  25.    
  26.     tmysql.query("INSERT INTO db_users(`steamid`, `name`, `donator`, `money`, `title`) VALUES('"..SteamID.."', '"..name.."', '0' '0', 'Guest')")
  27.     local query = tmysql.query( "SELECT donator, money, title FROM db_users WHERE steamid= '"..SteamID.."' ")
  28.    
  29.     if query then
  30.         MsgN("DB working...")
  31.         DB.LoadAccount( pl )
  32.     else
  33.         MsgN("DB failed...")
  34.         return
  35.     end
  36. end
  37.  
  38. // Load an existing account.
  39. function DB.LoadAccount( pl )
  40.     pl.PlayerData = {}
  41.    
  42.     ID = pl:SteamID()
  43.     pl.PlayerData["money"] = tmysql.query("SELECT money FROM db_users WHERE steamid = '"..ID.."'")
  44.     pl.PlayerData["title"] = tmysql.query("SELECT title FROM db_users WHERE steamid = '"..ID.."'")
  45.     pl.PlayerData["donator"] = tmysql.query("SELECT donator FROM db_users WHERE steamid = '"..ID.."'")
  46.  
  47.     pl:ChatPrint("Your account has loaded.")
  48. end
  49.  
  50. // Save an account.
  51. function DB.SaveAccount( pl )
  52.     name = pl:Name()
  53.     ID = pl:SteamID()
  54.     money = pl.PlayerData["money"]
  55.     VIP = pl.PlayerData["donator"]
  56.     title = pl.PlayerData["title"]
  57.    
  58.     tmysql.query("UPDATE db_users SET name = "..name.." WHERE steamid = '"..ID.."'")
  59.     tmysql.query("UPDATE db_users SET money = "..money.." WHERE steamid = '"..ID.."'")
  60.     tmysql.query("UPDATE db_users SET donator = "..VIP.." WHERE steamid = '"..ID.."'")
  61.     tmysql.query("UPDATE db_users SET title = "..title.." WHERE steamid = '"..ID.."'")
  62. end
  63.  
  64. // Check if we have the player in our database or not..
  65. function Player( pl )
  66.  
  67.     SteamID = pl:SteamID()
  68.     query = tmysql.query("SELECT steamid, donator, money FROM db_users WHERE steamid = '"..SteamID.."'")
  69.    
  70.     if query then
  71.         DB.LoadAccount( pl )
  72.     else
  73.         DB.NewAccount( pl )
  74.     end
  75.    
  76. end
  77.  
  78. function SQL( pl )
  79.     ID = pl:SteamID()
  80.     Player( pl )
  81. end
  82. concommand.Add("MYSQL", SQL)
  83.  
  84. Connect()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement