SQL=nil
dbName="pseudol"
dbUser="pseudol"
dbPass="pseudol1234"
dbHost="127.0.0.1"

-- Functions
function dbSet(...)
    if not {...} then return end
    local qh = dbQuery(DBHandler, ...)
    if not qh then return false end
    local result, num_affected_rows, last_insert_id = dbPoll(qh, -1)
    return result, num_affected_rows, last_insert_id
end

function dbGet(...)
    if not {...} then return end
    local stringe=dbPrepareString(DBHandler,...)
    local query=dbQuery(DBHandler, stringe)
    local result,num_affected_rows, last_insert_id =dbPoll(query, -1)
    return result
end


addEventHandler("onResourceStart", resourceRoot, function()
    DBHandler=dbConnect("mysql", "dbname="..dbName..";host="..dbHost.."", dbUser, dbPass, "share=1;autoreconnect=1")
    if DBHandler then
        outputDebugString("* Połączono pomyślnie! (MySQL)")
        dbSet("SET NAMES utf8")
    else
        outputDebugString("* Brak połączenia! (MySQL)")
    end
end)





function pobierzTabeleWynikow(...)
    local h=dbQuery(DBHandler,...)
    if (not h) then
        return nil
    end
    local rows = dbPoll(h, -1)
    return rows
end

function pobierzWyniki(...)
    local h=dbQuery(DBHandler,...)
    if (not h) then
        return nil
    end
    local rows = dbPoll(h, -1)
    if not rows then return nil end
    return rows[1]
end

function zapytanie(...)
    local h=dbQuery(DBHandler,...)
    local result,numrows=dbPoll(h,-1)
    return numrows
end

--[[
function insertID()
    return mysql_insert_id(SQL)
end
function affectedRows()
    return mysql_affected_rows(SQL)
end
]]--