179121 179123

SDQL query


Raw Data
{
    "data": {
        "nianjiilical": {
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/mob\/living\/carbon\/human WHERE ckey != null": 3,
            "CALL AddSpell (new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/mob\/living\/carbon\/human WHERE ckey != null": 2,
            "CALL AddSpell (\/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/mob\/living\/carbon\/human WHERE ckey != null": 1,
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport(null)) ON \/mob\/living\/carbon\/human WHERE ckey != null": 1,
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport(null)) ON \/mob\/living\/carbon": 1,
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/mob\/living\/carbon": 1,
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/datum\/mind ": 1,
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport(null)) ON \/datum\/mind ": 1,
            "CALL AddSpell (new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/mob\/living\/carbon\/human WHERE ckey != null": 1,
            "CALL AddSpell (new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/datum\/mind": 1,
            "CALL AddSpell (new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport) ON \/datum\/mind": 1,
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/mob\/living\/carbon\/human WHERE ckey != null": 1,
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/mob\/living\/carbon\/human ": 1,
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/ethereal_jaunt) ON \/mob\/living\/carbon\/human WHERE ckey != null": 1,
            "CALL _AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/mob\/living\/carbon\/human WHERE ckey != null": 1,
            "CALL _AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/datum\/mind": 1,
            "CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport) ON \/datum\/mind": 1,
            "CALL add_filter(\"team\", 2, list(\"type\" = \"outline\", \"color\" = \"#ff0000\", \"size\" = 5)) ON \/mob\/living\/carbon\/human\/species\/felinid WHERE ckey = null": 1,
            "CALL add_filter(\"haunt_glow\", 2, list(\"type\" = \"outline\", \"color\" = \"#f8f8ff\", \"size\" = 1)) ON \/mob\/living\/carbon\/human\/species\/felinid  WHERE z = 1": 1,
            "CALL add_filter(\"haunt_glow\", 2, list(\"type\" = \"outline\", \"color\" = \"#f8f8ff\", \"size\" = 1)) ON \/mob\/living\/carbon\/human WHERE z = 1": 1,
            "CALL UPDATE \/mob\/living\/carbon\/human SET color = global._pick(\"#ff0000\", \"#00ff00\", \"#0000ff\")": 1,
            "UPDATE \/mob\/living\/carbon\/human SET color = global._pick(\"#ff0000\", \"#00ff00\", \"#0000ff\")": 2,
            "UPDATE \/mob\/living\/silicon SET color = global._pick(\"#ff0000\", \"#00ff00\", \"#0000ff\")": 1,
            "UPDATE \/mob\/living\/carbon\/human SET color = global._pick(\"#ff00ff\", \"#ffff00\", \"#00ffff\")": 1,
            "UPDATE \/mob\/living\/silicon SET color = global._pick(\"#ff00ff\", \"#ffff00\", \"#00ffff\")": 1,
            "UPDATE \/mob\/living\/carbon\/human SET color = global._pick(\"#ff00ff\", \"#ffff00\", \"#00ffff\") WHERE color = null": 1
        },
        "bastardblaster": {
            "UPDATE \/obj\/item\/clothing\/shoes SET can_be_tied = 1; UPDATE \/obj\/item\/clothing\/shoes SET #null = adjust_laces(2)": 1
        }
    },
    "parser": null,
    "id": 6876583,
    "datetime": {
        "date": "2022-02-27 07:57:10.000000",
        "timezone_type": 3,
        "timezone": "UTC"
    },
    "round": 179122,
    "key": "SDQL query",
    "type": "nested tally",
    "version": 1,
    "json": "{\"data\":{\"nianjiilical\":{\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/mob\/living\/carbon\/human WHERE ckey != null\":3,\"CALL AddSpell (new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/mob\/living\/carbon\/human WHERE ckey != null\":2,\"CALL AddSpell (\/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/mob\/living\/carbon\/human WHERE ckey != null\":1,\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport(null)) ON \/mob\/living\/carbon\/human WHERE ckey != null\":1,\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport(null)) ON \/mob\/living\/carbon\":1,\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/mob\/living\/carbon\":1,\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport) ON \/datum\/mind \":1,\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport(null)) ON \/datum\/mind \":1,\"CALL AddSpell (new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/mob\/living\/carbon\/human WHERE ckey != null\":1,\"CALL AddSpell (new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/datum\/mind\":1,\"CALL AddSpell (new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport) ON \/datum\/mind\":1,\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/mob\/living\/carbon\/human WHERE ckey != null\":1,\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/mob\/living\/carbon\/human \":1,\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/ethereal_jaunt) ON \/mob\/living\/carbon\/human WHERE ckey != null\":1,\"CALL _AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/mob\/living\/carbon\/human WHERE ckey != null\":1,\"CALL _AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport(null)) ON \/datum\/mind\":1,\"CALL AddSpell(new \/obj\/effect\/proc_holder\/spell\/targeted\/area_teleport\/teleport) ON \/datum\/mind\":1,\"CALL add_filter(\\\"team\\\", 2, list(\\\"type\\\" = \\\"outline\\\", \\\"color\\\" = \\\"#ff0000\\\", \\\"size\\\" = 5)) ON \/mob\/living\/carbon\/human\/species\/felinid WHERE ckey = null\":1,\"CALL add_filter(\\\"haunt_glow\\\", 2, list(\\\"type\\\" = \\\"outline\\\", \\\"color\\\" = \\\"#f8f8ff\\\", \\\"size\\\" = 1)) ON \/mob\/living\/carbon\/human\/species\/felinid  WHERE z = 1\":1,\"CALL add_filter(\\\"haunt_glow\\\", 2, list(\\\"type\\\" = \\\"outline\\\", \\\"color\\\" = \\\"#f8f8ff\\\", \\\"size\\\" = 1)) ON \/mob\/living\/carbon\/human WHERE z = 1\":1,\"CALL UPDATE \/mob\/living\/carbon\/human SET color = global._pick(\\\"#ff0000\\\", \\\"#00ff00\\\", \\\"#0000ff\\\")\":1,\"UPDATE \/mob\/living\/carbon\/human SET color = global._pick(\\\"#ff0000\\\", \\\"#00ff00\\\", \\\"#0000ff\\\")\":2,\"UPDATE \/mob\/living\/silicon SET color = global._pick(\\\"#ff0000\\\", \\\"#00ff00\\\", \\\"#0000ff\\\")\":1,\"UPDATE \/mob\/living\/carbon\/human SET color = global._pick(\\\"#ff00ff\\\", \\\"#ffff00\\\", \\\"#00ffff\\\")\":1,\"UPDATE \/mob\/living\/silicon SET color = global._pick(\\\"#ff00ff\\\", \\\"#ffff00\\\", \\\"#00ffff\\\")\":1,\"UPDATE \/mob\/living\/carbon\/human SET color = global._pick(\\\"#ff00ff\\\", \\\"#ffff00\\\", \\\"#00ffff\\\") WHERE color = null\":1},\"bastardblaster\":{\"UPDATE \/obj\/item\/clothing\/shoes SET can_be_tied = 1; UPDATE \/obj\/item\/clothing\/shoes SET #null = adjust_laces(2)\":1}}}",
    "originalUrl": null
}