1. Welcome to skUnity!

    Welcome to skUnity! This is a forum where members of the Skript community can communicate and interact. Skript Resource Creators can post their Resources for all to see and use.

    If you haven't done so already, feel free to join our official Discord server to expand your level of interaction with the comminuty!

    Now, what are you waiting for? Join the community now!

  2. LOOKING FOR A VERSION OF SKRIPT??:

    You can always check our our Wiki for downloads and any other information about Skript!

Dismiss Notice
This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Solved [MYSQL] Selecting and returning a value from a column.

Discussion in 'Skript' started by lucasmooon, Feb 26, 2018.

Thread Status:
Not open for further replies.
  1. lucasmooon

    lucasmooon Member

    Joined:
    Feb 4, 2017
    Messages:
    16
    Likes Received:
    0
    Solved.

    Good evening.

    I'm trying to return a value from a column, but all I get is the name of the column.

    What I want to do is: I have a database called api, with the table players with a column call "logged". It will be a boolean, true/false. This is a way I can check if the player is logged on the server or not.

    [​IMG]

    The code is:

    Code (Skript):
    1. on load:
    2.     set {sql} to the database "mysql:.."
    3.  
    4. command /dbtest:
    5.     trigger:
    6.         execute "SELECT logado FROM jogadores" in {sql} and store the result in {_output::*}
    7.         broadcast "%{_output::*}%"
    Is there anything I'm not getting right?

    Skript version: 2.2
    Using skript-db

    Thank you.
     
Thread Status:
Not open for further replies.
Loading...