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.

Loading a variable in SQL without repeating query

Discussion in 'Skript' started by ZuOnline, Oct 13, 2018.

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

    ZuOnline Member

    Joined:
    Oct 11, 2018
    Messages:
    7
    Likes Received:
    1
    Skript Version: 2.2-dev31c
    Skript Author: Me
    Minecraft Version: 1.11.2
    ---
    Full Code:

    Code (Skript):
    1.         set {_woodinfo13} to mysql result of query "SELECT * FROM player_jobs WHERE player = ""%player%"""
    2.         set {_arraysearch::*} to mysql string "talent1" in {_woodinfo}
    3.         set {_talent1} to {_arraysearch::1} parsed as integer
    4.         set {_arraysearch::*} to mysql string "talent2" in {_woodinfo}
    5.         set {_talent2} to {_arraysearch::1} parsed as integer
    Note: If the code is too large, feel free to use a pasting website (Pastebin or hastebin)


    Addons using:
    Skellet

    Have you tried searching the docs? Yes
    Have you tried searching the forums? Yes
    What other methods have you tried to fix it? None


    Hi guys, this isn't working for me, i don't know why {_arraysearch::*} can load {_woodinfo13} info and then it can't, i want to load 13 variables for a query without repeating the same query, is that possible? Thank you in advice!
     
Thread Status:
Not open for further replies.
Loading...