Hi,

I have some problems with variables in query.
When I try this,
"execute "INSERT INTO Coordonnees (`id`,`region`) VALUES ('%{_x}%', 1)" in {sql}"

I receive this mysql error:
"Parameter index out of range (1 > number of parameters, which is 0)."

It works normaly without %{_x}% in the query.

 

Thanks for your fast answer.

The async expression from MundoSK changes anythink.
The expression "execute" is like a "wait" for Skript.

 

There isn't really much you can do about this. The only workaround is using skquery functions which *are* compatible with async effects. I have used this a lot with reqn. They kinda suck, and skQuery shouldn't really be used anymore but at least it works. Another thing you can do is use mundosk custom events as functions and communicate the data through variables that you can grab with skript-mirror.

 

Hello, I'm switching from skellett's mysql to this and I ran into an issue

Code (Skript):

1. command /mysqltest:
2.     trigger:
3.         execute "INSERT INTO data (`uuid`, `displayname`, `username`, `first login`, `last login`) VALUES (%uuid of player%, %display name of player%, %name of player%, %year from date now%-%month from date now%-%day of month from date now% %hours from date now%:%minutes from date now%:00, %year from date now%-%month from date now%-%day of month from date now% %hours from date now%:%minutes from date now%:00)" in {x_sql}

and this is my table setup, using skellett syntax but just to show the data types

Code (Skript):

1. mysql update "CREATE TABLE IF NOT EXISTS `data` (`uuid` varchar(255), `displayname` varchar(255), `username` varchar(255), `first login` DATETIME, `last login` DATETIME)"

So when I ran that command there would not be any changes in the database and I figured maybe it was something within the date formatting since its so long that some character in there might be screwing with the syntax or something so I shortened it to the following and it worked:

Code (Skript):

1.  
2. execute "INSERT INTO data (`uuid`, `displayname`, `username`) VALUES (%uuid of player%, %display name of player%, %name of player%)" in {x_sql}

So basically my question is do you know why it doesn't work with the first code? I don't get any errors or anything it just doesn't insert any data in


And this is what the database looks like, the first row is an input from a while ago using skellett's syntax and the second row is my shortened version of the code using skript-db

 

I don't know the issue however the date formatting would be much better stored as epoch time

 

good idea, I'll probably switch to that, thanks!

Ah i see, thanks for the info and quick reply!

 

please add to `todo` list

Spoiler: skript

Code (Skript):

1. command sql:
2.     trigger:
3.         execute "select `default` from `sql-database`" in {sql} and store result in {_test::*}
4.         broadcast "test:%{_test::default::*}%"
5.  
6.         set {_arg} to "default"
7.         execute "select %{_arg}% from `sql-database`" in {sql} and store result in {_test_arg::*}
8.         broadcast "test_arg:%{_test_arg::%{_arg}%::*}%"

Spoiler: in console

Code (Skript):

1. [INFO]: test:data and store
2. [INFO]: test_arg:data, data and data

ps this is bug report)

 

what information about the database do you need?

 

I keep getting "Too many connections" error after some time (like when executing 5 insert - operations in a row). And my max-connections in mysql is set to 100. Are you closing them correctly?

https://hastebin.com/upiviyifab.swift

 

What information do you need?

 

So there is the script that causes this error when you enter the command ~7 times in a row:

Code (Skript):

1. options:
2.     database: yourdatabase
3.     user: youruser
4.     password: yourpassword
5.  
6. command /mysqlinsertcode:
7.     trigger:
8.         set {_code} to "test"
9.         set {_sql} to the database "mysql://localhost:3306/{@database}?user={@user}&password={@password}&useSSL=false"
10.         execute "INSERT INTO yourtable (`username`, `uuid`, `code`) VALUES (%name of player%, %uuid of player%, %{_code}%)" in {_sql}

Database: Server-Version: 10.1.26-MariaDB - mariadb.org binary distribution
Skript: latest bensku skript release
Server: PaperSpigot (latest 1.12.2)

 

I wonder if this is a MariaDB specific issue. There is a JDBC driver for MariaDB.

 

Hey is there any way to run sql code under a return function? Basically I have a bank system and I'd like to have a function that would return the player's bank balance and then I would just run the function under async, the code below is what I'm talking about

Code (Skript):

1. function checkbankbalance(p: player) :: number:
2.     async:
3.         execute "select * from BankData where uuid = %{_p}'s uuid%" in {x_sql} and store the result in {_result::*}
4.     if {_result::balance::*} is not set:
5.         return 0
6.     else:
7.         set {_balance} to "%{_result::balance::*}%" parsed as number
8.         return {_balance}
9. command /bankbalance:
10.     trigger:
11.         async:
12.             set {_balance} to checkbankbalance(player)
13.         send "&aBank: &c$%{_balance}%" to player

At the moment the code doesn't work I get the skript error: "A return statement after a delay is useless, as the calling trigger will resume when the delay starts..."