local sqlDatas = {
	["host"] = "mysqlgame.clans.hu",
	["user"] = "sadasdas947",
	["pw"] = "bYHuBygYGYNeLAh",
	["database"] = "sadasdas947",
}

local results = {}

function getSQLDatas()
	return sqlDatas
end

addEventHandler("onResourceStart", resourceRoot, function()
	dbHandler = dbConnect("mysql","dbname=".. sqlDatas["database"] ..";host="..sqlDatas["host"], sqlDatas["user"], sqlDatas["pw"], "autoreconnect=1")
	if not dbHandler then
		outputChatBox("#1 mysql kapcsolódás meghiúsult")
		cancelEvent(true)
	end
end)


function getConnection()
	return dbHandler
end

function getMySQLUsername()
	return username
end

function getMySQLPassword()
	return password
end

function getMySQLDBName()
	return db
end

function getMySQLHost()
	return host
end

function getMySQLPort()
	return port
end

function query_free(q,poll)
	local this = #results + 1
	results[this] = dbQuery(dbHandler, q)
	if poll then
		local result, num_affected_rows, last_insert_id = dbPoll(results[this], -1)
		if result == nil then
			dbFree(results[this])
			return this, nil
		elseif result == false then
			dbFree(results[this])
			return this, nil
		else
			dbFree(results[this])
			return this, tonumber(last_insert_id)
		end
	end
	dbFree(results[this])
	return this
end

function getConnection()
	return dbHandler
end

function singleQuery(str,...)
    if (dbHandler) then
        local query = dbQuery(dbHandler,str,...)
        local result = dbPoll(query,-1)
        if (type(result == "table")) then
			return result[1]
        else
			return result
        end
    else
        return false
    end
end

function execute(str)
    if (dbHandler) then
		local query, id = query_free(str, true)
		return query
    else
        return false
    end
end

function getFreeResultPoolID()
	return #results + 1
end

function escape_string(str)
	if (str) then
		return str
	end
	return false
end

function query_rows_assoc(str,...)
    if (dbHandler) then
		local this = #results + 1
		results[this] = dbQuery(dbHandler, str, ...)
		return dbPoll(results[this],-1)
    else
        return false
    end
end

function query(str,...)
    if (dbHandler) then
		return query_rows_assoc(str,...)
    else
        return false
    end
end

function query_fetch_assoc(str,...)
	if(not str)then
		return false
	end
	return singleQuery(str,...)
end

function query_insert_free(str)
    if (dbHandler) then
		local query, id = query_free(str, true)
		return id
    else
        return false
    end
end

function num_rows(result)
	if(not result)then
		return 0
	end
	if (type(result == "table")) then
		return (#result or 0)
	else
		return 1
	end
end