Good evening, dear comunity,
I would like to use Skquery's database feature to store Deats, Kills and K/D of the player in my games, I've programmed.
I'm using this:
But is there a way to select only the first line in those list variables ?
Besause in Minecraft im getting this:
And I want to have only on number wich should be displayed
Some details:
Skript Version: v2.2
Minecraft Version: 1.8.8
I'm using the following skript addons:
- MundoSK v1.7.4
- WildSkript v.8
- SkQuery v3.21.4
- SkRayFall v1.7.1
I would like to use Skquery's database feature to store Deats, Kills and K/D of the player in my games, I've programmed.
I'm using this:
Code:
set {player.%player%::*} to objects in column "Player" from result of query "SELECT * FROM {@table} WHERE Player = '%player%'" and close
set {deaths.%player%::*} to objects in column "Deaths" from result of query "SELECT * FROM {@table} WHERE Deaths = '%{skypvp.deaths.%uuid of player%}%'" and close
set {kills.%player%::*} to objects in column "Kills" from result of query "SELECT * FROM {@table} WHERE Kills = '%{skypvp.kills.%uuid of player%}%'" and close
set {kd.%player%::*} to objects in column "KD" from result of query "SELECT * FROM {@table} WHERE KD = '%{skypvp.kd.%uuid of player%}%'" and close
But is there a way to select only the first line in those list variables ?
Besause in Minecraft im getting this:
Code:
SQL Stats
Name: Player
Kills: Kills
Deaths: 0 and 0
K/D: 0 and 0
And I want to have only on number wich should be displayed
Some details:
Skript Version: v2.2
Minecraft Version: 1.8.8
I'm using the following skript addons:
- MundoSK v1.7.4
- WildSkript v.8
- SkQuery v3.21.4
- SkRayFall v1.7.1
Last edited: