From ee97031b04eb99f040c3e8ef31e83a9df3fa358d Mon Sep 17 00:00:00 2001 From: Alexander Pickering Date: Fri, 18 Aug 2017 22:07:59 -0400 Subject: PlayerData and MetaData are now stored as text instead of json --- gamemode/core/database/sv_setup.lua | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/gamemode/core/database/sv_setup.lua b/gamemode/core/database/sv_setup.lua index 400473e..607c7be 100644 --- a/gamemode/core/database/sv_setup.lua +++ b/gamemode/core/database/sv_setup.lua @@ -8,7 +8,7 @@ local sql = {} --Setup the database if it's not already local setup_db = [[ -CREATE TABLE IF NOT EXISTS playerdata(SteamID bigint primary key, PlayerData json, MetaData json)]] +CREATE TABLE IF NOT EXISTS playerdata(SteamID bigint primary key, PlayerData TEXT, MetaData TEXT)]] --Create a new player local create_player_query = [[ @@ -20,7 +20,7 @@ SELECT PlayerData, MetaData FROM playerdata WHERE SteamID=%.0f ]] local save_player_query = [[ -UPDATE playerdata SET MetaData=%s PlayerData=%s WHERE SteamID=%.0f +UPDATE playerdata SET MetaData='%s' PlayerData='%s' WHERE SteamID=%.0f ]] local function q_fai(err,query) -- cgit v1.2.3-70-g09d2