skript-db issue with variables

[mbgl]

Hey, I have an issue with Minecraft Skript and skript-db.

Addons: skript-db, TuSKe, skRayFall (maybe unimportant)
Version:
Server: 1.12.2
Skript: 1.6.4
Server Software: Mohist

When i want to pharse an variable in an sql execute statement, it is not working.

Example:

WORKING:
command /test:
trigger:
set {_p} to player
execute unsafe "SELECT u.rank FROM users u WHERE player = '%player%' ;" in {-sql} and store the result in {_s::*}
broadcast "test %{_s::rank::1}%"

NOT WORKING:
command /test2:
trigger:
set {_p} to player
execute unsafe "SELECT u.rank FROM users u WHERE player = '%{_p}%' ;" in {-sql} and store the result in {_s::*}
broadcast "test %{_s::rank::1}%"

Things like following are also not working:
execute unsafe "SELECT u.rank FROM users u WHERE player = %{_p}% ;" in {-sql} and store the result in {_s::*}
execute unsafe "SELECT u.rank FROM users u WHERE player = '{_p}' ;" in {-sql} and store the result in {_s::*}
execute unsafe "SELECT u.rank FROM users u WHERE player = {_p} ;" in {-sql} and store the result in {_s::*}
execute unsafe "SELECT u.rank FROM users u WHERE player = '" and {_p} and "' ;" in {-sql} and store the result in {_s::*}
execute unsafe "SELECT u.rank FROM users u WHERE player = '" + {_p} + "' ;" in {-sql} and store the result in {_s::*}

Thanks in forward for helping!

 

[mbgl]

So i actually got a solution, i'm not happy with it, but it is working.

function getRank(p: player) :: text:
    set {p} to {_p}
    execute unsafe "SELECT u.rank FROM users u WHERE player like '%{p}%' ;" in {-sql} and store the result in {_s::*}
    wait 1 tick
    return "%{_s::rank::1}%"

So the problem was, that the {_p} inside wasn't converted and it sends litterlary as %{_p}% to the Database.

I think it is because the server "waits" until the action is finished, so it clears the {_p}, with a permanent variable {p} it works.

I'm looking for another solution, but i'm unsure if there is a better.