I don't understand why are you doing all this:
local start = 0
for i,v in ipairs(tables) do
start = start+1
for column, value in pairs(v) do
loadUpTable[start] = value
end
end
It doesn't really make any sense to me, try my code above.
local loadUpTable = { }
function LoadUpOnResourceStart ( resource )
local dbqery = dbQuery ( Database, "SELECT name FROM sqlite_master WHERE type='table'" )
local tables = dbPoll ( dbqery, -1 )
outputChatBox ( "#6969C9*AS: Restoring ".. #tables .." records from sqlite.", root, 255, 255, 255, true )
for index, tbl in ipairs ( tables ) do
loadUpTable [ index ] = tbl.name
end
for _, v in ipairs ( loadUpTable ) do
local Query = dbQuery ( Database, "SELECT * FROM ".. v )
local result = dbPoll ( Query, -1 )
outputChatBox ( #result )
for i, v in pairs ( result ) do
outputChatBox ( v )
for col, val in ipairs ( v ) do
outputChatBox ( val )
end
end
end
end
addEventHandler ( "onResourceStart", resourceRoot, LoadUpOnResourceStart )