when apk installed …apps not show text
setting.lua
local sqlite3 = require “sqlite3”
local M = {}
function M.sqlite_db(dbname)
local option = {}
option.dbname = dbname or “setting.db”
local data_path = system.pathForFile(dbname,system.DocumentsDirectory)
M.db = sqlite3.open(data_path)
end
function M.sqlite_create(tbname)
local option = {}
option.tbname = tbname or “setting”
local query = [[CREATE TABLE IF NOT EXISTS]]…tbname…[[(name PRIMARY KEY,value);]]
M.tbname = tbname
M.db:exec(query)
end
function M.sqlite_insert(name,value)
local query = [[INSERT INTO]]…M.tbname…[[(name,value) VALUES (’]]…name…[[’,"]]…value…[[);]]
M.db:exec(query)
end
function M.sqlite_select(name)
local value
local query = [[SELECT * FROM]]…M.tbname…[[WHERE name=’]]…name…[[’]]
for row in M.db:nrows(query) do
value = row.value
end
return value
end
function M.sqlite_delete(name)
local query = [[DELETE FROM]]…M.tbname…[[WHERE name=’]]…name…[[’]]
M.db:exec(query)
end
function M.sqlite_update(name,value)
local query = [[UPDATE]]…M.tbname…[[SET value=’]]…value…[[’ WHERE name=’]]…name…[[’]]
M.db:exec(query)
end
function M.onSystemEvent( event )
if( event.type == “applicationExit” ) then
M.db:close()
end
end
function M.platform_font (win,droid,els)
local platform = system.getInfo(“platformName”)
local font
if (platform == “Win”) then
font = win
elseif (platform == “Android”) then
display.setStatusBar( display.HiddenStatusBar )
font = droid
else
font = els
end
return font
end
return M
main.lua
local setting = require(“setting”)
setting.sqlite_db(“game_setting.db”)
setting.sqlite_create(“game_setting”)
setting.sqlite_insert(“sound”, 100)
setting.sqlite_select(“sound”)
local myText = display.newText( setting.sqlite_select(“sound”), 100, 200, native.systemFontBold, 20 )
myText:setFillColor( 255/255, 255/255, 255/255 )