--[[
    Resource: OURGame v2
    Developers: Split <split.programista@gmail.com>
    You have no right to use this code without my permission.
    (c) 2015 <split.programista@gmail.com>. All rights reserved.
]]

-- Settings
DBHandler=nil
DBName=""
DBUser=""
DBPass=""
DBHost=""

-- 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
]]--