Not sure if anyone has done this before but here’s something I came up with today.
local Attributes = { "Strength", "Intelligence", "Dexterity", "Stamina" } //setup attributes
sql.Query("CREATE TABLE IF NOT EXISTS AndrewRPG_Attributes('steam' TEXT NOT NULL, '" .. table.concat(Attributes, "' INTEGER NOT NULL, '") .. "' INTEGER NOT NULL, PRIMARY KEY('steam'));") //table Holding Atrribute Levels
Basically you can put whatever you want into the lua table and when the query is run it will populate the sql database, every once in awhile i come up with something useful i like to think =P
Andrew (enjia2000 on steam)
