[John_Michael]

Hey all,

Does anyone have any plans to release a MySQL plugin for LU? I would really like this as I have a gamemode planned that requires MySQL. I suppose I could work around it, but having MySQL functions ready would be a lot easier (and more efficient).

Thanks in advance.

[SugarD]

I know there's a SQLite plugin available IIRC, but it would be nice to see this too. Some people with complicated gamemodes that wish to link them to websites would probably enjoy this as well.

[John_Michael]

Well, my plan is to have a shared accounts and ban database across the III, VC, SA, and IV servers running my gamemode, which is why this is important. It can wait tho, still need to work on the basics.

[SugarD]

Very nice!

For my server, we had a similar plan for some of our servers in our community, but I was told it was possible through sockets to link the databases, so worst case you could probably use a similar idea, but I agree that MySQL would probably be much easier for your scenario.

Hopefully someone will pop in here later and help you out. Best of luck to you! Don't give up when things get tough!

[stormeus]

Juppi has a MySQL module he never formally released.

Linux
Windows
Source

I've never tested it myself. Try it at your own risk, IMO, unless Juppi drops in here.

[John_Michael]

I'll play with it a bit later on, nothing too serious until Juppi shows up with a list of functions / directions or something. Thanks!

@SugarD - Another thing I've planned is to synchronize chat from all servers into one IRC channel. I noticed that there are sockets available - should I use these, or is there a hidden IRC module for LU laying around as well?

[Thijn]

I use Juppi's module (As he sort-of wrote it for me) on 2 of my servers and only noticed one annoying bug:
If you query your table and it you need multiple rows it only returns one row, and then it returns empty tables.
Juppi has looked into this for a small time and don't know how to fix it.
If anyone has some knowledge about the mysql api feel free to fix it!

And yes, There is a hidden IRC module as well, Prod vrocker for it. He was talking about releasing it anyways

[Vortrex]

I tried to use this plugin, but it doesn't let me connect to the MySQL server.

It has an error when trying to connect that says something about not being able to load userdata or something

Also, yes, the module was added to the script with LoadModule("lu_mysql");

[SugarD]

I tried to use this plugin, but it doesn't let me connect to the MySQL server.

It has an error when trying to connect that says something about not being able to load userdata or something

Also, yes, the module was added to the script with LoadModule("lu_mysql");

I remember on the server I'm helping to develop, Stormeus ran across that issue with SQLite too. I think it's a script or database error, if I remember correctly, although I'm not sure how he fixed it.

[Thijn]

I tried to use this plugin, but it doesn't let me connect to the MySQL server.

It has an error when trying to connect that says something about not being able to load userdata or something

Also, yes, the module was added to the script with LoadModule("lu_mysql");

Try compiling the module on the server machine. That worked for me.
Your errors basically means it failed to load the module.
You could also try print( LoadModule("lu_mysql") ); to see if that returns false.

[Vortrex]

How would I compile this in Ubuntu Linux (Server Edition)

[Vortrex]

Sorry for the double post, but I couldn't find an "Edit" button anywhere ... I tried the print() to see if it loaded, and it returns 'true', so I know its loading ... Connecting to the database is the problem ... what are the parameters for mysql_connect?

[John_Michael]

Browsing the source code, I see:

Code: [Select]

_SQUIRRELDEF( SQ_mysql_connect )
{
        const SQChar* szServer = NULL;
        const SQChar* szUser = NULL;
        const SQChar* szPass = NULL;
        const SQChar* szDatabase = NULL;

I'm gussing its database <- mysql_connect(server, user, pass, database[, port]);

[Vortrex]

Yeah, I tried that, with and without the port, but I keep getting the

AN ERROR HAS OCCURED [getVarInfo: Could not retrieve UserData]

The line number in the console points to the line where it tries to connect with mysql_connect

[Thijn]

Are you using any variables in your connect statement? That could be the problem.
And you can compile it by downloading the source code to your machine and use the command "make" in the lu_mysql folder.