Solved Any working skript-database addon for 2.8?

[L0v0lup]

Good morning,

i am having quite some trouble getting Skript 2.8 to run. Currently, all major skript-db plugins are outdated. Event the more recent ones such as the one from "Govindas".
Has anyone found a solution or is there a "Patch-Agent" for 2.8 out? Can't find a way to get it to run and all the database addons seem to be dead :/

 

[lotzy]

if Skript-db doesn't work, use Skcrew, it has same syntax as skript-db, but without auto-parsing 'unsafe values'
Docs

 

[L0v0lup]

Oh thank you, that seems to be working.. kind of.
Can i just add one question?
I am using this syntax: sync execute "SELECT * FROM `Settings` WHERE UUID =%uuid of {_p}%" in {DB.sql} and store result in {_Settings::*}.
That worked well on skript-db but doesn't work on SkCrew. According to docs it's correct.
Console tells me "Unknown column 'cc5be6de' in 'where clause'". (So it splits the UUID at the " - " an therefore can't find the UUID :/)

Can you give me a sample prompt?

 

[BaeFell]

Oh thank you, that seems to be working.. kind of.
Can i just add one question?
I am using this syntax: sync execute "SELECT * FROM `Settings` WHERE UUID =%uuid of {_p}%" in {DB.sql} and store result in {_Settings::*}.
That worked well on skript-db but doesn't work on SkCrew. According to docs it's correct.
Console tells me "Unknown column 'cc5be6de' in 'where clause'". (So it splits the UUID at the " - " an therefore can't find the UUID :/)

Can you give me a sample prompt?

You need to do '%uuid of {_p}%' as it's a string

 

[lotzy]

agree with BaeFell.
As I wrote above, there is no automatic conversion of data types in queries; you must do it yourself. Conventionally, this is how to use the expression 'unsafe %expr%' in Skript-db. In general, use this the same way you would use it in other programming languages when querying relational databases

 

[L0v0lup]

Oh, Baefell, the legend itself.
Thank you. That was the cause for the problem