Hey guys, complete n00b here, please bear with me.
Ive been searching this forum for hours but cant seem to find the right information, im under the impression that LUA5 supports connections to mysql dbases? can anyone please point me to any information about this?
Im not looking to be spoon fed, and am more than willing to read up on the necessary info and learn what i need, but i am in need of a push in the right direction, lol.
What im looking at doing is writing a script that will sit in a hub and look for any kick/bans, and if so, write the information (user, date/time, reason) to the dbase for our mods to review.
Any help, guidance, information gladly received :)
contact info in profile.
Many Thanks
Stanton.
To my knoledge, LUA5 does not support MySQL or any ODBC Drivers.
There are ways around it, but it's not simple. For instance, my chat all gets logged to a MySQL db, via a sql file that gets imported into MySQL via a command line.
LuaSQL?
http://www.keplerproject.org/luasql/
BlueBear has recently posted a link to a Sqlite interface for PtokaX Lua. So i suggest you use that.
Or compile MySql including PXLua.lib and a LUA wrapper class.
Yes, PxSQLite3 can be used.
I'm also looking into builing some Lua wrapper for MySQL. It will probably be LuaSQL.
I will create a thread, in "LUA & PtokaX-Scripting-Interface" wich you peeps can use to request extensions for ptokax.
The thread http://board.univ-angers.fr/thread.php?threadid=5448&boardid=5&styleid=1&page=1#1 (http://board.univ-angers.fr/thread.php?threadid=5448&boardid=5&styleid=1&page=1#1)
MySQL access for Ptokax Lua is here now: http://board.univ-angers.fr/thread.php?threadid=5451&boardid=5&styleid=1 (http://board.univ-angers.fr/thread.php?threadid=5451&boardid=5&styleid=1)