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!

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

Addon skript-db 0.1.1

Sensible SQL support for Skript

  1. Uzumaki

    Uzumaki Well-Known Member

    Feb 20, 2017
    Likes Received:
    how i can create a sqlite database?, thanks
  2. T

    Tai1er Member

    Jan 30, 2017
    Likes Received:
    All my local variables are deleted when I execute a query.

    Code (Text):
    1. command /test:
    2.     trigger:
    3.         join(player)
    4. function join(p: player):
    5.     broadcast "%{_p}%"
    6.     set {_uuid} to {_p}'s UUID
    7.     execute "SELECT id FROM Players WHERE uuid = %{_uuid}%" in {sql} and store the result in {_players::*}
    8.     broadcast last sql error
    9.     broadcast "%{_p}%"
    The first broadcast shows the username, the second shows nothing since it's an empty string because there is no errors and the last shows <none>

    When I try to execute this query in unsafe mode, the {_uuid} variable has already been deleted before the execution of the query which results in a syntax error near '<none>'.

    It's not the first time I get this type of problem with Skript-db.