Help about storing stuff

[Dazee]

I was getting an idea of creating an iron miner job for my local server but I realised how am I going to store the iron in the database or in account data I really have no idea could someone explain me how to create an custom item (element) like getPlayerMoney but for iron so I can call it back to display the amount.

[DiSaMe]

Um... Using variables, tables, element data or whatever other stuff you can find for general purpose data storage, probably?

[Anubhav]

SQL?

  
local ironMined = {} 
local con = dbConnect("sqlite","database.db") 
function createTables() 
dbExec(con,"CREATE TABLE IF NOT EXISTS ironMined(accName,ironMined)") 
end 
function doIronMine() 
....After finishing iron mining..... 
local iron = howMuchIronYouMined? 
local player = getPlayerAccount( source ) 
dbExec(con,"INSERT INTRO ironMined accName=? ironMined", player, iron) 
end 
function createSavedData(prevAccount,currectAccount,autologin) 
local query = dbQuery(con,"SELECT * FROM con WHERE accName=?",currentAccount) 
local poll = dbPoll(query,-1) 
if not poll then 
return end 
if poll and query then 
local answer = poll[1] 
setElementData( source, "jobs.ironMined", tostring(answer)) 
   end 
end 
addEventHandler("onPlayerLogin", root, createSavedData)