Yadda za a Yi amfani da SQLite don Tattaunawa Game da Bayanai da Saituna
Ɗaya daga cikin abu kusan dukkanin wasanni da wasan suna da mahimmanci shine buƙatar adanawa da kuma dawo da bayanan. Ko da wasa mai sauƙi zai iya amfani da SQLite don adana lambar app, wanda za'a iya amfani dasu don tabbatar da haɗin kai a yayin yin gyare-gyare, ko saituna masu sauƙi kamar sauya kunne ko kashewa.
Idan ba ka taba yin aiki sosai tare da bayanan bayanai ba ko amfani da fasalin bayanai a cikin Corona SDK , kada ka damu. Yana da ainihin a in mun gwada da sauƙi tsari godiya ga ikon LUA da SQLite database engine amfani a Corona SDK. Wannan koyaswar za tayi tafiya ta hanyar aiwatar da saitunan tebur da kuma adanawa da kuma dawo da bayanin daga gare ta. Yadda za a inganta kayan aiki na iPad.
Har ila yau ka tuna cewa wannan ƙwarewar za ta iya wuce bayan adana saitunan masu amfani. Alal misali, idan kana da wasan da za a iya buga ta amfani da nau'ikan yanayin wasanni kamar yanayin "labarin" da yanayin "arcade". Za'a iya amfani da wannan tebur saitin don adana halin yanzu. Ko wani bangare na bayanan da kake so ka kasance da ci gaba ko da mai amfani ya fita daga wasan kuma ya sake shi.
Mataki na farko: Farawa da kuma samar da saitunan saiti
Abu na farko da muke buƙatar mu yi shi ne tabbatar da ɗakin karatu na SQLite kuma gaya wa app inda za mu sami fayil din fayil. Mafi kyaun sanya wannan lambar yana daidai a saman fayil na main.lua tare da sauran buƙatar maganganun. Za'a ƙirƙiri fayil ɗin bayanan idan babu wanda aka samo, kuma za mu adana shi a cikin Rubutun Rubutun don mu iya karanta daga gare ta kuma mu rubuta zuwa gare shi.
buƙatar "sqlite3"
gida data_path = system.pathForFile ("data.db", system.DocumentsDirectory);
db = sqlite3.open (data_path);
Ka lura da yadda ba'a gano "db" ba. Mun yi wannan domin tabbatar da cewa za mu iya samun dama ga bayanai a duk aikinmu. Zaka kuma iya ƙirƙirar wani takamaiman fayil na .lua ga duk ayyukan bayanan yanar gizo da kuma adana bayanan da aka gano zuwa wannan fayil ɗin.
Na gaba, muna buƙatar ƙirƙirar tarin bayanai wanda zai adana saitunanmu:
sql na gida = "CREATE TABLE IF BAYA SANYAR SUNI (suna, darajar) ba;"
db: exec (sql);
Wannan sanarwa yana kirkiro tebur saitunanmu. Yana da kyau don gudanar da shi a duk lokacin da kayan aiki na kayan aiki domin idan tebur ya wanzu, wannan sanarwa ba zai yi wani abu ba. Za ka iya sanya wannan sanarwa daidai a ƙarƙashin inda muka bayyana database ko a cikin aikin da ya kafa na'urarka don gudu. Babban buƙatar ita ce (1) don aiwatar da waɗannan maganganu duk lokacin da aka ƙaddamar da app kuma (2) aiwatar da shi kafin wani kira don ɗauka ko ajiye saitunan.
Mataki na biyu: Ajiye saituna zuwa database
aikin saitinSetting (suna, darajar)
sql = "KASHE DAGA SAUNTA SAWA suna =" ".. suna .." '";
db: exec (sql)
sql = "Sanya a cikin saituna (suna, darajar) VALUES (" "..name .." ', ".. value .."); ";
db: exec (sql)
karshen
aikin saitinSettingString (suna, darajar)
setSetting (suna, "'" .. darajar .. "'");
karshen
Sabis ɗin setSetting yana share duk wani saiti da aka ajiye a cikin tebur kuma yana saka sabon darajarmu. Zai yi aiki tare da dukkanin lambobi da igiyoyi, amma adana layi yana buƙatar buƙata guda ɗaya a kusa da darajar, saboda haka mun yi amfani da aikin setSettingString don yin wannan ƙarin aiki na gare mu.
Mataki na Uku: Saitunan da aka yi amfani da su daga asusun
aiki GetSetting (sunan)
sql na gida = "SELECT * DAGA saituna INA suna =" ".. suna .." '";
ƙimar gida = -1;
don jere a db: nrows (sql) yi
darajar = row.value;
karshen
sake dawowa;
karshen
aikin samunSettingString (sunan)
sql na gida = "SELECT * DAGA saituna INA suna =" ".. suna .." '";
gida darajar = "';
don jere a db: nrows (sql) yi
darajar = row.value;
karshen
sake dawowa;
karshen
Kamar yadda a sama, mun karya ayyukan a cikin nau'i biyu: daya don mahaɗin kuma daya don kirtani. Dalilin da ya sa muka yi wannan shi ne don mu iya sanya su da ƙididdiga masu mahimmanci idan babu tsari a cikin database. Ayyukan samunSetting zai dawo da -1, wanda zai sanar da mu cewa ba a ajiye tsarin ba. Samun samunSettingString zai dawo da kirtani marar lahani.
Ayyukan samunSettingString na gaba ɗaya ne. Bambanci kawai tsakaninsa da al'ada GetSetting aiki shine abin da aka dawo idan babu abun da aka samu a cikin database.
Mataki na hudu: Yin amfani da tebur saitunan mu
Yanzu muna da aiki mai wuyar gaske, zamu iya ɗauka da adana saituna zuwa cibiyar sadarwa. Alal misali, zamu iya sautin sauti tare da sanarwa mai zuwa:
saitaSetting ("sauti", ƙarya);
Kuma zamu iya amfani da wuri a cikin aikin duniya don kunna sauti:
aikin playSound (soundID)
idan (samuSetting ("sauti")) to
Siffar sauti (soundID)
karshen
karshen
Don kunna sauti a kunne, za mu saita saitin sauti a gaskiya:
saitaSetting ('sauti', gaskiya);
Mafi kyau game da wadannan ayyuka shine zaka iya ajiye kirtani ko mahaɗan zuwa layin saitunan kuma maido da su sauƙi. Wannan yana ba ka damar yin wani abu daga ceton sunan mai kunnawa don ceton su.
Corona SDK: Yadda za a ɗauka masu zane-zane, Matsar da zane-zane da kuma kawo kayan zane zuwa gaban