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.

 

[ShaneBee]

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%}

 

[ShaneBee]

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

 

[ShaneBee]

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..

 

[ShaneBee]

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?

 

[ShaneBee]

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.

 

[ShaneBee]

Ok! Thank you for yor answer!