ulx_leysql syncbans v6

local oprint = print
local print = function(...)
    local t = {...}
    for k,v in pairs(player.GetAll()) do
        v:ChatPrint(t[1])
    end
    return oprint(...)
end

local oldbans, err = ULib.parseKeyValues( ULib.fileRead( ULib.BANS_FILE ) )



local db = ulx_leysql.sqldb.dbobj

local values = {}

local size = table.Count(oldbans)

for k,v in pairs(oldbans) do
    if(not v.time) then size = size - 1 continue end
    v.name = v.name or "unknown"
    v.time = tonumber(v.time)
    v.unban = tonumber(v.unban)

    if(v.unban!=0) then
        v.unban = (tonumber(v.unban)-tonumber(v.time))/60
    end

    v.reason = v.reason or ""
    v.admin = v.modified_admin or v.admin or "Console"
    v.adminid = 0;

    local finda, findb = string.find(v.admin, "(STEAM_0:", 0, true)

    if(finda) then
        local name_sid = v.admin
        local normalid_withend = string.sub(name_sid, finda+1)
        local normaldid = string.sub(normalid_withend, 0, -2)
        v.adminid = util.SteamIDTo64(normaldid)

        local normalname = string.sub(name_sid, 0, finda-1)
        v.admin = normalname

    end

    table.insert(values, "(" .. util.SteamIDTo64(k) .. ", '" .. db:escape(v.name) ..  "', " .. v.time .. "," .. v.unban .. ",'" .. db:escape(v.reason) .. "', " .. tostring(v.adminid) .. ", '" .. db:escape(v.admin) .. "', NULL, '')")

end



print("syncing bans, should end up being: " .. tostring(size) .. "in mysql!")
local bans_add = db:query("INSERT INTO `lsql_bans`(`steamid`, `nick`, `time`, `duration`, `reason`, `bannedby`, `bannedby_nick`, `unbannedby`, `unbannedby_nick`) VALUES " .. table.concat(values, ","))
bans_add:start()

local check_query = db:query("SELECT COUNT(*) as `cunt` FROM `lsql_bans`")

check_query.onSuccess = function(q, tbl)

    if(not tbl[1]) then print("something went wrong while syncing! :(") return end

    local num = tbl[1]["cunt"]

    if(num >= size) then
        ErrorNoHalt("Successfully synced: " .. tostring(num) .. "bans !")
    else
        ErrorNoHalt("Something went wrong! " .. num .. " bans out of " .. size .. " got synced! :(")
    end
end

check_query.onError = function(q, s)

    ErrorNoHalt("Something went wrong! " .. q .. " :: " .. s)
end

check_query:start()