[2014-09-26 13:53:32] ERROR: exports: Call to non-running server resource (mysql) [string \"?\"]
[2014-10-10 22:33:22] ERROR: exports: Call to non-running server resource (mysql) [string \"?\"]
[2014-10-10 22:35:22] ERROR: exports: Call to non-running server resource (mysql) [string \"?\"]
[2014-10-26 15:50:32] ERROR: exports: Call to non-running server resource (mysql) [string \"?\"]
[2014-10-26 16:43:33] ERROR: mysql\\connection.lua:206: bad argument #2 to \'mysql_escape_string\' (string expected, got nil)
[2014-10-26 16:43:33] ERROR: mysql\\connection.lua:206: bad argument #2 to \'mysql_escape_string\' (string expected, got nil)
[2014-10-26 16:43:33] ERROR: call: failed to call \'mysql:escape_string\' [string \"?\"]
[2014-10-26 16:43:33] ERROR: account-system\\s_account_system.lua:821: attempt to concatenate a boolean value
[2014-10-26 16:45:24] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 16:50:25] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 16:50:43] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 16:50:46] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 16:58:40] ERROR: mysql\\connection.lua:206: bad argument #2 to \'mysql_escape_string\' (string expected, got nil)
[2014-10-26 16:58:40] ERROR: mysql\\connection.lua:206: bad argument #2 to \'mysql_escape_string\' (string expected, got nil)
[2014-10-26 16:58:40] ERROR: call: failed to call \'mysql:escape_string\' [string \"?\"]
[2014-10-26 16:58:40] ERROR: account-system\\s_account_system.lua:821: attempt to concatenate a boolean value
[2014-10-26 16:58:54] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 16:58:57] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 16:58:58] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 16:59:02] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:03:27] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:03:30] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:03:53] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:03:55] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:03:55] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:03:58] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:04:16] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:04:19] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:04:21] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:04:23] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:04:55] ERROR: call: failed to call \'global:isPlayerSilverDonator\' [string \"?\"]
[2014-10-26 17:18:07] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 17:21:41] ERROR: mysql\\connection.lua:206: bad argument #2 to \'mysql_escape_string\' (string expected, got nil)
[2014-10-26 17:21:41] ERROR: mysql\\connection.lua:206: bad argument #2 to \'mysql_escape_string\' (string expected, got nil)
[2014-10-26 17:21:41] ERROR: call: failed to call \'mysql:escape_string\' [string \"?\"]
[2014-10-26 17:21:41] ERROR: account-system\\s_account_system.lua:821: attempt to concatenate a boolean value
[2014-10-26 17:22:15] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 18:03:42] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 18:03:47] ERROR: call: failed to call \'global:isPlayerSilverDonator\' [string \"?\"]
[2014-10-26 18:05:17] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 18:05:19] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 18:05:20] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 18:05:24] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 18:05:35] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 18:05:37] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 18:06:48] ERROR: exports: Call to non-running server resource (lottery) [string \"?\"]
[2014-10-26 18:06:48] ERROR: shop-system\\s_generalshop_system.lua:332: attempt to concatenate local \'ticketNumber\' (a nil value)
[2014-10-26 18:06:50] ERROR: exports: Call to non-running server resource (lottery) [string \"?\"]
[2014-10-26 18:06:50] ERROR: shop-system\\s_generalshop_system.lua:332: attempt to concatenate local \'ticketNumber\' (a nil value)
[2014-10-26 18:06:51] ERROR: exports: Call to non-running server resource (lottery) [string \"?\"]
[2014-10-26 18:06:51] ERROR: shop-system\\s_generalshop_system.lua:332: attempt to concatenate local \'ticketNumber\' (a nil value)
[2014-10-26 18:06:52] ERROR: exports: Call to non-running server resource (lottery) [string \"?\"]
[2014-10-26 18:06:52] ERROR: shop-system\\s_generalshop_system.lua:332: attempt to concatenate local \'ticketNumber\' (a nil value)
[2014-10-26 18:07:18] ERROR: item-system\\s_item_system.lua:643: attempt to perform arithmetic on a nil value
[2014-10-26 18:13:32] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside
[2014-10-26 18:52:40] ERROR: Client (Joe_North) triggered serverside event nametags:chatbubble, but event is not added serverside

-- connection settings
local hostname = \"localhost\"
local username = \"root\"
local password =  \"\"
local database = \"budapestlife\"
local port =  3306
-- global things.
local MySQLConnection = nil
local resultPool = { }
local sqllog = false
local countqueries = 0
-- connectToDatabase - Internal function, to spawn a DB connection
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)
-- destroyDatabaseConnection - Internal function, kill the connection if theres one.
function destroyDatabaseConnection()
if (not MySQLConnection) then
return nil
end
mysql_close(MySQLConnection)
return nil
end
addEventHandler(\"onResourceStop\", getResourceRootElement(getThisResource()), destroyDatabaseConnection, false)
-- do something usefull here
function logSQLError(str)
local message = str or \'N/A\'
outputDebugString(\"MYSQL ERROR \"..mysql_errno(MySQLConnection) .. \": \" .. mysql_error(MySQLConnection))
exports[\'logs\']:logMessage(\"MYSQL ERROR :O! [QUERY] \" .. message .. \" [ERROR] \" .. mysql_errno(MySQLConnection) .. \": \" .. mysql_error(MySQLConnection), 24)
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
------------ EXPORTED FUNCTIONS ---------------
function ping()
if (mysql_ping(MySQLConnection) == false) then
-- FUU, NO MOAR CONNECTION
destroyDatabaseConnection()
connectToDatabase(nil)
if (mysql_ping(MySQLConnection) == false) then
   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)
if sqllog then
exports[\'logs\']:logMessage(str, 24)
end
countqueries = countqueries + 1
if (ping()) then
local result = mysql_query(MySQLConnection, str)
if (not result) then
   logSQLError(str)
   return false
end
local resultid = getFreeResultPoolID()
resultPool[resultid] = result
return resultid
end
return false
end
function unbuffered_query(str)
if sqllog then
exports[\'logs\']:logMessage(str, 24)
end
countqueries = countqueries + 1
if (ping()) then
local result = mysql_unbuffered_query(MySQLConnection, str)
if (not result) then
   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
-- maybe later more
end