mysql+DCDM

[Alexandros]

how do you use mysql with DCDM? I have a mysql server, what can i store in the DB? how? (i want for example store nick,IP,client,version)
thanks

Alex

[plop]

Originally posted by Alexandros
how do you use mysql with DCDM? I have a mysql server, what can i store in the DB? how? (i want for example store nick,IP,client,version)
thanks

Alex

dcdm is based on bcdc, which doesn't have sql support.
but rabitwombat has made a mod of bcdc on which he added sql support.
you can find it on my site.

plop

[Alexandros]

but DCDM has luasql_20b_MySQL_41.dll, that dont give it MySQL support?
if not i try with the other one...what can i do with this and MuSQL, what can i store there?

thanks

[Herodes]

if you dont know y you need a database then y try using one ?

"I need an apple but what do i need it for ?"

[Alexandros]

i want to know how to use, and what can i do with it, i want to store nick, IP, sharing for example, how can i do that? im not saying "make something for me :P" i want to test some things :)
sorry about my english

[Herodes]

you'll need to setup a table in mySQL ...

CREATE TABLE some_table (

nick varchar(35) not null,

ip_num varchar(15) not null

);

what is above is following the syntax found in the mysql manual available from the mysql website ...

then there are many ways to get and store values to and from the db ...  look in the mysql manual and also look at some sql scripts usually found in php packages ( sourceforge.net is a good place to search for those )

Later use the bcdc mod from RambitWombat to actually be able to interact with the db ..

[TecMaster]

This link might help you
http://www.keplerproject.org/luasql/manual.html#environment_object

It's the only help I used to get my "dcdm - mysql" to work togehter and it works fine.

You can also download MySQL Administrator to setup initial tables and backup your db ...
MySQL Query browser is nice to used when debugging and even after debugging is finished... a bit unstable due ...