I placed the libmysql.so where srcds_run is (also made a link named libmySQL.so, just to be sure).
I also placed the gmcl_mysqloo_i486.dll and gmsv_mysqloo_i846.dll into garrysmod/lua/includes/modules, but still, when the server start it says "ERROR! Module 'mysql' not found!".

And what if I would like to have UBan on my server which is hosted under Linux? I will surely not clog up their forum with one post and if they don't want to port it, then nevermind. It costs nothing to ask...

21st July 2010
Last edited by Kopimi; 21st July 2010 at 06:06PM.
Post #176

Am I the only one that is having an impossibly hard time getting this module to function like it should or..? I've required MySQLoo, I've declared the META, all the other meta functions in the file work, and yet whenever I bring MySQLoo into the equasion its just more debugging to do.

Am I the only one that is having an impossibly hard time getting this module to function like it should or..? I've required MySQLoo, I've declared the META, all the other meta functions in the file work, and yet whenever I bring MySQLoo into the equasion its just more debugging to do.

After a lot of unnecessary work I got it to query and connect, but the organization of the module is such a clusterfuck I have to bend over backwards just to set a meta functions return value to a query value..
If I could find documentation on gm_tmysql I think I'd rather use it. No offense to you andy, you're a better programmer than I, but both of your SQL modules are handled so oddly I'd have an easier time reading an encrypted message through a cereal box decoder ring.

First off, because Port, Number Of Connections and Threads are all in brackets, I had assumed they were optional arguments, however, when unspecified, it wouldnt connect and I would recieve an error. The same goes for the 3 arguments other than the query in the Query function. I've tried calling the callback function via the following methods in arguments:

CheckForSQL
CheckForSQL()
CheckForSQL(result, status, error)

And yet I'm still getting this error. Am I missing something here or am I just having terrible luck with MySQL modules, because it seems no matter what I do, one way or the other they simply will not work. I've tried everything I can think of and yet I cant get anything to work (And yes I'm requiring "tmysql"). I just want to get my server linked to my databases, is that too much to ask? :sigh:

I have no idea if this will work or not, but run this query right after you make the insert:

Code:

SELECT @@IDENTITY AS ID

This should return a table of a single row and single column, of the name 'ID', containing the last inserted ID. It has to be run on the same connection as the insert, and before you do any more inserts (so straight after will be fine).