Loading a variable in SQL without repeating query

  • 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!

  • LOOKING FOR A VERSION OF SKRIPT?

    You can always check out skUnity Downloads for downloads and any other information about Skript!

Status
Not open for further replies.

ZuOnline

New Member
Oct 11, 2018
7
1
0
31
Skript Version: 2.2-dev31c
Skript Author: Me
Minecraft Version: 1.11.2
---
Full Code:

code_language.skript:
        set {_woodinfo13} to mysql result of query "SELECT * FROM player_jobs WHERE player = ""%player%"""
        set {_arraysearch::*} to mysql string "talent1" in {_woodinfo}
        set {_talent1} to {_arraysearch::1} parsed as integer
        set {_arraysearch::*} to mysql string "talent2" in {_woodinfo}
        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!
 
Status
Not open for further replies.