Using AzuiSleet's tmysql module with two databases.

[find me]

The title basically says it all, is it possible to access and query more than one database with AzuiSleet's threaded mysql module? I couldn't find any information about it and have tried my own tests which I listed below but couldn't figure it out. I would like to do this for a ban system that works over multiple servers and then the main one for the server and saving player information.

[lua]
DB = tmysql.initialize("This", "Info", "Is", "Valid")
print(type(DB))
print(tostring(DB))

Q = tmysql.query("SELECT * FROM MyTable", function(tbl, isok, error) end)
print(type(Q))
print(tostring(Q))
[/lua]

nil
nil
nil
nil

[AzuiSleet]

Someone probably gave you a virus, that's the exact usage in the readme.txt.

[jiggz88]

Hate to revive here, but could you repost then the actual link to your module?

[pollyzoid]

[url]http://gmodmodules.googlecode.com/svn/trunk/gm_tmysql2/[/url]

[jiggz88]

still fails to load then.

lua_run require("tmysql")
> require("tmysql")
error loading module 'tmysql' from file 'c:/<path to server>/orangebox/garrysmod/lua/includes/modules/gm_tmysql.dll': The specified module could not be found.

and this is even double checking everything, making sure the 2005 and 2008 sp1 C++ redistrib's are installed

[Deco Da Man]

[url]http://gmodmodules.googlecode.com/svn/trunk/gm_tmysql2/readme.txt[/url]

Follow the 'Installation' section to the word.

[jiggz88]

woudnt it be possible if you localized the init's to databases in two separate files to have two databases connected?