sh_pdata.lua

-- incredible-gmod.ru
-- Still helpful&useful&comfy, but without stupid as fuck `Unique` ID collisions
-- This solution simply replaces the default pdata features, nothing more.

local PMETA = FindMetaTable("Player")
local Format, SQLStr, sql, SteamID64 = Format, SQLStr, sql, PMETA.SteamID64

function PMETA:GetPData(name, default)
	name = Format( "%s[%s]", SteamID64(self), name)
	local val = sql.QueryValue("SELECT value FROM playerpdata WHERE infoid = ".. SQLStr(name) .." LIMIT 1")

	return val or default
end

function PMETA:SetPData(name, value)
	if value == nil then
		return self:RemovePData(name)
	end

	name = Format("%s[%s]", SteamID64(self), name)
	return sql.Query("REPLACE INTO playerpdata (infoid, value) VALUES (".. SQLStr(name) ..", ".. SQLStr(value) .." )") ~= false
end

function PMETA:RemovePData(name)
	name = Format("%s[%s]", SteamID64(self), name)
	return sql.Query("DELETE FROM playerpdata WHERE infoid = ".. SQLStr(name)) ~= false
end