Lua Query Other DB

[HeberPcL]

Guys, I have this little problem. I would run a query that is on an external server.
Does anyone have any idea how I can do it in LUA?

	$host="myip.com"; //source
	$user="root";
	$password="pass";
	$db="mydbname";

[B]$ots->connect(POT::DB_MYSQL, array('host' => $host, 'user' => $user, 'password' => $password, 'database' => $db));[/B]

Example:

db.query("UPDATE ...;", "host","user","password","database")

Thanks!

 

[TGYoshi]

You can not do this directly via the TFS stuff. You'd have to establish a new mysql connection which is currently source sided.

 

[SpiderOT]

Using Luasocket you can fetch a webpage (and thus triggering your php page) with socket.http.request(url).
you can read more about Luasocket here

 

[HeberPcL]

TGYoshi & SpiderOt,
thanks.

Edit source solution.