Author Topic: LUA5 connect and write to mysql dbase  (Read 2651 times)

0 Members and 1 Guest are viewing this topic.

Offline Stanton

  • Newbie
  • *
  • Posts: 1
  • Karma: +0/-0
LUA5 connect and write to mysql dbase
« on: 20 July, 2005, 22:40:58 »
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.

PtokaX forum

LUA5 connect and write to mysql dbase
« on: 20 July, 2005, 22:40:58 »

Offline Ivan Von Girderboot

  • Newbie
  • *
  • Posts: 2
  • Karma: +0/-0
(No subject)
« Reply #1 on: 13 October, 2005, 23:46:18 »
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.

Offline bastya_elvtars

  • Forum God
  • ****
  • Posts: 3 744
  • Karma: +173/-7
  • The rock n' roll doctor
    • The FreshStuff3 Site
(No subject)
« Reply #2 on: 13 October, 2005, 23:54:06 »
Everything could have been anything else and it would have just as much meaning.

Offline Pothead

  • Lord
  • ***
  • Posts: 455
  • Karma: +25/-4
(No subject)
« Reply #3 on: 14 October, 2005, 09:24:32 »
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.
« Last Edit: 14 October, 2005, 09:25:27 by Pothead »

Offline bluebear

  • Double Ace
  • *
  • Posts: 116
  • Karma: +12/-0
  • Life is a bitch - And then you marry one!
(No subject)
« Reply #4 on: 14 October, 2005, 10:08:22 »
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
Sincerely,
bluebear
--
http://www.thewildplace.dk/ is is closed - Use the following mirrors instead
http://bluebear.psycho-chihuahua.net
http://pxextension.piratez.dk/
[Lua extensions - Chat stats - YnHub PMSpy - DC Source code - and more]

Offline bluebear

  • Double Ace
  • *
  • Posts: 116
  • Karma: +12/-0
  • Life is a bitch - And then you marry one!
(No subject)
« Reply #5 on: 14 October, 2005, 19:06:46 »
Sincerely,
bluebear
--
http://www.thewildplace.dk/ is is closed - Use the following mirrors instead
http://bluebear.psycho-chihuahua.net
http://pxextension.piratez.dk/
[Lua extensions - Chat stats - YnHub PMSpy - DC Source code - and more]

PtokaX forum

(No subject)
« Reply #5 on: 14 October, 2005, 19:06:46 »