SkQuery MySQL question

[dudle]

So I have this:
When I perform a command, it syncs the stats I have with the mysql database, but it ain't working. I have the code over here, what's the issue though?:

loop all players:
    update "UPDATE `Stats` SET `Stats`.`Deaths` = `Deaths`+%{deaths.%loop-player%}% WHERE `Deaths` = '%loop-player%'"

on death:
    attacker is player
    victim is player
    add 1 to {deaths.%victim%}

 

[ShaneBee]

@HiiqhFive , please help with MySQL
TY

 

[ShaneBee]

Could you post the full script, also what is your server version and skript version?

 

[ShaneBee]

Could you post the full script, also what is your server version and skript version?

Srv version: Spigot 1.7.10; Skript: 2.2
This one is pretty much the script where I'm having trouble, other script things are not related to my problem.

 

[ShaneBee]

Srv version: Spigot 1.7.10; Skript: 2.2
This one is pretty much the script where I'm having trouble, other script things are not related to my problem.

And you've got an SQL Connection established?

 

[ShaneBee]

And you've got an SQL Connection established?

Yes, other plugins successfully connect to the database, create tables, update them etc.

 

[ShaneBee]

Yes, other plugins successfully connect to the database, create tables, update them etc.

Why are you checking the column `deaths` for a username if it is an integer? You'll need a separate column to store usernames in

 

[ShaneBee]

Why are you checking the column `deaths` for a username if it is an integer?

Hahah, Idek I didn't really understand the pattern I should use so if you could tell me the correct one that'd be great

 

[ShaneBee]

Okay well firstly, never use . in Column names, keep them one word.

At the top of your script, you'll want:

script options:
    $ init com.mysql.jdbc.Driver
    $ db url jdbc:mysql://host:port/Database?autoReconnect=true
    $ db username Username
    $ db password Password

You'll also need to make the table:

on load:
    update "CREATE TABLE IF NOT EXISTS Stats(uuid varchar(100), deaths int)"

Make sure to create a new row for each player who joins:

on first join:
    update "INSERT INTO `Stats` (`uuid`, `deaths`) VALUES ('%uuid of player%', '0')"

As you're syncing the stats by command, you might as well just set the field to the {deaths.%player%} variable (Would highly recommend using UUID's for this to make sure a player, if they change their name, still keeps their data: {deaths.%uuid of victim%})

on death: #Try using 'on death of player' if you wish
    if attacker is player:
        if victim is player:
            add 1 to {deaths.%uuid of victim%}

As for the command:

Command /syncstats:
    Trigger:
        Loop all players:
            $ thread
            update "UPDATE `Stats` SET `Deaths` = '%{deaths.%uuid of loop-player%}%' WHERE `uuid` = '%uuid of loop-player%'"
// Make sure that you have at least two columns in your table, uuid(VARCHAR(100)) and deaths(int)

This should do the trick, untested though

 

[ShaneBee]

// Make sure that you have at least two columns in your table, uuid(VARCHAR(100)) and deaths(int)

On script load:
update "CREATE TABLE IF NOT EXISTS `Stats` (`uuid` VARCHAR(100), `deaths`(int))"
this?

 

[ShaneBee]

On script load:
update "CREATE TABLE IF NOT EXISTS `Stats` (`uuid` VARCHAR(100), `deaths`(int))"
this?

Looks good c:

 

[ShaneBee]

It says this:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '[MYDBNAME].Stats' doesn't exist

edit: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(int))' at line 1

 

[ShaneBee]

Your SQL Syntax is invalid.
You want to update "Deaths" declared as an integer, but in your WHERE Condition your asking a text instead of the integer. So SQL doesn't update because it does not find any data.

 

[ShaneBee]

Your SQL Syntax is invalid.
You want to update "Deaths" declared as an integer, but in your WHERE Condition your asking a text instead of the integer. So SQL doesn't update because it does not find any data.

Not sure what you mean, it's setting the deaths column (int) where the uuid column(VARCHAR) is the loop-player's uuid

EDIT: Never mind, you were answering the original post. We've already sorted that issue.

It says this:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table '[MYDBNAME].Stats' doesn't exist

edit: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '(int))' at line 1

Try this:

update "CREATE TABLE IF NOT EXISTS Stats(uuid varchar(100), deaths int)"

 

[ShaneBee]

Ah, rip
Try this.

On script load:
Update "CREATE TABLE IF NOT EXIST `stats` (`uuid` varchar(255), `deaths` int(11))"

 

[ShaneBee]

update "CREATE TABLE IF NOT EXISTS Stats(uuid varchar(100), deaths int)"

This one creates the table. but when I use the command it doesn't do anything..

 

[ShaneBee]

This one creates the table. but when I use the command it doesn't do anything..

Any errors or does nothing happen at all?

 

[ShaneBee]

Any errors or does nothing happen at all?

Nothing happens at all ;-;

 

[ShaneBee]

Nothing happens at all ;-;

on first join:
    update "INSERT INTO `Stats` (`uuid`, `deaths`) VALUES ('%uuid of player%', '0')"

Add this to your script, you need to create a row for each player before you can update it.

 

[ShaneBee]

on first join:
    update "INSERT INTO `Stats` (`uuid`, `deaths`) VALUES ('%uuid of player%', '0')"

Add this to your script, you need to create a row for each player before you can update it.

Works perfectly! Thanks a lot man!