tmysql Guide?

[.0mega]

Hello all,

Trying to find any information regarding tmysql. I know there is the guide ([url]https://facepunch.com/showthread.php?t=1442438[/url]) but I am struggling to get it working and can't find any reference to it anywhere.

I have the following so far in my init.lua file

local Database, error = tmysql.Connect( "185.38.XXX.XXX", "gmXXX", "XXXXX", "gm_main", 3306, nil, CLIENT_MULTI_STATEMENTS ) 

- X in the blanking that user and pass.

Error I am receiving is as follows.

[ERROR] gamemode/player.lua:5: attempt to index global 'tmysql' (a nil value)

  1. unknown - gamemode/player.lua:5

The query that needs to run is simple enough and just pulls player information from a table, query as follows.

tmysql.query("SELECT Money,Class,Classes,Skills FROM fw_playerdata WHERE SteamID=\'"..steamid.."\'",
	function(res,stat,err)
		if err ~= 0 or (not IsValid(pl)) then return end

Starting to get to grips with the Lua but this my squirrel is not working out for me.

All help appreciated :)

[Billy]

Add:

[lua]
require("tmysql4")
[/lua]

at the top of your file.

[.0mega]

Ok so I have added the require and now getting the following error?

[ERROR] gamemodes/fortwars/gamemode/player.lua:5: attempt to call field 'query' (a nil value)

  1. unknown - gamemodes/fortwars/gamemode/player.lua:5

Is the code correct that I posted above? I am following the instructions in the guide :S

[Klaes4Zaugen]

Do
[lua]
Database:Query(str)
[/lua]

[.0mega]

Doesn't like that either :S

[ERROR] gamemodes/fortwars/gamemode/player.lua:11: attempt to index local 'Database' (a boolean value)

  1. unknown - gamemodes/fortwars/gamemode/player.lua:11

[bigdogmat]

[QUOTE=.0mega;50672692]Doesn't like that either :S

[ERROR] gamemodes/fortwars/gamemode/player.lua:11: attempt to index local 'Database' (a boolean value)

  1. unknown - gamemodes/fortwars/gamemode/player.lua:11

[/QUOTE]

First result is a boolean telling you if it was successful in connecting, second is the database object

[.0mega]

Thanks for that BigDogMat! All sorted and now linking to the database.