SQL Error: 21 about source-x HOT 7 CLOSED

That's indeed weird, it worked at the time, might have been broken by a sqlite update? I'll look into it

from source-x.

That's indeed weird, it worked at the time, might have been broken by a sqlite update? I'll look into it

Is there any recent commit for sqlite with older artifact that I could test to confirm?

from source-x.

It kind of works If u use the function from console, but this way, im not able to run it from players or from ingame to change their progres or so. Dont know if its intended or not, or im doing something wrong.

from source-x.

https://www.sqlite.org/rescode.html

ldb.execute "INSERT OR REPLACE INTO '<def.DTL_DB_Table>' ('defname','class','race','sex','expansion','flags') VALUES("<local.defname>","<local.c>","<local.r>","<dlocal.sid>","<dlocal.e>","<dlocal.f>")";

insert, replace, update, delete these are executes. not query.

Also, what is the table structure and data types of columns?

from source-x.

This is for the dynamictemplates, the thing is, it was working using the function as GM char from game, now it works only through console.
But If I want to use other DB or tables for players, I just cant write from ingame.

This one is im trying to use, once player activates function doesnt matter how, it writes into DB.

I honestly tried many different ways, execute or query, both have same result. The ldb.query line is from X scriptpack.

from source-x.

Is it possible that somehow using it from game, not from server console, there are some permissions missing?

from source-x.

Well magicaly I found the correct syntax, so i guess syntax was a problem. Im pretty sure I 100% tried it like this and it didnt work. Closing the issue.

ldb.execute INSERT INTO 'Progres' ('name','fame') VALUES ("<src.name>",<src.fame>)

from source-x.