Solved MySql question, how to

[FilipeNock]

I wanted to know how to use mysql in skript, for example: send the variable {kills.% Player%} to the database. This for some should be a stupid question, but I mess with skripts at one time but never tried using mysql.

Thx for the help.

 

[Deleted member 5254]

You need to install SQLibrary and setup the config in config.sk.

An example of a config.sk

    MySQL:
        type: MySQL
        pattern: db_.*
        host: host
        port: port
        user: user
        password: password
        database: database
        monitor changes: true
        monitor interval: 20 seconds

Since "pattern" is set to "db_.*" for me, to send a variable you would need to do:

on death of a player:
    attacker is a player
    add 1 to {db_.kills::%attacker%}

 

[Deleted member 5254]

SQlibrary has not been updated since 2014. Is it still relevant?
What do you preconize between CSV and MySQL?

 

[Deleted member 5254]

SQlibrary has not been updated since 2014. Is it still relevant?
What do you preconize between CSV and MySQL?

I am using last skript version, and is working..

 

[Deleted member 5254]

and is working

Sure! I never said it does not work. But, will it be usefull in the long term...I don't know.

Can you say me if you think it's faster than CSV file access?

 

[Deleted member 5254]

Sure! I never said it does not work. But, will it be usefull in the long term...I don't know.

Can you say me if you think it's faster than CSV file access?

Yehp SqLite and MySql, it much faster than normal.

 

[Deleted member 5254]

Ok! Thank you for yor answer!