You are using two different paths:
local rootNote = xmlLoadFile(":Data/Data.xml") --to load it once
if not rootNode then
rootNode = xmlCreateFile("Data.xml", "Data")
outputChatBox("File created !", source)
end
1º path: ":Data/Data.xml"
2º path: "Data.xml"
function setSQLData ( element, row, data )
local db = executeSQLQuery ( "SELECT * FROM ?? WHERE name = ?", "db", getPlayerName ( element ) )
if ( db and #db == 1 ) then
executeSQLQuery ( "UPDATE db SET ?? = ? WHERE name = ?", row, data, getPlayerName ( element ) )
else
executeSQLQuery ( "INSERT INTO db ( '"..row.."' ) VALUES ( ? )", data, getPlayerName ( element ) )
end
end
Try it.