Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- local meta = FindMetaTable("Player")
- if !meta then return end
- require("tmysql")
- DB = {}
- // Login info.
- local HOST = "mysql.xenonservers.com"
- local PORT = 3306
- local NAME = "kunden_53984"
- local USERNAME = "kunden_53984"
- local PASSWORD = "selthion"
- // Connect.
- function Connect()
- tmysql.initialize( HOST, NAME , PASSWORD, USERNAME, PORT, 2, 2)
- end
- // Create a new account...
- function DB.NewAccount( pl )
- --if !pl then return end
- SteamID = pl:SteamID()
- name = pl:Name()
- tmysql.query("INSERT INTO db_users(`steamid`, `name`, `donator`, `money`, `title`) VALUES('"..SteamID.."', '"..name.."', '0' '0', 'Guest')")
- local query = tmysql.query( "SELECT donator, money, title FROM db_users WHERE steamid= '"..SteamID.."' ")
- if query then
- MsgN("DB working...")
- DB.LoadAccount( pl )
- else
- MsgN("DB failed...")
- return
- end
- end
- // Load an existing account.
- function DB.LoadAccount( pl )
- pl.PlayerData = {}
- ID = pl:SteamID()
- pl.PlayerData["money"] = tmysql.query("SELECT money FROM db_users WHERE steamid = '"..ID.."'")
- pl.PlayerData["title"] = tmysql.query("SELECT title FROM db_users WHERE steamid = '"..ID.."'")
- pl.PlayerData["donator"] = tmysql.query("SELECT donator FROM db_users WHERE steamid = '"..ID.."'")
- pl:ChatPrint("Your account has loaded.")
- end
- // Save an account.
- function DB.SaveAccount( pl )
- name = pl:Name()
- ID = pl:SteamID()
- money = pl.PlayerData["money"]
- VIP = pl.PlayerData["donator"]
- title = pl.PlayerData["title"]
- tmysql.query("UPDATE db_users SET name = "..name.." WHERE steamid = '"..ID.."'")
- tmysql.query("UPDATE db_users SET money = "..money.." WHERE steamid = '"..ID.."'")
- tmysql.query("UPDATE db_users SET donator = "..VIP.." WHERE steamid = '"..ID.."'")
- tmysql.query("UPDATE db_users SET title = "..title.." WHERE steamid = '"..ID.."'")
- end
- // Check if we have the player in our database or not..
- function Player( pl )
- SteamID = pl:SteamID()
- query = tmysql.query("SELECT steamid, donator, money FROM db_users WHERE steamid = '"..SteamID.."'")
- if query then
- DB.LoadAccount( pl )
- else
- DB.NewAccount( pl )
- end
- end
- function SQL( pl )
- ID = pl:SteamID()
- Player( pl )
- end
- concommand.Add("MYSQL", SQL)
- Connect()
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement