Mmene Mungagwiritsire ntchito SQLite kusunga Game Data ndi Maimidwe
Chinthu chimodzi pafupifupi pulogalamu iliyonse ndi masewera omwe ali ofanana ndizofunikira kusungira ndi kulandira deta. Ngakhale sewero losavuta kwambiri lingagwiritse ntchito SQLite kusunga nambala yeniyeni ya pulogalamu, yomwe ingagwiritsidwe ntchito kuti zitsimikizidwe pamene mukukweza mapulogalamu, kapena masewera osavuta monga kutsegula kapena kutseka masewerawo.
Ngati simunagwiritsepo ntchito zambiri ndizolemba kapena kugwiritsa ntchito zida zachinsinsi ku Corona SDK , musadandaule. Ndizowona bwino chifukwa cha mphamvu ya LUA ndi injini ya SQLite yosungiramo deta yomwe imagwiritsidwa ntchito mu Corona SDK. Phunziroli lidzayenda popanga tebulo lokonzekera ndipo zonse zikusungira ndi kulandira uthenga kuchokera pamenepo. Momwe mungakhalire iPad mapulogalamu.
Komanso kumbukirani kuti njira iyi ikhoza kupitirira kuposa kusunga makonzedwe opangira ntchito. Mwachitsanzo, bwanji ngati muli ndi masewera omwe angasewedwe pogwiritsa ntchito njira zosiyana siyana monga "nkhani" ndi "Arcade". Gome lokonzekerali lingagwiritsidwe ntchito kusungira njira yomwe ilipo. Kapena mbali ina iliyonse ya deta yomwe mukufuna kuti mupitirizebe ngakhale atagwiritsa ntchito masewerawo ndikuyambiranso.
Khwerero 1: Kuyambitsa deta ndikupanga mapepala apangidwe
Chinthu choyamba chimene tikufunikira kuchita ndikulengeza laibulale ya SQLite ndikuwuza pulogalamu yathu komwe mungapeze fayilo yachinsinsi. Malo abwino kwambiri oyika codeyi ali pamwamba pa fayilo yaikulu.lua pamodzi ndi zina zomwe zimafunikira mawu. Fayilo yachinsinsi idzapangidwa ngati palibe yopezeka, ndipo tidzaisunga mu foda ya Documents kuti tiwerenge kuchokera kwa izo ndikulembera.
mukufuna "sqlite3"
malo data_path = system.pathForFile ("data.db", system.DocumentsDirectory);
db = sqlite3.open (data_path);
Tawonani momwe kusintha kwa "db" sikukuyendera. Tachita izi kuti titsimikizire kuti tingathe kupeza malowa mu polojekiti yathu yonse. Mukhozanso kupanga fayilo yapadera ya .lua kwa onse ogwiritsa ntchito deta ndikusunga malo omwe akupezeka pa fayilo.
Pambuyo pake, tikufunika kupanga tebulo lachinsinsi limene lingasungire zochitika zathu:
malo sql = "LENGANI ZIKHALIDWE NGATI ZINTHU ZOPHUNZITSIDWA (dzina, mtengo);"
db: exec (sql);
Mawu awa amapanga tebulo lathu lokhazikitsa. Ndi bwino kuyendetsa nthawi iliyonse pulogalamuyo itanyamula chifukwa ngati tebulo ilipo kale, mawu awa sadzachita chirichonse. Mukhoza kufotokoza izi pansi pomwe takhala tikuwonetsera deta kapena ntchito imene imayambitsa pulogalamu yanu kuyendetsa. Chofunikira chachikulu ndi (1) kuti azichita zomwezo nthawi iliyonse pulogalamuyo itayambika ndipo (2) ichite izo musanayambe kuyitana kapena kusunga zosintha.
Khwerero Lachiwiri: Kusungira zosintha ku deta
ntchito setSetting (dzina, mtengo)
sql = "DELETE kuchokera ku zolemba WHERE dzina =" ".. dzina ..." '";
db: exec (sql)
sql = "INSERT INTO mipangidwe (dzina, kufunika) ZOYENERA ('" .. ..name .. "', .. .. value .."); ";
db: exec (sql)
TSIRIZA
ntchito setSettingString (dzina, mtengo)
setSetting (dzina, "'" .. .. value .. "'");
TSIRIZA
Ntchito yokonzayi imachotsa zochitika zonse zapitazo zomwe zasungidwa patebulo ndikuyika mtengo wathu watsopano. Idzagwira ntchito limodzi ndi zingwe ndi zingwe, koma kusunga chingwe kumafuna ndemanga imodzi yokha yozungulira phindu, kotero tagwiritsa ntchito setSettingString ntchito kuti tichite ntchito yapadera imeneyi kwa ife.
Khwerero 3: Kusungiratu zosinthika kuchokera ku deta
ntchito getSetting (dzina)
malo sql = "SELECT * FROM zochitika WHERE dzina =" ".. .. dzina .." '";
mtengo wapatali = -1;
mzere mu db: nrows (sql) do
mtengo = row.value;
TSIRIZA
mtengo wobwerera;
TSIRIZA
ntchito getSettingString (dzina)
malo sql = "SELECT * FROM zochitika WHERE dzina =" ".. .. dzina .." '";
mtengo wamtundu = '';
mzere mu db: nrows (sql) do
mtengo = row.value;
TSIRIZA
mtengo wobwerera;
TSIRIZA
Monga tanena kale, tathyola ntchitoyi m'zinenero ziwiri: imodzi ya integers ndi imodzi ya zingwe. Chifukwa chachikulu chimene tachita izi ndikuti titha kuyambitsa ndi zikhalidwe zina ngati palibe malo omwe alipo. Ntchito ya getSetting idzabwerenso 1, yomwe idzatidziwitse kuti malowa sanasungidwe. The getSettingString adzabwezera chingwe chopanda kanthu.
Ntchito ya getSettingString ndi yokhazikika. Kusiyanitsa kokha pakati pa izo ndi ntchito yeniyeni ya getSetting ndizobwezeredwa ngati palibe chopezeka mu databata.
Khwerero 4: Pogwiritsa ntchito tebulo lathu
Tsopano popeza tili ndi khama, timatha kusunga ndi kusunga zofunikira ku malo osungirako. Mwachitsanzo, tikhoza kulira phokoso ndi mawu otsatirawa:
setSetting ('phokoso', zabodza);
Ndipo tikhoza kugwiritsira ntchito pulogalamu yonse yochitira phokoso:
ntchito yowonjezeraSound (soundID)
ngati (getSetting ('phokoso') ndiye
audio.play (soundID)
TSIRIZA
TSIRIZA
Kuti tibwezeretsenso, timangokhalira kukhazikitsa phokoso lamakono:
setSetting ('phokoso', chowonadi);
Gawo labwino lokhudza ntchitozi ndizomwe mungasunge zingwe kapena integers ku tebulo lokonzekera ndikuzilandila mosavuta. Izi zimakulolani kuti muchite chilichonse populumutsa dzina la osewera kuti apulumutse mapiritsi awo apamwamba.
Corona SDK: Momwe Mungapangire Zithunzi Zamatabwa, Pitani Zithunzi Zojambula ndi Kujambula Zojambulajambula