· 7 years ago · Dec 06, 2018, 07:42 PM
1
2local plyMeta = FindMetaTable( "Player" )
3
4if( !plyMeta ) then return end
5
6if ( !sql.TableExists( "playerupdata" ) ) then
7 sql.Query( "CREATE TABLE IF NOT EXISTS playerupdata ( infoid TEXT NOT NULL PRIMARY KEY, value TEXT );" )
8end
9
10function 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 ) .. " )" )
14end
15
16function 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
22end