Advertisement
GlorifiedPig

Untitled

Dec 6th, 2018
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.75 KB | None | 0 0
  1.  
  2. local plyMeta = FindMetaTable( "Player" )
  3.  
  4. if( !plyMeta ) then return end
  5.  
  6. if ( !sql.TableExists( "playerupdata" ) ) then
  7. sql.Query( "CREATE TABLE IF NOT EXISTS playerupdata ( infoid TEXT NOT NULL PRIMARY KEY, value TEXT );" )
  8. end
  9.  
  10. function plyMeta:SetUPData( name, value )
  11. print('yeet')
  12. name = Format( "%s[%s]", self:SteamID64(), name )
  13. sql.Query( "REPLACE INTO playerupdata ( infoid, value ) VALUES ( " .. SQLStr( name ) .. ", " .. SQLStr( value ) .. " )" )
  14. end
  15.  
  16. function plyMeta:GetUPData( name, default )
  17. name = Format( "%s[%s]", self:SteamID64(), name )
  18. local val = sql.QueryValue( "SELECT value FROM playerupdata WHERE infoid = " .. SQLStr( name ) .. " LIMIT 1" )
  19. if ( val == nil ) then return default end
  20.  
  21. return val
  22. end
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement