local hostname = \"127.0.0.1\"
local username = \"mta_22299\"
local password = \"h6p5bLxI\"
local database = \"mta_22299\"
local port = 3306
local MySQLConnection = nil
local resultPool = { }
local sqllog = false
local countqueries = 0
function connectToDatabase(res)
MySQLConnection = mysql_connect(hostname, username, password, database, port)

if (not MySQLConnection) then
   if (res == getThisResource()) then
      cancelEvent(true, \"Cannot connect to the database.\")
   end
   return nil
end

return nil
end
addEventHandler(\"onResourceStart\", getResourceRootElement(getThisResource()), connectToDatabase, false)

function destroyDatabaseConnection()
if (not MySQLConnection) then
   return nil
end
mysql_close(MySQLConnection)
return nil
end
addEventHandler(\"onResourceStop\", getResourceRootElement(getThisResource()), destroyDatabaseConnection, false)
function sgs_logsQLError(str)
local message = str or \'N/A\'
outputDebugString(\"MYSQL ERROR \"..mysql_errno(MySQLConnection) .. \": \" .. mysql_error(MySQLConnection))
end
function getFreeResultPoolID()
local size = #resultPool
if (size == 0) then
   return 1 
end
for index, query in ipairs(resultPool) do
   if (query == nil) then
      return index
   end
end
return (size + 1)
end
function ping()
if (mysql_ping(MySQLConnection) == false) then
   destroyDatabaseConnection()
   connectToDatabase(nil)
   if (mysql_ping(MySQLConnection) == false) then
      sgs_logsQLError()
      return false
   end
   return true
end
return true
end
function escape_string(str)
if (ping()) then
   return mysql_escape_string(MySQLConnection, str)
end
return false
end
function query(str)
countqueries = countqueries + 1

if (ping()) then
   local result = mysql_query(MySQLConnection, str)
   if (not result) then
      sgs_logsQLError(str)
      return false
   end
   local resultid = getFreeResultPoolID()
   resultPool[resultid] = result
   return resultid
end
return false
end
function unbuffered_query(str)
countqueries = countqueries + 1

if (ping()) then
   local result = mysql_unbuffered_query(MySQLConnection, str)
   if (not result) then
      sgs_logsQLError(str)
      return false
   end
   local resultid = getFreeResultPoolID()
   resultPool[resultid] = result
   return resultid
end
return false
end
function query_free(str)
local queryresult = query(str)
if  not (queryresult == false) then
   free_result(queryresult)
   return true
end
return false
end
function rows_assoc(resultid)
if (not resultPool[resultid]) then
   return false
end
return mysql_rows_assoc(resultPool[resultid])
end
function fetch_assoc(resultid)
if (not resultPool[resultid]) then
   return false
end
return mysql_fetch_assoc(resultPool[resultid])
end
function free_result(resultid)
if (not resultPool[resultid]) then
   return false
end
mysql_free_result(resultPool[resultid])
table.remove(resultPool, resultid)
return nil
end
-- incase a nub wants to use it, FINE
function result(resultid, row_offset, field_offset)
if (not resultPool[resultid]) then
   return false
end
return mysql_result(resultPool[resultid], row_offset, field_offset)
end
function num_rows(resultid)
if (not resultPool[resultid]) then
   return false
end
return mysql_num_rows(resultPool[resultid])

end
function insert_id()
return mysql_insert_id(MySQLConnection) or false
end
function query_fetch_assoc(str)
local queryresult = query(str)
if  not (queryresult == false) then
   local result = fetch_assoc(queryresult)
   free_result(queryresult)
   return result
end
return false
end
function query_rows_assoc(str)
local queryresult = query(str)
if  not (queryresult == false) then
   local result = rows_assoc(queryresult)
   free_result(queryresult)
   return result
end
return false
end
function query_insert_free(str)
local queryresult = query(str)
if  not (queryresult == false) then
   local result = insert_id()
   free_result(queryresult)
   return result
end
return false
end
-- function escape_string(str)
-- return mysql_escape_string(MySQLConnection, str)
-- end
function debugMode()
if (sqllog) then
   sqllog = false
else
   sqllog = true
end
return sqllog
end
function returnQueryStats()
return countqueries
end
function queryNullaz()
countqueries = 0
end

username =  \"mta_22299\"
password =  \"h6p5bLxI\"
db = \"mta_22299\"
host = \"127.0.0.1\"
port = 3306
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

local host = \"127.0.0.1\"
local username = \"mta_22299\"
local password = \"h6p5bLxI\"
local db = \"mta_22299\"
local results = {}
addEventHandler(\"onResourceStart\", resourceRoot, function()
dbHandler = dbConnect(\"mysql\",\"dbname=\".. db ..\";host=\"..host, username, password, \"autoreconnect=1\")
if not dbHandler then
   outputChatBox(\"#1 mysql kapcsolódás meghiúsult\")
   cancelEvent(true)
end
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

<meta>
<script src=\"dxdraw.lua\" type=\"server\" />
</meta>