diff options
| author | Alexander Pickering <alexandermpickering@gmail.com> | 2017-08-18 22:07:59 -0400 |
|---|---|---|
| committer | Alexander Pickering <alexandermpickering@gmail.com> | 2017-08-18 22:07:59 -0400 |
| commit | ee97031b04eb99f040c3e8ef31e83a9df3fa358d (patch) | |
| tree | 3ad00da532c3cd619397dcb682d13a5875ded38d /gamemode/core/database | |
| parent | 7a31161e59b34d34917a5c8826d5187fd63e844b (diff) | |
| download | artery-ee97031b04eb99f040c3e8ef31e83a9df3fa358d.tar.gz artery-ee97031b04eb99f040c3e8ef31e83a9df3fa358d.tar.bz2 artery-ee97031b04eb99f040c3e8ef31e83a9df3fa358d.zip | |
PlayerData and MetaData are now stored as text instead of json
Diffstat (limited to 'gamemode/core/database')
| -rw-r--r-- | gamemode/core/database/sv_setup.lua | 4 |
1 files 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) |