[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 settingslocal hostname = \"localhost\"local username = \"root\"local password = \"\"local database = \"budapestlife\"local port = 3306-- global things.local MySQLConnection = nillocal resultPool = { }local sqllog = falselocal countqueries = 0-- connectToDatabase - Internal function, to spawn a DB connectionfunction connectToDatabase(res)MySQLConnection = mysql_connect(hostname, username, password, database, port)if (not MySQLConnection) thenif (res == getThisResource()) then cancelEvent(true, \"Cannot connect to the database.\")endreturn nilendreturn nilendaddEventHandler(\"onResourceStart\", getResourceRootElement(getThisResource()), connectToDatabase, false)-- destroyDatabaseConnection - Internal function, kill the connection if theres one.function destroyDatabaseConnection()if (not MySQLConnection) thenreturn nilendmysql_close(MySQLConnection)return nilendaddEventHandler(\"onResourceStop\", getResourceRootElement(getThisResource()), destroyDatabaseConnection, false)-- do something usefull herefunction 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)endfunction getFreeResultPoolID()local size = #resultPoolif (size == 0) thenreturn 1 endfor index, query in ipairs(resultPool) doif (query == nil) then return indexendendreturn (size + 1)end------------ EXPORTED FUNCTIONS ---------------function ping()if (mysql_ping(MySQLConnection) == false) then-- FUU, NO MOAR CONNECTIONdestroyDatabaseConnection()connectToDatabase(nil)if (mysql_ping(MySQLConnection) == false) then logSQLError() return falseendreturn trueendreturn trueendfunction escape_string(str)if (ping()) thenreturn mysql_escape_string(MySQLConnection, str)endreturn falseendfunction query(str)if sqllog thenexports[\'logs\']:logMessage(str, 24)endcountqueries = countqueries + 1if (ping()) thenlocal result = mysql_query(MySQLConnection, str)if (not result) then logSQLError(str) return falseendlocal resultid = getFreeResultPoolID()resultPool[resultid] = resultreturn resultidendreturn falseendfunction unbuffered_query(str)if sqllog thenexports[\'logs\']:logMessage(str, 24)endcountqueries = countqueries + 1if (ping()) thenlocal result = mysql_unbuffered_query(MySQLConnection, str)if (not result) then logSQLError(str) return falseendlocal resultid = getFreeResultPoolID()resultPool[resultid] = resultreturn resultidendreturn falseendfunction query_free(str)local queryresult = query(str)if not (queryresult == false) thenfree_result(queryresult)return trueendreturn falseendfunction rows_assoc(resultid)if (not resultPool[resultid]) thenreturn falseendreturn mysql_rows_assoc(resultPool[resultid])endfunction fetch_assoc(resultid)if (not resultPool[resultid]) thenreturn falseendreturn mysql_fetch_assoc(resultPool[resultid])endfunction free_result(resultid)if (not resultPool[resultid]) thenreturn falseendmysql_free_result(resultPool[resultid])table.remove(resultPool, resultid)return nilend-- incase a nub wants to use it, FINEfunction result(resultid, row_offset, field_offset)if (not resultPool[resultid]) thenreturn falseendreturn mysql_result(resultPool[resultid], row_offset, field_offset)endfunction num_rows(resultid)if (not resultPool[resultid]) thenreturn falseendreturn mysql_num_rows(resultPool[resultid])endfunction insert_id()return mysql_insert_id(MySQLConnection) or falseendfunction query_fetch_assoc(str)local queryresult = query(str)if not (queryresult == false) thenlocal result = fetch_assoc(queryresult)free_result(queryresult)return resultendreturn falseendfunction query_rows_assoc(str)local queryresult = query(str)if not (queryresult == false) thenlocal result = rows_assoc(queryresult)free_result(queryresult)return resultendreturn falseendfunction query_insert_free(str)local queryresult = query(str)if not (queryresult == false) thenlocal result = insert_id()free_result(queryresult)return resultendreturn falseendfunction escape_string(str)return mysql_escape_string(MySQLConnection, str)endfunction debugMode()if (sqllog) thensqllog = falseelsesqllog = trueendreturn sqllogendfunction returnQueryStats()return countqueries-- maybe later moreend