/*Database is created on world new in another file*/
var/global
database/gq//
const
db="mydata.db"
table="CharPlus"
currency_name="GOLDENRYO"
proc
CheckDB(var/database/query/q)
if(q.Execute(gq))
world<<"worked"
else
return q.ErrorMsg()
mob
verb
MakeTable()
set category="Database"
var/database/query/q=new({"CREATE TABLE [table](
ID INT PRIMARY KEY NOT NULL,
NAME TEXT NOT NULL,
[currency_name] INT
);"})
if(q.Execute(gq))
world<<"worked"
else
world<<q.ErrorMsg()
UpdDB()
set category="Database"
.=rand(5,999)
//var/database/query/w=new({"UPDATE [table] SET [currency_name] = 999 WHERE NAME = [usr.key];"})
var/database/query/w=new({"UPDATE `[table]` SET `[currency_name]` = '999' WHERE `NAME` = '[usr.ckey]';"})
if(w.Execute(gq))
world<<"worked"
else
world<<w.ErrorMsg()
InzDB()
set category="Database"
set name="Insert Player Into DB"
//INSERT INTO [table](NAME) VALUES([usr.key]);
//var/database/query/q=new({"INSERT INTO [table]([usr.key]) VALUES(NAME);"})
var/database/query/q=new({"INSERT INTO [table] (`NAME`) VALUES ('[usr.ckey]');"})
if(q.Execute(gq))
world<<"worked"
else
world<<q.ErrorMsg()
GrabDB()
set category="Database"
var/database/query/f=new({"SELECT `[currency_name]` FROM `[table]` WHERE `NAME`= '[usr.ckey]';"})
if(f.Execute(gq))
var/list/ex=f.GetRowData()
var/amount=text2num(ex["[currency_name]"])
for(var/i in ex)
world<<"worked grabbed [i] : [amount]"
else
world<<f.ErrorMsg()
GrabAllInfo()
set category="Database"
var/database/query/f=new({"SELECT * FROM `[table]` WHERE `NAME`= '[usr.ckey]';"})
if(f.Execute(gq))
var/list/ex=f.GetRowData()
//var/amount=text2num(ex["[currency_name]"])
for(var/i in ex)
world<<"worked grabbed [i] : [ex[i]]"
else
world<<f.ErrorMsg()
Problem description:
Can't seem to get the Update or Insert Queries to work. Any ideas on what I'm missing or messing up? This is the file pertaining to database work in it's entirety.
Note: I'm trying to use SQLite to utilize the database features of BYOND, do I still need to include the libmysql.dll? that's the only thing I haven't tried
I.e.
I'd suggested changing so it becomes: