[Skellet] getting specific MySQL value

[FleecyTeddy]

Hey
I'm currently working on a settings menu for my bungeecord server. All (important) values are stored on a mysql server. So, I need my script to connect to the mysql server (which works) and get the values, I will need for my script to work (which is not working as I expected)... So, here's what I got already:

on script load:
    connect to mysql
   
command /test:  
    trigger:
        set {_test} to mysql result of query "SELECT player_id FROM fr_players WHERE player_name=""{_player}%"" limit 1"
        broadcast "%{_test}%"

But it's just giving me something like com.mysql.jdbc.JDBC4ResultSet@22e847b0...

Here's the structure of the table:

%YAML 1.1
---
# serpix.fr_players
- #First column. I need the player_id value, which I tried to get by searching the player_name first.
  player_id: 1
  player_name: "FleecyTeddy"
  player_uuid: "66cf7490-9090-4af4-8035-bf35078269df"
  last_online: "2017-08-06 15:47:32"
...

 

[Deleted member 5254]

Hey
I'm currently working on a settings menu for my bungeecord server. All (important) values are stored on a mysql server. So, I need my script to connect to the mysql server (which works) and get the values, I will need for my script to work (which is not working as I expected)... So, here's what I got already:

on script load:
    connect to mysql
  
command /test: 
    trigger:
        set {_test} to mysql result of query "SELECT player_id FROM fr_players WHERE player_name=""{_player}%"" limit 1"
        broadcast "%{_test}%"

But it's just giving me something like com.mysql.jdbc.JDBC4ResultSet@22e847b0...

Here's the structure of the table:

%YAML 1.1
---
# serpix.fr_players
- #First column. I need the player_id value, which I tried to get by searching the player_name first.
  player_id: 1
  player_name: "FleecyTeddy"
  player_uuid: "66cf7490-9090-4af4-8035-bf35078269df"
  last_online: "2017-08-06 15:47:32"
...

Perhaps you can find the expressions you need here

 

[Deleted member 5254]

Hey
I'm currently working on a settings menu for my bungeecord server. All (important) values are stored on a mysql server. So, I need my script to connect to the mysql server (which works) and get the values, I will need for my script to work (which is not working as I expected)... So, here's what I got already:

on script load:
    connect to mysql
  
command /test: 
    trigger:
        set {_test} to mysql result of query "SELECT player_id FROM fr_players WHERE player_name=""{_player}%"" limit 1"
        broadcast "%{_test}%"

But it's just giving me something like com.mysql.jdbc.JDBC4ResultSet@22e847b0...

Here's the structure of the table:

%YAML 1.1
---
# serpix.fr_players
- #First column. I need the player_id value, which I tried to get by searching the player_name first.
  player_id: 1
  player_name: "FleecyTeddy"
  player_uuid: "66cf7490-9090-4af4-8035-bf35078269df"
  last_online: "2017-08-06 15:47:32"
...

Two words, sql injection